Finance Remission and Exemptions Table - Sirius Case Management

Contains details of deputies who have investigations in the database

Stability: The investigation table is to be considered unstable .

Analytical Platform : Yes

Alternative formats : JSON

investigation table columns

Column Name	Column Type	Character Maximum	Is Nullable	Default	Constrained values
id	integer		NO
caseitem_id	integer		YES
investigationtitle	character varying	255	YES	NULL::character varying
additionalinformation	text		YES
investigationreceiveddate	date		YES
reportapprovaldate	date		YES
createdtime	date		YES
reportapprovaloutcome	character varying	255	YES	NULL::character varying
approvinguser_id	integer		YES
type	character varying	255	YES	NULL::character varying
riskassessmentdate	date		YES
investigationclosuredate	date		YES
person_id	integer		YES