School District

One of our PAC members needed to support one of their clients who is a large school district with multiple school locations. The unusual aspect of this application was the need for the photo ID system to work with district’s Oracle database at the local levels.

Problems:

• Across the school district are four high schools with a student population of anywhere from three thousand to five thousand students.
• Each high school needed access to the district’s central Oracle database for registered student information.
• Each of the four high schools had different configuration requirements for the centralized Oracle database.
• Each local school needed the flexibility to have its own student, faculty id card design.
• The four schools needed the ability to re-issue missing photo ID’s and change individual student information. All changes were required to come directly from the district’s central Oracle database.
• Student images taken locally were required to be exported to the district’s Oracle database for record keeping.
• The district and schools had a limited budget to work with.

Solution:

Once we identified the overall project requirements and understood the limited budget issues, the software of choice was our LEXID LE with the optional School Edition package.

• One of the key features of LexID is its reference link capabilities. This feature allowed us to build a reference link to the district’s Oracle database without the need for costly software customization.
• This LexID LE software package gave the four high schools total control over card template designs and database customization.
• The software is capable of handling large databases allowing for an initial loading of all registered students at the beginning of each school year. This feature also allowed the downloading of thousands of student records from the central Oracle database to the individual local databases. The local high schools could then add student photos to the database for printing student IDs.
• After the initial load of information, incremental updating can be done by specific request at the time of need. Operators simply type in the student’s ID information to search the local database, or central Oracle database. Any new data will be queried from the central Oracle database and updated to the local database.
• Once the students ID’s were produced, the local schools used the School Edition option to export all student photos back to the Oracle database.

The school district’s requirements were met and the installed system has far exceeded their expectations. The local high schools were ecstatic over the ability to download student records then work independently from the district’s Oracle database giving them more operational flexibility. The databases (central and local) always remain updated and in synchronization with one another.

For additional information on this type of unique application contact your sales consultant at Lexington Technology.
Call 1 (800) 265-6090 "SOFTWARE TO IDENTIFY AND TRACK"

---

Student, Faculty, Contract Workers and the Police

In a large metropolitan school district one of our PAC members encountered a unique application. Our PAC partner is a school photographer who as part of his school package sells Student ID’s. This particular school had some issues they needed to resolve.

The Problem:

• The school had a need to produce ID cards with very unique identifiers for Students, Faculty, and Contractors.
• Campus security had a hard time realizing who was authorized to be on the school property and what were they authorized to do.
• Students and Contractors needed to be tracked with regards to schedules and authorization.
• Mobile Visual identity verification was needed as many students would not have their ID cards.
• The school was working with local police authorities to quickly identify certain students via mug shots.

The school looked for ways to hire additional staff to help with the problems they were encountering. However, with limited funding no approval for additional staff was granted. The principle at the school mentioned to our PAC partner the dilemma the school was facing with and our PAC Partner with Lexington Technology provided the needed system.

The Solution:

Our PAC partner and we came to the conclusion to do this project the school would need LEXID LE to replace their existing ID Software package. LexID LE was chosen as this software provided a reference link to the schools existing database, our Track Master software was used for providing mobile tracking.

