poa.investigation

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
person_id	integer		YES
caseitem_id	integer		YES
approvinguser_id	integer		YES
riskassessmentdate	date		YES
investigationclosuredate	date		YES
id	integer		NO
investigationreceiveddate	date		YES
reportapprovaldate	date		YES
createdtime	date		YES
investigationtitle	character varying	255	YES	NULL::character varying
additionalinformation	text		YES
type	character varying	255	YES	NULL::character varying
reportapprovaloutcome	character varying	255	YES	NULL::character varying