Standard Safeguarding Dataset: Object Concept Model

Last updated:07-06-2024 12:44

Objects Overview:

This page shows how the Standard Safeguarding Dataset's tables relate, and details the structure of each table. Right click and open the image in a new browser tab to zoom/magnify/scroll object level detail. Data item id numbers [AAA000A] enable specific item/field referencing.

This is work in progress subject to frequent change; Data objects and item definitions are published here to support iterative development. Diagrams consisdered as conceptual interpretations, not a true relational/representational model

Object/Data item key:

Existing - Current returned data
Local - Recorded locally but not currently included in any data collections
1aDraft - Suggested new item for SSD
1bDraft - Suggested new item for one of the 1b projects
1bSpecified - Final specified item for one of the 1b projects
1aRemove - Specified item rejected from final spec.
1aNotInCMS - Currently exists but commonly outside Social Care CMS. (SSD==Placeholder data)

Note: Colour identifiers on Overview image indicate presence of at least one known change. See below tables for the item level changes/additions with granular colour-coding.

Object Data Points Overview:

Object name: ssd_address

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
ADDR007A	addr_table_id	liquid_logic, mosaic	identity, address	Local
ADDR001A	addr_address_json	liquid_logic, mosaic, eclipse, caredirector, azeus	identity, address	Local
ADDR002A	addr_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	identity, address	Local
ADDR003A	addr_address_type	liquid_logic, mosaic	identity, address	Local
ADDR004A	addr_address_start_date	liquid_logic, mosaic	identity, address	Local
ADDR005A	addr_address_end_date	liquid_logic, mosaic	identity, address	Local
ADDR006A	addr_address_postcode	liquid_logic, mosaic, eclipse, caredirector, azeus	identity, address	SSDA903, AnnexA, SEN2

Object name: ssd_cla_health

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
CLAH001A	clah_health_check_id		looked_after, health	Local
CLAH002A	clah_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	looked_after, health	Local
CLAH003A	clah_health_check_type	liquid_logic, mosaic	looked_after, health	SSDA903, AnnexA
CLAH004A	clah_health_check_date	liquid_logic, mosaic	looked_after, health	SSDA903, AnnexA
CLAH005A	clah_health_check_status	liquid_logic, mosaic	looked_after, health	SSDA903, AnnexA

Object name: ssd_cla_care_plan

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
LACP001A	lacp_table_id	liquid_logic, mosaic	looked_after, care_plan	Local
LACP007A	lacp_person_id	liquid_logic, mosaic	looked_after, care_plan	Local
LACP004A	lacp_cla_care_plan_start_date	liquid_logic, mosaic	looked_after, care_plan	Local
LACP005A	lacp_cla_care_plan_end_date	liquid_logic, mosaic	looked_after, care_plan	Local
LACP003A	lacp_cla_care_plan_json	liquid_logic, mosaic	looked_after, care_plan	AnnexA

Object name: ssd_cp_reviews

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
CPPR001A	cppr_cp_review_id	liquid_logic, mosaic	child_protection, cp_plan, review	Local
CPPR008A	cppr_person_id	liquid_logic, mosaic	child_protection, cp_plan, review	Local
CPPR002A	cppr_cp_plan_id	liquid_logic, mosaic	child_protection, cp_plan, review	Local
CPPR003A	cppr_cp_review_due	liquid_logic, mosaic	child_protection, cp_plan, review	Local
CPPR004A	cppr_cp_review_date	liquid_logic, mosaic	child_protection, cp_plan, review	CIN, AnnexA
CPPR009A	cppr_cp_review_meeting_id		child_protection, cp_plan, review	Local
CPPR005A	cppr_cp_review_outcome_continue_cp	liquid_logic, mosaic	child_protection, cp_plan, review	Local
CPPR006A	cppr_cp_review_quorate	liquid_logic, mosaic	child_protection, cp_plan, review	Local
CPPR007A	cppr_cp_review_participation	liquid_logic, mosaic	child_protection, cp_plan, review	Local

Object name: ssd_contacts

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
CONT001A	cont_contact_id	liquid_logic, mosaic	contact	Local
CONT002A	cont_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	contact	Local
CONT003A	cont_contact_date	liquid_logic, mosaic, azeus	contact	AnnexA, RIIA
CONT004A	cont_contact_source_code	liquid_logic, mosaic, azeus	contact	AnnexA, RIIA
CONT006A	cont_contact_source_desc		contact	Local
CONT005A	cont_contact_outcome_json	liquid_logic, mosaic	contact	ADCS_SP, RIIA

Object name: ssd_disability

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
DISA001A	disa_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	identity, disability	Local
DISA003A	disa_table_id	liquid_logic, mosaic	identity, disability	Local
DISA002A	disa_disability_code	liquid_logic, mosaic	identity, disability	CIN, AnnexA

