docs/index.html

<html><head><style>body { margin: 20px; }table { border-collapse: collapse; width: 100%; margin: auto; table-layout: fixed; }th, td { text-align: left; padding: 8px; word-wrap: break-word; border: 1px solid #ddd; }th { background-color: #f2f2f2; }th.image-column { width: 300px; }th.field-ref-column { width: 100px; }th.data-item-column { width: 30%; }th.cms-column { width: 15%; }th.categories-column { width: 15%; }th.returns-column { width: 20%; }th.changelog-column { width: 20%; }.last-updated-container { display: flex; align-items: center; }.last-updated-text { font-weight: bold; margin-right: 5px; }.repo-link { text-decoration: none; }.link-section a { margin-left: 10px; margin-right: 10px; }</style></head><body><script>
var returns_categories = {"Existing": {"colour": "#CCCCCC", "description": "Current returned data"}, "Local": {"colour": "#C5E625", "description": "Recorded locally but not currently included in any data collections"}, "1aDraft": {"colour": "#1CFCF2", "description": "Suggested new item for SSD"}, "1bDraft": {"colour": "#F57C1D", "description": "Suggested new item for one of the 1b projects"}, "1bSpecified": {"colour": "#FFC91E", "description": "Final specified item for one of the 1b projects"}, "1aRemove": {"colour": "#FF2114", "description": "Specified item rejected from final spec."}, "1aNotInCMS": {"colour": "#F08080", "description": "Currently exists but commonly outside Social Care CMS. (SSD==Placeholder data)"}};
</script><h1>Standard Safeguarding Dataset: Object Concept Model</h1><p></p><div style='padding: 2px;'><div class='last-updated-container'><span class='last-updated-text'>Last updated:</span><span class='last-updated-date'>08-11-2024 15:00</span><div class='link-section'><a href='https://data-to-insight.github.io/ssd-data-model/README.html' class='repo-link'> | Get Started & Project description</a><a href='https://data-to-insight.github.io/ssd-data-model/index.html' class='repo-link'> | Object Concept Model</a><a href='https://data-to-insight.github.io/ssd-data-model/guidance.html' class='repo-link'> | Data Item Guidance</a><a href='https://data-to-insight.github.io/ssd-data-model/existingreturnsmap.html' class='repo-link'> | Existing Returns Maps</a><a href='https://forms.office.com/e/UysrcGApJ1' class='repo-link'> | Submit Change Request</a><a href='https://data-to-insight.github.io/ssd-data-model/object_definitions.pdf' class='repo-link'> | Object Spec download(PDF)</a><a href='https://dbdiagram.io/d/SSD-Schema-V1-65cf6008ac844320ae4e8484' class='repo-link'> | Object ER diagram</a></div></div><h1>Objects Overview:</h1><p>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.</p><p>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</p><div id='table-container'><img id="main-image" src="imgs/ssd_conceptual_diagram.png" alt="Data Objects Overview" style="max-width: 100%; margin-bottom: 20px;"><div id='legend-container' style='margin-top: 20px;'><h3>Object/Data item key:</h3><ul id='legend' style='background: rgba(255, 255, 255, 0.7); padding: 10px; border-radius: 5px; list-style: none; margin-top: 2px;'><li style='margin-bottom: 5px; font-size: 12px;'><div style='display: inline-block; width: 20px; height: 20px; margin-right: 5px; background: #CCCCCC;'></div>Existing - Current returned data</li><li style='margin-bottom: 5px; font-size: 12px;'><div style='display: inline-block; width: 20px; height: 20px; margin-right: 5px; background: #C5E625;'></div>Local - Recorded locally but not currently included in any data collections</li><li style='margin-bottom: 5px; font-size: 12px;'><div style='display: inline-block; width: 20px; height: 20px; margin-right: 5px; background: #1CFCF2;'></div>1aDraft - Suggested new item for SSD</li><li style='margin-bottom: 5px; font-size: 12px;'><div style='display: inline-block; width: 20px; height: 20px; margin-right: 5px; background: #F57C1D;'></div>1bDraft - Suggested new item for one of the 1b projects</li><li style='margin-bottom: 5px; font-size: 12px;'><div style='display: inline-block; width: 20px; height: 20px; margin-right: 5px; background: #FFC91E;'></div>1bSpecified - Final specified item for one of the 1b projects</li><li style='margin-bottom: 5px; font-size: 12px;'><div style='display: inline-block; width: 20px; height: 20px; margin-right: 5px; background: #FF2114;'></div>1aRemove - Specified item rejected from final spec.</li><li style='margin-bottom: 5px; font-size: 12px;'><div style='display: inline-block; width: 20px; height: 20px; margin-right: 5px; background: #F08080;'></div>1aNotInCMS - Currently exists but commonly outside Social Care CMS. (SSD==Placeholder data)</li></ul><p>Note: Colour identifiers on Overview image indicate presence of <i>at least</i> one known change. See below tables for the item level changes/additions with granular colour-coding.</p></div></div></div><h1>Object Data Points Overview:</h1><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_cp_plans</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_cp_plans.png" alt="ssd_cp_plans" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-CPPL001A"><td>CPPL001A</td><td>cppl_cp_plan_id</td><td>liquid_logic, mosaic</td><td>child_protection, cp_plan</td><td>Local</td><td></td></tr><tr class="row-CPPL007A"><td>CPPL007A</td><td>cppl_referral_id</td><td></td><td>child_protection, cp_plan</td><td>Local</td><td></td></tr><tr class="row-CPPL008A"><td>CPPL008A</td><td>cppl_icpc_id</td><td>liquid_logic, mosaic</td><td>child_protection, cp_plan</td><td>Local</td><td></td></tr><tr class="row-CPPL002A"><td>CPPL002A</td><td>cppl_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>child_protection, cp_plan</td><td>Local</td><td></td></tr><tr class="row-CPPL003A"><td>CPPL003A</td><td>cppl_cp_plan_start_date</td><td>liquid_logic, mosaic</td><td>child_protection, cp_plan</td><td>CIN, AnnexA, RIIA</td><td></td></tr><tr class="row-CPPL004A"><td>CPPL004A</td><td>cppl_cp_plan_end_date</td><td>liquid_logic, mosaic</td><td>child_protection, cp_plan</td><td>CIN, AnnexA, RIIA</td><td></td></tr><tr class="row-CPPL009A"><td>CPPL009A</td><td>cppl_cp_plan_initial_category</td><td></td><td>child_protection, cp_plan</td><td>CIN, AnnexA</td><td></td></tr><tr class="row-CPPL011A"><td>CPPL011A</td><td>cppl_cp_plan_ola</td><td></td><td>child_protection, cp_plan</td><td>Local</td><td></td></tr><tr class="row-CPPL010A"><td>CPPL010A</td><td>cppl_cp_plan_latest_category</td><td></td><td>child_protection, cp_plan</td><td>CIN, AnnexA</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_cla_placement</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_cla_placement.png" alt="ssd_cla_placement" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-CLAP001A"><td>CLAP001A</td><td>clap_cla_placement_id</td><td>liquid_logic, mosaic</td><td>looked_after, placement</td><td>Local</td><td></td></tr><tr class="row-CLAP003A"><td>CLAP003A</td><td>clap_cla_placement_start_date</td><td>liquid_logic, mosaic</td><td>looked_after, placement</td><td>SSDA903, AnnexA</td><td></td></tr><tr class="row-CLAP004A"><td>CLAP004A</td><td>clap_cla_placement_type</td><td>liquid_logic, mosaic</td><td>looked_after, placement</td><td>SSDA903, AnnexA</td><td></td></tr><tr class="row-CLAP005A"><td>CLAP005A</td><td>clap_cla_placement_urn</td><td>liquid_logic, mosaic</td><td>looked_after, placement</td><td>SSDA903, AnnexA</td><td></td></tr><tr class="row-CLAP011A"><td>CLAP011A</td><td>clap_cla_placement_distance</td><td>liquid_logic</td><td>looked_after, placement</td><td>SSDA903</td><td></td></tr><tr class="row-CLAP012A"><td>CLAP012A</td><td>clap_cla_id</td><td>liquid_logic, mosaic</td><td>looked_after, placement</td><td>Local</td><td></td></tr><tr class="row-CLAP007A"><td>CLAP007A</td><td>clap_cla_placement_provider</td><td>liquid_logic, mosaic</td><td>looked_after, placement</td><td>SSDA903, AnnexA</td><td></td></tr><tr class="row-CLAP008A"><td>CLAP008A</td><td>clap_cla_placement_postcode</td><td>liquid_logic, mosaic</td><td>looked_after, placement</td><td>SSDA903, AnnexA</td><td></td></tr><tr class="row-CLAP009A"><td>CLAP009A</td><td>clap_cla_placement_end_date</td><td>liquid_logic, mosaic</td><td>looked_after, placement</td><td>SSDA903, AnnexA</td><td></td></tr><tr class="row-CLAP010A"><td>CLAP010A</td><td>clap_cla_placement_change_reason</td><td>liquid_logic, mosaic</td><td>looked_after, placement</td><td>SSDA903</td><td></td></tr><tr class="row-CLAP013A"><td>CLAP013A</td><td>clap_person_id</td><td>liquid_logic, mosaic</td><td>looked_after, placement</td><td>Local</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_ehcp_assessment</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_ehcp_assessment.png" alt="ssd_ehcp_assessment" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-EHCA001A"><td>EHCA001A</td><td>ehca_ehcp_assessment_id</td><td>liquid_logic</td><td>send, ehcp_request, ehcp_assessment</td><td>1aNotInCMS, RIIA</td><td></td></tr><tr class="row-EHCA002A"><td>EHCA002A</td><td>ehca_ehcp_request_id</td><td>liquid_logic</td><td>send, ehcp_request, ehcp_assessment</td><td>1aNotInCMS</td><td></td></tr><tr class="row-EHCA003A"><td>EHCA003A</td><td>ehca_ehcp_assessment_outcome_date</td><td>liquid_logic</td><td>send, ehcp_request, ehcp_assessment</td><td>1aNotInCMS, SEN2, RIIA, SEN2</td><td></td></tr><tr class="row-EHCA004A"><td>EHCA004A</td><td>ehca_ehcp_assessment_outcome</td><td>liquid_logic</td><td>send, ehcp_request, ehcp_assessment</td><td>1aNotInCMS, SEN2, RIIA, SEN2</td><td></td></tr><tr class="row-EHCA005A"><td>EHCA005A</td><td>ehca_ehcp_assessment_exceptions</td><td>liquid_logic</td><td>send, ehcp_request, ehcp_assessment</td><td>1aNotInCMS, SEN2, RIIA, SEN2</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_sen_need</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_sen_need.png" alt="ssd_sen_need" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-SENN001A"><td>SENN001A</td><td>senn_table_id</td><td>liquid_logic</td><td>send, ehcp_request, ehcp, need</td><td>1aNotInCMS</td><td></td></tr><tr class="row-SENN002A"><td>SENN002A</td><td>senn_active_ehcp_id</td><td>liquid_logic</td><td>send, ehcp_request, ehcp, need</td><td>1aNotInCMS</td><td></td></tr><tr class="row-SENN003A"><td>SENN003A</td><td>senn_active_ehcp_need_type</td><td>liquid_logic</td><td>send, ehcp_request, ehcp, need</td><td>1aNotInCMS, SEN2</td><td></td></tr><tr class="row-SENN004A"><td>SENN004A</td><td>senn_active_ehcp_need_rank</td><td>liquid_logic</td><td>send, ehcp_request, ehcp, need</td><td>1aNotInCMS, SEN2</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_cin_visits</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_cin_visits.png" alt="ssd_cin_visits" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-CINV001A"><td>CINV001A</td><td>cinv_cin_visit_id</td><td>liquid_logic, mosaic</td><td>child_in_need, cin_plan, visit</td><td>Local</td><td></td></tr><tr class="row-CINV007A"><td>CINV007A</td><td>cinv_person_id</td><td>liquid_logic, mosaic</td><td>child_in_need, cin_plan, visit</td><td>Local</td><td></td></tr><tr class="row-CINV003A"><td>CINV003A</td><td>cinv_cin_visit_date</td><td>liquid_logic, mosaic</td><td>child_in_need, cin_plan, visit</td><td>Local</td><td></td></tr><tr class="row-CINV004A"><td>CINV004A</td><td>cinv_cin_visit_seen</td><td>liquid_logic, mosaic</td><td>child_in_need, cin_plan, visit</td><td>AnnexA</td><td></td></tr><tr class="row-CINV005A"><td>CINV005A</td><td>cinv_cin_visit_seen_alone</td><td>liquid_logic, mosaic</td><td>child_in_need, cin_plan, visit</td><td>Local</td><td></td></tr><tr class="row-CINV006A"><td>CINV006A</td><td>cinv_cin_visit_bedroom</td><td>liquid_logic, mosaic</td><td>child_in_need, cin_plan, visit</td><td>Local</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_linked_identifiers</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_linked_identifiers.png" alt="ssd_linked_identifiers" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-LINK001A"><td>LINK001A</td><td>link_table_id</td><td>liquid_logic, mosaic</td><td>linked_identifiers</td><td>1aNotInCMS</td><td></td></tr><tr class="row-LINK002A"><td>LINK002A</td><td>link_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>linked_identifiers</td><td>Local</td><td></td></tr><tr class="row-LINK003A"><td>LINK003A</td><td>link_identifier_type</td><td>liquid_logic, mosaic</td><td>linked_identifiers</td><td>1aNotInCMS</td><td></td></tr><tr class="row-LINK004A"><td>LINK004A</td><td>link_identifier_value</td><td>liquid_logic, mosaic</td><td>linked_identifiers</td><td>1aNotInCMS</td><td></td></tr><tr class="row-LINK005A"><td>LINK005A</td><td>link_valid_from_date</td><td>liquid_logic, mosaic</td><td>linked_identifiers</td><td>1aNotInCMS</td><td></td></tr><tr class="row-LINK006A"><td>LINK006A</td><td>link_valid_to_date</td><td>liquid_logic, mosaic</td><td>linked_identifiers</td><td>1aNotInCMS</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_cla_immunisations</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_cla_immunisations.png" alt="ssd_cla_immunisations" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-CLAI002A"><td>CLAI002A</td><td>clai_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>looked_after, health, immunisations</td><td>Local</td><td></td></tr><tr class="row-CLAI004A"><td>CLAI004A</td><td>clai_immunisations_status</td><td>liquid_logic, mosaic</td><td>looked_after, health, immunisations</td><td>SSDA903</td><td></td></tr><tr class="row-CLAI005A"><td>CLAI005A</td><td>clai_immunisations_status_date</td><td></td><td>looked_after, health, immunisations</td><td>Local</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_cin_episodes</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_cin_episodes.png" alt="ssd_cin_episodes" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-CINE001A"><td>CINE001A</td><td>cine_referral_id</td><td>liquid_logic, mosaic</td><td>child_in_need, referral</td><td>Loca;</td><td></td></tr><tr class="row-CINE002A"><td>CINE002A</td><td>cine_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>child_in_need</td><td>Local</td><td></td></tr><tr class="row-CINE003A"><td>CINE003A</td><td>cine_referral_date</td><td>liquid_logic, mosaic</td><td>child_in_need, referral</td><td>CIN, AnnexA, RIIA</td><td></td></tr><tr class="row-CINE010A"><td>CINE010A</td><td>cine_cin_primary_need_code</td><td>liquid_logic, mosaic</td><td>child_in_need, referral</td><td>CIN, AnnexA, RIIA</td><td></td></tr><tr class="row-CINE004A"><td>CINE004A</td><td>cine_referral_source_code</td><td>liquid_logic, mosaic</td><td>child_in_need, referral</td><td>CIN, AnnexA, RIIA</td><td></td></tr><tr class="row-CINE012A"><td>CINE012A</td><td>cine_referral_source_desc</td><td></td><td>child_in_need, referral</td><td>Local</td><td></td></tr><tr class="row-CINE005A"><td>CINE005A</td><td>cine_referral_outcome_json</td><td>liquid_logic, mosaic</td><td>child_in_need, referral</td><td>AnnexA, RIIA</td><td></td></tr><tr class="row-CINE011A"><td>CINE011A</td><td>cine_referral_nfa</td><td>liquid_logic, mosaic</td><td>child_in_need, referral</td><td>CIN, AnnexA, RIIA</td><td></td></tr><tr class="row-CINE006A"><td>CINE006A</td><td>cine_close_reason</td><td>liquid_logic, mosaic</td><td>child_in_need</td><td>CIN, RIIA</td><td></td></tr><tr class="row-CINE007A"><td>CINE007A</td><td>cine_close_date</td><td>liquid_logic, mosaic</td><td>child_in_need</td><td>CIN, RIIA</td><td></td></tr><tr class="row-CINE008A"><td>CINE008A</td><td>cine_referral_team</td><td>liquid_logic, mosaic</td><td>child_in_need, referral</td><td>AnnexA, RIIA</td><td></td></tr><tr class="row-CINE009A"><td>CINE009A</td><td>cine_referral_worker_id</td><td>liquid_logic, mosaic</td><td>child_in_need, referral</td><td>AnnexA, RIIA</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_department</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_department.png" alt="ssd_department" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-DEPT1001A"><td>DEPT1001A</td><td>dept_team_id</td><td>liquid_logic, mosaic</td><td>workforce</td><td>Local</td><td></td></tr><tr class="row-DEPT1002A"><td>DEPT1002A</td><td>dept_team_name</td><td>liquid_logic, mosaic</td><td>workforce</td><td>Local,AnnexA</td><td></td></tr><tr class="row-DEPT1003A"><td>DEPT1003A</td><td>dept_team_parent_id</td><td>liquid_logic, mosaic</td><td>workforce</td><td>Local</td><td></td></tr><tr class="row-DEPT1004A"><td>DEPT1004A</td><td>dept_team_parent_name</td><td>liquid_logic, mosaic</td><td>workforce</td><td>Local</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_permanence</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_permanence.png" alt="ssd_permanence" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-PERM001A"><td>PERM001A</td><td>perm_table_id</td><td>liquid_logic, mosaic</td><td>looked_after, permanence, adoption</td><td>Local</td><td></td></tr><tr class="row-PERM002A"><td>PERM002A</td><td>perm_person_id</td><td>liquid_logic, mosaic</td><td>looked_after, permanence, adoption</td><td>Local</td><td></td></tr><tr class="row-PERM022A"><td>PERM022A</td><td>perm_cla_id</td><td>liquid_logic, mosaic</td><td>looked_after, permanence, adoption</td><td>Local</td><td></td></tr><tr class="row-PERM003A"><td>PERM003A</td><td>perm_adm_decision_date</td><td>liquid_logic, mosaic</td><td>looked_after, permanence, adoption</td><td>SSDA903, ASGLB</td><td></td></tr><tr class="row-PERM004A"><td>PERM004A</td><td>perm_ffa_cp_decision_date</td><td>liquid_logic, mosaic</td><td>looked_after, permanence, adoption</td><td>ASGLB, AnnexA</td><td></td></tr><tr class="row-PERM006A"><td>PERM006A</td><td>perm_placement_order_date</td><td>liquid_logic, mosaic</td><td>looked_after, permanence, adoption</td><td>SSDA903, AnnexA, ASGLB</td><td></td></tr><tr class="row-PERM007A"><td>PERM007A</td><td>perm_placed_for_adoption_date</td><td>liquid_logic, mosaic</td><td>looked_after, permanence, adoption</td><td>SSDA903, AnnexA, ASGLB</td><td></td></tr><tr class="row-PERM008A"><td>PERM008A</td><td>perm_matched_date</td><td>liquid_logic, mosaic</td><td>looked_after, permanence, adoption</td><td>SSDA903, AnnexA, ASGLB</td><td></td></tr><tr class="row-PERM021A"><td>PERM021A</td><td>perm_adopted_by_carer_flag</td><td>liquid_logic, mosaic</td><td>looked_after, permanence, adoption</td><td>SSDA903, AnnexA</td><td></td></tr><tr class="row-PERM009A"><td>PERM009A</td><td>perm_placed_ffa_cp_date</td><td>liquid_logic, mosaic</td><td>looked_after, permanence, adoption</td><td>AnnexA, ASGLB</td><td></td></tr><tr class="row-PERM010A"><td>PERM010A</td><td>perm_decision_reversed_date</td><td>liquid_logic, mosaic</td><td>looked_after, permanence, adoption</td><td>SSDA903, AnnexA, ASGLB</td><td></td></tr><tr class="row-PERM011A"><td>PERM011A</td><td>perm_placed_foster_carer_date</td><td>liquid_logic, mosaic</td><td>looked_after, permanence, adoption</td><td>AnnexA, ASGLB</td><td></td></tr><tr class="row-PERM012A"><td>PERM012A</td><td>perm_part_of_sibling_group</td><td>liquid_logic, mosaic</td><td>looked_after, permanence, adoption</td><td>ASGLB</td><td></td></tr><tr class="row-PERM013A"><td>PERM013A</td><td>perm_siblings_placed_together</td><td>liquid_logic, mosaic</td><td>looked_after, permanence, adoption</td><td>ASGLB</td><td></td></tr><tr class="row-PERM014A"><td>PERM014A</td><td>perm_siblings_placed_apart</td><td>liquid_logic, mosaic</td><td>looked_after, permanence, adoption</td><td>ASGLB</td><td></td></tr><tr class="row-PERM015A"><td>PERM015A</td><td>perm_placement_provider_urn</td><td>liquid_logic, mosaic</td><td>looked_after, permanence, adoption</td><td>Local</td><td></td></tr><tr class="row-PERM016A"><td>PERM016A</td><td>perm_decision_reversed_reason</td><td>liquid_logic, mosaic</td><td>looked_after, permanence, adoption</td><td>SSDA903, AnnexA, ASGLB</td><td></td></tr><tr class="row-PERM017A"><td>PERM017A</td><td>perm_permanence_order_date</td><td>liquid_logic, mosaic</td><td>looked_after, permanence</td><td>AnnexA, ASGLB</td><td></td></tr><tr class="row-PERM018A"><td>PERM018A</td><td>perm_permanence_order_type</td><td>liquid_logic, mosaic</td><td>looked_after, permanence</td><td>ASGLB</td><td></td></tr><tr class="row-PERM023A"><td>PERM023A</td><td>perm_adoption_worker_id</td><td>liquid_logic, mosaic</td><td>looked_after, permanence, adoption</td><td>Local</td><td></td></tr><tr class="row-PERM025A"><td>PERM025A</td><td>perm_adopter_sex</td><td></td><td>looked_after, permanence, adoption</td><td>SSDA903</td><td></td></tr><tr class="row-PERM026A"><td>PERM026A</td><td>perm_adopter_legal_status</td><td></td><td>looked_after, permanence, adoption</td><td>SSDA903</td><td></td></tr><tr class="row-PERM027A"><td>PERM027A</td><td>perm_number_of_adopters</td><td></td><td>looked_after, permanence, adoption</td><td>SSDA903</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_send</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_send.png" alt="ssd_send" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-SEND001A"><td>SEND001A</td><td>send_table_id</td><td>liquid_logic</td><td>identity, send</td><td>1aNotInCMS, RIIA</td><td></td></tr><tr class="row-SEND002A"><td>SEND002A</td><td>send_upn</td><td>liquid_logic</td><td>identity, send</td><td>1aNotInCMS, RIIA, SEN2</td><td></td></tr><tr class="row-SEND003A"><td>SEND003A</td><td>send_uln</td><td>liquid_logic</td><td>identity, send</td><td>1aNotInCMS, RIIA, SEN2</td><td></td></tr><tr class="row-SEND004A"><td>SEND004A</td><td>send_upn_unknown</td><td>liquid_logic</td><td>identity, send</td><td>1aNotInCMS, RIIA, SEN2</td><td></td></tr><tr class="row-SEND005A"><td>SEND005A</td><td>send_person_id</td><td>liquid_logic</td><td>identity, send</td><td>1aNotInCMS, RIIA</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_ehcp_named_plan</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_ehcp_named_plan.png" alt="ssd_ehcp_named_plan" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-EHCN001A"><td>EHCN001A</td><td>ehcn_named_plan_id</td><td>liquid_logic</td><td>send, ehcp_request, ehcp_assessment</td><td>1aNotInCMS</td><td></td></tr><tr class="row-EHCN002A"><td>EHCN002A</td><td>ehcn_ehcp_asmt_id</td><td>liquid_logic</td><td>send, ehcp_request, ehcp_assessment</td><td>1aNotInCMS</td><td></td></tr><tr class="row-EHCN003A"><td>EHCN003A</td><td>ehcn_named_plan_start_date</td><td>liquid_logic</td><td>send, ehcp_request, ehcp_assessment</td><td>1aNotInCMS, SEN2</td><td></td></tr><tr class="row-EHCN004A"><td>EHCN004A</td><td>ehcn_named_plan_ceased_date</td><td>liquid_logic</td><td>send, ehcp_request, ehcp_assessment</td><td>1aNotInCMS, SEN2</td><td></td></tr><tr class="row-EHCN005A"><td>EHCN005A</td><td>ehcn_named_plan_ceased_reason</td><td>liquid_logic</td><td>send, ehcp_request, ehcp_assessment</td><td>1aNotInCMS, SEN2</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_address</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_address.png" alt="ssd_address" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-ADDR007A"><td>ADDR007A</td><td>addr_table_id</td><td>liquid_logic, mosaic</td><td>identity, address</td><td>Local</td><td></td></tr><tr class="row-ADDR001A"><td>ADDR001A</td><td>addr_address_json</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>identity, address</td><td>Local</td><td></td></tr><tr class="row-ADDR002A"><td>ADDR002A</td><td>addr_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>identity, address</td><td>Local</td><td></td></tr><tr class="row-ADDR003A"><td>ADDR003A</td><td>addr_address_type</td><td>liquid_logic, mosaic</td><td>identity, address</td><td>Local</td><td></td></tr><tr class="row-ADDR004A"><td>ADDR004A</td><td>addr_address_start_date</td><td>liquid_logic, mosaic</td><td>identity, address</td><td>Local</td><td></td></tr><tr class="row-ADDR005A"><td>ADDR005A</td><td>addr_address_end_date</td><td>liquid_logic, mosaic</td><td>identity, address</td><td>Local</td><td></td></tr><tr class="row-ADDR006A"><td>ADDR006A</td><td>addr_address_postcode</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>identity, address</td><td>SSDA903, AnnexA, SEN2</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_assessment_factors</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_assessment_factors.png" alt="ssd_assessment_factors" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-CINF003A"><td>CINF003A</td><td>cinf_table_id</td><td></td><td>child_in_need, assessment</td><td>Local</td><td></td></tr><tr class="row-CINF001A"><td>CINF001A</td><td>cinf_assessment_id</td><td>liquid_logic, mosaic</td><td>child_in_need, assessment</td><td>Local</td><td></td></tr><tr class="row-CINF002A"><td>CINF002A</td><td>cinf_assessment_factors_json</td><td>liquid_logic, mosaic</td><td>child_in_need, assessment</td><td>CIN</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_disability</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_disability.png" alt="ssd_disability" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-DISA001A"><td>DISA001A</td><td>disa_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>identity, disability</td><td>Local</td><td></td></tr><tr class="row-DISA003A"><td>DISA003A</td><td>disa_table_id</td><td>liquid_logic, mosaic</td><td>identity, disability</td><td>Local</td><td></td></tr><tr class="row-DISA002A"><td>DISA002A</td><td>disa_disability_code</td><td>liquid_logic, mosaic</td><td>identity, disability</td><td>CIN, AnnexA</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_cla_substance_misuse</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_cla_substance_misuse.png" alt="ssd_cla_substance_misuse" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-CLAS001A"><td>CLAS001A</td><td>clas_substance_misuse_id</td><td>liquid_logic, mosaic</td><td>looked_after, health, substance_misuse</td><td>Local</td><td></td></tr><tr class="row-CLAS002A"><td>CLAS002A</td><td>clas_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>looked_after, health, substance_misuse</td><td>Local</td><td></td></tr><tr class="row-CLAS003A"><td>CLAS003A</td><td>clas_substance_misuse_date</td><td>liquid_logic, mosaic</td><td>looked_after, health, substance_misuse</td><td>SSDA903</td><td></td></tr><tr class="row-CLAS004A"><td>CLAS004A</td><td>clas_substance_misused</td><td>liquid_logic, mosaic</td><td>looked_after, health, substance_misuse</td><td>Local</td><td></td></tr><tr class="row-CLAS005A"><td>CLAS005A</td><td>clas_intervention_received</td><td>liquid_logic, mosaic</td><td>looked_after, health, substance_misuse</td><td>SSDA903</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_cp_reviews</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_cp_reviews.png" alt="ssd_cp_reviews" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-CPPR001A"><td>CPPR001A</td><td>cppr_cp_review_id</td><td>liquid_logic, mosaic</td><td>child_protection, cp_plan, review</td><td>Local</td><td></td></tr><tr class="row-CPPR008A"><td>CPPR008A</td><td>cppr_person_id</td><td>liquid_logic, mosaic</td><td>child_protection, cp_plan, review</td><td>Local</td><td></td></tr><tr class="row-CPPR002A"><td>CPPR002A</td><td>cppr_cp_plan_id</td><td>liquid_logic, mosaic</td><td>child_protection, cp_plan, review</td><td>Local</td><td></td></tr><tr class="row-CPPR003A"><td>CPPR003A</td><td>cppr_cp_review_due</td><td>liquid_logic, mosaic</td><td>child_protection, cp_plan, review</td><td>Local</td><td></td></tr><tr class="row-CPPR004A"><td>CPPR004A</td><td>cppr_cp_review_date</td><td>liquid_logic, mosaic</td><td>child_protection, cp_plan, review</td><td>CIN, AnnexA</td><td></td></tr><tr class="row-CPPR009A"><td>CPPR009A</td><td>cppr_cp_review_meeting_id</td><td></td><td>child_protection, cp_plan, review</td><td>Local</td><td></td></tr><tr class="row-CPPR005A"><td>CPPR005A</td><td>cppr_cp_review_outcome_continue_cp</td><td>liquid_logic, mosaic</td><td>child_protection, cp_plan, review</td><td>Local</td><td></td></tr><tr class="row-CPPR006A"><td>CPPR006A</td><td>cppr_cp_review_quorate</td><td>liquid_logic, mosaic</td><td>child_protection, cp_plan, review</td><td>Local</td><td></td></tr><tr class="row-CPPR007A"><td>CPPR007A</td><td>cppr_cp_review_participation</td><td>liquid_logic, mosaic</td><td>child_protection, cp_plan, review</td><td>Local</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_contacts</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_contacts.png" alt="ssd_contacts" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-CONT001A"><td>CONT001A</td><td>cont_contact_id</td><td>liquid_logic, mosaic</td><td>contact</td><td>Local</td><td></td></tr><tr class="row-CONT002A"><td>CONT002A</td><td>cont_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>contact</td><td>Local</td><td></td></tr><tr class="row-CONT003A"><td>CONT003A</td><td>cont_contact_date</td><td>liquid_logic, mosaic, azeus</td><td>contact</td><td>AnnexA, RIIA</td><td></td></tr><tr class="row-CONT004A"><td>CONT004A</td><td>cont_contact_source_code</td><td>liquid_logic, mosaic, azeus</td><td>contact</td><td>AnnexA, RIIA</td><td></td></tr><tr class="row-CONT006A"><td>CONT006A</td><td>cont_contact_source_desc</td><td></td><td>contact</td><td>Local</td><td></td></tr><tr class="row-CONT005A"><td>CONT005A</td><td>cont_contact_outcome_json</td><td>liquid_logic, mosaic</td><td>contact</td><td>ADCS_SP, RIIA</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_care_leavers</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_care_leavers.png" alt="ssd_care_leavers" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-CLEA001A"><td>CLEA001A</td><td>clea_table_id</td><td>liquid_logic, mosaic</td><td>care_leavers</td><td>Local</td><td></td></tr><tr class="row-CLEA002A"><td>CLEA002A</td><td>clea_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>care_leavers</td><td>Local</td><td></td></tr><tr class="row-CLEA003A"><td>CLEA003A</td><td>clea_care_leaver_eligibility</td><td>liquid_logic, mosaic</td><td>care_leavers</td><td>AnnexA, RIIA</td><td></td></tr><tr class="row-CLEA004A"><td>CLEA004A</td><td>clea_care_leaver_in_touch</td><td>liquid_logic, mosaic</td><td>care_leavers</td><td>SSDA903, RIIA</td><td></td></tr><tr class="row-CLEA005A"><td>CLEA005A</td><td>clea_care_leaver_latest_contact</td><td>liquid_logic, mosaic</td><td>care_leavers</td><td>AnnexA, RIIA</td><td></td></tr><tr class="row-CLEA006A"><td>CLEA006A</td><td>clea_care_leaver_accommodation</td><td>liquid_logic, mosaic</td><td>care_leavers</td><td>SSDA903, RIIA, AnnexA</td><td></td></tr><tr class="row-CLEA007A"><td>CLEA007A</td><td>clea_care_leaver_accom_suitable</td><td>liquid_logic, mosaic</td><td>care_leavers</td><td>AnnexA, RIIA</td><td></td></tr><tr class="row-CLEA008A"><td>CLEA008A</td><td>clea_care_leaver_activity</td><td>liquid_logic, mosaic</td><td>care_leavers</td><td>SSDA903, RIIA, AnnexA</td><td></td></tr><tr class="row-CLEA009A"><td>CLEA009A</td><td>clea_pathway_plan_review_date</td><td>liquid_logic, mosaic</td><td>care_leavers</td><td>AnnexA, RIIA</td><td></td></tr><tr class="row-CLEA010A"><td>CLEA010A</td><td>clea_care_leaver_personal_advisor</td><td>liquid_logic, mosaic</td><td>care_leavers</td><td>AnnexA, RIIA</td><td></td></tr><tr class="row-CLEA011A"><td>CLEA011A</td><td>clea_care_leaver_allocated_team</td><td>liquid_logic, mosaic</td><td>care_leavers</td><td>AnnexA, RIIA</td><td></td></tr><tr class="row-CLEA012A"><td>CLEA012A</td><td>clea_care_leaver_worker_id</td><td>liquid_logic, mosaic</td><td>care_leavers</td><td>AnnexA, RIIA</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_cla_visits</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_cla_visits.png" alt="ssd_cla_visits" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-CLAV001A"><td>CLAV001A</td><td>clav_cla_visit_id</td><td>liquid_logic, mosaic</td><td>looked_after, visit</td><td>Local</td><td></td></tr><tr class="row-CLAV007A"><td>CLAV007A</td><td>clav_cla_id</td><td></td><td>looked_after, visit</td><td>Local</td><td></td></tr><tr class="row-CLAV008A"><td>CLAV008A</td><td>clav_person_id</td><td>liquid_logic, mosaic</td><td>looked_after, visit</td><td>Local</td><td></td></tr><tr class="row-CLAV003A"><td>CLAV003A</td><td>clav_cla_visit_date</td><td>liquid_logic, mosaic</td><td>looked_after, visit</td><td>AnnexA</td><td></td></tr><tr class="row-CLAV004A"><td>CLAV004A</td><td>clav_cla_visit_seen</td><td>liquid_logic, mosaic</td><td>looked_after, visit</td><td>Local</td><td></td></tr><tr class="row-CLAV005A"><td>CLAV005A</td><td>clav_cla_visit_seen_alone</td><td>liquid_logic, mosaic</td><td>looked_after, visit</td><td>Local</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_professionals</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_professionals.png" alt="ssd_professionals" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-PROF001A"><td>PROF001A</td><td>prof_professional_id</td><td>liquid_logic</td><td>workforce</td><td>Local</td><td></td></tr><tr class="row-PROF010A"><td>PROF010A</td><td>prof_staff_id</td><td>liquid_logic, mosaic, azeus</td><td>workforce</td><td>Local</td><td></td></tr><tr class="row-PROF013A"><td>PROF013A</td><td>prof_professional_name</td><td>liquid_logic, mosaic, azeus</td><td>workforce</td><td>AnnexA</td><td></td></tr><tr class="row-PROF002A"><td>PROF002A</td><td>prof_social_worker_registration_no</td><td>liquid_logic, mosaic, azeus</td><td>workforce</td><td>Local</td><td></td></tr><tr class="row-PROF007A"><td>PROF007A</td><td>prof_professional_job_title</td><td>liquid_logic, mosaic</td><td>workforce</td><td>CSCWF, RIIA</td><td></td></tr><tr class="row-PROF008A"><td>PROF008A</td><td>prof_professional_caseload</td><td>liquid_logic, mosaic</td><td>workforce</td><td>CSCWF, RIIA</td><td></td></tr><tr class="row-PROF012A"><td>PROF012A</td><td>prof_professional_department</td><td>liquid_logic, mosaic</td><td>workforce</td><td>Local</td><td></td></tr><tr class="row-PROF011A"><td>PROF011A</td><td>prof_full_time_equivalency</td><td>liquid_logic, mosaic</td><td>workforce</td><td>Local</td><td></td></tr><tr class="row-PROF014A"><td>PROF014A</td><td>prof_agency_worker_flag</td><td></td><td>workforce</td><td>Local</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_missing</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_missing.png" alt="ssd_missing" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-MISS001A"><td>MISS001A</td><td>miss_table_id</td><td>liquid_logic, mosaic</td><td>looked_after, missing</td><td>Local</td><td></td></tr><tr class="row-MISS002A"><td>MISS002A</td><td>miss_person_id</td><td>liquid_logic, mosaic</td><td>looked_after, missing</td><td>Local</td><td></td></tr><tr class="row-MISS003A"><td>MISS003A</td><td>miss_missing_episode_start_date</td><td>liquid_logic, mosaic</td><td>looked_after, missing</td><td>SSDA903, AnnexA</td><td></td></tr><tr class="row-MISS004A"><td>MISS004A</td><td>miss_missing_episode_type</td><td>liquid_logic, mosaic</td><td>looked_after, missing</td><td>SSDA903, AnnexA</td><td></td></tr><tr class="row-MISS005A"><td>MISS005A</td><td>miss_missing_episode_end_date</td><td>liquid_logic, mosaic</td><td>looked_after, missing</td><td>SSDA903, AnnexA</td><td></td></tr><tr class="row-MISS006A"><td>MISS006A</td><td>miss_missing_rhi_offered</td><td>liquid_logic, mosaic</td><td>looked_after, missing</td><td>AnnexA</td><td></td></tr><tr class="row-MISS007A"><td>MISS007A</td><td>miss_missing_rhi_accepted</td><td>liquid_logic, mosaic</td><td>looked_after, missing</td><td>AnnexA</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_legal_status</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_legal_status.png" alt="ssd_legal_status" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-LEGA001A"><td>LEGA001A</td><td>lega_legal_status_id</td><td>liquid_logic, mosaic</td><td>identity, looked_after</td><td>Local</td><td></td></tr><tr class="row-LEGA002A"><td>LEGA002A</td><td>lega_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>identity, looked_after</td><td>Local</td><td></td></tr><tr class="row-LEGA003A"><td>LEGA003A</td><td>lega_legal_status</td><td>liquid_logic, mosaic</td><td>identity, looked_after</td><td>SSDA903, AnnexA, RIIA</td><td></td></tr><tr class="row-LEGA004A"><td>LEGA004A</td><td>lega_legal_status_start_date</td><td>liquid_logic, mosaic</td><td>identity, looked_after</td><td>RIIA</td><td></td></tr><tr class="row-LEGA005A"><td>LEGA005A</td><td>lega_legal_status_end_date</td><td>liquid_logic, mosaic</td><td>identity, looked_after</td><td>RIIA</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_s251_finance</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_s251_finance.png" alt="ssd_s251_finance" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-S251001A"><td>S251001A</td><td>s251_table_id</td><td>liquid_logic, mosaic</td><td>finance</td><td>1aDraft</td><td></td></tr><tr class="row-S251002A"><td>S251002A</td><td>s251_cla_placement_id</td><td>liquid_logic, mosaic</td><td>finance</td><td>1aDraft</td><td></td></tr><tr class="row-S251003A"><td>S251003A</td><td>s251_placeholder_1</td><td>liquid_logic, mosaic</td><td>finance</td><td>1aDraft</td><td></td></tr><tr class="row-S251004A"><td>S251004A</td><td>s251_placeholder_2</td><td>liquid_logic, mosaic</td><td>finance</td><td>1aDraft</td><td></td></tr><tr class="row-S251005A"><td>S251005A</td><td>s251_placeholder_3</td><td>liquid_logic, mosaic</td><td>finance</td><td>1aDraft</td><td></td></tr><tr class="row-S251006A"><td>S251006A</td><td>s251_placeholder_4</td><td>liquid_logic, mosaic</td><td>finance</td><td>1aDraft</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_person</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_person.png" alt="ssd_person" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-PERS001A"><td>PERS001A</td><td>pers_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>identity</td><td>SSDA903, CIN, AnnexA, RIIA, SEN2</td><td></td></tr><tr class="row-PERS002A"><td>PERS002A</td><td>pers_sex</td><td>liquid_logic, mosaic, eclipse, caredirector</td><td>identity</td><td>SSDA903, RIIA, AnnexA, SEN2</td><td></td></tr><tr class="row-PERS003A"><td>PERS003A</td><td>pers_gender</td><td>liquid_logic, mosaic, azeus</td><td>identity</td><td>CIN, RIIA</td><td></td></tr><tr class="row-PERS004A"><td>PERS004A</td><td>pers_ethnicity</td><td>liquid_logic, mosaic, azeus</td><td>identity</td><td>SSDA903, CIN, AnnexA, RIIA, SEN2</td><td></td></tr><tr class="row-PERS005A"><td>PERS005A</td><td>pers_dob</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>identity</td><td>SSDA903, CIN, AnnexA, RIIA, SEN2</td><td></td></tr><tr class="row-PERS013A"><td>PERS013A</td><td>pers_common_child_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>identity</td><td>Local</td><td></td></tr><tr class="row-PERS014A"><td>PERS014A</td><td>pers_legacy_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>identity</td><td>Local</td><td></td></tr><tr class="row-PERS007A"><td>PERS007A</td><td>pers_upn_unknown</td><td>liquid_logic, mosaic, azeus</td><td>identity</td><td>RIIA, CIN, SEN2</td><td></td></tr><tr class="row-PERS008A"><td>PERS008A</td><td>pers_send_flag</td><td>liquid_logic</td><td>identity</td><td>NEETandparticipation, RIIA</td><td></td></tr><tr class="row-PERS009A"><td>PERS009A</td><td>pers_expected_dob</td><td>liquid_logic, azeus</td><td>identity</td><td>CIN, RIIA</td><td></td></tr><tr class="row-PERS010A"><td>PERS010A</td><td>pers_death_date</td><td>liquid_logic, azeus</td><td>identity</td><td>CIN, RIIA</td><td></td></tr><tr class="row-PERS011A"><td>PERS011A</td><td>pers_is_mother</td><td>liquid_logic, azeus</td><td>identity</td><td>SSDA903, RIIA</td><td></td></tr><tr class="row-PERS012A"><td>PERS012A</td><td>pers_nationality</td><td>liquid_logic, mosaic</td><td>identity</td><td>ADCS_SP, RIIA</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_cp_visits</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_cp_visits.png" alt="ssd_cp_visits" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-CPPV007A"><td>CPPV007A</td><td>cppv_cp_visit_id</td><td></td><td>child_protection, cp_plan, visit</td><td>Local</td><td></td></tr><tr class="row-CPPV008A"><td>CPPV008A</td><td>cppv_person_id</td><td>liquid_logic, mosaic</td><td>child_protection, cp_plan, visit</td><td>Local</td><td></td></tr><tr class="row-CPPV001A"><td>CPPV001A</td><td>cppv_cp_plan_id</td><td>liquid_logic, mosaic</td><td>child_protection, cp_plan, visit</td><td>Local</td><td></td></tr><tr class="row-CPPV003A"><td>CPPV003A</td><td>cppv_cp_visit_date</td><td>liquid_logic, mosaic</td><td>child_protection, cp_plan, visit</td><td>AnnexA</td><td></td></tr><tr class="row-CPPV004A"><td>CPPV004A</td><td>cppv_cp_visit_seen</td><td>liquid_logic, mosaic</td><td>child_protection, cp_plan, visit</td><td>Local</td><td></td></tr><tr class="row-CPPV005A"><td>CPPV005A</td><td>cppv_cp_visit_seen_alone</td><td>liquid_logic, mosaic</td><td>child_protection, cp_plan, visit</td><td>AnnexA</td><td></td></tr><tr class="row-CPPV006A"><td>CPPV006A</td><td>cppv_cp_visit_bedroom</td><td>liquid_logic, mosaic</td><td>child_protection, cp_plan, visit</td><td>Local</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_s47_enquiry</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_s47_enquiry.png" alt="ssd_s47_enquiry" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-S47E001A"><td>S47E001A</td><td>s47e_s47_enquiry_id</td><td>liquid_logic, mosaic</td><td>s47_enquiry, child_protection</td><td>Local</td><td></td></tr><tr class="row-S47E010A"><td>S47E010A</td><td>s47e_referral_id</td><td>liquid_logic, mosaic</td><td>s47_enquiry, child_protection</td><td>Local</td><td></td></tr><tr class="row-S47E002A"><td>S47E002A</td><td>s47e_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>s47_enquiry, child_protection</td><td>Local</td><td></td></tr><tr class="row-S47E004A"><td>S47E004A</td><td>s47e_s47_start_date</td><td>liquid_logic, mosaic</td><td>s47_enquiry, child_protection</td><td>CIN, RIIA, AnnexA</td><td></td></tr><tr class="row-S47E005A"><td>S47E005A</td><td>s47e_s47_end_date</td><td>liquid_logic, mosaic</td><td>s47_enquiry, child_protection</td><td>RIIA, AnnexA</td><td></td></tr><tr class="row-S47E006A"><td>S47E006A</td><td>s47e_s47_nfa</td><td>liquid_logic, mosaic</td><td>s47_enquiry, child_protection</td><td>AnnexA</td><td></td></tr><tr class="row-S47E007A"><td>S47E007A</td><td>s47e_s47_outcome_json</td><td>liquid_logic, mosaic</td><td>s47_enquiry, child_protection</td><td>Local</td><td></td></tr><tr class="row-S47E008A"><td>S47E008A</td><td>s47e_s47_completed_by_worker_id</td><td>liquid_logic, mosaic</td><td>s47_enquiry, child_protection</td><td>Local</td><td></td></tr><tr class="row-S47E009A"><td>S47E009A</td><td>s47e_s47_completed_by_team</td><td>liquid_logic, mosaic</td><td>s47_enquiry, child_protection</td><td>Local</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_involvements</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_involvements.png" alt="ssd_involvements" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-INVO005A"><td>INVO005A</td><td>invo_involvements_id</td><td>liquid_logic, mosaic</td><td>workforce</td><td>Local</td><td></td></tr><tr class="row-INVO006A"><td>INVO006A</td><td>invo_professional_id</td><td>liquid_logic, mosaic</td><td>workforce</td><td>Local</td><td></td></tr><tr class="row-INVO007A"><td>INVO007A</td><td>invo_professional_role_id</td><td>liquid_logic, mosaic</td><td>workforce</td><td>Local</td><td></td></tr><tr class="row-INVO009A"><td>INVO009A</td><td>invo_professional_team</td><td>liquid_logic, mosaic</td><td>workforce</td><td>AnnexA</td><td></td></tr><tr class="row-INVO002A"><td>INVO002A</td><td>invo_involvement_start_date</td><td>liquid_logic, azeus</td><td>workforce</td><td>RIIA</td><td></td></tr><tr class="row-INVO003A"><td>INVO003A</td><td>invo_involvement_end_date</td><td>liquid_logic, azeus</td><td>workforce</td><td>RIIA</td><td></td></tr><tr class="row-INVO004A"><td>INVO004A</td><td>invo_worker_change_reason</td><td>liquid_logic, azeus</td><td>workforce</td><td>RIIA</td><td></td></tr><tr class="row-INVO011A"><td>INVO011A</td><td>invo_person_id</td><td></td><td>workforce</td><td>Local</td><td></td></tr><tr class="row-INVO010A"><td>INVO010A</td><td>invo_referral_id</td><td>liquid_logic, mosaic</td><td>workforce</td><td>Local</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_version_log</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_version_log.png" alt="ssd_version_log" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-VERS1001A"><td>VERS1001A</td><td>version_number</td><td></td><td>admin</td><td></td><td></td></tr><tr class="row-VERS1002A"><td>VERS1002A</td><td>release_date</td><td></td><td>admin</td><td></td><td></td></tr><tr class="row-VERS1003A"><td>VERS1003A</td><td>description</td><td></td><td>admin</td><td></td><td></td></tr><tr class="row-VERS1004A"><td>VERS1004A</td><td>is_current</td><td></td><td>admin</td><td></td><td></td></tr><tr class="row-VERS1005A"><td>VERS1005A</td><td>created_at</td><td></td><td>admin</td><td></td><td></td></tr><tr class="row-VERS1006A"><td>VERS1006A</td><td>created_by</td><td></td><td>admin</td><td></td><td></td></tr><tr class="row-VERS1007A"><td>VERS1007A</td><td>impact_description</td><td></td><td>admin</td><td></td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_cin_plans</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_cin_plans.png" alt="ssd_cin_plans" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-CINP001A"><td>CINP001A</td><td>cinp_cin_plan_id</td><td>liquid_logic, mosaic</td><td>child_in_need, cin_plan</td><td>RIIA</td><td></td></tr><tr class="row-CINP007A"><td>CINP007A</td><td>cinp_referral_id</td><td>liquid_logic, mosaic</td><td>child_in_need, cin_plan</td><td>Local</td><td></td></tr><tr class="row-CINP002A"><td>CINP002A</td><td>cinp_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>child_in_need, cin_plan</td><td>Local</td><td></td></tr><tr class="row-CINP003A"><td>CINP003A</td><td>cinp_cin_plan_start_date</td><td>liquid_logic, mosaic</td><td>child_in_need, cin_plan</td><td>CIN, RIIA, AnnexA</td><td></td></tr><tr class="row-CINP004A"><td>CINP004A</td><td>cinp_cin_plan_end_date</td><td>liquid_logic, mosaic</td><td>child_in_need, cin_plan</td><td>RIIA, CIN, AnnexA</td><td></td></tr><tr class="row-CINP005A"><td>CINP005A</td><td>cinp_cin_plan_team</td><td>liquid_logic, mosaic</td><td>child_in_need, cin_plan</td><td>AnnexA, RIIA</td><td></td></tr><tr class="row-CINP006A"><td>CINP006A</td><td>cinp_cin_plan_worker_id</td><td>liquid_logic, mosaic</td><td>child_in_need, cin_plan</td><td>AnnexA, RIIA</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_cla_convictions</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_cla_convictions.png" alt="ssd_cla_convictions" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-CLAC001A"><td>CLAC001A</td><td>clac_cla_conviction_id</td><td>liquid_logic, mosaic</td><td>looked_after, convictions</td><td>Local</td><td></td></tr><tr class="row-CLAC002A"><td>CLAC002A</td><td>clac_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>looked_after, convictions</td><td>Local</td><td></td></tr><tr class="row-CLAC003A"><td>CLAC003A</td><td>clac_cla_conviction_date</td><td>liquid_logic, mosaic</td><td>looked_after, convictions</td><td>SSDA903</td><td></td></tr><tr class="row-CLAC004A"><td>CLAC004A</td><td>clac_cla_conviction_offence</td><td></td><td>looked_after, convictions</td><td>Local</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_mother</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_mother.png" alt="ssd_mother" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-MOTH004A"><td>MOTH004A</td><td>moth_table_id</td><td></td><td>identity, looked_after, mother</td><td>Local</td><td></td></tr><tr class="row-MOTH002A"><td>MOTH002A</td><td>moth_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>identity, looked_after, mother</td><td>Local</td><td></td></tr><tr class="row-MOTH001A"><td>MOTH001A</td><td>moth_childs_person_id</td><td>liquid_logic, mosaic</td><td>identity, looked_after, mother</td><td>Local</td><td></td></tr><tr class="row-MOTH003A"><td>MOTH003A</td><td>moth_childs_dob</td><td>liquid_logic, mosaic</td><td>identity, looked_after, mother</td><td>SSDA903, AnnexA</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_cla_previous_permanence</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_cla_previous_permanence.png" alt="ssd_cla_previous_permanence" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-LAPP001A"><td>LAPP001A</td><td>lapp_table_id</td><td>liquid_logic, mosaic</td><td>looked_after, permanence</td><td>Local</td><td></td></tr><tr class="row-LAPP002A"><td>LAPP002A</td><td>lapp_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>looked_after, permanence</td><td>Local</td><td></td></tr><tr class="row-LAPP003A"><td>LAPP003A</td><td>lapp_previous_permanence_order_date</td><td>liquid_logic, mosaic</td><td>looked_after, permanence</td><td>SSDA903</td><td></td></tr><tr class="row-LAPP004A"><td>LAPP004A</td><td>lapp_previous_permanence_option</td><td>liquid_logic, mosaic</td><td>looked_after, permanence</td><td>SSDA903</td><td></td></tr><tr class="row-LAPP005A"><td>LAPP005A</td><td>lapp_previous_permanence_la</td><td>liquid_logic, mosaic</td><td>looked_after, permanence</td><td>SSDA903</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_initial_cp_conference</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_initial_cp_conference.png" alt="ssd_initial_cp_conference" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-ICPC001A"><td>ICPC001A</td><td>icpc_icpc_id</td><td></td><td>initial_cp_conference, child_protection</td><td>Local</td><td></td></tr><tr class="row-ICPC009A"><td>ICPC009A</td><td>icpc_icpc_meeting_id</td><td></td><td></td><td>Local</td><td></td></tr><tr class="row-ICPC002A"><td>ICPC002A</td><td>icpc_s47_enquiry_id</td><td>liquid_logic, mosaic</td><td></td><td>RIIA</td><td></td></tr><tr class="row-ICPC010A"><td>ICPC010A</td><td>icpc_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>s47_enquiry, child_protection</td><td>Local</td><td></td></tr><tr class="row-ICPC011A"><td>ICPC011A</td><td>icpc_cp_plan_id</td><td>liquid_logic, mosaic</td><td>child_protection, cp_plan</td><td>RIIA, AnnexA</td><td></td></tr><tr class="row-ICPC012A"><td>ICPC012A</td><td>icpc_referral_id</td><td>liquid_logic, mosaic</td><td></td><td>Local</td><td></td></tr><tr class="row-ICPC003A"><td>ICPC003A</td><td>icpc_icpc_transfer_in</td><td>liquid_logic, mosaic</td><td>initial_cp_conference, child_protection</td><td>RIIA, AnnexA</td><td></td></tr><tr class="row-ICPC004A"><td>ICPC004A</td><td>icpc_icpc_target_date</td><td>liquid_logic, mosaic</td><td>initial_cp_conference, child_protection</td><td>CIN</td><td></td></tr><tr class="row-ICPC005A"><td>ICPC005A</td><td>icpc_icpc_date</td><td>liquid_logic, mosaic</td><td>initial_cp_conference, child_protection</td><td>CIN, RIIA, AnnexA</td><td></td></tr><tr class="row-ICPC013A"><td>ICPC013A</td><td>icpc_icpc_outcome_cp_flag</td><td></td><td></td><td>AnnexA</td><td></td></tr><tr class="row-ICPC006A"><td>ICPC006A</td><td>icpc_icpc_outcome_json</td><td>liquid_logic, mosaic</td><td>initial_cp_conference, child_protection</td><td>AnnexA, RIIA</td><td></td></tr><tr class="row-ICPC007A"><td>ICPC007A</td><td>icpc_icpc_team</td><td>liquid_logic, mosaic</td><td>initial_cp_conference, child_protection</td><td>AnnexA, RIIA</td><td></td></tr><tr class="row-ICPC008A"><td>ICPC008A</td><td>icpc_icpc_worker_id</td><td>liquid_logic, mosaic</td><td>initial_cp_conference, child_protection</td><td>AnnexA, RIIA</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_cla_episodes</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_cla_episodes.png" alt="ssd_cla_episodes" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-CLAE001A"><td>CLAE001A</td><td>clae_cla_episode_id</td><td>liquid_logic, mosaic</td><td>looked_after</td><td>RIIA</td><td></td></tr><tr class="row-CLAE002A"><td>CLAE002A</td><td>clae_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>looked_after</td><td>Local</td><td></td></tr><tr class="row-CLAE003A"><td>CLAE003A</td><td>clae_cla_episode_start_date</td><td>liquid_logic, mosaic</td><td>looked_after</td><td>SSDA903, RIIA, AnnexA</td><td></td></tr><tr class="row-CLAE004A"><td>CLAE004A</td><td>clae_cla_episode_start_reason</td><td>liquid_logic, mosaic</td><td>looked_after</td><td>SSDA903, RIIA</td><td></td></tr><tr class="row-CLAE009A"><td>CLAE009A</td><td>clae_cla_primary_need_code</td><td>liquid_logic, mosaic</td><td>looked_after</td><td>SSDA903, AnnexA, RIIA</td><td></td></tr><tr class="row-CLAE005A"><td>CLAE005A</td><td>clae_cla_episode_ceased</td><td>liquid_logic, mosaic</td><td>looked_after</td><td>SSDA903, AnnexA, RIIA</td><td></td></tr><tr class="row-CLAE006A"><td>CLAE006A</td><td>clae_cla_episode_ceased_reason</td><td>liquid_logic, mosaic</td><td>looked_after</td><td>SSDA903, AnnexA, RIIA</td><td></td></tr><tr class="row-CLAE010A"><td>CLAE010A</td><td>clae_cla_id</td><td>liquid_logic, mosaic</td><td>looked_after</td><td>Local</td><td></td></tr><tr class="row-CLAE011A"><td>CLAE011A</td><td>clae_referral_id</td><td>liquid_logic, mosaic</td><td>looked_after</td><td>Local</td><td></td></tr><tr class="row-CLAE013A"><td>CLAE013A</td><td>clae_cla_placement_id</td><td>liquid_logic, mosaic</td><td>looked_after</td><td>Local</td><td></td></tr><tr class="row-CLAE014A"><td>CLAE014A</td><td>clae_entered_care_date</td><td>liquid_logic, mosaic</td><td>looked_after</td><td>SSD903</td><td></td></tr><tr class="row-CLAE012A"><td>CLAE012A</td><td>clae_cla_last_iro_contact_date</td><td>liquid_logic, mosaic</td><td>looked_after</td><td>AnnexA</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_sdq_scores</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_sdq_scores.png" alt="ssd_sdq_scores" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-CSDQ001A"><td>CSDQ001A</td><td>csdq_table_id</td><td>liquid_logic, mosaic</td><td>looked_after, sdq</td><td>Local</td><td></td></tr><tr class="row-CSDQ002A"><td>CSDQ002A</td><td>csdq_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>looked_after, sdq</td><td>Local</td><td></td></tr><tr class="row-CSDQ003A"><td>CSDQ003A</td><td>csdq_sdq_completed_date</td><td>liquid_logic, mosaic</td><td>looked_after, sdq</td><td>Local</td><td></td></tr><tr class="row-CSDQ004A"><td>CSDQ004A</td><td>csdq_sdq_reason</td><td>liquid_logic, mosaic</td><td>looked_after, sdq</td><td>SSDA903</td><td></td></tr><tr class="row-CSDQ005A"><td>CSDQ005A</td><td>csdq_sdq_score</td><td>liquid_logic, mosaic</td><td>looked_after, sdq</td><td>SSDA903</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_family</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_family.png" alt="ssd_family" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-FAMI003A"><td>FAMI003A</td><td>fami_table_id</td><td></td><td>identity, family</td><td>Local</td><td></td></tr><tr class="row-FAMI001A"><td>FAMI001A</td><td>fami_family_id</td><td>liquid_logic, mosaic</td><td>identity, family</td><td>ASGLB, AnnexA</td><td></td></tr><tr class="row-FAMI002A"><td>FAMI002A</td><td>fami_person_id</td><td>liquid_logic, mosaic</td><td>identity, family</td><td>Local</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_cin_assessments</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_cin_assessments.png" alt="ssd_cin_assessments" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-CINA001A"><td>CINA001A</td><td>cina_assessment_id</td><td>liquid_logic, mosaic</td><td>child_in_need, assessment</td><td>CIN, RIIA</td><td></td></tr><tr class="row-CINA002A"><td>CINA002A</td><td>cina_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>child_in_need, assessment</td><td>Local</td><td></td></tr><tr class="row-CINA010A"><td>CINA010A</td><td>cina_referral_id</td><td>liquid_logic, mosaic</td><td>child_in_need, assessment</td><td>Local</td><td></td></tr><tr class="row-CINA003A"><td>CINA003A</td><td>cina_assessment_start_date</td><td>liquid_logic, mosaic</td><td>child_in_need, assessment</td><td>CIN, RIIA</td><td></td></tr><tr class="row-CINA004A"><td>CINA004A</td><td>cina_assessment_child_seen</td><td>liquid_logic, mosaic</td><td>child_in_need, assessment</td><td>AnnexA, RIIA</td><td></td></tr><tr class="row-CINA005A"><td>CINA005A</td><td>cina_assessment_auth_date</td><td>liquid_logic, mosaic</td><td>child_in_need, assessment</td><td>CIN, RIIA, AnnexA</td><td></td></tr><tr class="row-CINA006A"><td>CINA006A</td><td>cina_assessment_outcome_json</td><td>liquid_logic, mosaic</td><td>child_in_need, assessment</td><td>AnnexA, RIIA</td><td></td></tr><tr class="row-CINA009A"><td>CINA009A</td><td>cina_assessment_outcome_nfa</td><td>liquid_logic, mosaic</td><td>child_in_need, assessment</td><td>CIN, RIIA, AnnexA</td><td></td></tr><tr class="row-CINA007A"><td>CINA007A</td><td>cina_assessment_team</td><td>liquid_logic, mosaic</td><td>child_in_need, assessment</td><td>AnnexA, RIIA</td><td></td></tr><tr class="row-CINA008A"><td>CINA008A</td><td>cina_assessment_worker_id</td><td>liquid_logic, mosaic</td><td>child_in_need, assessment</td><td>AnnexA, RIIA</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_cla_health</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_cla_health.png" alt="ssd_cla_health" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-CLAH001A"><td>CLAH001A</td><td>clah_health_check_id</td><td></td><td>looked_after, health</td><td>Local</td><td></td></tr><tr class="row-CLAH002A"><td>CLAH002A</td><td>clah_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>looked_after, health</td><td>Local</td><td></td></tr><tr class="row-CLAH003A"><td>CLAH003A</td><td>clah_health_check_type</td><td>liquid_logic, mosaic</td><td>looked_after, health</td><td>SSDA903, AnnexA</td><td></td></tr><tr class="row-CLAH004A"><td>CLAH004A</td><td>clah_health_check_date</td><td>liquid_logic, mosaic</td><td>looked_after, health</td><td>SSDA903, AnnexA</td><td></td></tr><tr class="row-CLAH005A"><td>CLAH005A</td><td>clah_health_check_status</td><td>liquid_logic, mosaic</td><td>looked_after, health</td><td>SSDA903, AnnexA</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_voice_of_child</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_voice_of_child.png" alt="ssd_voice_of_child" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-VOCH007A"><td>VOCH007A</td><td>voch_table_id</td><td>liquid_logic, mosaic</td><td>voice_of_child</td><td>1bDraft</td><td></td></tr><tr class="row-VOCH001A"><td>VOCH001A</td><td>voch_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>voice_of_child</td><td>Local</td><td></td></tr><tr class="row-VOCH002A"><td>VOCH002A</td><td>voch_explained_worries</td><td>liquid_logic, mosaic</td><td>voice_of_child</td><td>1bDraft</td><td>release: In review|pending<br>change_id: SSD-0023<br>change_source: 1bDraft<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-VOCH003A"><td>VOCH003A</td><td>voch_story_help_understand</td><td>liquid_logic, mosaic</td><td>voice_of_child</td><td>1bDraft</td><td>release: In review|pending<br>change_id: SSD-0024<br>change_source: 1bDraft<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-VOCH004A"><td>VOCH004A</td><td>voch_agree_worker</td><td>liquid_logic, mosaic</td><td>voice_of_child</td><td>1bDraft</td><td>release: In review|pending<br>change_id: SSD-0025<br>change_source: 1bDraft<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-VOCH005A"><td>VOCH005A</td><td>voch_plan_safe</td><td>liquid_logic, mosaic</td><td>voice_of_child</td><td>1bDraft</td><td>release: In review|pending<br>change_id: SSD-0026<br>change_source: 1bDraft<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-VOCH006A"><td>VOCH006A</td><td>voch_tablet_help_explain</td><td>liquid_logic, mosaic</td><td>voice_of_child</td><td>1bDraft</td><td>release: In review|pending<br>change_id: SSD-0027<br>change_source: 1bDraft<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_immigration_status</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_immigration_status.png" alt="ssd_immigration_status" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-IMMI001A"><td>IMMI001A</td><td>immi_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>identity, immigration, uasc</td><td>Local</td><td></td></tr><tr class="row-IMMI005A"><td>IMMI005A</td><td>immi_immigration_status_id</td><td>liquid_logic, mosaic</td><td>identity, immigration, uasc</td><td>Local</td><td></td></tr><tr class="row-IMMI002A"><td>IMMI002A</td><td>immi_immigration_status</td><td>liquid_logic, mosaic</td><td>identity, immigration, uasc</td><td>SSDA903, RIIA, AnnexA</td><td></td></tr><tr class="row-IMMI003A"><td>IMMI003A</td><td>immi_immigration_status_start_date</td><td>liquid_logic, mosaic</td><td>identity, immigration, uasc</td><td>RIIA</td><td></td></tr><tr class="row-IMMI004A"><td>IMMI004A</td><td>immi_immigration_status_end_date</td><td>liquid_logic, mosaic</td><td>identity, immigration, uasc</td><td>SSDA903, RIIA</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_ehcp_active_plans</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_ehcp_active_plans.png" alt="ssd_ehcp_active_plans" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-EHCP001A"><td>EHCP001A</td><td>ehcp_active_ehcp_id</td><td>liquid_logic</td><td>send, ehcp_request, ehcp</td><td>1aNotInCMS</td><td></td></tr><tr class="row-EHCP002A"><td>EHCP002A</td><td>ehcp_ehcp_request_id</td><td>liquid_logic</td><td>send, ehcp_request, ehcp</td><td>1aNotInCMS</td><td></td></tr><tr class="row-EHCP003A"><td>EHCP003A</td><td>ehcp_active_ehcp_last_review_date</td><td>liquid_logic</td><td>send, ehcp_request, ehcp</td><td>1aNotInCMS, SEN2</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_cla_care_plan</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_cla_care_plan.png" alt="ssd_cla_care_plan" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-LACP001A"><td>LACP001A</td><td>lacp_table_id</td><td>liquid_logic, mosaic</td><td>looked_after, care_plan</td><td>Local</td><td></td></tr><tr class="row-LACP007A"><td>LACP007A</td><td>lacp_person_id</td><td>liquid_logic, mosaic</td><td>looked_after, care_plan</td><td>Local</td><td></td></tr><tr class="row-LACP004A"><td>LACP004A</td><td>lacp_cla_care_plan_start_date</td><td>liquid_logic, mosaic</td><td>looked_after, care_plan</td><td>Local</td><td></td></tr><tr class="row-LACP005A"><td>LACP005A</td><td>lacp_cla_care_plan_end_date</td><td>liquid_logic, mosaic</td><td>looked_after, care_plan</td><td>Local</td><td></td></tr><tr class="row-LACP003A"><td>LACP003A</td><td>lacp_cla_care_plan_json</td><td>liquid_logic, mosaic</td><td>looked_after, care_plan</td><td>AnnexA</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_cla_reviews</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_cla_reviews.png" alt="ssd_cla_reviews" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-CLAR001A"><td>CLAR001A</td><td>clar_cla_review_id</td><td>liquid_logic, mosaic</td><td>looked_after, review</td><td>Local</td><td></td></tr><tr class="row-CLAR011A"><td>CLAR011A</td><td>clar_cla_id</td><td>liquid_logic, mosaic</td><td>looked_after, review</td><td>Local</td><td></td></tr><tr class="row-CLAR003A"><td>CLAR003A</td><td>clar_cla_review_due_date</td><td>liquid_logic, mosaic</td><td>looked_after, review</td><td>Local</td><td></td></tr><tr class="row-CLAR004A"><td>CLAR004A</td><td>clar_cla_review_date</td><td>liquid_logic, mosaic</td><td>looked_after, review</td><td>SSDA903, AnnexA</td><td></td></tr><tr class="row-CLAR012A"><td>CLAR012A</td><td>clar_cla_review_cancelled</td><td></td><td>looked_after, review</td><td>Local</td><td></td></tr><tr class="row-CLAR007A"><td>CLAR007A</td><td>clar_cla_review_participation</td><td>liquid_logic, mosaic</td><td>looked_after, review</td><td>SSDA903</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_early_help_episodes</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_early_help_episodes.png" alt="ssd_early_help_episodes" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-EARL001A"><td>EARL001A</td><td>earl_episode_id</td><td>liquid_logic, mosaic</td><td>early_help</td><td>Local</td><td></td></tr><tr class="row-EARL002A"><td>EARL002A</td><td>earl_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>early_help</td><td>Local</td><td></td></tr><tr class="row-EARL003A"><td>EARL003A</td><td>earl_episode_start_date</td><td>liquid_logic, mosaic</td><td>early_help</td><td>AnnexA, RIIA</td><td></td></tr><tr class="row-EARL004A"><td>EARL004A</td><td>earl_episode_end_date</td><td>liquid_logic, mosaic</td><td>early_help</td><td>AnnexA, RIIA</td><td></td></tr><tr class="row-EARL005A"><td>EARL005A</td><td>earl_episode_reason</td><td>liquid_logic, mosaic</td><td>early_help</td><td>ADCS_SP, RIIA</td><td></td></tr><tr class="row-EARL006A"><td>EARL006A</td><td>earl_episode_end_reason</td><td>liquid_logic, mosaic</td><td>early_help</td><td>ADCS_SP, RIIA</td><td></td></tr><tr class="row-EARL007A"><td>EARL007A</td><td>earl_episode_organisation</td><td>liquid_logic, mosaic</td><td>early_help</td><td>AnnexA, RIIA</td><td></td></tr><tr class="row-EARL008A"><td>EARL008A</td><td>earl_episode_worker_id</td><td>liquid_logic, mosaic</td><td>early_help</td><td>RIIA</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_ehcp_requests</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_ehcp_requests.png" alt="ssd_ehcp_requests" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-EHCR001A"><td>EHCR001A</td><td>ehcr_ehcp_request_id</td><td>liquid_logic</td><td>send, ehcp_request</td><td>1aNotInCMS, RIIA</td><td></td></tr><tr class="row-EHCR002A"><td>EHCR002A</td><td>ehcr_send_table_id</td><td>liquid_logic</td><td>identity, send, ehcp_request</td><td>1aNotInCMS</td><td></td></tr><tr class="row-EHCR003A"><td>EHCR003A</td><td>ehcr_ehcp_req_date</td><td>liquid_logic</td><td>send, ehcp_request</td><td>1aNotInCMS, SEN2, RIIA, SEN2</td><td></td></tr><tr class="row-EHCR004A"><td>EHCR004A</td><td>ehcr_ehcp_req_outcome_date</td><td>liquid_logic</td><td>send, ehcp_request</td><td>1aNotInCMS, SEN2, RIIA, SEN2</td><td></td></tr><tr class="row-EHCR005A"><td>EHCR005A</td><td>ehcr_ehcp_req_outcome</td><td>liquid_logic</td><td>send, ehcp_request</td><td>1aNotInCMS, SEN2, RIIA, SEN2</td><td></td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'><div><h2 style='text-align: left; margin-top: 20px;'>Object name: ssd_pre_proceedings</h2><div style='display: flex; align-items: flex-start;'><img src="imgs/erd_data_objects/ssd_pre_proceedings.png" alt="ssd_pre_proceedings" style="width: 300px; margin-right: 20px;"><div style='padding-bottom: 50px;'><table style='border-collapse: collapse; border: none;'><colgroup><col style='width: 12%;'/><col style='width: 28%;'/><col style='width: 10%;'/><col style='width: 15%;'/><col style='width: 15%;'/><col style='width: 20%;'/></colgroup><tr><th class='item-ref-column'>Item Ref</th><th class='data-item-column'>Data Item Name</th><th class='cms-column'>Exists in CMS</th><th class='categories-column'>Data Category Group(s)</th><th class='returns-column'>Returns</th><th class='changelog-column'>Change Log</th></tr><tr class="row-PREP024A"><td>PREP024A</td><td>prep_table_id</td><td>liquid_logic, mosaic</td><td>pre_proceedings</td><td>1bSpecified</td><td></td></tr><tr class="row-PREP001A"><td>PREP001A</td><td>prep_person_id</td><td>liquid_logic, mosaic, eclipse, caredirector, azeus</td><td>pre_proceedings</td><td>Local</td><td></td></tr><tr class="row-PREP002A"><td>PREP002A</td><td>prep_plo_family_id</td><td>liquid_logic, mosaic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0001<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP003A"><td>PREP003A</td><td>prep_pre_pro_decision_date</td><td>liquid_logic, mosaic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0002<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP004A"><td>PREP004A</td><td>prep_initial_pre_pro_meeting_date</td><td>liquid_logic, mosaic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0003<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP005A"><td>PREP005A</td><td>prep_pre_pro_outcome</td><td>liquid_logic, mosaic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0004<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP006A"><td>PREP006A</td><td>prep_agree_stepdown_issue_date</td><td>liquid_logic, mosaic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0005<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP007A"><td>PREP007A</td><td>prep_cp_plans_referral_period</td><td>liquid_logic, mosaic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0006<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP008A"><td>PREP008A</td><td>prep_legal_gateway_outcome</td><td>liquid_logic, mosaic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0007<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP009A"><td>PREP009A</td><td>prep_prev_pre_proc_child</td><td>liquid_logic, mosaic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0008<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP010A"><td>PREP010A</td><td>prep_prev_care_proc_child</td><td>liquid_logic, mosaic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0009<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP011A"><td>PREP011A</td><td>prep_pre_pro_letter_date</td><td>liquid_logic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0010<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP012A"><td>PREP012A</td><td>prep_care_pro_letter_date</td><td>liquid_logic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0011<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP013A"><td>PREP013A</td><td>prep_pre_pro_meetings_num</td><td>liquid_logic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0012<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP014A"><td>PREP014A</td><td>prep_pre_pro_parents_legal_rep</td><td>liquid_logic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0013<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP015A"><td>PREP015A</td><td>prep_parents_legal_rep_point_of_issue</td><td>liquid_logic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0014<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP016A"><td>PREP016A</td><td>prep_court_reference</td><td>liquid_logic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0015<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP017A"><td>PREP017A</td><td>prep_care_proc_court_hearings</td><td>liquid_logic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0016<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP018A"><td>PREP018A</td><td>prep_care_proc_short_notice</td><td>liquid_logic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0017<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP019A"><td>PREP019A</td><td>prep_proc_short_notice_reason</td><td>liquid_logic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0018<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP020A"><td>PREP020A</td><td>prep_la_inital_plan_approved</td><td>liquid_logic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0019<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP021A"><td>PREP021A</td><td>prep_la_initial_care_plan</td><td>liquid_logic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0020<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP022A"><td>PREP022A</td><td>prep_la_final_plan_approved</td><td>liquid_logic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0021<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr><tr class="row-PREP023A"><td>PREP023A</td><td>prep_la_final_care_plan</td><td>liquid_logic</td><td>pre_proceedings</td><td>1bSpecified</td><td>release: In review|pending<br>change_id: SSD-0022<br>change_source: 1bSpecified<br>versions_count: 1<br>impact_title: None<br>type: New Feature</td></tr></table></div></div></div><hr style='border: none; border-top: 1px solid #ddd; margin-bottom: 20px;'>
<script>
window.addEventListener('load', function() {
  // Function to check if a row matches a category and color it
  function colourRow(row, returns) {
    // Check if any of the return elements matches a category
    for (var i = 0; i < returns.length; i++) {
      if (returns_categories[returns[i].trim()]) {
        // If it matches, color the row and stop checking
        row.style.backgroundColor = returns_categories[returns[i].trim()]["colour"];
        return;
      }
    }
  }

  // Go through all rows
  var rows = document.getElementsByTagName("tr");

  for (var i = 0; i < rows.length; i++) {
    // Get the returns column and split it by ", "
    var returns = rows[i].children[4].innerText.split(", ").map(item => item.trim());

    // Apply the colourRow function
    colourRow(rows[i], returns);
  }
});
</script>

</body></html>