Download Reference Guide

__________________________________
Reference Guide Ver 3.9
_________________________________
3. Select the
button to start the search. The search results
will display in the Dossier List and Cardholder’s Data Tab on
the right. The entry box below the Card Holder List s displays
the equivalent SQL syntax of the simple search feature. The
first displayed database record will display on the data tab
after the search results are displayed.
To Perform a SQL Database Search:
Type the SQL query for the search and click the Refresh
button.
The results of the query will display in the Cardholder List
directly above the search entry box.
Note: Verify the field names to be used in your SQL query exist precisely
with field names found in the Addresses Table. A list of field names
can be found in the Project Node Tree  Databases  Cardlist 
Addresses  Table. These field names must be matched exactly to
perform the query.
4.3 - Card Database Tabs
The following section describes each field in the four database tabs:
4.3.1 - CardData Tab
The Data tab is used to enter and manage individual dossier
information. Data is entered into the database using the default data
entry screen named CardData.


Cardholder Image – used to display the image (photo) associated
with the database record.
Card Data Section – comprised of the following fields:
1. Encoded No – the number programmed into
the access card.
2. Emboss No – the printed number that
appears on the access card (may be different
from the Encoded Number).
3. Site Code – a number from 0 to 255 matches
the facility code of the card.
70
Copyright © 1999- 2013 OSSI, LLC