Standard Safeguarding Dataset: Object Concept Model

Last updated:10-04-2024 16:34

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

Data Objects Overview

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_contacts

ssd_contacts
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
CONT001Acont_contact_idliquid_logic, mosaiccontactRIIA
CONT002Acont_person_idliquid_logic, mosaic, eclipse, caredirector, azeuscontactSSDA903, CINcensus, RIIA
CONT003Acont_contact_dateliquid_logic, mosaic, azeuscontactAnnexA, RIIA
CONT004Acont_contact_source_codeliquid_logic, mosaic, azeuscontactAnnexA, RIIA
CONT006Acont_contact_source_desc
CONT005Acont_contact_outcome_jsonliquid_logic, mosaiccontactADCS_SP, RIIA

Object name: ssd_ehcp_assessment

ssd_ehcp_assessment
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
EHCA001Aehca_ehcp_assessment_idliquid_logicsend, ehcp_request, ehcp_assessment1aNotInCMS, RIIA
EHCA002Aehca_ehcp_request_idliquid_logicsend, ehcp_request, ehcp_assessment1aNotInCMS, RIIA
EHCA003Aehca_ehcp_assessment_outcome_dateliquid_logicsend, ehcp_request, ehcp_assessment1aNotInCMS, SEN2, RIIA
EHCA004Aehca_ehcp_assessment_outcomeliquid_logicsend, ehcp_request, ehcp_assessment1aNotInCMS, SEN2, RIIA
EHCA005Aehca_ehcp_assessment_exceptionsliquid_logicsend, ehcp_request, ehcp_assessment1aNotInCMS, SEN2, RIIA

Object name: ssd_cla_episodes

ssd_cla_episodes
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
CLAE001Aclae_cla_episode_idliquid_logic, mosaiclooked_afterRIIA
CLAE002Aclae_person_idliquid_logic, mosaic, eclipse, caredirector, azeuslooked_afterSSDA903, CINcensus, RIIA
CLAE003Aclae_cla_episode_start_dateliquid_logic, mosaiclooked_afterSSDA903, RIIA
CLAE004Aclae_cla_episode_start_reasonliquid_logic, mosaiclooked_afterSSDA903, RIIA
CLAE009Aclae_cla_primary_needliquid_logic, mosaiclooked_afterSSDA903, AnnexA, RIIA
CLAE005Aclae_cla_episode_ceasedliquid_logic, mosaiclooked_afterSSDA903, AnnexA, RIIA
CLAE006Aclae_cla_episode_cease_reasonliquid_logic, mosaiclooked_afterSSDA903, AnnexA, RIIA
CLAE010Aclae_cla_idliquid_logic, mosaiclooked_afterLocal
CLAE011Aclae_referral_idliquid_logic, mosaiclooked_afterLocal
CLAE013Aclae_cla_placement_idliquid_logic, mosaiclooked_after, review
CLAE014Aclae_entered_care_dateliquid_logic, mosaiclooked_after, reviewSSDA903, AnnexA, ASGLB
CLAE012Aclae_cla_last_iro_contact_dateliquid_logic, mosaiclooked_after, reviewAnnexA

Object name: ssd_care_leavers

ssd_care_leavers
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
CLEA001Aclea_table_idliquid_logic, mosaiccare_leaversRIIA
CLEA002Aclea_person_idliquid_logic, mosaic, eclipse, caredirector, azeuscare_leaversSSDA903, CINcensus, RIIA
CLEA003Aclea_care_leaver_eligibilityliquid_logic, mosaiccare_leaversAnnexA, RIIA
CLEA004Aclea_care_leaver_in_touchliquid_logic, mosaiccare_leaversAnnexA, RIIA
CLEA005Aclea_care_leaver_latest_contactliquid_logic, mosaiccare_leaversAnnexA, RIIA
CLEA006Aclea_care_leaver_accommodationliquid_logic, mosaiccare_leaversAnnexA, RIIA
CLEA007Aclea_care_leaver_accom_suitableliquid_logic, mosaiccare_leaversAnnexA, RIIA
CLEA008Aclea_care_leaver_activityliquid_logic, mosaiccare_leaversAnnexA, RIIA
CLEA009Aclea_pathway_plan_review_dateliquid_logic, mosaiccare_leaversAnnexA, RIIA
CLEA010Aclea_care_leaver_personal_advisorliquid_logic, mosaiccare_leaversAnnexA, RIIA
CLEA011Aclea_care_leaver_allocated_team_nameliquid_logic, mosaiccare_leaversAnnexA, RIIA
CLEA012Aclea_care_leaver_worker_nameliquid_logic, mosaiccare_leaversAnnexA, RIIA

Object name: ssd_cp_visits

ssd_cp_visits
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
CPPV007Acppv_cp_visit_idchild_protection, cp_plan, visitLocal
CPPV008Acppv_person_idliquid_logic, mosaicchild_protection, cp_plan, visit
CPPV001Acppv_cp_plan_idliquid_logic, mosaicchild_protection, cp_plan, visitLocal
CPPV003Acppv_cp_visit_dateliquid_logic, mosaicchild_protection, cp_plan, visitAnnexA
CPPV004Acppv_cp_visit_seenliquid_logic, mosaicchild_protection, cp_plan, visitLocal
CPPV005Acppv_cp_visit_seen_aloneliquid_logic, mosaicchild_protection, cp_plan, visitAnnexA
CPPV006Acppv_cp_visit_bedroomliquid_logic, mosaicchild_protection, cp_plan, visitLocal