Object name: ssd_cin_episodes

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
CINE001A	cine_referral_id	liquid_logic, mosaic	child_in_need, referral	Loca;
CINE002A	cine_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	child_in_need	Local
CINE003A	cine_referral_date	liquid_logic, mosaic	child_in_need, referral	CIN, AnnexA, RIIA
CINE010A	cine_cin_primary_need_code	liquid_logic, mosaic	child_in_need, referral	CIN, AnnexA, RIIA
CINE004A	cine_referral_source_code	liquid_logic, mosaic	child_in_need, referral	CIN, AnnexA, RIIA
CINE012A	cine_referral_source_desc		child_in_need, referral	Local
CINE005A	cine_referral_outcome_json	liquid_logic, mosaic	child_in_need, referral	AnnexA, RIIA
CINE011A	cine_referral_nfa	liquid_logic, mosaic	child_in_need, referral	CIN, AnnexA, RIIA
CINE006A	cine_close_reason	liquid_logic, mosaic	child_in_need	CIN, RIIA
CINE007A	cine_close_date	liquid_logic, mosaic	child_in_need	CIN, RIIA
CINE008A	cine_referral_team	liquid_logic, mosaic	child_in_need, referral	AnnexA, RIIA
CINE009A	cine_referral_worker_id	liquid_logic, mosaic	child_in_need, referral	AnnexA, RIIA

Object name: ssd_department

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
DEPT1001A	dept_team_id	liquid_logic, mosaic	workforce	Local
DEPT1002A	dept_team_name	liquid_logic, mosaic	workforce	Local,AnnexA
DEPT1003A	dept_team_parent_id	liquid_logic, mosaic	workforce	Local
DEPT1004A	dept_team_parent_name	liquid_logic, mosaic	workforce	Local

Object name: ssd_sdq_scores

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
CSDQ001A	csdq_table_id	liquid_logic, mosaic	looked_after, sdq	Local
CSDQ002A	csdq_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	looked_after, sdq	Local
CSDQ003A	csdq_sdq_completed_date	liquid_logic, mosaic	looked_after, sdq	Local
CSDQ004A	csdq_sdq_reason	liquid_logic, mosaic	looked_after, sdq	SSDA903
CSDQ005A	csdq_sdq_score	liquid_logic, mosaic	looked_after, sdq	SSDA903

Object name: ssd_cla_substance_misuse

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
CLAS001A	clas_substance_misuse_id	liquid_logic, mosaic	looked_after, health, substance_misuse	Local
CLAS002A	clas_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	looked_after, health, substance_misuse	Local
CLAS003A	clas_substance_misuse_date	liquid_logic, mosaic	looked_after, health, substance_misuse	SSDA903
CLAS004A	clas_substance_misused	liquid_logic, mosaic	looked_after, health, substance_misuse	Local
CLAS005A	clas_intervention_received	liquid_logic, mosaic	looked_after, health, substance_misuse	SSDA903

Object name: ssd_s251_finance

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
S251001A	s251_table_id	liquid_logic, mosaic	finance	1aDraft
S251002A	s251_cla_placement_id	liquid_logic, mosaic	finance	1aDraft
S251003A	s251_placeholder_1	liquid_logic, mosaic	finance	1aDraft
S251004A	s251_placeholder_2	liquid_logic, mosaic	finance	1aDraft
S251005A	s251_placeholder_3	liquid_logic, mosaic	finance	1aDraft
S251006A	s251_placeholder_4	liquid_logic, mosaic	finance	1aDraft

Object name: ssd_s47_enquiry

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
S47E001A	s47e_s47_enquiry_id	liquid_logic, mosaic	s47_enquiry, child_protection	Local
S47E010A	s47e_referral_id	liquid_logic, mosaic	s47_enquiry, child_protection	Local
S47E002A	s47e_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	s47_enquiry, child_protection	Local
S47E004A	s47e_s47_start_date	liquid_logic, mosaic	s47_enquiry, child_protection	CIN, RIIA, AnnexA
S47E005A	s47e_s47_end_date	liquid_logic, mosaic	s47_enquiry, child_protection	RIIA, AnnexA
S47E006A	s47e_s47_nfa	liquid_logic, mosaic	s47_enquiry, child_protection	AnnexA
S47E007A	s47e_s47_outcome_json	liquid_logic, mosaic	s47_enquiry, child_protection	Local
S47E008A	s47e_s47_completed_by_worker_id		s47_enquiry, child_protection	Local
S47E009A	s47e_s47_completed_by_team		s47_enquiry, child_protection	Local

Object name: ssd_linked_identifiers

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
LINK001A	link_table_id	liquid_logic, mosaic	linked_identifiers	1aNotInCMS
LINK002A	link_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	linked_identifiers	Local
LINK003A	link_identifier_type	liquid_logic, mosaic	linked_identifiers	1aNotInCMS
LINK004A	link_identifier_value	liquid_logic, mosaic	linked_identifiers	1aNotInCMS
LINK005A	link_valid_from_date	liquid_logic, mosaic	linked_identifiers	1aNotInCMS
LINK006A	link_valid_to_date	liquid_logic, mosaic	linked_identifiers	1aNotInCMS

