Integration Guide

Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 152
© 2000, Symbol Technologies, Inc. February 1, 2000
B.46 Table Name: UMS_Cradle
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Cradle_ID varchar(4) NOT NULL Yes No
Power_ID int NULL No Yes
Dispenser_ID varchar(4) NULL No Yes
Status_Code int NULL No Yes
Status_Datetime datetime NULL No No
Cradle_Notes varchar(40) NULL No No
Default_Interface varchar(40) NULL No No
UMS_Cradle Table contains definitions of the configured cradles, or charging slots, for the
terminals used by the system
Cradle_ID the unique identifier scanned by a terminal placed into this cradle
Power_ID the power supply ID (from UMS_Power) from which this cradle gets its
power
Dispenser_ID the dispenser ID (from UMS_Dispenser) that this cradle is associated with
Status_Code the status code (from UMS_Status_Codes) for the current state of this
cradle
Status_Datetime the date/time of the last status update for this cradle
Cradle_Notes text associated with this cradle (typically for reason marked out of service)
Default_Interface the default interface for the terminals dispensed from this cradle
B.47 Table Name: UMS_Dispenser
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Dispenser_ID varchar(4) NOT NULL Yes No
Dispenser_Name varchar(50) NULL No No
Entrance_ID int NULL No Yes
Printer_ID int NULL No Yes
Default_Entrance int NULL No No
Status_Code int NULL No Yes
Status_Datetime datetime NULL No No
Default_Printer int NULL No No
Current_Mode int NULL No No
UMS_Dispenser Table contains definitions of the dispensers, or logical grouping of cradles,
used by the system
Dispenser_ID a unique identifier for this dispenser
Dispenser_Name a text description of this dispenser
Entrance_ID the entrance unit ID (from UMS_Entrance) associated with this dispenser
Printer_ID the printer ID (from UMS_Printer) associated with this dispenser