Name |
Datatype |
Comment |
Is PK |
Is FK |
rpt_id |
bigint |
The automatically generated primary key of the rpt table. |
Yes |
No |
rpt_name |
varchar(255) |
The name of the Report. |
No |
No |
rpt_descr |
varchar(512) |
A descriptive name of the Report. This descriptive name may be localized.
|
No |
No |
rpt_comment |
varchar(255) |
The value of a Report, stored as a string. |
No |
No |
rpt_title |
varchar(255) |
The name of the Report. |
No |
No |
item_defn_id |
bigint |
A Foreign Key to the Definition Version table. |
No |
Yes |
created_by |
bigint |
A Foreign Key to the Application User table. |
No |
Yes |
created_on |
datetime |
The value of a Report, stored as a date. |
No |
No |
mod_by |
bigint |
A Foreign Key to the Application User table. |
No |
Yes |
mod_on |
datetime |
The value of a Report, stored as a date. |
No |
No |
rpt_visibility_type_id |
int |
A Foreign Key to the Report Visibility Type table. |
No |
Yes |
next_schdd_run_date |
datetime |
Next run date |
No |
No |
rpt_grp_id |
bigint |
A Foreign Key to the Definition Version table. |
No |
Yes |
rpt_type_id |
bigint |
A Foreign Key to the Definition table. |
No |
Yes |
deleted_on |
datetime |
The value of a Report, stored as a date. |
No |
No |