• Our software incorporated multiple design temples. A total of seven separate card templates were created and associated to a data field for Students, Faculty and Contractors.
• Once the ID card is created and produced photographs, names and schedules are downloaded into multiple Mobile Tracking Devices. These devices were PDA’s with attached barcode scanners.
• By then scanning a barcode on the ID card a photograph of the individual appears on the PDA screen. Associated with the photograph is the name or the card holder, schedule and appropriate authorizations. In the situations where there was no ID card a quick name search also produced the same data results as scanning the barcode. Using this approach in searching 4,200 records the Photograph and associated data appeared within 2 seconds.
• One benefit that was provided but not required was an end of day report which showed all activities logged within the Mobile Tracking devices thus helping school administrators to identify problem areas of the daily activities.
• The software also provided a check box for individuals based on groups. When the appropriate box was checked the software produces, in mug shot format, photographs of individuals based on groups. These photographs are then used by our PAC partner for year book publishers. They are also used by local authorities (in a special sorted report) as a quick identification for known students. These mug shots formats are stored as reports, are archived, saved to CD or printed.
• The camera equipment selected was a web cam style of camera.
• A new Evolis printer was selected for this application to replace their aging ID card printer. The Evolis was selected based on ID card supply costs and the overall price per card in producing approximately 4,400 ID cards per year.
• Our PAC partner populated our LexID LE software with the existing school database, created the new ID card templates, designed the data entry screens using our design wizard function, downloaded the PDA’s, and trained the staff. This entire process took our PAC partner two days to complete.
• The school has become so familiar with the system they are now using Track Master for tracking student activities at off campus events, such as dances, field trips and away games.

For additional information on this type of unique application contact your sales consultant at Lexington Technology.
Call 1 (800) 265-6090 "SOFTWARE TO IDENTIFY AND TRACK"

Voter Registration

One of the American territories was seeking a solution for registering voters. This presented some unusual circumstances for their project.




The Problem:

• A large database with hundreds of thousands records.
• There was a legacy database in place which held some of the information.
• There existed security issues surrounding the voter’s identity. These were in issuing the registration card, duplication of records, and Identity verification.
• Voter registration and card issuing needed to be at multiple locations.
• The system when installed had to be intuitively easy to operate and above all had to work.
• Serviceability of the system (trained technicians) was also a concern dealing with large amounts of critical data.
• There was also a limited budget to work with.

The customer had looked extensively for an off-the–shelf software solution as designing a system from scratch was costly and time consuming. The commercially available packages they found could not handle the amount of data required and the legacy interface was cumbersome at best.

The Solution:

Lexington Technology working in conjunction with the voter registration board came to the conclusion our IDMX SQL product, was a close fit for their requirements. This off-the-shelf enterprise level solution had 95% of the systems requirements but fell short in some unique data handling elements. Lexington Technology spent approximately one week in software modifications and testing.

• The large database with thousands of records was imported into our software with notification of missing fields or anomalies.
• The interface to the legacy database was integrated with an additional database, matching historical photographs of registrants with current photographs.
• The software already had built into it the security needed.
• Password protection and limited viewing of fields associated with the password security.
• Verification of authorized person to issue the card.
• Record duplication check and card issuance check. The system also limited the time of day when cards could be issued and the database accessed.
• The cards were printed on a CR80 composite card.
• Card was designed with personalized photograph.
• Signature capture of both card holder and issuing authority.
• All the normal text you would expect on a registration card.
• Ghosted images.
• Sequential serial numbers with unique identifiers based on multiple attributes of the registrant.
• Registration cards can be inputted, verified and issued from multiple select locations, with other locations as "View Only" stations.
• Input screens were customized with our wizard tool to match the needs of the operators and assist with work flow.
• The voter registration board was trained on the software a total of one and one half days.
• The system is totally serviceable with local technicians and operators maintaining and updating the system.
• The system with one week of customization on our part came in 45% under their budget.
• The printers we felt best suited this particular application was Fargo. There was no need for special encoding, subsequently barcodes became the encoding of choice, the printers were, however, dual sided.
• The customer supplied their own cameras and we interfaced them to our software.

For additional information on this type of unique application contact your sales consultant at Lexington Technology.
Call 1 (800) 265-6090 "SOFTWARE TO IDENTIFY AND TRACK"

---

Concealed Weapons Permit Program

One of our PAC members was approached by their state government to see what types of available technology could be incorporated to produce a concealed weapon ID card and permit. The application required verification of the permit requesters’ information, background check, multiple authorizations, issuing an ID card with permit. Our PAC member who already distributes Nisca ID card printers and serviced these printers throughout the state, requested to get Lexington involved in this project.

The Problem:

