...
| Column | Type | References | Comments | |||
|---|---|---|---|---|---|---|
| id | Integer | Primary key | ||||
| created | Date | |||||
| guid | String | |||||
| vdb_id | Integer | |||||
| name | String | Short name | ||||
| description | String | Description | ||||
| templatetype_id | Integer | Report template id | ||||
| version | Integer | |||||
| creator_id | Integer | db_person.id | Owner of the report | |||
| params | String | Report parameters | ||||
| specificity | Integer | BO type of project or task | ||||
| sharing | Integer | Indicates who the report is shared with | ||||
| shared_ | departmentworkspace_ids | String | If shared with | deptworkspace, csv of | deptworkspace ids | |
| all_client_sharing | Boolean (t or f) | If true means all clients can see this report | ||||
| acl_id | Integer | |||||
| repeat_sub_type | Integer | The sub-type qualifier for the repeat type. e.g. if EVERY_MONTH, then whether it is on a specific day of the week or last day of month etc. | ||||
| repeat_pattern | String | ICalendar Repeat pattern | ||||
| repeat_until_utc | Date | Date until which emails are to be sent | ||||
| run_as_user_id | Integer | User to run report as for delivery | ||||
| subscribers | String | The subscribers for this report | ||||
| schedule_start_date | Date | The date to start sending the report and time at which to send report 0-23 | ||||
| scheduled | Boolean (t or f) | Is scheduled for delivery | ||||
| is_view | Boolean (t or f) | Is VIEW type report | ||||
| process_type_id | Integer | db_process_type.id |