Object name: ssd_permanence

ssd_permanence
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
PERM001Aperm_table_idliquid_logic, mosaiclooked_after, permanence, adoptionLocal
PERM002Aperm_person_idliquid_logic, mosaiclooked_after, permanence, adoptionSSDA903, CINcensus
PERM022Aperm_cla_idliquid_logic, mosaiclooked_after, permanence, adoption
PERM003Aperm_adm_decision_dateliquid_logic, mosaiclooked_after, permanence, adoptionSSDA903, AnnexA, ASGLB
PERM004Aperm_ffa_cp_decision_dateliquid_logic, mosaiclooked_after, permanence, adoptionASGLB
PERM006Aperm_placement_order_dateliquid_logic, mosaiclooked_after, permanence, adoptionSSDA903, AnnexA, ASGLB
PERM007Aperm_placed_for_adoption_dateliquid_logic, mosaiclooked_after, permanence, adoptionSSDA903, AnnexA, ASGLB
PERM008Aperm_matched_dateliquid_logic, mosaiclooked_after, permanence, adoptionSSDA903, AnnexA, ASGLB
PERM021Aperm_adopted_by_carer_flagliquid_logic, mosaiclooked_after, permanence, adoption
PERM009Aperm_placed_ffa_cp_dateliquid_logic, mosaiclooked_after, permanence, adoptionSSDA903, AnnexA, ASGLB
PERM010Aperm_decision_reversed_dateliquid_logic, mosaiclooked_after, permanence, adoptionAnnexA, ASGLB
PERM011Aperm_placed_foster_carer_dateliquid_logic, mosaiclooked_after, permanence, adoptionSSDA903, AnnexA, ASGLB
PERM012Aperm_part_of_sibling_groupliquid_logic, mosaiclooked_after, permanence, adoptionASGLB
PERM013Aperm_siblings_placed_togetherliquid_logic, mosaiclooked_after, permanence, adoptionASGLB
PERM014Aperm_siblings_placed_apartliquid_logic, mosaiclooked_after, permanence, adoptionASGLB
PERM015Aperm_placement_provider_urnliquid_logic, mosaiclooked_after, permanence, adoptionSSDA903
PERM016Aperm_decision_reversed_reasonliquid_logic, mosaiclooked_after, permanence, adoptionSSDA903, AnnexA, ASGLB
PERM017Aperm_permanence_order_dateliquid_logic, mosaiclooked_after, permanenceSSDA903, AnnexA, ASGLB
PERM018Aperm_permanence_order_typeliquid_logic, mosaiclooked_after, permanenceSSDA903, ASGLB
PERM023Aperm_adoption_worker_nameliquid_logic, mosaiclooked_after, permanence, adoption
PERM025Aperm_adopter_sexlooked_after, permanence, adoptionSSDA903
PERM026Aperm_adopter_legal_statuslooked_after, permanence, adoptionAnnexA
PERM027Aperm_number_of_adopterslooked_after, permanence, adoptionSSDA903

Object name: ssd_family

ssd_family
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
FAMI003Afami_table_ididentity, family
FAMI001Afami_family_idliquid_logic, mosaicidentity, familyASGLB, AnnexA
FAMI002Afami_person_idliquid_logic, mosaicidentity, familySSDA903, CINcensus

Object name: ssd_immigration_status

ssd_immigration_status
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
IMMI001Aimmi_person_idliquid_logic, mosaic, eclipse, caredirector, azeusidentity, immigration, uascSSDA903, CINcensus, RIIA
IMMI005Aimmi_Immigration_status_idliquid_logic, mosaicidentity, immigration, uascLocal
IMMI002Aimmi_immigration_statusliquid_logic, mosaicidentity, immigration, uascLocal, RIIA
IMMI003Aimmi_immigration_status_start_dateliquid_logic, mosaicidentity, immigration, uascLocal, RIIA
IMMI004Aimmi_immigration_status_end_dateliquid_logic, mosaicidentity, immigration, uascLocal, RIIA

Object name: ssd_ehcp_requests

ssd_ehcp_requests
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
EHCR001Aehcr_ehcp_request_idliquid_logicsend, ehcp_request1aNotInCMS, RIIA
EHCR002Aehcr_send_table_idliquid_logicidentity, send, ehcp_request1aNotInCMS, RIIA
EHCR003Aehcr_ehcp_req_dateliquid_logicsend, ehcp_request1aNotInCMS, SEN2, RIIA
EHCR004Aehcr_ehcp_req_outcome_dateliquid_logicsend, ehcp_request1aNotInCMS, SEN2, RIIA
EHCR005Aehcr_ehcp_req_outcomeliquid_logicsend, ehcp_request1aNotInCMS, SEN2, RIIA

