Integration Guide

Table Of Contents
Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 156
© 2000, Symbol Technologies, Inc. February 1, 2000
B.51 Table Name: UMS_Status_Codes
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Status_Code int NOT NULL Yes No
Status_Text varchar(30) NULL No No
UMS_Status_Codes Table contains definitions of the hardware status codes used throughout
the system
Status_Code unique identifier for this status code
Status_Text text description of this status code
B.52 Table Name: UMS_Terminal
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Terminal_ID varchar(16) NOT NULL Yes No
Cradle_ID varchar(4) NULL No No
Status_Code int NULL No Yes
Status_Datetime datetime NULL No No
Battery_Level int NULL No No
Battery_Datetime int NULL No No
Terminal_Type varchar(8) NULL No Yes
Good_Scans int NULL No No
Bad_Scans int NULL No No
Seconds_Used int NULL No No
Tot_Issue_Count int NULL No No
Tot_Good_Scans int NULL No No
Tot_Bad_Scans int NULL No No
Tot_Seconds_Used int NULL No No
Timeout_Count int NULL No No
Current_Interface varchar(50) NULL No No
Dispenser_ID varchar(4) NULL No No
Terminal_Notes varchar(40) NULL No No
Battery_Status int NULL No No
UMS_Terminal Table contains definitions of the configured hand-held terminals used by the
system
Terminal_ID unique identifier for this terminal (the MAC address of its network card)
Cradle_ID the cradle ID (from UMS_Cradle) for the current location of this terminal
Status_Code the status code (from UMS_Status_Codes) for the current state of this
terminal
Status_Datetime the date/time of the last status update for this terminal
Battery_Level a number corresponding to the amount of battery life remaining for this
terminal
Battery_Datetime the date/time of the last battery level update for this terminal
Terminal_Type the type of terminal (from UMS_Terminal_Types)
Good_Scans the number of good scans for this terminal from the last issue