Annual Report Lodging Details Table - Sirius Case Management
Contains details of annual reports lodging associated with deputies
Stability: The annual_report_lodging_details 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 | |||
| annual_report_log_id | integer | YES | |||
| digidepsreport | boolean | YES | |||
| deadlinedate | date | YES | |||
| reasonfordetermination | text | YES | |||
| datereportlodged | date | YES | |||
| lodgedstatus | character varying | 255 | YES | NULL::character varying |
ACKNOWLEDGED, ACKNOWLEDGED_FURTHER_CASEWORK, INCOMPLETE, REFERRED_FOR_REVIEW, |
| bankstatementsreceived | boolean | YES | |||
| resubmitteddate | date | YES | |||
| bankstatementdeadlinedate | date | YES | |||
| lodgedby_id | integer | YES |