Object name: ssd_cla_previous_permanence

ssd_cla_previous_permanence
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
LAPP001Alapp_table_idliquid_logic, mosaiclooked_after, permanenceSSDA903
LAPP002Alapp_person_idliquid_logic, mosaic, eclipse, caredirector, azeuslooked_after, permanenceSSDA903, CINcensus
LAPP003Alapp_previous_permanence_order_dateliquid_logic, mosaiclooked_after, permanenceSSDA903
LAPP004Alapp_previous_permanence_optionliquid_logic, mosaiclooked_after, permanenceSSDA903
LAPP005Alapp_previous_permanence_laliquid_logic, mosaiclooked_after, permanenceSSDA903

Object name: ssd_cla_immunisations

ssd_cla_immunisations
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
CLAI002Aclai_person_idliquid_logic, mosaic, eclipse, caredirector, azeuslooked_after, health, immunisationsSSDA903, CINcensus
CLAI004Aclai_immunisations_statusliquid_logic, mosaiclooked_after, health, immunisationsSSDA903
CLAI005Aclai_immunisations_status_date

Object name: ssd_voice_of_child

ssd_voice_of_child
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
VOCH007Avoch_table_idliquid_logic, mosaicvoice_of_child1bDraft
VOCH001Avoch_person_idliquid_logic, mosaic, eclipse, caredirector, azeusvoice_of_childSSDA903, CINcensus
VOCH002Avoch_explained_worriesliquid_logic, mosaicvoice_of_child1bDraftrelease: In review|pending
change_id: SSD-0023
change_source: 1bDraft
versions_count: 1
impact_title: None
type: New Feature
VOCH003Avoch_story_help_understandliquid_logic, mosaicvoice_of_child1bDraftrelease: In review|pending
change_id: SSD-0024
change_source: 1bDraft
versions_count: 1
impact_title: None
type: New Feature
VOCH004Avoch_agree_workerliquid_logic, mosaicvoice_of_child1bDraftrelease: In review|pending
change_id: SSD-0025
change_source: 1bDraft
versions_count: 1
impact_title: None
type: New Feature
VOCH005Avoch_plan_safeliquid_logic, mosaicvoice_of_child1bDraftrelease: In review|pending
change_id: SSD-0026
change_source: 1bDraft
versions_count: 1
impact_title: None
type: New Feature
VOCH006Avoch_tablet_help_explainliquid_logic, mosaicvoice_of_child1bDraftrelease: In review|pending
change_id: SSD-0027
change_source: 1bDraft
versions_count: 1
impact_title: None
type: New Feature

Object name: ssd_cla_reviews

ssd_cla_reviews
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
CLAR001Aclar_cla_review_idliquid_logic, mosaiclooked_after, reviewLocal
CLAR011Aclar_cla_idliquid_logic, mosaiclooked_after, review
CLAR003Aclar_cla_review_due_dateliquid_logic, mosaiclooked_after, reviewLocal
CLAR004Aclar_cla_review_dateliquid_logic, mosaiclooked_after, reviewSSDA903, AnnexA
CLAR012Aclar_cla_review_cancelled
CLAR007Aclar_cla_review_participationliquid_logic, mosaiclooked_after, reviewSSDA903

Object name: ssd_send

ssd_send
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
SEND001Asend_table_idliquid_logicidentity, send1aNotInCMS, RIIA
SEND002Asend_upnliquid_logicidentity, send1aNotInCMS, RIIA
SEND003Asend_ulnliquid_logicidentity, send1aNotInCMS, RIIA
SEND004Asend_upn_unknownliquid_logicidentity, send1aNotInCMS, RIIA
SEND005Asend_person_idliquid_logicidentity, send1aNotInCMS, SSDA903, CINcensus, RIIA

Object name: ssd_cp_reviews

ssd_cp_reviews
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
CPPR001Acppr_cp_review_idliquid_logic, mosaicchild_protection, cp_plan, reviewLocal
CPPR008Acppr_person_idliquid_logic, mosaicchild_protection, cp_plan, review
CPPR002Acppr_cp_plan_idliquid_logic, mosaicchild_protection, cp_plan, reviewLocal
CPPR003Acppr_cp_review_dueliquid_logic, mosaicchild_protection, cp_plan, reviewLocal
CPPR004Acppr_cp_review_dateliquid_logic, mosaicchild_protection, cp_plan, reviewCINcensus, AnnexA
CPPR009Acppr_cp_review_meeting_idchild_protection, cp_plan, reviewLocal
CPPR005Acppr_cp_review_outcome_continue_cpliquid_logic, mosaicchild_protection, cp_plan, reviewLocal
CPPR006Acppr_cp_review_quorateliquid_logic, mosaicchild_protection, cp_plan, reviewLocal
CPPR007Acppr_cp_review_participationliquid_logic, mosaicchild_protection, cp_plan, reviewLocal

Object name: ssd_cin_plans

