Supervision Notes Table - Sirius Case Management
Notes relating to clients on deputyships
Stability: The supervision_notes table is to be considered unstable .
Analytical Platform : Yes
Alternative formats : JSON
| Column Name | Column Type | Character Maximum | Is Nullable | Default | Constrained values |
|---|---|---|---|---|---|
| id | integer | NO | |||
| person_id | integer | YES | |||
| type | character varying | 255 | YES | ||
| notetype | character varying | 255 | NO |
EVENT_CREATED, TASK_CREATED, TASK_UPDATED, TASK_COMPLETED, REPORT_ABANDONED, REPORT_DUE_DATE_UPDATED, REPORT_LODGED, REPORT_REPORTING_PERIOD_CHANGED, REPORT_REVIEWED, REPORT_OPG102_REQUESTED, CLIENT_RISK_SCORE_RECORDED, WARNING_CREATED, REPORT_PRESELECTED, DOCUMENT_REPLACED, SUPERVISION_LEVEL_UPDATED, DEATH_RECORDED, ORDER_CREATED, ORDER_UPDATED, ORDER_STATUS_UPDATED, IMPORTANT_COMMENTS, GENERAL_COMMENTS, MINOR_COMMENTS, OBSERVATION, VISITS, HW_SPECIAL_CASE, TELEPHONE_COMPLAINT, BOND_PROVIDER_CHANGE, ANNUAL_REPORTS, FINANCE_TRACKING, DEPUTY_DECEASED_DISCHARGED, PANEL, |
|
| description | text | NO | |||
| name | character varying | 255 | YES | NULL::character varying | |
| createdtime | timestamp without time zone | NO | |||
| direction | character varying | 255 | YES | NULL::character varying | |
| createdbyuser_id | integer | YES | |||
| source_note_id | integer | YES | |||
| source_task_id | integer | YES | |||
| source_annualreportlog_id | integer | YES | |||
| source_deathnotification_id | integer | YES | |||
| source_document_id | integer | YES | |||
| source_warning_id | integer | YES | |||
| source_clientriskscore_id | integer | YES | |||
| source_order_id | integer | YES | |||
| reportingperiodenddate | date | YES | |||
| reportingperiodstartdate | date | YES |