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

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.

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 | liquid_logic, mosaic | s47_enquiry, child_protection | Local | |
| S47E009A | s47e_s47_completed_by_team | liquid_logic, mosaic | s47_enquiry, child_protection | Local |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| VERS1001A | version_number | liquid_logic, mosaic, eclipse, azeus, caredirector | admin | ||
| VERS1002A | release_date | liquid_logic, mosaic, eclipse, azeus, caredirector | admin | ||
| VERS1003A | description | liquid_logic, mosaic, eclipse, azeus, caredirector | admin | ||
| VERS1004A | is_current | liquid_logic, mosaic, eclipse, azeus, caredirector | admin | ||
| VERS1005A | created_at | liquid_logic, mosaic, eclipse, azeus, caredirector | admin | ||
| VERS1006A | created_by | liquid_logic, mosaic, eclipse, azeus, caredirector | admin | ||
| VERS1007A | impact_description | liquid_logic, mosaic, eclipse, azeus, caredirector | admin |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| PERS001A | pers_person_id | liquid_logic, mosaic, eclipse, caredirector, azeus | identity | SSDA903, CIN, AnnexA, RIIA, SEN2 | |
| PERS015A | pers_forename | liquid_logic, mosaic, eclipse, caredirector, azeus | identity | ||
| PERS016A | pers_surname | liquid_logic, mosaic, eclipse, caredirector, azeus | identity | ||
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| APIS1001A | id | liquid_logic, mosaic, eclipse, azeus, caredirector | admin | ||
| APIS1002A | person_id | liquid_logic, mosaic, eclipse, azeus, caredirector | admin | Local | |
| APIS1003A | json_payload | liquid_logic, mosaic, eclipse, azeus, caredirector | admin | Local | |
| APIS1004A | current_hash | liquid_logic, mosaic, eclipse, azeus, caredirector | admin | ||
| APIS1005A | previous_hash | liquid_logic, mosaic, eclipse, azeus, caredirector | admin | ||
| APIS1006A | submission_status | liquid_logic, mosaic, eclipse, azeus, caredirector | admin | ||
| APIS1007A | submission_timestamp | liquid_logic, mosaic, eclipse, azeus, caredirector | admin | ||
| APIS1008A | api_response | liquid_logic, mosaic, eclipse, azeus, caredirector | admin | ||
| APIS1009A | row_state | liquid_logic, mosaic, eclipse, azeus, caredirector | admin | ||
| APIS1010A | last_updated | liquid_logic, mosaic, eclipse, azeus, caredirector | admin |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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_date | 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |

| 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 |

| Item Ref | Data Item Name | Exists in CMS | Data Category Group(s) | Returns | Change Log |
|---|---|---|---|---|---|
| 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 |