Report Description
This report displays the number of children who had had both at least one test for glucose and one test for cholesterol 90 days prior to or 15 days after the start of a new antipsychotic medication (no prior medications within 120 days).
Refresh Schedule
This report is refreshed periodically.
Time Periods
This report uses rolling year time periods. Available intervals: Jan-Dec, Apr-Mar, Jul-Jun, & Oct-Sep. The earliest available time period for this report is October 01, 2022 – Sept 30, 2023.
Report Data
The CWS/CMS data for children in foster care and Medi-Cal fee for service and managed care paid claims data for children in foster care from the Department of Health Care Services’ (DHCS) MIS/DSS are matched. The process for the match involves using a probabilistic, multi-step, multi-method algorithm of exact and inexact matches based on a combination of name, social security number, and date of birth records between the two systems.
Notes on Source Data
Refresh Schedule:
| Extract name | Data cutoff | Website refreshed by |
|---|---|---|
| Quarter 1 | April 1 | July 1 |
| Quarter 2 | July 1 | October 1 |
| Quarter 3 | October 1 | January 1 (following year) |
| Quarter 4 | January 1 | April 1 |
For example, the CWS/CMS 2025 Quarter 3 Extract (Q3 25) reported on events up to the data cutoff of October 1, 2025. Reports based on the Q3 25 extract were available on the website by January 1, 2025.
For reporting purposes, we use the CWS/CMS extracts to construct three primary longitudinal analysis files types (allegation, foster care, and case) which track children’s histories in the Child Welfare System. In addition to specifying supervising county and capturing child-level demographics, these files include additional information:
Allegation File
– This file includes one row for each allegation for each child, including allegation type, reporter type, responses such as investigation, as well as allegation disposition (e.g., substantiated, inconclusive, and unfounded).
Foster Care Files
– These files include one row for each placement home for each child, including dates of entries and exits to foster care, placement type, and length of stay.
Case Files
– The primary file includes one row for each case service component for each child. Secondary files serve to locate cases within caseloads, offices, and counties. The files include information about children’s case services, including case openings and closings, and service components.
Population Data Files
– Includes California Department of Finance (DOF) annual child population counts and Poverty Population Estimates derived from the US Census Bureau’s American Community Survey (ACS).
Quarterly Wage File
– Quarterly Wage data from 1993 forward for all children age 16 and older with a record of an out-of-home foster care placement in the Child Welfare Services / Case Management System (CWS/CMS) since January 1, 1998.
Postsecondary Enrollment Data
– Postsecondary Enrollment data for children age 16 and older with a record of an out-of-home foster care placement in the Child Welfare Services / Case Management System (CWS/CMS).
Important Note
Data for the most recent time periods are considered preliminary due to lag times in reporting by Medi-Cal providers and plans. Lag times are longer for laboratory data when compared to pharmacy data. Additionally, Medi-Cal eligibility data are considered preliminary due to various adjustments made retroactively as additional information is ascertained.
Denominator
The denominator includes children:
- In foster care for 30 days or more, and is computed by subtracting the CWS/CMS episode removal date variable (removal_dt), from the end date variable (pleps_endt). If the episode is open, the last day of the reporting period is used. The 30-day period allows for the court to establish jurisdiction over the youth, Welfare and Institutions Code sections 369.5 and 739.5.
- In Child Welfare, Probation, State Adoptions, and Indian Child Welfare supervised care.
- Under 18 years old on the most recent psychotropic medication paid claim date.
- With a new antipsychotic medication during the 12-month period (did not have any prior paid claims for medication within 120 days of start of the new medication). Who also had two or more dispensing events of the same or different medication.
The denominator excludes children:
- Placed in California under the jurisdiction of another state (incoming ICPC – Interstate Compact on the Placement of Children),
- In Non-Dependent Legal Guardian placements (The most recent episode in which the youth was a depended guardian is included),
- 18 years of age or older,
- In Non-Foster Care placements, Supervised by other agency types: Kin-GAP, Out-of-State Agency, Mental Health, and Private Adoptions.
Numerator
The numerator includes children:
- In the denominator who had at least one test for blood glucose, as specified in the Glucose Tests Value Set4, or HbA1c, as specified in the HbA1c Tests Value Set, and
- Who had at least one test for LDL-C, as specified in the LDL-C Tests Value Set, or cholesterol other than an LDL, as specified in the Cholesterol Other Than LDL Tests Value Set. A value set is the complete set of Medi-Cal codes used to identify a service or condition included in a measure.
Both tests must have occurred within 90 days prior to or 15 days after the start of the new antipsychotic medication.
Performance
Performance is displayed as both count and percentage.
The following methodology may include references to report features not available on the public site version. On the public site, masking is performed to protect the privacy of individuals served by CDSS and comply with CDSS data de-identification guidelines. Values of 1 to 10 and calculations based on values of 1 to 10 are masked (‘M’ or ‘*’). In stratified views of the data, additional values (the lowest available) are masked to prevent calculation of values 1 to 10.