CWS/CMS Reporting Database Code

CWS/CMS Reporting (Q4 24)

Production database code for web-based dynamic reporting

UCB composite tables (pre-joined base tables)

UCB_REF(referrals)
UCB_FC (out-of-home placements); code also produces UCB_FC2
UCB_PIT(point-in-time out-of-home placements)
UCB_ASSIGNMENT_CASE (assignment level with office numbers)
UCB_CASE_SVC_COMP(case service components)
UCB_FC_AFCARS (out-of-home placements, adjusted to mirror AFCARS)
CENSUS_RC(census conforming ethnic classification)

Federal Measures (CFSR database construction code)

4-S1 Maltreatment in foster care
4-S2 Recurrence of maltreatment
4-P1 Permanency in 12 months (entry cohort)
4-P2/P3 Permanency in 12 months (in care 12-23 months/24 months or more)
4-P4 Re-entry to foster care in 12 months (exit cohort)
4-P5 Placement stability
CFSR3-P4 Re-entry to foster care in 12 months (entry cohort)

Database code for web-based dynamic reporting

CWS Outcomes System

Other Reports (database construction code/static report code)

Referrals
Entries
Point-in-Time
Exits
Reentry Following Permanency (Exit Cohort): See 4-P4
Case Openings
Case Service Components
Case Closures
Placement Stability (Entry Cohort)
Placement Days
Placement Grids CW
Placement Grids CW 16-21
Placement Grids Probation
Placement Grids Probation 16-21
Recurrence of Allegations
Median Length of Stay
Disparity Indices

Other

Autoexec (referenced in database programs)
UCB_OFFICE (office assignment)

Transition-Age Youth Research & Evaluation Hub (TAY-Hub)

Entries: Entries to Foster Care (Age 18 to 20 Years)
In Care: In Care—Point In Time Count (Age 18 to 21 Years)
TAY-EDD (TAY Employment base table code)
TAY Cumulative Employment Status by Age (EDD1 production database code)
TAY Quarters Employed by Age (EDD2 production database code)
TAY Annual Earnings by Age (EDD3 production database code)
TAY Enrollment Status by Age (NSC production database code)

page last edited: April 9, 2025