Footprints Data Model

Table
Table Name Recur Schedule Type
Table Definition The Schedule type. Choices include IMMEDIATELY/SCHEDULED_ONCE/MANUAL_ONLY. This is an enum table that must be kept in sync with the application code. It explains the values for database queries only, and is not mapped for application access.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Recur Schedule Type Id The unique identifier for an instance of Recur Schedule Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. INTEGER Yes
Recur Schedule Type Name The unique string identifier for an instance of Recur Schedule Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. VARCHAR(255) Yes