ssd_cin_episodes.yml

---
nodes:
- name: ssd_cin_episodes
  fields:
  - name: cine_referral_id
    description: CIN Referral ID
    item_ref: CINE001A
    type: nvarchar
    primary_key: true
    validators:
    - required:
        enabled: true
    - unique:
        enabled: true
    categories:
    - child_in_need
    - referral
    returns:
    - Loca;
    cms:
    - liquid_logic
    - mosaic
    cms_field:
    - liquid_logic:cine_referral_id
    - mosaic:cine_referral_id
    cms_table:
    - liquid_logic:ssd_cin_episodes
    - mosaic:ssd_cin_episodes
    guidance: Row identifier for the ssd_cin_episodes table
  - name: cine_person_id
    description: Person Unique ID
    item_ref: CINE002A
    type: nvarchar
    foreign_key: ssd_person.pers_person_id
    validators:
    - required:
        enabled: true
    categories:
    - child_in_need
    returns:
    - Local
    cms:
    - liquid_logic
    - mosaic
    - eclipse
    - caredirector
    - azeus
    cms_field:
    - liquid_logic:cine_person_id
    - mosaic:cine_person_id
    cms_table:
    - liquid_logic:ssd_cin_episodes
    - mosaic:ssd_cin_episodes
    guidance: Person's ID generated in CMS Database
  - name: cine_referral_date
    description: CIN Referral Date
    item_ref: CINE003A
    type: datetime
    categories:
    - child_in_need
    - referral
    returns:
    - CIN
    - AnnexA
    - RIIA
    cms:
    - liquid_logic
    - mosaic
    cms_field:
    - liquid_logic:cine_referral_date
    - mosaic:cine_referral_date
    cms_table:
    - liquid_logic:ssd_cin_episodes
    - mosaic:ssd_cin_episodes
    guidance: Date the Referral is effective from
  - name: cine_cin_primary_need_code
    description: CIN Primary Need Code
    item_ref: CINE010A
    type: nvarchar
    categories:
    - child_in_need
    - referral
    returns:
    - CIN
    - AnnexA
    - RIIA
    cms:
    - liquid_logic
    - mosaic
    cms_field:
    - liquid_logic:cine_cin_primary_need
    - mosaic:cine_cin_primary_need
    cms_table:
    - liquid_logic:ssd_cin_episodes
    - mosaic:ssd_cin_episodes
    guidance: "CIN Primary Need Code. This code indicates the main reason why a child\
      \ started to receive services.\nThe categories are designed only to identify\
      \ what kind of pressures are placed on social services. They have no diagnostic\
      \ value with regard to the children themselves and must not be used to determine\
      \ what type of service the child should receive.\nIf there is difficulty choosing\
      \ between two or more categories of need, choose the category that comes highest\
      \ up in the table, for example, if trying to decide between family in acute\
      \ stress and family dysfunction, choose family in acute stress.\nThe order of\
      \ the categories relates to the specificity of the description and not necessarily\
      \ importance. However, the order is fixed so that there is consistency.\nThe\
      \ children in need census for 2005 and earlier tried to account for all money\
      \ spent in a census week. To allow for this, \u2018N9\u2019 was created, but\
      \ as this census is specifically child based, the definition of \u2018N9\u2019\
      \ from 2005 is not applicable. As in previous years, \u2018N9\u2019 can be used\
      \ if a child is no longer in need and the only service they are receiving is\
      \ adoption support (on an open case) immediately after they have been in need.\n\
      Code Set\nN1 - Abuse or neglect\nChildren in need as a result of, or at risk\
      \ of, abuse or neglect; also includes children at risk because of domestic violence.\n\
      N2 - Child\u2019s disability\nChildren and families whose main need for services\
      \ arises because of their child\u2019s disability, illness or intrinsic condition.\n\
      N3 - Parental disability or illness\nChildren whose main need for services arises\
      \ because the capacity of their parent(s) (or carer(s)) to care for them is\
      \ impaired by the parent(s) (or carer(s)) disability, physical or mental illness,\
      \ or addictions.\nN4 - Family in acute stress\nChildren whose needs arise from\
      \ living in a family that is going through a temporary crisis that diminishes\
      \ the parental capacity to adequately meet some of the children\u2019s needs.\n\
      N5 - Family dysfunction\nChildren whose needs primarily arise from living in\
      \ a family where the parenting capacity is chronically inadequate.\nN6 - Socially\
      \ unacceptable behaviour\nChildren and families whose need for services primarily\
      \ arise out of the child\u2019s behaviour impacting detrimentally on the community.\n\
      N7 - Low income\nChildren, living in families or independently, whose needs\
      \ primarily arise from being dependent on an income below the standard state\
      \ entitlements.\nN8 - Absent parenting\nChildren whose needs for services arise\
      \ mainly from having no parents available to provide for them.\nN9 - Cases other\
      \ than children in need\nChildren who have been adopted and, although they are\
      \ no longer a child in need, receive adoption support from children\u2019s social\
      \ services immediately after adoption. This should not be used where a child\
      \ receives an adoption payment only.\nN0 - Not stated\nChildren whose reference\
      \ data is not completely entered on the system and whose need code is yet to\
      \ be determined, or the case is a referral that has been closed following assessment."
  - name: cine_referral_source_code
    description: CIN Referral Source code
    item_ref: CINE004A
    type: nvarchar
    categories:
    - child_in_need
    - referral
    returns:
    - CIN
    - AnnexA
    - RIIA
    cms:
    - liquid_logic
    - mosaic
    cms_field:
    - liquid_logic:cine_referral_source_code
    - mosaic:cine_referral_source_code
    cms_table:
    - liquid_logic:ssd_cin_episodes
    - mosaic:ssd_cin_episodes
    guidance: Contact Source Code
  - name: cine_referral_source_desc
    description: CIN Referral Source description
    item_ref: CINE012A
    type: nvarchar
    categories:
    - child_in_need
    - referral
    returns:
    - Local
    guidance: Contact Source Name
  - name: cine_referral_outcome_json
    description: CIN Referral Outcome
    item_ref: CINE005A
    type: nvarchar
    categories:
    - child_in_need
    - referral
    returns:
    - AnnexA
    - RIIA
    cms:
    - liquid_logic
    - mosaic
    cms_field:
    - liquid_logic:cine_referral_outcome_json
    - mosaic:cine_referral_outcome_json
    cms_table:
    - liquid_logic:ssd_cin_episodes
    - mosaic:ssd_cin_episodes
    guidance: 'Outcome of the Referral. This indicates the outcome of the initial
      Referral, not the CIN Episode.

      Combined dictionary/ json type containing the following, where there is a value
      recorded:

      - SINGLE_ASSESSMENT_FLAG

      - NFA_FLAG

      - STRATEGY_DISCUSSION_FLAG

      - CLA_REQUEST_FLAG

      - NON_AGENCY_ADOPTION_FLAG

      - PRIVATE_FOSTERING_FLAG

      - CP_TRANSFER_IN_FLAG

      - CP_CONFERENCE_FLAG

      - CARE_LEAVER_FLAG

      - OTHER_OUTCOMES_EXIST_FLAG

      - NUMBER_OF_OUTCOMES

      - COMMENTS'
  - name: cine_referral_nfa
    description: CIN Referral NFA Flag
    item_ref: CINE011A
    type: nchar
    categories:
    - child_in_need
    - referral
    returns:
    - CIN
    - AnnexA
    - RIIA
    cms:
    - liquid_logic
    - mosaic
    cms_field:
    - liquid_logic:cine_referral_nfa
    - mosaic:cine_referral_nfa
    cms_table:
    - liquid_logic:ssd_cin_episodes
    - mosaic:ssd_cin_episodes
    guidance: Indicates the outcome of this contact was that there was no further
      assessment required
  - name: cine_close_reason
    description: CIN Closure Reason
    item_ref: CINE006A
    type: nvarchar
    categories:
    - child_in_need
    returns:
    - CIN
    - RIIA
    cms:
    - liquid_logic
    - mosaic
    cms_field:
    - liquid_logic:cine_close_reason
    - mosaic:cine_close_reason
    cms_table:
    - liquid_logic:ssd_cin_episodes
    - mosaic:ssd_cin_episodes
    guidance: 'This is the reason the local authority stops providing services to
      the child.

      Code set

      RC1 - Adopted.

      RC2 - Died.

      RC3 - Child arrangements order.

      RC4 - Special guardianship order.

      RC5 - Transferred to services of another local authority.

      RC6 - Transferred to adult social care services.

      RC7 - Services ceased for any other reason, including child no longer in need.

      RC8 - Case closed after assessment, no further action.

      RC9 - Case closed after assessment, referred to early help.'
  - name: cine_close_date
    description: CIN Closure Date
    item_ref: CINE007A
    type: datetime
    categories:
    - child_in_need
    returns:
    - CIN
    - RIIA
    cms:
    - liquid_logic
    - mosaic
    cms_field:
    - liquid_logic:cine_close_date
    - mosaic:cine_close_date
    cms_table:
    - liquid_logic:ssd_cin_episodes
    - mosaic:ssd_cin_episodes
    guidance: Date the Referral is effective to, i.e. Case Closure Date
  - name: cine_referral_team
    description: CIN Referral Completed by Team
    item_ref: CINE008A
    type: nvarchar
    foreign_key: ssd_department.dept_team_id
    categories:
    - child_in_need
    - referral
    returns:
    - AnnexA
    - RIIA
    cms:
    - liquid_logic
    - mosaic
    cms_field:
    - liquid_logic:cine_referral_team_name
    - mosaic:cine_referral_team_name
    cms_table:
    - liquid_logic:ssd_cin_episodes
    - mosaic:ssd_cin_episodes
    guidance: Team responsible for completing the initial Referral
  - name: cine_referral_worker_id
    description: CIN Referral Completed by Worker Name
    item_ref: CINE009A
    type: nvarchar
    foreign_key: ssd_professionals.prof_professional_id
    categories:
    - child_in_need
    - referral
    returns:
    - AnnexA
    - RIIA
    cms:
    - liquid_logic
    - mosaic
    cms_field:
    - liquid_logic:cine_referral_worker_name
    - mosaic:cine_referral_worker_name
    cms_table:
    - liquid_logic:ssd_cin_episodes
    - mosaic:ssd_cin_episodes
    guidance: Worker responsible for completing initial Referral