Footprints Data Model

Table
Table Name Report Scheduled Task
Table Definition The report schedule is association between a report and the scheduled task. Report schedule specific information can also be placed here.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Scheduled Task Id A Foreign Key to the Scheduled Task table. LONG Yes
Report Id A Foreign Key to the Report table. LONG Yes
Mail Empty Report Flag A boolean flag for xxx INTEGER Yes
Report Folder Name A search key for the Report Scheduled Task, composed of letters and numbers. VARCHAR(255) No
Report Format Name The unique string identifier for an instance of Report Format. 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) No