ssd_cin_plans
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
CINP001Acinp_cin_plan_idliquid_logic, mosaicchild_in_need, cin_planRIIA
CINP007Acinp_referral_idliquid_logic, mosaicLocal
CINP002Acinp_person_idliquid_logic, mosaic, eclipse, caredirector, azeuschild_in_need, cin_planSSDA903, CINcensus, RIIA
CINP003Acinp_cin_plan_start_dateliquid_logic, mosaicchild_in_need, cin_planCINcensus, RIIA
CINP004Acinp_cin_plan_end_dateliquid_logic, mosaicchild_in_need, cin_planCINcensus, RIIA
CINP005Acinp_cin_plan_team_nameliquid_logic, mosaicchild_in_need, cin_planAnnexA, RIIA
CINP006Acinp_cin_plan_worker_nameliquid_logic, mosaicchild_in_need, cin_planAnnexA, RIIA

Object name: ssd_cla_health

ssd_cla_health
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
CLAH001Aclah_health_check_idlooked_after, healthLocal
CLAH002Aclah_person_idliquid_logic, mosaic, eclipse, caredirector, azeuslooked_after, healthSSDA903, CINcensus
CLAH003Aclah_health_check_typeliquid_logic, mosaiclooked_after, healthSSDA903, AnnexA
CLAH004Aclah_health_check_dateliquid_logic, mosaiclooked_after, healthSSDA903, AnnexA
CLAH005Aclah_health_check_statusliquid_logic, mosaiclooked_after, healthSSDA903, AnnexA

Object name: ssd_pre_proceedings

ssd_pre_proceedings
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
PREP024Aprep_table_idliquid_logic, mosaicpre_proceedings1bSpecified
PREP001Aprep_person_idliquid_logic, mosaic, eclipse, caredirector, azeuspre_proceedingsSSDA903, CINcensus
PREP002Aprep_plo_family_idliquid_logic, mosaicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0001
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP003Aprep_pre_pro_decision_dateliquid_logic, mosaicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0002
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP004Aprep_initial_pre_pro_meeting_dateliquid_logic, mosaicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0003
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP005Aprep_pre_pro_outcomeliquid_logic, mosaicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0004
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP006Aprep_agree_stepdown_issue_dateliquid_logic, mosaicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0005
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP007Aprep_cp_plans_referral_periodliquid_logic, mosaicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0006
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP008Aprep_legal_gateway_outcomeliquid_logic, mosaicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0007
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP009Aprep_prev_pre_proc_childliquid_logic, mosaicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0008
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP010Aprep_prev_care_proc_childliquid_logic, mosaicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0009
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP011Aprep_pre_pro_letter_dateliquid_logicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0010
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP012Aprep_care_pro_letter_dateliquid_logicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0011
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP013Aprep_pre_pro_meetings_numliquid_logicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0012
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP014Aprep_pre_pro_parents_legal_repliquid_logicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0013
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP015Aprep_parents_legal_rep_point_of_issueliquid_logicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0014
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP016Aprep_court_referenceliquid_logicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0015
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP017Aprep_care_proc_court_hearingsliquid_logicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0016
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP018Aprep_care_proc_short_noticeliquid_logicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0017
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP019Aprep_proc_short_notice_reasonliquid_logicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0018
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP020Aprep_la_inital _plan_approvedliquid_logicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0019
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP021Aprep_la_initial_care_planliquid_logicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0020
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP022Aprep_la_final_plan_approvedliquid_logicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0021
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature
PREP023Aprep_la_final_care_planliquid_logicpre_proceedings1bSpecifiedrelease: In review|pending
change_id: SSD-0022
change_source: 1bSpecified
versions_count: 1
impact_title: None
type: New Feature

Object name: ssd_sen_need

ssd_sen_need
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
SENN001Asenn_table_idliquid_logicsend, ehcp_request, ehcp, need1aNotInCMS
SENN002Asenn_active_ehcp_idliquid_logicsend, ehcp_request, ehcp, need1aNotInCMS
SENN003Asenn_active_ehcp_need_typeliquid_logicsend, ehcp_request, ehcp, need1aNotInCMS, SEN2
SENN004Asenn_active_ehcp_need_rankliquid_logicsend, ehcp_request, ehcp, need1aNotInCMS, SEN2

Object name: ssd_mother

ssd_mother
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
MOTH004Amoth_table_ididentity, looked_after, mother
MOTH002Amoth_person_idliquid_logic, mosaic, eclipse, caredirector, azeusidentity, looked_after, motherSSDA903, CINcensus
MOTH001Amoth_childs_person_idliquid_logic, mosaicidentity, looked_after, motherLocal
MOTH003Amoth_childs_dobliquid_logic, mosaicidentity, looked_after, motherSSDA903

Object name: ssd_sdq_scores

ssd_sdq_scores
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
CSDQ001Acsdq_table_idliquid_logic, mosaiclooked_after, sdqLocal
CSDQ002Acsdq_person_idliquid_logic, mosaic, eclipse, caredirector, azeuslooked_after, sdqSSDA903, CINcensus
CSDQ003Acsdq_sdq_completed_dateliquid_logic, mosaiclooked_after, sdqLocal
CSDQ004Acsdq_sdq_reasonliquid_logic, mosaiclooked_after, sdqSSDA903
CSDQ005Acsdq_sdq_scoreliquid_logic, mosaiclooked_after, sdqSSDA903