Object name: ssd_legal_status

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
LEGA001A	lega_legal_status_id	liquid_logic, mosaic	identity, looked_after	Local
LEGA002A	lega_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	identity, looked_after	Local
LEGA003A	lega_legal_status	liquid_logic, mosaic	identity, looked_after	SSDA903, AnnexA, RIIA
LEGA004A	lega_legal_status_start_date	liquid_logic, mosaic	identity, looked_after	RIIA
LEGA005A	lega_legal_status_end_date	liquid_logic, mosaic	identity, looked_after	RIIA

Object name: ssd_cla_previous_permanence

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
LAPP001A	lapp_table_id	liquid_logic, mosaic	looked_after, permanence	Local
LAPP002A	lapp_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	looked_after, permanence	Local
LAPP003A	lapp_previous_permanence_order_date	liquid_logic, mosaic	looked_after, permanence	SSDA903
LAPP004A	lapp_previous_permanence_option	liquid_logic, mosaic	looked_after, permanence	SSDA903
LAPP005A	lapp_previous_permanence_la	liquid_logic, mosaic	looked_after, permanence	SSDA903

Object name: ssd_ehcp_assessment

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
EHCA001A	ehca_ehcp_assessment_id	liquid_logic	send, ehcp_request, ehcp_assessment	1aNotInCMS, RIIA
EHCA002A	ehca_ehcp_request_id	liquid_logic	send, ehcp_request, ehcp_assessment	1aNotInCMS
EHCA003A	ehca_ehcp_assessment_outcome_date	liquid_logic	send, ehcp_request, ehcp_assessment	1aNotInCMS, SEN2, RIIA, SEN2
EHCA004A	ehca_ehcp_assessment_outcome	liquid_logic	send, ehcp_request, ehcp_assessment	1aNotInCMS, SEN2, RIIA, SEN2
EHCA005A	ehca_ehcp_assessment_exceptions	liquid_logic	send, ehcp_request, ehcp_assessment	1aNotInCMS, SEN2, RIIA, SEN2

Object name: ssd_care_leavers

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
CLEA001A	clea_table_id	liquid_logic, mosaic	care_leavers	Local
CLEA002A	clea_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	care_leavers	Local
CLEA003A	clea_care_leaver_eligibility	liquid_logic, mosaic	care_leavers	AnnexA, RIIA
CLEA004A	clea_care_leaver_in_touch	liquid_logic, mosaic	care_leavers	SSDA903, RIIA
CLEA005A	clea_care_leaver_latest_contact	liquid_logic, mosaic	care_leavers	AnnexA, RIIA
CLEA006A	clea_care_leaver_accommodation	liquid_logic, mosaic	care_leavers	SSDA903, RIIA, AnnexA
CLEA007A	clea_care_leaver_accom_suitable	liquid_logic, mosaic	care_leavers	AnnexA, RIIA
CLEA008A	clea_care_leaver_activity	liquid_logic, mosaic	care_leavers	SSDA903, RIIA, AnnexA
CLEA009A	clea_pathway_plan_review_date	liquid_logic, mosaic	care_leavers	AnnexA, RIIA
CLEA010A	clea_care_leaver_personal_advisor	liquid_logic, mosaic	care_leavers	AnnexA, RIIA
CLEA011A	clea_care_leaver_allocated_team	liquid_logic, mosaic	care_leavers	AnnexA, RIIA
CLEA012A	clea_care_leaver_worker_id	liquid_logic, mosaic	care_leavers	AnnexA, RIIA

Object name: ssd_ehcp_active_plans

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
EHCP001A	ehcp_active_ehcp_id	liquid_logic	send, ehcp_request, ehcp	1aNotInCMS
EHCP002A	ehcp_ehcp_request_id	liquid_logic	send, ehcp_request, ehcp	1aNotInCMS
EHCP003A	ehcp_active_ehcp_last_review_date	liquid_logic	send, ehcp_request, ehcp	1aNotInCMS, SEN2

Object name: ssd_send

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
SEND001A	send_table_id	liquid_logic	identity, send	1aNotInCMS, RIIA
SEND002A	send_upn	liquid_logic	identity, send	1aNotInCMS, RIIA, SEN2
SEND003A	send_uln	liquid_logic	identity, send	1aNotInCMS, RIIA, SEN2
SEND004A	send_upn_unknown	liquid_logic	identity, send	1aNotInCMS, RIIA, SEN2
SEND005A	send_person_id	liquid_logic	identity, send	1aNotInCMS, RIIA

Object name: ssd_voice_of_child

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns	Change Log
VOCH007A	voch_table_id	liquid_logic, mosaic	voice_of_child	1bDraft
VOCH001A	voch_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	voice_of_child	Local
VOCH002A	voch_explained_worries	liquid_logic, mosaic	voice_of_child	1bDraft	release: In review\|pending change_id: SSD-0023 change_source: 1bDraft versions_count: 1 impact_title: None type: New Feature
VOCH003A	voch_story_help_understand	liquid_logic, mosaic	voice_of_child	1bDraft	release: In review\|pending change_id: SSD-0024 change_source: 1bDraft versions_count: 1 impact_title: None type: New Feature
VOCH004A	voch_agree_worker	liquid_logic, mosaic	voice_of_child	1bDraft	release: In review\|pending change_id: SSD-0025 change_source: 1bDraft versions_count: 1 impact_title: None type: New Feature
VOCH005A	voch_plan_safe	liquid_logic, mosaic	voice_of_child	1bDraft	release: In review\|pending change_id: SSD-0026 change_source: 1bDraft versions_count: 1 impact_title: None type: New Feature
VOCH006A	voch_tablet_help_explain	liquid_logic, mosaic	voice_of_child	1bDraft	release: In review\|pending change_id: SSD-0027 change_source: 1bDraft versions_count: 1 impact_title: None type: New Feature

