Back to Notes on Source Data

Case Files

Children’s case services, including case openings and closings, and service components.
Filename(s)

UCB_CASE_SVC_COMP (Case Service Component Periods)

Table used for case-service-component related analyses.

Revision History

2023.04.21

  1. Added voluntary status at start and end of each case service component spell.

2022.09.27

  1. Added ICWA and tribal membership status

2014.03.04

  1. Modified to include case counter.
  2. Added FKCHLD_CLT to the case-service-component level.
  3. Restricted to child welfare supervised.

2014.02.24

  1. Modified to include starting and ending county.

2013.12.02

  1. Modified to exclude KinGAP and Mental Health cases as they are only in CWS/CMS for convenience of Los Angeles and are not part of the CWS population
  2. Added census race/ethnicity from DWH.CENSUS_RC
  3. Added case start and end dates and rename as CASE_ST_DT, CASE_E_DT
  4. Added case closure reason type

2013.09.10
2013.08.12

2012.05.18

  1. Made correction to mapping of P_ETHNCTYC to derived var ETHNIC.

2010.09.21

  1. Modified to include all cases. A new attribute, CASE_T.RSP_AGY_CD has been added and can be used to report by responsible agency. * Previous to R6.4, this table excluded mental health, KinGAP and non-CWD foster care cases, * determined by intervention reason (INTV_RNT.INTVRSNC).

2008.02.12

  1. Starting with UCB_CASE.sas, a substantial simplification and re-write was done.

UCB_ASSIGNMENT_CASE (Assignment of County and Office Number)

An assignment-level table which incorporates: assignment dates, assignment county and office number. Restrict to assignments of primary responsibility to cases.

Revision History

2008.02.12

  1. Version 1.00

UCB_OFFICE (Assignment of County and Office Number)

A table with one row for each county and office assignment for each child based on case and referral. When the child is assigned to more than one office during the day, the file shows the office assignment at the end of the day. The program only considers primary assignments.

Revision History

2019.03.04

  1. Fixed error in ST_ID table creation corrected

2016.11.09

  1. Adapted for production use

2016.08.15

  1. First revision