Object name: ssd_early_help_episodes

ssd_early_help_episodes
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
EARL001Aearl_episode_idliquid_logic, mosaicearly_helpRIIA
EARL002Aearl_person_idliquid_logic, mosaic, eclipse, caredirector, azeusearly_helpSSDA903, CINcensus, RIIA
EARL003Aearl_episode_start_dateliquid_logic, mosaicearly_helpAnnexA, RIIA
EARL004Aearl_episode_end_dateliquid_logic, mosaicearly_helpAnnexA, RIIA
EARL005Aearl_episode_reasonliquid_logic, mosaicearly_helpADCS_SP, RIIA
EARL006Aearl_episode_end_reasonliquid_logic, mosaicearly_helpADCS_SP, RIIA
EARL007Aearl_episode_organisationliquid_logic, mosaicearly_helpAnnexA, RIIA
EARL008Aearl_episode_worker_nameliquid_logic, mosaicearly_helpLocal, RIIA

Object name: ssd_cin_episodes

ssd_cin_episodes
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
CINE001Acine_referral_idliquid_logic, mosaicchild_in_need, referralRIIA
CINE002Acine_person_idliquid_logic, mosaic, eclipse, caredirector, azeuschild_in_needSSDA903, CINcensus, RIIA
CINE003Acine_referral_dateliquid_logic, mosaicchild_in_need, referralCINcensus, AnnexA, RIIA
CINE010Acine_cin_primary_needliquid_logic, mosaicchild_in_need, referralCINcensus, AnnexA, RIIA
CINE004Acine_referral_source_codeliquid_logic, mosaicchild_in_need, referralCINcensus, AnnexA, RIIA
CINE012Acine_referral_source_desc
CINE005Acine_referral_outcome_jsonliquid_logic, mosaicchild_in_need, referralCINcensus, AnnexA, RIIA
CINE011Acine_referral_nfaliquid_logic, mosaicchild_in_need, referralCINcensus, AnnexA, RIIA
CINE006Acine_close_reasonliquid_logic, mosaicchild_in_needCINcensus, RIIA
CINE007Acine_close_dateliquid_logic, mosaicchild_in_needCINcensus, RIIA
CINE008Acine_referral_team_nameliquid_logic, mosaicchild_in_need, referralAnnexA, RIIA
CINE009Acine_referral_worker_nameliquid_logic, mosaicchild_in_need, referralAnnexA, RIIA

Object name: ssd_cla_substance_misuse

ssd_cla_substance_misuse
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
CLAS001Aclas_substance_misuse_idliquid_logic, mosaiclooked_after, health, substance_misuseLocal
CLAS002Aclas_person_idliquid_logic, mosaic, eclipse, caredirector, azeuslooked_after, health, substance_misuseSSDA903, CINcensus
CLAS003Aclas_substance_misuse_dateliquid_logic, mosaiclooked_after, health, substance_misuseLocal
CLAS004Aclas_substance_misusedliquid_logic, mosaiclooked_after, health, substance_misuseSSDA903
CLAS005Aclas_intervention_receivedliquid_logic, mosaiclooked_after, health, substance_misuseSSDA903

Object name: ssd_disability

ssd_disability
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
DISA001Adisa_person_idliquid_logic, mosaic, eclipse, caredirector, azeusidentity, disabilitySSDA903, CINcensus
DISA003Adisa_table_idliquid_logic, mosaicidentity, disabilityLocal
DISA002Adisa_disability_codeliquid_logic, mosaicidentity, disabilityCINcensus

Object name: ssd_cin_assessments

ssd_cin_assessments
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
CINA001Acina_assessment_idliquid_logic, mosaicchild_in_need, assessmentRIIA
CINA002Acina_person_idliquid_logic, mosaic, eclipse, caredirector, azeuschild_in_need, assessmentSSDA903, CINcensus, RIIA
CINA010Acina_referral_idliquid_logic, mosaicLocal
CINA003Acina_assessment_start_dateliquid_logic, mosaicchild_in_need, assessmentCINcensus, RIIA
CINA004Acina_assessment_child_seenliquid_logic, mosaicchild_in_need, assessmentAnnexA, RIIA
CINA005Acina_assessment_auth_dateliquid_logic, mosaicchild_in_need, assessmentCINcensus, RIIA
CINA006Acina_assessment_outcome_jsonliquid_logic, mosaicchild_in_need, assessmentAnnexA, RIIA
CINA009Acina_assessment_outcome_nfaliquid_logic, mosaicchild_in_need, assessmentAnnexA, RIIA
CINA007Acina_assessment_team_nameliquid_logic, mosaicchild_in_need, assessmentAnnexA, RIIA
CINA008Acina_assessment_worker_nameliquid_logic, mosaicchild_in_need, assessmentAnnexA, RIIA

Object name: ssd_cla_placement

