Footprints Data Model

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

Column
Name Datatype Comment Is PK Is FK
schdd_task_id bigint A Foreign Key to the Scheduled Task table. Yes Yes
rpt_id bigint A Foreign Key to the Report table. No Yes
mail_empty_rpt_flag numeric(1) A boolean flag for xxx No No
rpt_folder_name varchar(255) A search key for the Report Scheduled Task, composed of letters and numbers. No No
rpt_format_name varchar(255) The name of the Report Format. No Yes