Object name: ssd_cla_immunisations

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
CLAI002A	clai_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	looked_after, health, immunisations	Local
CLAI004A	clai_immunisations_status	liquid_logic, mosaic	looked_after, health, immunisations	SSDA903
CLAI005A	clai_immunisations_status_date		looked_after, health, immunisations	Local

Object name: ssd_ehcp_named_plan

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
EHCN001A	ehcn_named_plan_id	liquid_logic	send, ehcp_request, ehcp_assessment	1aNotInCMS
EHCN002A	ehcn_ehcp_asmt_id	liquid_logic	send, ehcp_request, ehcp_assessment	1aNotInCMS
EHCN003A	ehcn_named_plan_start_date	liquid_logic	send, ehcp_request, ehcp_assessment	1aNotInCMS, SEN2
EHCN004A	ehcn_named_plan_ceased_date	liquid_logic	send, ehcp_request, ehcp_assessment	1aNotInCMS, SEN2
EHCN005A	ehcn_named_plan_ceased_reason	liquid_logic	send, ehcp_request, ehcp_assessment	1aNotInCMS, SEN2

Object name: ssd_cla_episodes

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
CLAE001A	clae_cla_episode_id	liquid_logic, mosaic	looked_after	RIIA
CLAE002A	clae_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	looked_after	Local
CLAE003A	clae_cla_episode_start_date	liquid_logic, mosaic	looked_after	SSDA903, RIIA, AnnexA
CLAE004A	clae_cla_episode_start_reason	liquid_logic, mosaic	looked_after	SSDA903, RIIA
CLAE009A	clae_cla_primary_need_code	liquid_logic, mosaic	looked_after	SSDA903, AnnexA, RIIA
CLAE005A	clae_cla_episode_ceased	liquid_logic, mosaic	looked_after	SSDA903, AnnexA, RIIA
CLAE006A	clae_cla_episode_ceased_reason	liquid_logic, mosaic	looked_after	SSDA903, AnnexA, RIIA
CLAE010A	clae_cla_id	liquid_logic, mosaic	looked_after	Local
CLAE011A	clae_referral_id	liquid_logic, mosaic	looked_after	Local
CLAE013A	clae_cla_placement_id	liquid_logic, mosaic	looked_after	Local
CLAE014A	clae_entered_care_date	liquid_logic, mosaic	looked_after	SSD903
CLAE012A	clae_cla_last_iro_contact_date	liquid_logic, mosaic	looked_after	AnnexA

Object name: ssd_early_help_episodes

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
EARL001A	earl_episode_id	liquid_logic, mosaic	early_help	Local
EARL002A	earl_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	early_help	Local
EARL003A	earl_episode_start_date	liquid_logic, mosaic	early_help	AnnexA, RIIA
EARL004A	earl_episode_end_date	liquid_logic, mosaic	early_help	AnnexA, RIIA
EARL005A	earl_episode_reason	liquid_logic, mosaic	early_help	ADCS_SP, RIIA
EARL006A	earl_episode_end_reason	liquid_logic, mosaic	early_help	ADCS_SP, RIIA
EARL007A	earl_episode_organisation	liquid_logic, mosaic	early_help	AnnexA, RIIA
EARL008A	earl_episode_worker_id	liquid_logic, mosaic	early_help	RIIA

Object name: ssd_pre_proceedings

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns	Change Log
PREP024A	prep_table_id	liquid_logic, mosaic	pre_proceedings	1bSpecified
PREP001A	prep_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	pre_proceedings	Local
PREP002A	prep_plo_family_id	liquid_logic, mosaic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0001 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP003A	prep_pre_pro_decision_date	liquid_logic, mosaic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0002 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP004A	prep_initial_pre_pro_meeting_date	liquid_logic, mosaic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0003 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP005A	prep_pre_pro_outcome	liquid_logic, mosaic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0004 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP006A	prep_agree_stepdown_issue_date	liquid_logic, mosaic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0005 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP007A	prep_cp_plans_referral_period	liquid_logic, mosaic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0006 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP008A	prep_legal_gateway_outcome	liquid_logic, mosaic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0007 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP009A	prep_prev_pre_proc_child	liquid_logic, mosaic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0008 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP010A	prep_prev_care_proc_child	liquid_logic, mosaic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0009 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP011A	prep_pre_pro_letter_date	liquid_logic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0010 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP012A	prep_care_pro_letter_date	liquid_logic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0011 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP013A	prep_pre_pro_meetings_num	liquid_logic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0012 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP014A	prep_pre_pro_parents_legal_rep	liquid_logic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0013 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP015A	prep_parents_legal_rep_point_of_issue	liquid_logic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0014 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP016A	prep_court_reference	liquid_logic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0015 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP017A	prep_care_proc_court_hearings	liquid_logic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0016 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP018A	prep_care_proc_short_notice	liquid_logic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0017 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP019A	prep_proc_short_notice_reason	liquid_logic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0018 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP020A	prep_la_inital_plan_approved	liquid_logic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0019 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP021A	prep_la_initial_care_plan	liquid_logic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0020 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP022A	prep_la_final_plan_approved	liquid_logic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0021 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature
PREP023A	prep_la_final_care_plan	liquid_logic	pre_proceedings	1bSpecified	release: In review\|pending change_id: SSD-0022 change_source: 1bSpecified versions_count: 1 impact_title: None type: New Feature