• A large number of associated data and records.
• Maintaining database integrity and not allowing for breach of databases at various government locations.
• Interface to multiple (3) legacy databases of differing file structures and access levels.
• Security of data, card issuance, card modification and counterfeiting was of concern.
• Multiple levels of approvals.
• Physical card layout with a lot of information was required on the ID card/permit.

One of the major concerns was the need to create and maintain a totally customized database, the time to finish such a project and the budget. Our PAC partner contacted us with the problem and for the next few weeks working in conjunction with the state and Lexington our PAC Partner had the answers.

The Solution:

IDMX SQL was selected as the software of choice for several reasons, the inherent security features within SQL, and the potentially large database capacity required for the project. As it turned out our Off-the-Shelf IDMX SQL software had all the necessary functionality, with one slight exception. The need did exist to work with the state on certain images (photographs) who’s formatting and database extensions, were stored and processed differently across the multiple databases.

Our PAC Partner supplied all the hardware; with the exception of signature pads they purchased form Lexington.

• The records for each applicant were linked with associated data from multiple locations. This created the need for a fairly large database which is well within the IDMX SQL capacity.
• A reference link was built as a portal for data coming from three separate data sources. This insured there was no security breaches with the databases from various departments within the state. A single data import was then used to populate the database for the ID card/permit issuance.
• Multiple level passwords were implemented within the system; these multilevel passwords controlled the data security, the actual issuance of the ID card/permit. An authorization signature could not be placed on the card until the authority approving the signature logged on to the system and approved the ID card/permit production. A record or audit trail was then created and approved to insure the card was authorized for ID card print production.
• Within the Nisca printer and our software the (F) ribbon panel was used to add additional security features to the card. As part of our software a SecurMark™ graphical image (translucent) in appearance was strategically placed on the card to prevent tampering. This allowed the state to use a YMCFKOK ribbon which helped reduce the overall supply expenses.
• The physical card has the appearance of a state driver’s license with all the text you would normally expect, with the addition of ghosted images, multiple signature locations, additional text and SecurMark’s. Consider the concealed ID card/permit has the appearance of a driver’s license on steroids. There is a lot of data and images to fit into a confined area of a CR80 card, however the ID card/permit remained esthetically pleasing to the eye.
• The end result? The project is a success and with careful planning complex systems can be installed quickly, easily and at affordable prices.

For additional information on this type of unique application contact your sales consultant at Lexington Technology.
Call 1 (800) 265-6090 "SOFTWARE TO IDENTIFY AND TRACK"

Manufacturer Access Control Card System

A major international manufacturing Company was looking for a suitable ID card for the production of their RFID cards. Their newly installed Access Control system did not have all the ID card production features they needed. Here are a few of the issues they were faced with:

Problems:

• The existing Access Control System photo ID module did not allow for multiple ID card Templates. The Company wished to have a distinctive card appearance for employees, part time workers, contractors, and frequent visitors (suppliers). The existing Access Control system ID card module had only one style of ID card.
• The company wanted to integrate the ID card system with the Access Control system by recording each of the RFID serial numbers and associate those serial numbers with the ID card holder record.
• The system needed to read each RFID card’s serial number prior to personalizing the ID card with person’s photo and names.
• Currently, the company orders the RFID cards with pre encoded serial numbers printed on the face of the card which present a security risk to the company. By having the serial numbers printed on the face of the RFID card it opened the possibility for un authorized access to the facilities, approximately fourteen locations.
• The customer had to retype each RFID serial number into the system, each time a ID card was issued. This opened the possibilities of human errors and the potential scraping of an expensive combination Access Control and ID card.

Solutions:

Lexington Technology working with a local PAC member selected the LEXID Pro software with our RDIF reader option. This option was selected for the following reasons:

