Note: This document update can be used with the most recent
version of NCANDS. It may be further revised should the Children's
Bureau release the revised CFSR Procedures Manual and incorporated into a revised
complete CFSR: Toolkit for Understanding the State Data Profiles.
What follows is a reference guide to the data elements that
comprise the State Data Profiles for the Child and Family Service Reviews. The
format of the profiles and specific footnotes are a duplicate of the text to
be found in the Child and Family Services Reviews Procedures Manual. The data
definitions provided correspond to the letters or numbers located in the individual
cells of the data profiles. Each definition consists of two parts, the general
definition/description of the element appears first in bold, while the material
that follows provides detail on the data elements and calculation used to generate
the number on the profile.
When using the reference guide there are a few general notes
to keep in mind about the origin of the data profiles:
Finally, it should be noted that there is a possibility of
some minor changes to the calculation methods detailed in the following sections
as the review process moves forward.
| Cell |
Calculation Using SDC |
Calculation Using Child File |
 A |
It is the number of reports in Item 2.2 “Investigations or Assessments by Disposition – Total.” |
It uses Field 3, Report ID. Each report ID is counted only once, regardless of how many children are associated with that report ID. Only reports with dispositions during the current reporting year (FFY) are counted. This may include reports that were filed in previous years. State submissions of Child File data are all based upon the selection of all reports alleging maltreatment that reached a disposition within the reporting year. Subsequent references to the Child File assume that this selection process has been followed in preparing the data submission.
States using the PIP CFSR syntax to generate counts related to other 12-month periods will use a Start Date that indicates when the 12-month period begins, e.g. January, April, July, October.
Standard syntax starting with FFY 2003 will use the FFY, which starts in October.
|
| B |
It is the number of reports in item 3.1 “Children Subject of a CPS Investigation or Assessment by Disposition Pertaining to the Child—Total.” |
Field 3, Report ID and Field 4, Child ID are used to define all of the report/child pairs under consideration. Duplicated counts include a child each time that he/she is associated with an investigated report. |
| C |
NA |
It uses Field 4: Child ID. Each child is counted only once regardless of how many investigated reports he/she is associated with. Records containing the same Child ID as coded in a previous record (i.e., a different report) are excluded from the count of unique victims. |
| D |
It is the sum of Item 2.2.A “Investigations in Which the Allegation of Maltreatment or Risk of Maltreatment was Substantiated,” 2.2.B “Investigations in Which the Allegation of Maltreatment Was Indicated,” and 2.2C “Investigations in Which the Allegation of Maltreatment was Given an Alternative Response Disposition that Identified Child Victims.” |
Field 3, Report ID and Field 9, Report Disposition, are used in the computation. A report is counted only once regardless of how many children are associated with the report. After eliminating duplicate records associated with the same Report ID (i.e., multiple children in the same report), the count is taken as the number of report records that contain a code of 01 = “substantiated” or 02 = “indicated or reason to suspect” or 03= “alternate response victim.” By convention, all records associated with the same report will have the same value coded for the report disposition. |
| E |
It is the sum of Item 2.2A, 2.2B, and 2.2 C divided by the total of Item 2.2 and multiplied by 100. |
It is the sum of unique reports with substantiated or indicated or alternative response – victim dispositions (Field 3, Field 9, codes 01,02, and 03), divided by the total number of unique reports and multiplied by 100. Percentage can also be derived using the values computed for cells A and D above. |
| F |
It is the sum of Item 3.1.A “Children for Whom the Allegation of Maltreatment or Risk of Maltreatment was Substantiated” and 3.1.B “Children for Whom the Allegation of Maltreatment Was Indicated,” and 3.1 C “Children for whom the Allegation of Maltreatment was Given an Alternative Response Disposition that Identified Child Victims.” |
Field 3, Report ID, Field 4, Child ID, Fields 27, 29, 31, and 33 Maltreatment Disposition Level(s), and Field 34 Maltreatment Death are used to count substantiated, indicated, and alternative response-victims. Each child record with at least one substantiated, indicated or alternative response victim maltreatments coded into one or more of the maltreatment disposition level fields, or with Maltreatment Death Field coded to 1=“yes” is counted. If the same child is associated with multiple maltreatment levels in one report, the child is counted only once. If the child is associated with multiple records in which at least one substantiated or indicated or alternative response victim disposition level is recorded, each of the respective reports is enumerated in the final count. |
| G |
It is the sum of Items 3.1A, 3.1 B and 3.1 C divided by the total l of Item 3.1-2 and multiplied by 100. |
Field 3, Report ID, Field 4, Child ID, Fields 27, 29, 31, and 33, Maltreatment Disposition Level(s), and Filed 34 Maltreatment Death are used in the computation. The percentage is computed by dividing the duplicated count of children with a substantiated, indicated or alternative response victim maltreatment, or with Maltreatment Death Field coded to 1=“yes” (Cell F) by the total duplicated count of children subject of an investigated report (Cell B) and multiplying by 100. |
| H |
NA |
Field 3, Report ID, Field 4, Child ID, Fields 27, 29, 31, and 33, Maltreatment Disposition Level(s), and Field 34 Maltreatment Death are utilized. Each child with at least one substantiated, indicated, or alternative response victim maltreatment coded into the maltreatment disposition level fields, or with Maltreatment Death Field coded to 1=“yes” is counted only once regardless of the number or dispositions of additional maltreatments or reports associated with the child. |
| I |
NA |
Field 3, Report ID, Field 4, Child ID, Fields 27, 29, 31, and 33 Maltreatment Disposition Level(s), and Field 34 Maltreatment Death are utilized. The percentage is computed by dividing the unique count of children with a substantiated, indicated or alternative response victim, or with Maltreatment Death Field coded to 1=“yes” (Cell H) by the total unique count of unique children subject of an investigated report (Cell C) and multiplying by 100. |
| J |
It is the sum of Item 2.2 E “Investigations in Which the Allegation of Maltreatment Was Not Substantiated ” and Item 2.2F “Investigations in Which the Allegation was Determined to be Intentionally False.” |
Field 3, Report ID and Field 9, Report Disposition, are used in the computation. After eliminating records associated with the same Report ID (i.e., multiple children in the same report), the count is taken as the number of reports with a report disposition of 05 = unsubstantiated or 06 = unsubstantiated due to intentionally false reporting. By convention, all records associated with the same report ID have the same value coded for the report disposition. A report is counted only once regardless of how many children are associated with the same Report ID. |
| K |
It is Item 2.2 E “Investigations in Which the Allegation of Maltreatment Was Not Substantiated” and Item 2.2 F “Investigations in Which the Allegation was Determined to be Intentionally False” divided by the total of Item 2.2 and multiplied by 100. |
Field 3, Report ID, Field 4, Child ID, Field 9, Report Disposition, code 05, “unsubstantiated” and code 06 “unsubstantiated due to intentionally false reporting” for unique report IDs divided by the total number of unique reports and multiplied by 100. Percentage can also be derived using the values computed for Cells J and A above. |
| L |
It is Data Element 3.1.E “Children for Whom the Allegation of Maltreatment Was Not Substantiated” and 3.1 F “Children for Whom the Allegation of was Determined to be Intentionally False.” |
Field 3, Report ID, Field 4, Child ID, Field 9, Report Disposition, and Fields 27, 29, 31, and 33 Maltreatment Disposition Level(s) are used to count unsubstantiated children. Each child record with a report disposition code of unsubstantiated (05) or unsubstantiated due to intentionally false reporting (06) or having no maltreatment disposition codes < 04 in a report with a report disposition <04 is
counted as unsubstantiated. The latter circumstance occurs if one or more children in a report is found to be a victim of maltreatment, but the subject child is not. In other words, a report disposition of substantiated, indicated or alternative response victim can have a child who is not a victim; but the converse is not true. A report with a disposition unsubstantiated (either code 05 or 06) cannot have any children who are victims associated with that report. If the same child is associated with multiple reports where the child would be categorized as unsubstantiated, the child is counted each time. |
| M |
It is Item 3.1 E “Children for Whom the Allegation of Maltreatment Was Not Substantiated” and 3.1 F “Children for Whom the Allegation was Determined to be Intentionally False” divided by the total of Item 3.1 and multiplied by 100. |
Field 3, Report ID, Field 4, Child ID, Field 9, Report Disposition, and Fields 27, 29, 31, and 33, Maltreatment Disposition Levels are utilized. The percentage is computed by dividing Cell L by the total duplicated count of children subject of an investigated report (Cell B) and multiplying by 100. |
| N |
NA |
Field 3, Report ID, Field 4, Child ID, Field 8, Report Disposition, and Fields 27, 29, 31, and 33 Maltreatment Disposition Levels are utilized. Each child record with a report disposition code of unsubstantiated (05) or unsubstantiated due to intentionally false reporting (06) or having no maltreatment disposition codes < 04 in a report with a report disposition <04 is counted as unsubstantiated. Each child is counted only once no matter how many times he/she may be associated with a report in which categorized as unsubstantiated. |
| O |
NA |
Field 3, Report ID, Field 4, Child ID and Fields 27, 29, 31, and 33, Maltreatment Disposition, are used. The percentage is computed by dividing Cell N by the total count of unique children subject of an investigated report (Cell C) and multiplying by 100. |
| P |
It is the sum of Items 2.2 D “Investigations in Which the Allegation of Maltreatment was Given an Alternative Response Disposition that Did Not Identify Child Victims,” 2.2 G “Investigations Closed Without a Finding,” 2.2 H “Other Dispositions,” and 2.2 I “Unknown Dispositions.” |
Field 3, Report ID, Field 9, Report Dispositions are used. It is the total number of records that contain a Report Disposition of 04, 07, 88, 99. A report is counted only once, regardless of how records have the same Report ID indicating that multiple children were associated with the report. By convention, all records associated with the same report will have the same value coded for the report disposition. |
| Q |
It is the sum of Items 2.2 D Investigations in Which the Allegation of Maltreatment was Given an Alternative Response Disposition that Did Not Identify Child Victims, 2.2 G “Investigations Closed Without a Finding,” 2.2 H “Other Dispositions,” and 2.2 I “Unknown Dispositions.” divided by the total of Item 2.2 and multiplied by 100. |
Field 3, Report ID, Field 9, Report Dispositions are used. It is the total number of records that contain a Report Disposition of 04, 07, 88, 99 divided by the total number of reports and multiplied by 100. A report is counted only once, regardless of how records have the same Report ID indicating that multiple children were associated with the report. By convention, all records associated with the same report will have the same value coded for the report disposition. |
| R |
It is the sum of Items 3.1.D “Children for Whom the Allegation of Maltreatment was Given an Alternative Response Disposition that Did not Identify Child Victims,” 3.1G “Children for Whom the Investigation was Closed without a Finding,” 3.1 H “Other Dispositions,” and 3.1.I “Unknown Dispositions.” |
Field 3, Report ID, Field 4, Child ID, and Field 9, Report Disposition are used. Each child record with a report disposition code of 04, 07, 88 or 99 is counted as “other.” If the same child is associated with multiple reports with a report disposition code of 04, 07, 88 or 99, the child is also counted each time. |
| S |
It is the sum of Items 3.1.D “Children for Whom the Allegation of Maltreatment was Given an Alternative Response Disposition that Did not Identify Child Victims” 3.1G “Children for Whom the Investigation was Closed without a Finding,” 3.1 H “Other Dispositions,” and 3.1.I “Unknown Dispositions” divided by the total of Item 3.2 and multiplied by 100. |
Field 3, Report ID, Field 4, Child ID, and Field 9 Report Disposition are used. The percentage is computed by dividing the duplicated count of children with a report disposition of 04, 07, 88, 99 (Cell R) by the total duplicated count of children subject of an investigated report (Cell B) and multiplying by 100. |
| T |
NA |
Field 3, Report ID, Field 4, Child ID, and Field 9, Report Disposition are used. Each child record with a report disposition code of 04, 07, 88 or 99 is counted as “other.” If the same child is associated with multiple reports with 04, 07, 88 or 99 report disposition codes this child is counted only once. Unique counts of children with “other dispositions” do not include any child who has been counted as a child with as a victim or as a child with an unsubstantiated disposition. |
| U |
NA |
Field 3, Report ID, Field 4, Child ID, and Field 9, Report Disposition are utilized. The percentage is computed by dividing the count of unique children who are associated with a report with a disposition of 04, 07, 88 or 99 (Cell T) by the total count of unique children subject of an investigated report (Cell C) and multiplying by 100. |
| V |
It is the sum of Items 3.2.A “Children Who Received Services—Substantiated,” 3.2.B “Indicated,” and 3.2C “Alternative Response Victim.” |
Field 3, Report ID, Field 4, Child ID, Fields 27, 29, 31, 33 Maltreatment Disposition Level, and Field 34 Maltreatment Death (with at least one maltreatment level 1, 2 or 3, or Maltreatment Death Field coded to 1=“yes” and at least one of the following fields with a value of 1, fields 56, 58-60, 62, 65-85) are used. A child is counted each time he/she is associated with at least one of the service fields within a report, in which he/she is associated with at least one substantiated, indicated, or alternative response victim maltreatment level, or a child died as a result of maltreatment. |
| W |
It is the sum of Items 3.2.A “Children Who Received Services—Substantiated,” 3.2.B “Indicated,” and 3.2C “Alternative Response Victim” divided by the total of 3.1A, 3.1B, and 3.1 C (Cell F) and multiplied by 100. |
Field 3, Report ID, Field 4, Child ID, Fields 27, 29, 31, and 33 Maltreatment Disposition, and Field 34 Maltreatment Death (with at least one maltreatment level 1, 2 or 3, or Maltreatment Death Field coded to 1=“yes” and at least one of the following fields with a value of 1, fields 56, 58-60, 62, 65-85) are used. A child is counted each time he/she is associated with at least one of the service fields within a report, in which he/she is associated with at least one substantiated, indicated, or alternative response victim maltreatment, or a child died as a result of maltreatment. This number (cell V) is divided by the duplicated count of child victims (Cell F) and multiplied by 100. |
| X |
NA |
Field 3, Report ID, Field 4, Child ID, Fields 27, 29, 31, and 33 Maltreatment Disposition Level(s), and Field 34 Maltreatment Death (with at least one maltreatment level 01, 02 or 03, or Maltreatment Death field is coded to 1=“yes” and at least one of the following fields with a value of 1, fields 56, 58-60, 62, 65-85) are used. A child is counted only once regardless of how many reports he/she is associated with one of the service fields. |
| Y |
NA |
Field 3, Report ID, Field 4, Child ID, Fields 27, 29, 31, and 33 Maltreatment Disposition Level, and Field 34 Maltreatment Death (with at least one maltreatment level 01, 02 or 03, or Maltreatment Death field is coded to 1=“yes” and at least one of the following fields with a value of 1, fields 56, 58-60, 62, 65-85) are used. A child is counted only once regardless of how many reports he/she is associated with one of the service fields. This number (Cell X) is divided by the total number of unique child victims (Cell H) and multiplied by 100. |
| Z |
It is Items 3.3.A “Children Who Were Removed from the Home—Substantiated,” 3.2-5.B “Children Who Were Removed from the Home—Indicated,” And 3.3 C “Children Who Were Removed from the Home-Alternate Response- Victim.” |
Field 3, Report ID, Field 4,Child ID, Fields 27, 29, 31, 33 Maltreatment Disposition Level (with at least one maltreatment level 01, 02 or 03), and Field 34 Maltreatment Death (when coded to 1=“yes”) and Field 60, Foster Care Services with a value of 1 are used. A child is counted each time that the Field 60 has a value of 1 and the other conditions are met (report-child pair). |
| AA |
It is Items 3.3.A “Children Who Were Removed from the Home—Substantiated,” 3.2-5.B “Children Who Were Removed from the Home—Indicated,” and 3.3 C “Children Who Were Removed from the Home-Alternate Response- Victim” divided by the total of 3.1.A, 3.1 B, and 3.1 C and multiplied by 100. |
Field 3, Report ID, Field 4, Child ID, Fields 27, 29, 31, and 33 Maltreatment Disposition Level (with at least one maltreatment level 01, 02 or 03), and Field 34 Maltreatment Death (when coded to 1=“yes”) and Field 60 with a value of 1 are utilized. The duplicate count of children who entered foster care (Cell Z) is divided by the total duplicated count of children who have at least one substantiated, indicated or alternative response victim maltreatment per record (Cell F), or Maltreatment Death field is coded to 1=“yes” and multiplied by 100. |
| BB |
NA |
Field 3, Report ID, Field 4,Child ID, Fields 27, 29, 31, 33 Maltreatment Disposition Level (with at least one maltreatment level 01, 02 or 03 per record), and Field 34 Maltreatment Death (when coded to 1=“yes”) and Field 60, Foster Care Services with a value of 1 are used. A child is counted only once regardless of the number of times he/she is associated with these conditions. |
| CC |
NA |
Field 3, Report ID, Field 4,Child ID, Fields 27, 29, 31, 33 Maltreatment Disposition Level (with at least one maltreatment level 01, 02 or 03 per record), and Field 34 Maltreatment Death (when coded to 1=“yes”) and Field 60, Foster Care Services with a value of 1 are used. A child is counted only once regardless of the number of times he/she is associated with these conditions. The unique count of children entering foster care (Cell BB) is divided by the total number of unique children who have at least one maltreatment with a disposition of substantiated, indicated or alternative response victim per record, or Maltreatment Death field is coded to 1=“yes” (Cell H) and multiplied by 100. |
| DD |
It is item 5.1, “Child Victims Who Died as a Result of Maltreatment.” |
Field 3, Report ID, Field 4, Child ID, and Field 34 are utilized. Any unique Child ID associated with a maltreatment fatality (Field 34 = 1) is counted. A child is counted only once even if more than record reports on the death of the child. (Fatalities reported through the Agency File are not included in this cell. An additional footnote is provided.) |
| EE |
It is item 5.1 divided by the sum of Item 3.1AA, 3.1B, and 3.1 C and multiplied by 100. |
Field 3, Report ID, Field 4, Child ID, and Field 34 are utilized. Any unique Child ID associated with a maltreatment fatality (Field 34 = 1) is counted. The count of child fatalities (Cell DD) is divided by the count of unique victims with substantiated, indicated, or alternative response victim dispositions (Cell H) and multiplied by 100. |
| FF |
NA |
Field 4, Child ID, Field 6 Report Date, and Fields 27, 29, 31, and 33 Maltreatment Disposition Level(s), and Field 34 Maltreatment Death are utilized. Only records containing a maltreatment disposition level of 1=substantiated or 2=indicated, or with Maltreatment Death field is coded to 1=“yes” are reviewed. Records with a report date occurring in the previous calendar year are also excluded. The remaining records are subsequently grouped by Child ID and in sequential order by the report date. The records associated with a given unique child are retained only if the first report date falls within the first six months of the fiscal year. It is this group of children for whom the identification of recurrent maltreatment is addressed (i.e., victims within the first six months of the fiscal year). A substantiated or indicated child victim is identified as a recurrent victim and counted in this cell if the report date associated with a subsequent report falls within six months (183 calendar days) of the date of the initial report. Reports occurring on the same or next day, however, are excluded. If no additional reports are identified, or the next subsequent report has a date falling more than six months after the initial date, the child is not counted as a recurrent victim. Note: the alternative response-victim disposition is not included in this calculation of recurrence standard. States may however wish to have recurrence calculated with and without this disposition. States may also wish to examine their recurrence data based on a calendar year data period. |
| GG |
NA |
Field 4, Child ID, Field 6 Report Date, and Fields 27, 29, 31, and 33 Maltreatment Disposition Level(s), and Field 34 Maltreatment Death are utilized. Only records containing a maltreatment disposition level of 1=substantiated or 2=indicated, or with Maltreatment Death field is coded to 1=“yes” are reviewed. Records with a report date occurring in the previous fiscal year are also excluded. The remaining records are subsequently grouped by Child ID and in sequential order by the report date. The percent of unique substantiated or indicated victims who were recurrent victims is computed by dividing the count of recurrent victims (Cell FF) by the count of unique substantiated/indicated victims identified during the first six months of the fiscal year (October-March) Note that this number is not Cell H. It is computed separately. Also note that if the State decides to compute the recurrence statistical for the calendar year, it must also compute the unique count of substantiated or indicated for the first 6 months. |
| HH |
NA |
Field 4, Child ID, Field 6 Report Date, Fields 27, 29, 31, and 33 Maltreatment Disposition Level(s), and Field 34 Maltreatment Death and Fields 89,108, 127 Perpetrator Relationship are utilized. Only records containing a maltreatment disposition of 01=substantiated or 02=indicated, or with Maltreatment Death field is coded to 1=“yes” are reviewed. Only records with a report date occurring within the period of January-September are included. The records are subsequently grouped by Child ID. A unique child is counted as victimized in foster care if any of the perpetrator relationship fields hold a value of 03 = “Relative Foster Parent,” 04= “Nonrelative foster parent,” or 05= “Group Home or Residential Facility Staff.” |
| II |
NA |
Denominator derived from total number of children served in foster care during the reporting period, January to September through AFCARS.
Note: January to September represents the number of months of the NCANDS reporting period that overlap with the AFCARS reporting period. The percentage of unique children victimized in foster care is derived by dividing the count of children victimized by a foster care provider (Cell HH) divided by the number of unique children in foster care over this 9 month period (source AFCARS) multiplied by 100. With the new submission period of the FFY, all 12 months overlap, but since the period would be longer than 9 months, the total overlap period is not used. |