Integration Guide

Table Of Contents

Appendix B

WaveWorks PSS, Integration Guide, 1.10 Page 148

B.39 Table Name: PSS_System_Message

Table Column Name Table Column

Datatype

Table Column Null

Option

Table Column Is PK Table Column Is FK

System_Message_ID int NOT NULL Yes No

Message_Text varchar(255) NULL No No

Frequency_Type int NULL No No

Month_Of_Year int NULL No No

Day_Of_Month int NULL No No

Day_Of_Week int NULL No No

Hour_Of_Day int NULL No No

Minutes_After_Hour int NULL No No

Time_Interval int NULL No No

Repeat_Count int NULL No No

Send_Next_At_Datetime datetime NULL No No

PSS_System_Message Table contains configuration information for barcodes with special

meanings, such as an End-Of-Trip barcode, or Queue Buster barcodes.

System_Message_ID unique identifier for this system message

Message_Text the text of this message

Frequency_Type type of send frequency (annual = 1, monthly = 2, weekly = 3, daily

= 4, hourly = 5, interval = 6)

Month_Of_Year month of the year when message should be sent (1-12)

Day_Of_Month day of the month when message should be sent (1-31)

Day_Of_Week day of the week when message should be sent (1-7)

Hour_Of_Day hour of the day when message should be sent (0-23)

Minutes_After_Hour month of the year when message should be sent (1-12)

Time_Interval time interval (in minutes) between which the message should be

sent

Repeat_Count number of times to repeat the message send over a time interval

Send_Next_At_Datetime date/time when this message will be sent next (set by

PssSystemMessageCOM)