Integration Guide

Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 135
© 2000, Symbol Technologies, Inc. February 1, 2000
Target Coupon Amt if the message contains a coupon offer, this is the amount of the coupon
Target Rank the customer rank level targeted by this message
Start_Datetime date/time after which this message is to be displayed
End_Datetime date/time after which this message will no longer be displayed
B.18 Table Name: PSS_Marketing_Sent
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Customer_ID Int NOT NULL Yes No
Shopping_List_ID Int NOT NULL Yes No
Marketing_Datetime Datetime NOT NULL Yes No
Item_ID Varchar(20) NULL No No
Dept_ID Int NULL No No
Mfg_ID Int NULL No No
PSS Marketing Sent Table contains information on which marketing messages have been sent
to which customers on current shopping trips
Customer ID unique identifier for this customer (from PSS_Customer)
Shopping List ID identifies shopping list (from PSS_Shopping_List)
Marketing_Datetimedate/time when this message was displayed to the customer
Item ID unique item identifier for item messages (from PSS_Item)
Department ID unique department identifier for department messages (from
PSS_Department)
Manufacturer ID unique identifier for this manufacturer for manufacturer messages (from
PSS_Manufacturer)
B.19 Table Name: PSS_Message_Log
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Msg_Datetime datetime NOT NULL No No
Msg_Facility varchar(64) NOT NULL No No
Msg_Action varchar(64) NOT NULL No No
Msg_Severity int NOT NULL No No
Msg_Message varchar(255) NULL No No
Msg_Data int NULL No No
PSS Message Log Table contains logging information from PSS processes
Msg_Datetime date/time this message was logged
Msg_Facility the facility logging this action (e.g. POSInterfaceCOM)
Msg_Action the action this facility was performing
Msg_Severity the severity level of this message (e.g. Informational, Fatal, etc.)
Msg_Message the message text of this message
Msg_Data optional integer data associated with this message