Integration Guide

Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 153
© 2000, Symbol Technologies, Inc. February 1, 2000
Default_Entrance the default entrance unit ID (from UMS_Entrance) for this dispenser, in
case the entrance unit in use must be changed
Status_Code the status code (from UMS_Status_Codes) for the current state of this
dispenser
Status_Datetime the date/time of the last status update for this dispenser
Default_Printer the default printer ID (from UMS_Printer) for this dispenser, in case the
printer in use must be changed
Current_Mode indicates whether this dispenser is in Key-Controlled Unlock mode or not
B.48 Table Name: UMS_Entrance
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Entrance_ID int NOT NULL Yes No
Description varchar(50) NULL No No
Reader_Type int NULL No Yes
Reader_Port varchar(8) NULL No No
Status_Code int NULL No Yes
Status_Datetime datetime NULL No No
Display_Type int NULL No No
Display_Port varchar(8) NULL No No
Default_Mode int NULL No No
Current_Mode int NULL No No
Backup_ID int NULL No No
Hardware_ID varchar(16) NULL No No
Reader_Status int NULL No No
Display_Status int NULL No No
Entrance_Notes varchar(40) NULL No No
UMS_Entrance Table contains definitions of the configured entrance units used by the system
Entrance_ID unique identifier for this entrance unit
Description description of this entrance unit
Reader_Type the type of card reader (from UMS_Card_Reader_Type) used by this
entrance unit
Reader_Port the communications port (typically COMx port) used to communicate
with the non-RF card reader
Status_Code the status code (from UMS_Status_Codes) for the current state of this
entrance unit
Status_Datetime the date/time of the last status update for this entrance unit
Display_Type the type of display used by this entrance unit
Display_Port the communications port (typically COMx port) used to communicate
with the non-RF display
Default_Mode the default status message displayed by this entrance unit (swipe card, no
terminals available, etc.)
Current_Mode the current status message displayed by this entrance unit (swipe card, no
terminals available, etc.)
Backup_ID the entrance unit ID (from UMS_Entrance) to act as a backup if this
entrance unit is out of order