Footprints Data Model

Table
Table Name Scheduled Task Run
Table Definition An instance of a run for a schedule task used for last run and previous run information. The run date and the status of the run are kept here. There is only one row per run, so the time of each status change is not known.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Scheduled Task Run Id The automatically generated primary key of the Scheduled Task Run table. LONG Yes
Scheduled Task Id A Foreign Key to the Scheduled Task table. LONG Yes
Scheduled Task Status Id The unique identifier for an instance of Scheduled Task Status. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. INTEGER Yes
Detail Status The name of the Scheduled Task Run. VARCHAR(255) No
Status Change Date The date that the Scheduled Task Run was created. DATE Yes
Scheduled Run Date   DATE No