CARE_LEAVERS ERD

Table Field Previews

Tables in domain: 3

ssd_care_leavers

Field	Type	Notes
clea_table_id	nvarchar	PK
clea_person_id	nvarchar	FK → ssd_person
clea_care_leaver_eligibility	nvarchar
clea_care_leaver_in_touch	nvarchar
clea_care_leaver_latest_contact	datetime
clea_care_leaver_accommodation	nvarchar
clea_care_leaver_accom_suitable	nvarchar
clea_care_leaver_activity	nvarchar
clea_pathway_plan_review_date	datetime
clea_care_leaver_personal_advisor	nvarchar
clea_care_leaver_allocated_team	nvarchar	FK → ssd_department
clea_care_leaver_worker_id	nvarchar	FK → ssd_professionals

ssd_cla_previous_permanence

Field	Type	Notes
lapp_table_id	nvarchar	PK
lapp_person_id	nvarchar	FK → ssd_cla_episodes
lapp_previous_permanence_order_date	nvarchar
lapp_previous_permanence_option	nvarchar
lapp_previous_permanence_la	nvarchar

ssd_permanence

Field	Type	Notes
perm_table_id	nvarchar	PK
perm_person_id	nvarchar	FK → ssd_cla_episodes
perm_cla_id	nvarchar
perm_adm_decision_date	datetime
perm_ffa_cp_decision_date	datetime
perm_placement_order_date	datetime
perm_placed_for_adoption_date	datetime
perm_matched_date	datetime
perm_adopted_by_carer_flag	nchar
perm_placed_ffa_cp_date	datetime
perm_decision_reversed_date	datetime
perm_placed_foster_carer_date	datetime
perm_part_of_sibling_group	nchar
perm_siblings_placed_together	int
perm_siblings_placed_apart	int
perm_placement_provider_urn	nvarchar
perm_decision_reversed_reason	nvarchar
perm_permanence_order_date	datetime
perm_permanence_order_type	nvarchar
perm_adoption_worker_id	nvarchar	FK → ssd_professionals
perm_adopter_sex	nvarchar
perm_adopter_legal_status	nvarchar
perm_number_of_adopters	nvarchar