Cases Table - Sirius Case Management
Contains details of LPA, Supervision and Guardianship cases
Stability: The cases 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 | |||
| assignee_id | integer | YES | |||
| donor_id | integer | YES | |||
| correspondent_id | integer | YES | |||
| client_id | integer | YES | |||
| oldcaseid | integer | YES | |||
| applicationtype | integer | YES |
Classic, Online, |
||
| title | character varying | 255 | YES | NULL::character varying | |
| casetype | character varying | 255 | NO | NULL::character varying |
LPA, EPA, ORDER, |
| casesubtype | character varying | 255 | YES | NULL::character varying |
hw, pfa, |
| duedate | date | YES | |||
| registrationdate | date | YES | |||
| closeddate | date | YES | |||
| status | character varying | 255 | YES | NULL::character varying |
Cancelled, Imperfect, Invalid, Pending, Perfect, Registered, Rejected, Revoked, Withdrawn, |
| rejecteddate | timestamp without time zone | YES | NULL::timestamp without time zone | ||
| caseattorneysingular | boolean | YES | false | ||
| caseattorneyjointlyandseverally | boolean | YES | false | ||
| caseattorneyjointly | boolean | YES | false | ||
| caseattorneyjointlyandjointlyandseverally | boolean | YES | false | ||
| caseattorneyactionadditionalinfo | boolean | YES | false | ||
| repeatapplication | boolean | YES | false | ||
| repeatapplicationreference | character varying | 255 | YES | NULL::character varying | |
| uid | character varying | 36 | NO | ||
| type | character varying | 255 | NO | ||
| ascertained_by | integer | YES | 1 | ||
| lpadonorsignaturedate | date | YES | |||
| lpadonorsignature | boolean | YES | |||
| donorsignaturewitnessed | boolean | YES | false | ||
| lpadonorsignatoryfullname | character varying | 255 | YES | NULL::character varying | |
| donorhaspreviouslpas | boolean | YES | false | ||
| previouslpainfo | text | YES | |||
| applicantsignaturedate | date | YES | |||
| applicantsignatoryfullname | character varying | 255 | YES | NULL::character varying | |
| createddate | timestamp without time zone | YES | NULL::timestamp without time zone | ||
| lifesustainingtreatment | character varying | 255 | YES | NULL::character varying | |
| lifesustainingtreatmentsignaturedatea | date | YES | |||
| lifesustainingtreatmentsignaturedateb | date | YES | |||
| trustcorporationsignedas | integer | YES | 1 | ||
| hasrelativetonotice | boolean | YES | false | ||
| areallattorneysapplyingtoregister | boolean | YES | false | ||
| epadonorsignaturedate | date | YES | |||
| epadonornoticegivendate | date | YES | |||
| donorhasotherepas | boolean | YES | false | ||
| otherepainfo | text | YES | |||
| usesnotifiedpersons | boolean | YES | false | ||
| nonoticegiven | boolean | YES | false | ||
| notifiedpersonpermissionby | integer | YES | 1 | ||
| paymentbydebitcreditcard | integer | YES | 0 | ||
| paymentbycheque | integer | YES | 0 | ||
| haveappliedforfeeremission | integer | YES | 0 | ||
| cardpaymentcontact | text | YES | |||
| howattorneysact | character varying | 255 | YES | NULL::character varying |
JOINTLY, SEVERALLY, JOINTLY_AND_SEVERALLY, |
| howreplacementattorneysact | character varying | 255 | YES | NULL::character varying |
JOINTLY, SEVERALLY, JOINTLY_AND_SEVERALLY, |
| attorneyactdecisions | character varying | 255 | YES | NULL::character varying |
When Registered, Loss of capacity, |
| replacementattorneyactdecisions | character varying | 255 | YES | NULL::character varying |
When Registered, Loss of capacity, |
| replacementorder | text | YES | |||
| additionalinfo | text | YES | |||
| anyotherinfo | boolean | YES | false | ||
| additionalinfodonorsignature | boolean | YES | false | ||
| additionalinfodonorsignaturedate | date | YES | |||
| paymentid | character varying | 255 | YES | NULL::character varying | |
| paymentamount | character varying | 255 | YES | NULL::character varying | |
| paymentdate | date | YES | |||
| paymentremission | integer | YES | 0 | ||
| paymentexemption | integer | YES | 0 | ||
| attorneypartydeclaration | integer | YES | 1 | ||
| attorneyapplicationassertion | integer | YES | 1 | ||
| attorneymentalactpermission | integer | YES | 1 | ||
| attorneydeclarationsignaturedate | date | YES | |||
| attorneydeclarationsignature | boolean | YES | |||
| attorneydeclarationsignaturewitness | boolean | YES | false | ||
| attorneydeclarationsignatoryfullname | character varying | 255 | YES | NULL::character varying | |
| correspondentcomplianceassertion | integer | YES | 1 | ||
| notificationdate | date | YES | |||
| dispatchdate | date | YES | |||
| cancellationdate | date | YES | |||
| applicantsdeclaration | integer | YES | 1 | ||
| applicantsdeclarationsignaturedate | date | YES | |||
| applicationhasrestrictions | boolean | YES | |||
| applicationhasguidance | boolean | YES | |||
| applicationhascharges | boolean | YES | false | ||
| certificateprovidersignaturedate | date | YES | |||
| certificateprovidersignature | boolean | YES | |||
| attorneystatementdate | date | YES | |||
| signingonbehalfdate | date | YES | |||
| signingonbehalffullname | character varying | 255 | YES | NULL::character varying | |
| noticegivendate | date | YES | |||
| orderdate | date | YES | |||
| orderissuedate | date | YES | |||
| securitybond | boolean | YES | false | ||
| bondreferencenumber | character varying | 255 | YES | NULL::character varying | |
| bondvalue | double precision | YES | |||
| orderstatus | character varying | 255 | YES | NULL::character varying |
ACTIVE, DUPLICATE, OPEN, CLOSED, |
| statusdate | date | YES | |||
| caserecnumber | character varying | 255 | YES | NULL::character varying | |
| filelocationdescription | character varying | 255 | YES | NULL::character varying | |
| feepayer_id | integer | YES | |||
| paymentpostponement | integer | YES | 0 | ||
| invaliddate | date | YES | |||
| withdrawndate | date | YES | |||
| revokeddate | date | YES | |||
| receiptdate | timestamp without time zone | YES | NULL::timestamp without time zone | ||
| batchid | character varying | 255 | YES | NULL::character varying | |
| howdeputyappointed | character varying | 255 | YES | NULL::character varying |
SOLE, JOINT, JOINTANDSEVERALLY, |
| onlinelpaid | character varying | 12 | YES | NULL::character varying | |
| orderstatusnotes | text | YES | |||
| orderexpirydate | date | YES | |||
| orderclosurereason | character varying | 255 | YES | NULL::character varying |
CLIENT DECEASED, FULL ORDER EXPIRED, ORDER REVOKED, FUNDS EXHAUSTED, CLIENT REGAINED CAPACITY, DEPUTY DISCHARGED, DEPUTY DECEASED, NO FURTHER PROCEEDINGS, OTHER, |
| ordersubtype | character varying | 255 | YES | NULL::character varying |
NEW DEPUTY, INTERIM ORDER, REPLACEMENT, SUPPLEMENTARY, TENANCY, TRUSTEE, VARIATION, DIRECTION, GUARDIANSHIP, |
| ordernotes | text | YES | |||
| updateddate | timestamp without time zone | YES | NULL::timestamp without time zone | ||
| clauseexpirydate | timestamp without time zone | YES | |||
| madeactivedate | date | YES | |||
| workeddate | date | YES | |||
| closedondate | timestamp without time zone | YES | NULL::timestamp without time zone |