• LexID allowed the customer to create many professional looking card templates. The system allows the customer, to select certain attributes based on pre-defined card holders job descriptions and automatically selects one of nine pre-designed personalized card templates, which has greatly improved visual recognition and improved the over all company image.
• A Fargo printer was chosen, with the HID reader option installed.
• Customer now orders RFID card without serial numbers printed on the face of the card.
• LexID with the RFID options allows the user to load blank RFID cards into the printer hopper, as each RFID card is pulled to the printer, the RFID reader pulls the serial number from the card and automatically saved this number into the id card database where the number is recorded and associated to a particular card holder.
• The ID card system will then generate reports who was issued a specific serial number and if the serial number to the card holder has the correct access rights.
• If cards are lost the system will quickly determine the serial number of the lost card which in turn can be disabled from the Access Control System.

For additional information on this type of unique application contact your Lexington Sales representative and see if we have a solution for your application.
Call 1 (800) 265-6090 "SOFTWARE TO IDENTIFY AND TRACK"

---

Department Store

One of our PAC members needed to support a large department store chain. The corporate offices wished to go to a members ID card system, however they have no idea who the card holders are. There will be a total of three hundred stores opening in selected locations through out the United Stated. The corporation realized that their anticipated traffic will grow into the millions, however it would be to expensive to set-up the infrastructure at this time as the department stores are not fully functional or in most cases even opened.

Problems:

• Needs a system that can start producing ID cards of newly opened store locations.
• The databases are independent to each store however eventually all store databases will need to be merged.
• The department wished to build a system where multiple small databases could be merged into one centralized database in the future.
• Each local store needed the flexibility to have its own ID card design customized to the local environment, while maintaining the over all corporate image.
• The individual store ID card systems needed to be easy to operate due to personnel turnover.
• The ID card issuance system needs to be reliable and cost effective.
• Scalability was a major issue as the department store need to up load all local ID card information to a centralized database were millions of records would be stored.

Solution:

Once we identified the limited budget issues, growth requirements and the overall project requirements we selected LexID Pro as the project starting point.

• One of the key features of LEXID Pro is its database workflow capabilities. This feature allowed us to build data models for the individual store locations, without the need for costly software customization.
• This LexID Pro software package gave the individual department stores the ability to perform local customization while a pre loaded template maintained the departments store’s desire to maintain an overall corporate appearance.
• The software is capable of handling large databases at the local store levels with ample room for storing photographs and text data.
• We selected the Evolis ID card printers (based on their rugged performance), a signature capture device and camera for this particular application.
• Over the next few years and as new stores come on-line and their database grows the department store will trade in their existing LexID Pro software and up-grade their system to a full IDMX SQL server application.
• Once this is completed the system will handle millions of photo ID records at a centralized location. This will allow the department store to analyze customers, send direct mailers.

The departments store requirements were met and the installed systems are growing on monthly bases. To date the system has exceeded their expectations. The local stores were ecstatic over the ease of operation and their ability work independently from corporate. Once the project is completed the system will provide them with more operational data and flexibility. The databases (central and local) when converted to IDMX SQL will always remain updated and in synchronization with one another.

For additional information on this type of unique application contact Lexington Technology or one of our PAC members to discuss your specific needs.
Call 1 (800) 265-6090 "SOFTWARE TO IDENTITFY AND TRACK"

Library Card System

A large metropolitan Library had been using LexID to supplement their library card system issuing photo ID cards for its members. Over the years (ten) the library out grew the capabilities of their existing Lexington Technology’s card personalization software. Here are a few of the issues the Library encountered.

The Problem:

• Each year A legacy photo ID database established in 1995, increased by more than 10,000 members signing up for the library services.
• Because the large size of the legacy photo ID database, older data must be archived off line each year for storage.
• Images are stored as jpg files under numerous folders outside the main MS access database which causes difficulty in managing data. Online search is non-existant because of the large volume of the legacy data.
• The same photo ID card system is required to provide library cards, volunteer workers, employee’s, media passes as well as city employee badges.
• Special barcode encoding is required to integrate with a new library system.
• The library has multiple locations, spanning the entire city. Each location needs to verify the authenticity of member’s library card.
• Because of the high volume of volunteer workers with little computer knowledge, the system needed to be intuitively obvious to use.
• The library wished to improve the current photo image quality.

