Integration Guide

Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 139
© 2000, Symbol Technologies, Inc. February 1, 2000
B.27 Table Name: PSS_Session
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
Customer_ID int NOT NULL No Yes
Shopping_List_ID int NOT NULL No Yes
Customer_Name varchar(45) NULL No No
Status int NULL No No
Initiating_Customer_ID int NULL No No
Initiating_Shopping_List_ID int NULL No No
PSS Session Table contains the high level PSS terminal issue information
Terminal ID unique hand held terminal identifier (from UMS_Terminal)
Customer ID identifies customer (from PSS_Customer)
Shopping List ID identifies shopping list (from PSS_Shopping_List)
Customer Name abbreviated version of the customer name for hand-held terminal display
Status status of this session (used to mark queue-busting session in progress, etc.)
Initiating_Customer_ID identifies the customer who started this session (used to maintain the
main queue-busting customer)
Initiating_Shopping_List_ID identifies the shopping list created by the customer who started
this session (used to maintain the main queue-busting customer’s shopping
list)
B.28 Table Name: PSS_Shopping_Activity
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Customer_ID Int NOT NULL Yes Yes
Shopping_List_ID Int NOT NULL Yes Yes
Activity_Nbr Int NOT NULL Yes No
Activity_Datetime Datetime NULL No No
Activity_Type Varchar(10) NULL No No
Activity_Detail Varchar(80) NULL No No
PSS Shopping Activity Table contains activities that occurred on the hand-held terminal during
a shopping trip, including addition/removal of items, marketing messages displayed on the
terminal, etc.
Customer ID identifies the customer (from PSS_Customer)
Shopping List ID identifies shopping list (from PSS_Shopping_List)
Activity Nbr a sequential number showing the order in which the events occurred
Activity Datetime the date and time of the activity
Activity Type the type of activity which occurred (i.e. ADDITEM, DELITEM, etc.)
Activity Detail a description of the activity which occurred