Object name: ssd_missing

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
MISS001A	miss_table_id	liquid_logic, mosaic	looked_after, missing	Local
MISS002A	miss_person_id	liquid_logic, mosaic	looked_after, missing	Local
MISS003A	miss_missing_episode_start_date	liquid_logic, mosaic	looked_after, missing	SSDA903, AnnexA
MISS004A	miss_missing_episode_type	liquid_logic, mosaic	looked_after, missing	SSDA903, AnnexA
MISS005A	miss_missing_episode_end_date	liquid_logic, mosaic	looked_after, missing	SSDA903, AnnexA
MISS006A	miss_missing_rhi_offered	liquid_logic, mosaic	looked_after, missing	AnnexA
MISS007A	miss_missing_rhi_accepted	liquid_logic, mosaic	looked_after, missing	AnnexA

Object name: ssd_involvements

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
INVO005A	invo_involvements_id	liquid_logic, mosaic	workforce	Local
INVO006A	invo_professional_id	liquid_logic, mosaic	workforce	Local
INVO007A	invo_professional_role_id	liquid_logic, mosaic	workforce	Local
INVO009A	invo_professional_team	liquid_logic, mosaic	workforce	AnnexA
INVO002A	invo_involvement_start_date	liquid_logic, azeus	workforce	RIIA
INVO003A	invo_involvement_end_date	liquid_logic, azeus	workforce	RIIA
INVO004A	invo_worker_change_reason	liquid_logic, azeus	workforce	RIIA
INVO011A	invo_person_id		workforce	Local
INVO010A	invo_referral_id	liquid_logic, mosaic	workforce	Local

Object name: ssd_immigration_status

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
IMMI001A	immi_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	identity, immigration, uasc	Local
IMMI005A	immi_immigration_status_id	liquid_logic, mosaic	identity, immigration, uasc	Local
IMMI002A	immi_immigration_status	liquid_logic, mosaic	identity, immigration, uasc	SSDA903, RIIA, AnnexA
IMMI003A	immi_immigration_status_start_date	liquid_logic, mosaic	identity, immigration, uasc	RIIA
IMMI004A	immi_immigration_status_end_date	liquid_logic, mosaic	identity, immigration, uasc	SSDA903, RIIA

Object name: ssd_family

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
FAMI003A	fami_table_id		identity, family	Local
FAMI001A	fami_family_id	liquid_logic, mosaic	identity, family	ASGLB, AnnexA
FAMI002A	fami_person_id	liquid_logic, mosaic	identity, family	Local

Object name: ssd_cin_plans

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
CINP001A	cinp_cin_plan_id	liquid_logic, mosaic	child_in_need, cin_plan	RIIA
CINP007A	cinp_referral_id	liquid_logic, mosaic	child_in_need, cin_plan	Local
CINP002A	cinp_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	child_in_need, cin_plan	Local
CINP003A	cinp_cin_plan_start_date	liquid_logic, mosaic	child_in_need, cin_plan	CIN, RIIA, AnnexA
CINP004A	cinp_cin_plan_end_date	liquid_logic, mosaic	child_in_need, cin_plan	RIIA, CIN, AnnexA
CINP005A	cinp_cin_plan_team	liquid_logic, mosaic	child_in_need, cin_plan	AnnexA, RIIA
CINP006A	cinp_cin_plan_worker_id	liquid_logic, mosaic	child_in_need, cin_plan	AnnexA, RIIA

Object name: ssd_mother

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
MOTH004A	moth_table_id		identity, looked_after, mother	Local
MOTH002A	moth_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	identity, looked_after, mother	Local
MOTH001A	moth_childs_person_id	liquid_logic, mosaic	identity, looked_after, mother	Local
MOTH003A	moth_childs_dob	liquid_logic, mosaic	identity, looked_after, mother	SSDA903, AnnexA

