Footprints Data Model

Table
Table Name Scheduled Task
Table Definition A scheduled task that may include recurrence. This is all of the information needed to provide the scheduler with data to execute a task. It is used for Reports, but is intended to be generic for other scheduled tasks. This is the root object. Report specific information will go in an association table.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Scheduled Task Id The automatically generated primary key of the Scheduled Task table. LONG Yes
Scheduled Task Name The name of the Scheduled Task. VARCHAR(255) Yes
Scheduled Task Description A descriptive name of the Scheduled Task. This descriptive name may be localized. VARCHAR(512) No
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
Begin Date Begin Date. DATE No
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 Hour The Hours portion of a time of day INTEGER No
Recur Minute The minutes portion of a time of day INTEGER No
Recur Days of Week Recur Days of Week. VARCHAR(255) No
Recur Days of Month Recur Days of Month. VARCHAR(255) No
Create Date The date that the Scheduled Task was created. DATE Yes
Create Application User Id A Foreign Key to the Application User table. LONG No
Scheduled Task Type Id The unique identifier for an instance of Scheduled Task Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. INTEGER Yes