The Solution:

Lexington Technology working in conjunction with the Library came up with the solution. (No PAC member was local to the Library for this solution).

• Due to the volume of records our IDMX SQL server software, was an ideal fit. The data capacity available in IDMX provides an enterprise level solution to meet the requirements now and into the future, the library requires.
• IDMX provided high performance (fast query) for the library card verification, and was able to accommodate fast searching among hundreds of thousands of library card holders.
• Today online data availability is provided to each of the library’s locations. The system at any location is fast with virtually instantaneous data retrival.
• Consolidation of entire legacy photo ID database was merged into a single SQL Server database. The system is able to partition the ASCII data and image data in separated database segments to improve database performance. The results were a dramatic improvement in record search responses.
• The Library’s existing camera was upgraded to our LexCam 600. The digital camera features a built-in auto flash, providing consistent high quality photo image.
• The system upgrade allowed the Library to preserve all the existing LexID card templates.

The system has been successfully implemented and is operational. After the initial setup, the system was so easy to operate, the time required to train librarians and volunteers was reduced to a fraction of the original training time. This resulted in the library actually saving money and reducing budgeted expenses.

For additional information on this type of unique application contact Lexington Technology or one of our PAC members to discuss your specific needs.
Call 1 (800) 265-6090 "SOFTWARE TO IDENTITFY AND TRACK"

---

Membership CS

One of Lexington’s PAC members came to us with a customer’s problem, seeking a workable solution. The customer is a historical site with thousands of visitors per year.


Problems:

• Customer had an existing SQL Server based Membership management software, complete with Point of Sale (POS) interface.
• The membership card production portion of their membership software was limited in functionality with only stock card templates. This customer wished to customize it’s membership templates and provide a choice for visitors as a souvenir.
• Different card software was required to satisfy increase demands for numerous card templates. The new card software needed a seamless interface to the existing membership program software.
• At the same time, the new system must identify new and existing members to avoid multiple cards being issued to the same individuals. This duplication of cards was corrupting the membership database causing unnecessary manpower with constant database changes.
• There was only a single workstation, however the system needed to add additional workstations during peak seasons or special events.
• The budget constraint is the new system must able to use the existing computer.

Solution:

After closely working with the customer and our PAC partner, Lexington recommended our IDMX NetV with Database Integration Package as the best choice. Our IDMX NetV is a desktop version of our IDMX SQL software. The customer also had an older dye-sub-lamination printer which was also changed out to an Evolis printer.

• IDMX NetV does not require a dedicated database server, thus the database and the photo ID software can reside on the same workstation.
• IDMX NetV includes a built-in SQL Server desktop database so there was no need to purchase a new SQL Server license which kept the project costs down.
• The entire project was completed under budget with a cost savings in maintenance and printer supplies.
• An upgrade path is now available from IDMX NetV to IDMX SQL Server helping to preserve custumizing investment. When the time comes for the customer to upgrade to a much large database (millions of records) the existing IDMX NetV database can be simply migrated to a true SQL Server database with a few mouse clicks. All the card templates and data will automatically be upgraded to the new system.
• A database interface file was created for the customer. This database interface file is responsible for passing and verifying data between the two systems. The database verification settings allow the customer to avoid double data entry.
The integration was so successful, that the need for a second workstation was placed on hold as a single workstation is handling the volume for the present time. The customer is excited about the system’s enhanced functionality and smooth operation between their membership program and Lexington’s IDMX NetV card personalization software.

For additional information on this type of unique application contact Lexington Technology or one of our PAC members to discuss your specific needs.
Call 1 (800) 265-6090 "SOFTWARE TO IDENTITFY AND TRACK"