db_custom_report
- Former user (Deleted)
- Rashmi Likhite
- Former user (Deleted)
Owned by Former user (Deleted)
Custom report
| Column | Type | References | Comments |
|---|---|---|---|
| id | Integer | Â | Primary key |
| created | Date | Â | Â |
| guid | String | Â | Â |
| vdb_id | Integer | Â | Â |
| name | String | Â | Short name |
| description | String | Â | Description |
| type_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_workspace_ids | String | Â | If shared with workspace, csv of workspace 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 | Â |