ssd_cla_placement
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
CLAP001Aclap_cla_placement_idliquid_logic, mosaiclooked_after, placementLocal
CLAP003Aclap_cla_placement_start_dateliquid_logic, mosaiclooked_after, placementSSDA903, AnnexA
CLAP004Aclap_cla_placement_typeliquid_logic, mosaiclooked_after, placementSSDA903, AnnexA
CLAP005Aclap_cla_placement_urnliquid_logic, mosaiclooked_after, placementSSDA903, AnnexA
CLAP011Aclap_cla_placement_distanceliquid_logiclooked_after, placementLocal
CLAP012Aclap_cla_idliquid_logic, mosaiclooked_after, placementLocal
CLAP007Aclap_cla_placement_providerliquid_logic, mosaiclooked_after, placementSSDA903
CLAP008Aclap_cla_placement_postcodeliquid_logic, mosaiclooked_after, placementLocal
CLAP009Aclap_cla_placement_end_dateliquid_logic, mosaiclooked_after, placementSSDA903
CLAP010Aclap_cla_placement_change_reasonliquid_logic, mosaiclooked_after, placementSSDA903

Object name: ssd_assessment_factors

ssd_assessment_factors
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
CINF003Acinf_table_idchild_in_need, assessmentLocal
CINF001Acinf_assessment_idliquid_logic, mosaicchild_in_need, assessmentLocal
CINF002Acinf_assessment_factors_jsonliquid_logic, mosaicchild_in_need, assessmentCINcensus

Object name: ssd_ehcp_active_plans

ssd_ehcp_active_plans
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
EHCP001Aehcp_active_ehcp_idliquid_logicsend, ehcp_request, ehcp1aNotInCMS
EHCP002Aehcp_ehcp_request_idliquid_logicsend, ehcp_request, ehcp1aNotInCMS
EHCP003Aehcp_active_ehcp_last_review_dateliquid_logicsend, ehcp_request, ehcp1aNotInCMS, SEN2

Object name: ssd_cp_plans

ssd_cp_plans
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
CPPL001Acppl_cp_plan_idliquid_logic, mosaicchild_protection, cp_planRIIA
CPPL007Acppl_referral_idchild_protection, cp_planLocal
CPPL008Acppl_icpc_idliquid_logic, mosaicchild_protection, cp_planLocal
CPPL002Acppl_person_idliquid_logic, mosaic, eclipse, caredirector, azeuschild_protection, cp_planSSDA903, CINcensus, RIIA
CPPL003Acppl_cp_plan_start_dateliquid_logic, mosaicchild_protection, cp_planCINcensus, AnnexA, RIIA
CPPL004Acppl_cp_plan_end_dateliquid_logic, mosaicchild_protection, cp_planCINcensus, AnnexA, RIIA
CPPL009Acppl_cp_plan_initial_categorychild_protection, cp_planLocal
CPPL0101Acppl_cp_plan_olachild_protection, cp_plan
CPPL010Acppl_cp_plan_latest_categorychild_protection, cp_planLocal

Object name: ssd_initial_cp_conference

ssd_initial_cp_conference
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
ICPC001Aicpc_icpc_idinitial_cp_conference, child_protectionLocal
ICPC009Aicpc_icpc_meeting_idLocal
ICPC002Aicpc_s47_enquiry_idliquid_logic, mosaicRIIA
ICPC010Aicpc_person_idliquid_logic, mosaic, eclipse, caredirector, azeuss47_enquiry, child_protectionSSDA903, CINcensus, RIIA
ICPC011Aicpc_cp_plan_idliquid_logic, mosaicchild_protection, cp_planRIIA
ICPC012Aicpc_referral_idliquid_logic, mosaicLocal
ICPC003Aicpc_icpc_transfer_inliquid_logic, mosaicinitial_cp_conference, child_protectionLocal, RIIA
ICPC004Aicpc_icpc_target_dateliquid_logic, mosaicinitial_cp_conference, child_protectionCINcensus
ICPC005Aicpc_icpc_dateliquid_logic, mosaicinitial_cp_conference, child_protectionCINcensus, RIIA
ICPC013Aicpc_icpc_outcome_cp_flagLocal, AnnexA
ICPC006Aicpc_icpc_outcome_jsonliquid_logic, mosaicinitial_cp_conference, child_protectionAnnexA, RIIA
ICPC007Aicpc_icpc_team_nameliquid_logic, mosaicinitial_cp_conference, child_protectionAnnexA, RIIA
ICPC008Aicpc_icpc_worker_nameliquid_logic, mosaicinitial_cp_conference, child_protectionAnnexA, RIIA

Object name: ssd_s251_finance

ssd_s251_finance
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
S251001As251_table_idliquid_logic, mosaicfinance1aDraft
S251002As251_cla_placement_idliquid_logic, mosaicfinance1aDraft
S251003As251_placeholder_1liquid_logic, mosaicfinance1aDraft
S251004As251_placeholder_2liquid_logic, mosaicfinance1aDraft
S251005As251_placeholder_3liquid_logic, mosaicfinance1aDraft
S251006As251_placeholder_4liquid_logic, mosaicfinance1aDraft

Object name: ssd_person

