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 |