Integration Guide

Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 129
© 2000, Symbol Technologies, Inc. February 1, 2000
Currency_ID int NULL No Yes
Language_ID int NULL No Yes
Rescan_Level int NULL No No
Rank int NULL No No
Suspend_Reason varchar(80) NULL No No
Card_Expiration_Datetime datetime NULL No No
Num_Trips int NULL No No
Num_Trips_Since_Rescan int NULL No No
Last_Trip_Datetime datetime NULL No No
First_Trip_Accurate char(1) NULL No No
Greeting_Text varchar(255) NULL No No
Registered_Datetime datetime NULL No No
Display_Foodstamp char(1) NULL No No
Special_Customer char(1) NULL No No
Suspend_ID int NULL No Yes
Num_Rescans int NULL No No
Group_ID int NULL No No
Num_Rescan_Diffs int NULL No No
Num_Trips_Incomplete int NULL No No
Total_Trip_Seconds int NULL No No
First_Trip_Datetime datetime NULL No No
Last_Incomplete_Datetime datetime NULL No No
Total_Spent int NULL No No
Last_Rescan_Datetime datetime NULL No No
PSS Customer Table holds all persistent data needed for a given PSS user.
Customer_ID a unique identifier for a given customer
Card_Number number on PSS shopper loyalty card which matches this customer
First_Name customer first name
Middle_Name customer middle name
Last_Name customer last name
Address customer address
Address2 customer address, line 2
City customer city
State customer state/province
Postal_Code customer postal code
Country customer country
Allow_Promotions indicates whether this customer allows marketing message display
on hand-held terminal
Allow_Checks indicates whether this customer may be rescanned
Currency_ID customer preferred currency (from PSS_Currency)
Language_ID customer preferred language (from PSS_Language)
Rescan_Level customer rescan level (from PSS_Rescan_Level)
Rank customer rank (0 to 100), typically based on amount spent through
PSS in last 30 days
Suspend_Reason reason text for customer suspension from PSS
Card_Expiration_Datetime expiration date/time of the customer’s loyalty card
Num_Trips number of PSS shopping trips this customer has been on
Num_Trips_Since_Rescan number of PSS shopping trips since this customer was last
rescanned
Last_Trip_Datetime date/time of this customer’s last PSS shopping trip
First_Trip_Accurate indicates whether the customer’s first shopping trip resulted in an
accurate rescan