Object name: ssd_cin_assessments

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
CINA001A	cina_assessment_id	liquid_logic, mosaic	child_in_need, assessment	CIN, RIIA
CINA002A	cina_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	child_in_need, assessment	Local
CINA010A	cina_referral_id	liquid_logic, mosaic	child_in_need, assessment	Local
CINA003A	cina_assessment_start_date	liquid_logic, mosaic	child_in_need, assessment	CIN, RIIA
CINA004A	cina_assessment_child_seen	liquid_logic, mosaic	child_in_need, assessment	AnnexA, RIIA
CINA005A	cina_assessment_auth_date	liquid_logic, mosaic	child_in_need, assessment	CIN, RIIA, AnnexA
CINA006A	cina_assessment_outcome_json	liquid_logic, mosaic	child_in_need, assessment	AnnexA, RIIA
CINA009A	cina_assessment_outcome_nfa	liquid_logic, mosaic	child_in_need, assessment	CIN, RIIA, AnnexA
CINA007A	cina_assessment_team	liquid_logic, mosaic	child_in_need, assessment	AnnexA, RIIA
CINA008A	cina_assessment_worker_id	liquid_logic, mosaic	child_in_need, assessment	AnnexA, RIIA

Object name: ssd_cla_visits

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
CLAV001A	clav_cla_visit_id	liquid_logic, mosaic	looked_after, visit	Local
CLAV007A	clav_cla_id		looked_after, visit	Local
CLAV008A	clav_person_id	liquid_logic, mosaic	looked_after, visit	Local
CLAV003A	clav_cla_visit_date	liquid_logic, mosaic	looked_after, visit	AnnexA
CLAV004A	clav_cla_visit_seen	liquid_logic, mosaic	looked_after, visit	Local
CLAV005A	clav_cla_visit_seen_alone	liquid_logic, mosaic	looked_after, visit	Local

Object name: ssd_permanence

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
PERM001A	perm_table_id	liquid_logic, mosaic	looked_after, permanence, adoption	Local
PERM002A	perm_person_id	liquid_logic, mosaic	looked_after, permanence, adoption	Local
PERM022A	perm_cla_id	liquid_logic, mosaic	looked_after, permanence, adoption	Local
PERM003A	perm_adm_decision_date	liquid_logic, mosaic	looked_after, permanence, adoption	SSDA903, ASGLB
PERM004A	perm_ffa_cp_decision_date	liquid_logic, mosaic	looked_after, permanence, adoption	ASGLB, AnnexA
PERM006A	perm_placement_order_date	liquid_logic, mosaic	looked_after, permanence, adoption	SSDA903, AnnexA, ASGLB
PERM007A	perm_placed_for_adoption_date	liquid_logic, mosaic	looked_after, permanence, adoption	SSDA903, AnnexA, ASGLB
PERM008A	perm_matched_date	liquid_logic, mosaic	looked_after, permanence, adoption	SSDA903, AnnexA, ASGLB
PERM021A	perm_adopted_by_carer_flag	liquid_logic, mosaic	looked_after, permanence, adoption	SSDA903, AnnexA
PERM009A	perm_placed_ffa_cp_date	liquid_logic, mosaic	looked_after, permanence, adoption	AnnexA, ASGLB
PERM010A	perm_decision_reversed_date	liquid_logic, mosaic	looked_after, permanence, adoption	SSDA903, AnnexA, ASGLB
PERM011A	perm_placed_foster_carer_date	liquid_logic, mosaic	looked_after, permanence, adoption	AnnexA, ASGLB
PERM012A	perm_part_of_sibling_group	liquid_logic, mosaic	looked_after, permanence, adoption	ASGLB
PERM013A	perm_siblings_placed_together	liquid_logic, mosaic	looked_after, permanence, adoption	ASGLB
PERM014A	perm_siblings_placed_apart	liquid_logic, mosaic	looked_after, permanence, adoption	ASGLB
PERM015A	perm_placement_provider_urn	liquid_logic, mosaic	looked_after, permanence, adoption	Local
PERM016A	perm_decision_reversed_reason	liquid_logic, mosaic	looked_after, permanence, adoption	SSDA903, AnnexA, ASGLB
PERM017A	perm_permanence_order_date	liquid_logic, mosaic	looked_after, permanence	AnnexA, ASGLB
PERM018A	perm_permanence_order_type	liquid_logic, mosaic	looked_after, permanence	ASGLB
PERM023A	perm_adoption_worker_id	liquid_logic, mosaic	looked_after, permanence, adoption	Local
PERM025A	perm_adopter_sex		looked_after, permanence, adoption	SSDA903
PERM026A	perm_adopter_legal_status		looked_after, permanence, adoption	SSDA903
PERM027A	perm_number_of_adopters		looked_after, permanence, adoption	SSDA903

Object name: ssd_cla_reviews

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
CLAR001A	clar_cla_review_id	liquid_logic, mosaic	looked_after, review	Local
CLAR011A	clar_cla_id	liquid_logic, mosaic	looked_after, review	Local
CLAR003A	clar_cla_review_due_date	liquid_logic, mosaic	looked_after, review	Local
CLAR004A	clar_cla_review_date	liquid_logic, mosaic	looked_after, review	SSDA903, AnnexA
CLAR012A	clar_cla_review_cancelled		looked_after, review	Local
CLAR007A	clar_cla_review_participation	liquid_logic, mosaic	looked_after, review	SSDA903

