Footprints Data Model

Table
Table Name Recur Period Type
Table Definition The recurrence type. Choices include No Recurrance, Daily, Weekly, Monthly. 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 Period Type Id The unique identifier for an instance of Recur Period 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 Period Type Name The unique string identifier for an instance of Recur Period 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