Annual Report Logs Table - Sirius Case Management

Contains details of annual reports associated with deputies

Stability: The annual_report_logs table is to be considered unstable .

Analytical Platform : Yes

Alternative formats : JSON

annual_report_logs table columns

Column Name	Column Type	Character Maximum	Is Nullable	Default	Constrained values
id	integer		NO
duedate	date		NO
reportingperiodenddate	date		NO
revisedduedate	date		YES
numberofchaseletters	integer		NO
lodgingchecklistdocument_id	integer		YES
reportingperiodstartdate	date		NO
client_id	integer		NO
status	character varying	255	YES	NULL::character varying	CATEGORY, PENDING, DUE, OVERDUE, NON_COMPLIANT, RECEIVED, LODGED, ABANDONED, INCOMPLETE,
receiveddate	date		YES
abandoneddate	date		YES
reasonforabandonment	text		YES
casesupervisionlevel	character varying	255	YES	NULL::character varying	GENERAL, MINIMAL,
reviewstatus	character varying	255	YES	NULL::character varying	CATEGORY, NO_REVIEW, RANDOM, STAFF_PRESELECTED, STAFF_REFERRED, REVIEWED,
reasonforreviewstatuschange	text		YES
reviewdecision	character varying	255	YES	NULL::character varying	NO_FURTHER_ACTION_REQUIRED, FURTHER_CASE_WORK, CASE_ESCALATED,
reasonforfinaldecision	text		YES
reviewdate	date		YES
order_id	integer		YES
reviewedby_id	integer		YES
randomreviewdate	date		YES