Object name: ssd_ehcp_requests

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
EHCR001A	ehcr_ehcp_request_id	liquid_logic	send, ehcp_request	1aNotInCMS, RIIA
EHCR002A	ehcr_send_table_id	liquid_logic	identity, send, ehcp_request	1aNotInCMS
EHCR003A	ehcr_ehcp_req_date	liquid_logic	send, ehcp_request	1aNotInCMS, SEN2, RIIA, SEN2
EHCR004A	ehcr_ehcp_req_outcome_date	liquid_logic	send, ehcp_request	1aNotInCMS, SEN2, RIIA, SEN2
EHCR005A	ehcr_ehcp_req_outcome	liquid_logic	send, ehcp_request	1aNotInCMS, SEN2, RIIA, SEN2

Object name: ssd_cp_visits

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
CPPV007A	cppv_cp_visit_id		child_protection, cp_plan, visit	Local
CPPV008A	cppv_person_id	liquid_logic, mosaic	child_protection, cp_plan, visit	Local
CPPV001A	cppv_cp_plan_id	liquid_logic, mosaic	child_protection, cp_plan, visit	Local
CPPV003A	cppv_cp_visit_date	liquid_logic, mosaic	child_protection, cp_plan, visit	AnnexA
CPPV004A	cppv_cp_visit_seen	liquid_logic, mosaic	child_protection, cp_plan, visit	Local
CPPV005A	cppv_cp_visit_seen_alone	liquid_logic, mosaic	child_protection, cp_plan, visit	AnnexA
CPPV006A	cppv_cp_visit_bedroom	liquid_logic, mosaic	child_protection, cp_plan, visit	Local

Object name: ssd_person

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
PERS001A	pers_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	identity	SSDA903, CIN, AnnexA, RIIA, SEN2
PERS002A	pers_sex	liquid_logic, mosaic, eclipse, caredirector	identity	SSDA903, RIIA, AnnexA, SEN2
PERS003A	pers_gender	liquid_logic, mosaic, azeus	identity	CIN, RIIA
PERS004A	pers_ethnicity	liquid_logic, mosaic, azeus	identity	SSDA903, CIN, AnnexA, RIIA, SEN2
PERS005A	pers_dob	liquid_logic, mosaic, eclipse, caredirector, azeus	identity	SSDA903, CIN, AnnexA, RIIA, SEN2
PERS013A	pers_common_child_id	liquid_logic, mosaic, eclipse, caredirector, azeus	identity	Local
PERS014A	pers_legacy_id	liquid_logic, mosaic, eclipse, caredirector, azeus	identity	Local
PERS007A	pers_upn_unknown	liquid_logic, mosaic, azeus	identity	RIIA, CIN, SEN2
PERS008A	pers_send_flag	liquid_logic	identity	NEETandparticipation, RIIA
PERS009A	pers_expected_dob	liquid_logic, azeus	identity	CIN, RIIA
PERS010A	pers_death_date	liquid_logic, azeus	identity	CIN, RIIA
PERS011A	pers_is_mother	liquid_logic, azeus	identity	SSDA903, RIIA
PERS012A	pers_nationality	liquid_logic, mosaic	identity	ADCS_SP, RIIA

Object name: ssd_cla_convictions

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
CLAC001A	clac_cla_conviction_id	liquid_logic, mosaic	looked_after, convictions	Local
CLAC002A	clac_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	looked_after, convictions	Local
CLAC003A	clac_cla_conviction_date	liquid_logic, mosaic	looked_after, convictions	SSDA903
CLAC004A	clac_cla_conviction_offence		looked_after, convictions	Local

Object name: ssd_assessment_factors

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
CINF003A	cinf_table_id		child_in_need, assessment	Local
CINF001A	cinf_assessment_id	liquid_logic, mosaic	child_in_need, assessment	Local
CINF002A	cinf_assessment_factors_json	liquid_logic, mosaic	child_in_need, assessment	CIN

Object name: ssd_cp_plans

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
CPPL001A	cppl_cp_plan_id	liquid_logic, mosaic	child_protection, cp_plan	Local
CPPL007A	cppl_referral_id		child_protection, cp_plan	Local
CPPL008A	cppl_icpc_id	liquid_logic, mosaic	child_protection, cp_plan	Local
CPPL002A	cppl_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	child_protection, cp_plan	Local
CPPL003A	cppl_cp_plan_start_date	liquid_logic, mosaic	child_protection, cp_plan	CIN, AnnexA, RIIA
CPPL004A	cppl_cp_plan_end_date	liquid_logic, mosaic	child_protection, cp_plan	CIN, AnnexA, RIIA
CPPL009A	cppl_cp_plan_initial_category		child_protection, cp_plan	CIN, AnnexA
CPPL011A	cppl_cp_plan_ola		child_protection, cp_plan	Local
CPPL010A	cppl_cp_plan_latest_category		child_protection, cp_plan	CIN, AnnexA

