1. Date Dictionary
  2. Sirius
  3. public.persons

public.persons

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
lpapartcsignaturedate date YES
parent_id integer YES
dob date YES
dateofdeath date YES
correspondencebypost boolean NO
correspondencebyphone boolean NO
correspondencebyemail boolean NO
createddate timestamp without time zone YES NULL::timestamp without time zone
lpa002signaturedate date YES
id integer NO
systemstatus boolean YES true
cannotsignform boolean YES
applyingforfeeremission boolean YES
receivingbenefits boolean YES
receiveddamageaward boolean YES
haslowincome boolean YES
signaturedate date YES
haspreviouslpa boolean YES
noticegivendate date YES
statusdate date YES
correspondencebywelsh boolean NO 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
feepayer_id integer YES
isorganisation boolean YES false
casesmanagedashybrid boolean YES false
supervisioncaseowner_id integer YES
risk_score integer YES
updateddate timestamp without time zone YES NULL::timestamp without time zone
executor_id integer YES
deputycasrecid integer YES
deputynumber integer YES
executivecasemanager_id integer YES
firm_id integer YES
debtchaseactive boolean YES
isbondprovidercontact boolean YES false
deletedat timestamp without time zone YES NULL::timestamp without time zone
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,
email character varying 255 YES NULL::character varying
correspondencename character varying 200 YES NULL::character varying
deputyreferencenumber character varying 255 YES NULL::character varying
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
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,
deputystatus character varying 255 YES NULL::character varying DEPUTY_STATUS_ACTIVE,
DEPUTY_STATUS_DEATH_NOTIFIED,
DEPUTY_STATUS_DECEASED,
DEPUTY_STATUS_ERROR,
DEPUTY_STATUS_INACTIVE,
occupation character varying 255 YES NULL::character varying
medicalcondition text YES
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,
interpreterrequired character varying 255 YES NULL::character varying
dxnumber character varying 255 YES NULL::character varying
dxexchange character varying 255 YES NULL::character varying
mobilenumber character varying 30 YES NULL::character varying
companyname character varying 255 YES NULL::character varying
companynumber character varying 255 YES NULL::character varying
countryofresidence character varying 40 YES NULL::character varying
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
deputysubtype character varying 255 YES NULL::character varying PERSON,
ORGANISATION,
deputytype character varying 255 YES NULL::character varying LAY,
PRO,
PA,
activecasetype character varying 255 YES NULL::character varying
clientsource character varying 255 YES NULL::character varying SIRIUS,
SERVOPG,
SKELETON,
CASRECMIGRATION,
CASRECMIGRATION_P2,
FULLY_MIGRATED,
memorablephrase character varying 30 YES NULL::character varying
companyreference character varying 255 YES
organisationname character varying 255 YES NULL::character varying
notesforpreviouslpa character varying 255 YES NULL::character varying
sageid character varying 255 YES NULL::character varying
organisationteamordepartmentname character varying 255 YES NULL::character varying