ssd_person
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
PERS001Apers_person_idliquid_logic, mosaic, eclipse, caredirector, azeusidentitySSDA903, CINcensus, AnnexA, RIIA
PERS002Apers_sexliquid_logic, mosaic, eclipse, caredirectoridentitySSDA903, RIIA
PERS003Apers_genderliquid_logic, mosaic, azeusidentityCINcensus, RIIA
PERS004Apers_ethnicityliquid_logic, mosaic, azeusidentitySSDA903, CINcensus, AnnexA, RIIA
PERS005Apers_dobliquid_logic, mosaic, eclipse, caredirector, azeusidentitySSDA903, CINcensus, AnnexA, RIIA
PERS013Apers_common_child_ididentityLocal
PERS014Apers_legacy_ididentity
PERS007Apers_upn_unknownliquid_logic, mosaic, azeusidentitySSDA903, RIIA
PERS008Apers_send_flagliquid_logicidentityNEETandparticipation, RIIA
PERS009Apers_expected_dobliquid_logic, azeusidentityCINcensus, RIIA
PERS010Apers_death_dateliquid_logic, azeusidentityCINcensus, RIIA
PERS011Apers_is_motherliquid_logic, azeusidentitySSDA903, RIIA
PERS012Apers_nationalityliquid_logic, mosaicidentityADCS_SP, RIIA

Object name: ssd_cin_visits

ssd_cin_visits
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
CINV001Acinv_cin_visit_idliquid_logic, mosaicchild_in_need, cin_plan, visitLocal
CINV007Acinv_person_idliquid_logic, mosaicchild_in_need, cin_plan, visit
CINV003Acinv_cin_visit_dateliquid_logic, mosaicchild_in_need, cin_plan, visitLocal
CINV004Acinv_cin_visit_seenliquid_logic, mosaicchild_in_need, cin_plan, visitAnnexA
CINV005Acinv_cin_visit_seen_aloneliquid_logic, mosaicchild_in_need, cin_plan, visitLocal
CINV006Acinv_cin_visit_bedroomliquid_logic, mosaicchild_in_need, cin_plan, visitLocal

Object name: ssd_involvements

ssd_involvements
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
INVO005Ainvo_involvements_idliquid_logic, mosaicworkforceLocal
INVO006Ainvo_professional_idliquid_logic, mosaicworkforceLocal
INVO007Ainvo_professional_role_idliquid_logic, mosaicworkforceLocal
INVO009Ainvo_professional_teamliquid_logic, mosaicworkforceLocal
INVO002Ainvo_involvement_start_dateliquid_logic, azeusworkforceSSDA903, RIIA
INVO003Ainvo_involvement_end_dateliquid_logic, azeusworkforceSSDA903, RIIA
INVO004Ainvo_worker_change_reasonliquid_logic, azeusworkforceSSDA903, RIIA
INVO011Ainvo_person_idworkforce
INVO010Ainvo_referral_idliquid_logic, mosaicworkforceLocal

Object name: ssd_linked_identifiers

ssd_linked_identifiers
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
LINK001Alink_table_idliquid_logic, mosaiclinked_identifiers1aNotInCMS
LINK002Alink_person_idliquid_logic, mosaic, eclipse, caredirector, azeuslinked_identifiersLocal
LINK003Alink_identifier_typeliquid_logic, mosaiclinked_identifiers1aNotInCMS
LINK004Alink_identifier_valueliquid_logic, mosaiclinked_identifiers1aNotInCMS
LINK005Alink_valid_from_dateliquid_logic, mosaiclinked_identifiers1aNotInCMS
LINK006Alink_valid_to_dateliquid_logic, mosaiclinked_identifiers1aNotInCMS

Object name: ssd_address

ssd_address
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
ADDR007Aaddr_table_idliquid_logic, mosaicidentity, addressLocal
ADDR001Aaddr_address_jsonliquid_logic, mosaic, eclipse, caredirector, azeusidentity, addressLocal
ADDR002Aaddr_person_idliquid_logic, mosaic, eclipse, caredirector, azeusidentity, addressSSDA903, CINcensus
ADDR003Aaddr_address_typeliquid_logic, mosaicidentity, addressLocal
ADDR004Aaddr_address_start_dateliquid_logic, mosaicidentity, addressLocal
ADDR005Aaddr_address_end_dateliquid_logic, mosaicidentity, addressLocal
ADDR006Aaddr_address_postcodeliquid_logic, mosaic, eclipse, caredirector, azeusidentity, addressLocal

Object name: ssd_cla_convictions

ssd_cla_convictions
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
CLAC001Aclac_cla_conviction_idliquid_logic, mosaiclooked_after, convictionsSSDA903
CLAC002Aclac_person_idliquid_logic, mosaic, eclipse, caredirector, azeuslooked_after, convictionsSSDA903, CINcensus
CLAC003Aclac_cla_conviction_dateliquid_logic, mosaiclooked_after, convictionsSSDA903
CLAC004Aclac_cla_conviction_offencelooked_after, convictionsLocal

Object name: ssd_cla_visits