Object name: ssd_sen_need

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
SENN001A	senn_table_id	liquid_logic	send, ehcp_request, ehcp, need	1aNotInCMS
SENN002A	senn_active_ehcp_id	liquid_logic	send, ehcp_request, ehcp, need	1aNotInCMS
SENN003A	senn_active_ehcp_need_type	liquid_logic	send, ehcp_request, ehcp, need	1aNotInCMS, SEN2
SENN004A	senn_active_ehcp_need_rank	liquid_logic	send, ehcp_request, ehcp, need	1aNotInCMS, SEN2

Object name: ssd_cin_visits

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
CINV001A	cinv_cin_visit_id	liquid_logic, mosaic	child_in_need, cin_plan, visit	Local
CINV007A	cinv_person_id	liquid_logic, mosaic	child_in_need, cin_plan, visit	Local
CINV003A	cinv_cin_visit_date	liquid_logic, mosaic	child_in_need, cin_plan, visit	Local
CINV004A	cinv_cin_visit_seen	liquid_logic, mosaic	child_in_need, cin_plan, visit	AnnexA
CINV005A	cinv_cin_visit_seen_alone	liquid_logic, mosaic	child_in_need, cin_plan, visit	Local
CINV006A	cinv_cin_visit_bedroom	liquid_logic, mosaic	child_in_need, cin_plan, visit	Local

Object name: ssd_cla_placement

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
CLAP001A	clap_cla_placement_id	liquid_logic, mosaic	looked_after, placement	Local
CLAP003A	clap_cla_placement_start_date	liquid_logic, mosaic	looked_after, placement	SSDA903, AnnexA
CLAP004A	clap_cla_placement_type	liquid_logic, mosaic	looked_after, placement	SSDA903, AnnexA
CLAP005A	clap_cla_placement_urn	liquid_logic, mosaic	looked_after, placement	SSDA903, AnnexA
CLAP011A	clap_cla_placement_distance	liquid_logic	looked_after, placement	SSDA903
CLAP012A	clap_cla_id	liquid_logic, mosaic	looked_after, placement	Local
CLAP007A	clap_cla_placement_provider	liquid_logic, mosaic	looked_after, placement	SSDA903, AnnexA
CLAP008A	clap_cla_placement_postcode	liquid_logic, mosaic	looked_after, placement	SSDA903, AnnexA
CLAP009A	clap_cla_placement_end_date	liquid_logic, mosaic	looked_after, placement	SSDA903, AnnexA
CLAP010A	clap_cla_placement_change_reason	liquid_logic, mosaic	looked_after, placement	SSDA903
CLAP013A	clap_person_id	liquid_logic, mosaic	looked_after, placement	Local

Object name: ssd_initial_cp_conference

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
ICPC001A	icpc_icpc_id		initial_cp_conference, child_protection	Local
ICPC009A	icpc_icpc_meeting_id			Local
ICPC002A	icpc_s47_enquiry_id	liquid_logic, mosaic		RIIA
ICPC010A	icpc_person_id	liquid_logic, mosaic, eclipse, caredirector, azeus	s47_enquiry, child_protection	Local
ICPC011A	icpc_cp_plan_id	liquid_logic, mosaic	child_protection, cp_plan	RIIA, AnnexA
ICPC012A	icpc_referral_id	liquid_logic, mosaic		Local
ICPC003A	icpc_icpc_transfer_in	liquid_logic, mosaic	initial_cp_conference, child_protection	RIIA, AnnexA
ICPC004A	icpc_icpc_target_date	liquid_logic, mosaic	initial_cp_conference, child_protection	CIN
ICPC005A	icpc_icpc_date	liquid_logic, mosaic	initial_cp_conference, child_protection	CIN, RIIA, AnnexA
ICPC013A	icpc_icpc_outcome_cp_flag			AnnexA
ICPC006A	icpc_icpc_outcome_json	liquid_logic, mosaic	initial_cp_conference, child_protection	AnnexA, RIIA
ICPC007A	icpc_icpc_team	liquid_logic, mosaic	initial_cp_conference, child_protection	AnnexA, RIIA
ICPC008A	icpc_icpc_worker_id	liquid_logic, mosaic	initial_cp_conference, child_protection	AnnexA, RIIA

Object name: ssd_professionals

Item Ref	Data Item Name	Exists in CMS	Data Category Group(s)	Returns
PROF001A	prof_professional_id	liquid_logic	workforce	Local
PROF010A	prof_staff_id	liquid_logic, mosaic, azeus	workforce	Local
PROF013A	prof_professional_name	liquid_logic, mosaic, azeus	workforce	AnnexA
PROF002A	prof_social_worker_registration_no	liquid_logic, mosaic, azeus	workforce	Local
PROF007A	prof_professional_job_title	liquid_logic, mosaic	workforce	CSCWF, RIIA
PROF008A	prof_professional_caseload	liquid_logic, mosaic	workforce	CSCWF, RIIA
PROF012A	prof_professional_department	liquid_logic, mosaic	workforce	Local
PROF011A	prof_full_time_equivalency	liquid_logic, mosaic	workforce	Local
PROF014A	prof_agency_worker_flag		workforce	Local