1. Date Dictionary
  2. Sirius
  3. Persons

Persons Table - Sirius Case Management

The persons table includes data on people within the Sirius system. It contains both LPA, Guardianship and Supervision data, as well as data relating to persons who are informed parties.

Stability: The persons table is to be considered unstable .

Analytical Platform : Yes

Alternative formats : JSON

persons table columns
Column Name Column Type Character Maximum Is Nullable Default Constrained values
id integer NO
parent_id integer YES
email character varying 255 YES NULL::character varying
dob date YES
dateofdeath date YES
salutation character varying 255 YES NULL::character varying
firstname character varying 255 YES NULL::character varying
middlenames character varying 255 YES NULL::character varying
surname character varying 255 YES NULL::character varying
othernames character varying 255 YES NULL::character varying
correspondencebypost boolean NO
correspondencebyphone boolean NO
correspondencebyemail boolean NO
occupation character varying 255 YES NULL::character varying
createddate timestamp without time zone YES NULL::timestamp without time zone
uid character varying 36 NO
type character varying 255 NO lpa_attorney,
lpa_replacement_attorney,
lpa_trust_corporation,
lpa_correspondent,
lpa_donor,
lpa_notified_person,
lpa_certificate_provider,
actor_non_case_contact,
actor_notified_relative,
actor_notified_attorney,
actor_notified_donor,
actor_client,
actor_contact,
actor_deputy,
actor_fee_payer,
lpa002signaturedate date YES
dxnumber character varying 255 YES NULL::character varying
dxexchange character varying 255 YES NULL::character varying
lpapartcsignaturedate date YES
companyname character varying 255 YES NULL::character varying
companynumber character varying 255 YES NULL::character varying
systemstatus boolean YES true
relationshiptodonor character varying 255 YES NULL::character varying
trustcorporationappointedas character varying 255 YES NULL::character varying
signatoryone character varying 255 YES NULL::character varying
signatorytwo character varying 255 YES NULL::character varying
companyseal character varying 255 YES NULL::character varying
previousnames character varying 255 YES NULL::character varying
cannotsignform boolean YES
applyingforfeeremission boolean YES
receivingbenefits boolean YES
receiveddamageaward boolean YES
haslowincome boolean YES
signaturedate date YES
haspreviouslpa boolean YES
notesforpreviouslpa character varying 255 YES NULL::character varying
sageid character varying 255 YES NULL::character varying
noticegivendate date YES
certificateproviderstatementtype character varying 255 YES NULL::character varying
statement character varying 255 YES NULL::character varying
certificateproviderskills character varying 255 YES NULL::character varying
caserecnumber character varying 255 YES NULL::character varying
clientaccommodation character varying 255 YES NULL::character varying NO ACCOMMODATION TYPE,
COUNCIL RENTED,
FAMILY MEMBER/FRIEND'S HOME,
SUPERVISED SHELTERED,
HOUSING ASSOCIATION,
HOTEL,
HOSTEL,
HEALTH SERVICE PATIENT,
LA NURSING HOME OR RESIDENTIAL HOME,
NHS ACCOMMODATION,
NO FIXED ADDRESS,
CARE/NURSING/RESIDENTIAL HOME (PRIVATE/LA/REGISTERED),
maritalstatus character varying 255 YES NULL::character varying
clientstatus character varying 255 YES NULL::character varying OPEN,
ACTIVE,
INACTIVE,
DECEASED,
CLOSED,
DUPLICATE,
REGAINED_CAPACITY,
DEATH_CONFIRMED,
DEATH_NOTIFIED,
statusdate date YES
deputyreferencenumber character varying 255 YES NULL::character varying
deputycompliance character varying 255 YES NULL::character varying
relationshiptoclient character varying 255 YES NULL::character varying SIBLING,
SPOUSE,
CHILD,
PARENT,
CIVIL,
FRIEND,
PARTNER,
OTHERRELATION,
PANEL,
BANK,
SOLICITOR,
ACCOUNTANT,
UNREGULATED,
LEGAL,
TRUST,
OTHERPROFESSIONAL,
LOCAL,
NHS,
PCT,
correspondencebywelsh boolean NO false
medicalcondition text YES
interpreterrequired character varying 255 YES NULL::character varying
mobilenumber character varying 30 YES NULL::character varying
countryofresidence character varying 40 YES NULL::character varying
newsletter boolean YES false
specialcorrespondencerequirements_audiotape boolean NO false
specialcorrespondencerequirements_largeprint boolean NO false
specialcorrespondencerequirements_hearingimpaired boolean NO false
specialcorrespondencerequirements_spellingofnamerequirescare boolean NO false
client_id integer YES
companyreference character varying 255 YES
feepayer_id integer YES
isorganisation boolean YES false
correspondencename character varying 200 YES NULL::character varying
deputystatus character varying 255 YES NULL::character varying DEPUTY_STATUS_ACTIVE,
DEPUTY_STATUS_DEATH_NOTIFIED,
DEPUTY_STATUS_DECEASED,
DEPUTY_STATUS_ERROR,
DEPUTY_STATUS_INACTIVE,
casesmanagedashybrid boolean YES false
deputytype character varying 255 YES NULL::character varying LAY,
PRO,
PA,
supervisioncaseowner_id integer YES
clientsource character varying 255 YES NULL::character varying SIRIUS,
SERVOPG,
SKELETON,
CASRECMIGRATION,
CASRECMIGRATION_P2,
FULLY_MIGRATED,
memorablephrase character varying 30 YES NULL::character varying
risk_score integer YES
updateddate timestamp without time zone YES NULL::timestamp without time zone
executor_id integer YES
deputycasrecid integer YES
organisationname character varying 255 YES NULL::character varying
organisationteamordepartmentname character varying 255 YES NULL::character varying
deputynumber integer YES
executivecasemanager_id integer YES
deputysubtype character varying 255 YES NULL::character varying PERSON,
ORGANISATION,
firm_id integer YES
activecasetype character varying 255 YES NULL::character varying
debtchaseactive boolean YES