ssd_cla_visits
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
CLAV001Aclav_cla_visit_idliquid_logic, mosaiclooked_after, visitLocal
CLAV007Aclav_cla_id
CLAV008Aclav_person_idliquid_logic, mosaiclooked_after, review
CLAV003Aclav_cla_visit_dateliquid_logic, mosaiclooked_after, visitAnnexA
CLAV004Aclav_cla_visit_seenliquid_logic, mosaiclooked_after, visitLocal
CLAV005Aclav_cla_visit_seen_aloneliquid_logic, mosaiclooked_after, visitLocal

Object name: ssd_ehcp_named_plan

ssd_ehcp_named_plan
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
EHCN001Aehcn_named_plan_idliquid_logicsend, ehcp_request, ehcp_assessment1aNotInCMS
EHCN002Aehcn_ehcp_asmt_idliquid_logicsend, ehcp_request, ehcp_assessment1aNotInCMS
EHCN003Aehcn_named_plan_start_dateliquid_logicsend, ehcp_request, ehcp_assessment1aNotInCMS, SEN2
EHCN004Aehcn_named_plan_cease_dateliquid_logicsend, ehcp_request, ehcp_assessment1aNotInCMS, SEN2
EHCN005Aehcn_named_plan_cease_reasonliquid_logicsend, ehcp_request, ehcp_assessment1aNotInCMS, SEN2

Object name: ssd_legal_status

ssd_legal_status
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
LEGA001Alega_legal_status_idliquid_logic, mosaicidentity, looked_afterRIIA
LEGA002Alega_person_idliquid_logic, mosaic, eclipse, caredirector, azeusidentity, looked_afterSSDA903, CINcensus, RIIA
LEGA003Alega_legal_statusliquid_logic, mosaicidentity, looked_afterSSDA903, AnnexA, RIIA
LEGA004Alega_legal_status_start_dateliquid_logic, mosaicidentity, looked_afterLocal, RIIA
LEGA005Alega_legal_status_end_dateliquid_logic, mosaicidentity, looked_afterLocal, RIIA

Object name: ssd_professionals

ssd_professionals
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
PROF001Aprof_professional_idliquid_logicworkforceLocal
PROF010Aprof_staff_idliquid_logic, mosaic, azeusworkforceLocal
PROF013Aprof_professional_nameliquid_logic, mosaic, azeusworkforceLocal, AnnexA
PROF002Aprof_social_worker_registration_noliquid_logic, mosaic, azeusworkforceLocal
PROF007Aprof_professional_job_titleliquid_logic, mosaicworkforceCSCWF, RIIA
PROF012Aprof_professional_departmentliquid_logic, mosaicworkforceLocal
PROF011Aprof_full_time_equivalencyliquid_logic, mosaicworkforceLocal

Object name: ssd_s47_enquiry

ssd_s47_enquiry
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
S47E001As47e_s47_enquiry_idliquid_logic, mosaics47_enquiry, child_protectionRIIA
S47E010As47e_referral_idliquid_logic, mosaics47_enquiry, child_protectionLocal
S47E002As47e_person_idliquid_logic, mosaic, eclipse, caredirector, azeuss47_enquiry, child_protectionSSDA903, CINcensus, RIIA
S47E004As47e_s47_start_dateliquid_logic, mosaics47_enquiry, child_protectionCINcensus, RIIA
S47E005As47e_s47_end_dateliquid_logic, mosaics47_enquiry, child_protectionLocal, RIIA
S47E006As47e_s47_nfaliquid_logic, mosaics47_enquiry, child_protectionCINcensus
S47E007As47e_s47_outcome_jsonliquid_logic, mosaics47_enquiry, child_protectionCINcensus
S47E008As47e_s47_completed_by_worker_names47_enquiry, child_protectionLocal
S47E009As47e_s47_completed_by_team_names47_enquiry, child_protectionLocal

Object name: ssd_cla_care_plan

ssd_cla_care_plan
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
LACP001Alacp_table_idliquid_logic, mosaiclooked_after, care_planLocal
LACP007Alacp_person_idliquid_logic, mosaiclooked_after, care_planLocal
LACP004Alacp_cla_care_plan_start_dateliquid_logic, mosaiclooked_after, care_planLocal
LACP005Alacp_cla_care_plan_end_dateliquid_logic, mosaiclooked_after, care_planLocal
LACP003Alacp_cla_care_plan_jsonliquid_logic, mosaiclooked_after, care_planAnnexA

Object name: ssd_missing

ssd_missing
Item RefData Item NameExists in CMSData Category Group(s)ReturnsChange Log
MISS001Amiss_table_idliquid_logic, mosaiclooked_after, missingLocal
MISS002Amiss_person_idliquid_logic, mosaiclooked_after, missingLocal
MISS003Amiss_missing_episode_start_dateliquid_logic, mosaiclooked_after, missingSSDA903, AnnexA
MISS004Amiss_missing_episode_typeliquid_logic, mosaiclooked_after, missingSSDA903, AnnexA
MISS005Amiss_missing_episode_end_dateliquid_logic, mosaiclooked_after, missingSSDA903, AnnexA
MISS006Amiss_missing_rhi_offeredliquid_logic, mosaiclooked_after, missingAnnexA
MISS007Amiss_missing_rhi_acceptedliquid_logic, mosaiclooked_after, missingAnnexA