Table C-1 Combined Aggregate File Data Element List
Child Maltreatment 2004
General Information
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 1 | CAF Construction Date | cafdate |
| 2 | FIPS Code | fips |
| 3 | State Abbreviation | stateabb |
| 4 | State Name | state |
| 5 | Submission Year | year |
| 6 | Data Submission Type | datasrc |
| 7 | Child Population (based on census) | chpop |
Data in the Combined Aggregate File are based on the State's submission of the SDC or the Child File and the Agency File. For most items, data from the SDC are duplicated counts, comparable to the report-child pair. Some State exceptions are noted in the commentary section in Child Maltreatment 2004.
Referrals and Investigations
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 8 | Referrals Screened In by CPS | rptscrn |
| 9 | Referrals Screened Out | rptscout |
| 10 | Total Number of Investigations (Based on Number with Disposition) | invtotal |
Screened-in and screened-out referrals are based on counts of reports.
Source of Referrals Screened In (Report Count)
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 11 | Social Services | rsocr |
| 12 | Social Services and Mental Health Personnel | rsocmhr |
| 13 | Medical Personnel | rmedr |
| 14 | Mental Health Personnel | rmhpr |
| 15 | Legal, Law Enforcement, or Criminal Justice Personnel | rlegr |
| 16 | Educational Personnel | redur |
| 17 | Child Daycare Provider(s) | rccpr |
| 18 | Foster Care Provider(s) | rsubr |
| 19 | Child Daycare and Foster Care Provider(s) | rccsubr |
| 20 | Alleged Victim(s) | rvicr |
| 21 | Parent(s) | rparr |
| 22 | Other Relative(s) | rrelr |
| 23 | Friends or Neighbor(s) | rfrir |
| 24 | Alleged Perpetrator(s) | rperpr |
| 25 | Anonymous | ranor |
| 26 | Other | rothr |
| 27 | Unknown | runkr |
Counts from the Child File are based on counting each report only once, regardless of how many children are associated with a report. Information on only source per report is collected.
Source of Referrals Screened In (Report-Child Pair Count)
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 28 | Social Services | rsocrc |
| 29 | Social Services and Mental Health Personnel | rsocmhrc |
| 30 | Medical Personnel | rmedrc |
| 31 | Mental Health Personnel | rmhprc |
| 32 | Legal, Law Enforcement, or Criminal Justice Personnel | rlegrc |
| 33 | Educational Personnel | redurc |
| 34 | Child Daycare Provider(s) | rccprc |
| 35 | Foster Care Provider(s) | rsubrc |
| 36 | Child Daycare and Foster Care Provider(s) | rccsubrc |
| 37 | Alleged Victim(s) | rvicrc |
| 38 | Parent(s) | rparrc |
| 39 | Other Relative(s) | rrelrc |
| 40 | Friends or Neighbor(s) | rfrirc |
| 41 | Alleged Perpetrator(s) | rperprc |
| 42 | Anonymous | ranorc |
| 43 | Other | rothrc |
| 44 | Unknown | runkrc |
Counts from the Child File are based on counting each child every time a report is filed for that child. Information on only one report source for that child is collected.
Investigations or Assessments (Report Count)
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 45 | Average Response Time to Investigation (Hours) | resptime |
| 46 | Reports with Substantiated Dispositions | invsubr |
| 47 | Reports with Indicated Dispositions | invindr |
| 48 | Reports with Alternative Response Victim Dispositions | invarvr |
| 49 | Reports with Alternative Response Nonvictim Dispositions | inarnvr |
| 50 | Reports with Unsubstantiated Dispositions | invunr |
| 51 | Reports with Intentionally False Dispositions | invfalr |
| 52 | Reports Closed With No Finding | invnor |
| 53 | Reports with Other Dispositions | invothr |
| 54 | Reports with Unknown Dispositions | invunkr |
Counts from the Child File are based on counting each report only once, regardless of how many children are associated with a report.
Investigations or Assessments (Report-Child Pair Count)
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 55 | Reports with Substantiated Dispositions | invsubrc |
| 56 | Reports with Indicated Dispositions | invindrc |
| 57 | Reports with Alternative Response Victim Dispositions | invarvrc |
| 58 | Reports with Alternative Response Nonvictim Dispositions | inarnvrc |
| 59 | Reports with Unsubstantiated Dispositions | invunrc |
| 60 | Reports with Intentionally False Dispositions | invfalrc |
| 61 | Reports Closed With No Finding | invnorc |
| 62 | Reports with Other Dispositions | invothrc |
| 63 | Reports with Unknown Dispositions | invunkrc |
Counts from the Child File are based on counting each child, every time a report is filed for that child.
Workers
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 64 | Estimated Number of CPS Workers | worknum |
| 65 | Estimated Number of Workers Who Conduct Only Screening or Intake | numsi |
Children by Disposition (Report-Child Pair Count)
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 66 | Children with Substantiated Dispositions | chsubrc |
| 67 | Children with Indicated Dispositions | chindrc |
| 68 | Children with Alternative Response Victim Dispositions | charvrc |
| 69 | Children with Alternative Response Nonvictim Dispositions | charnvrc |
| 70 | Children with Unsubstantiated Dispositions | chunrc |
| 71 | Children with Intentionally False Dispositions | chfalsrc |
| 72 | Children whose Investigations Were Closed With No Finding | chnorc |
| 73 | Children with No Alleged Maltreatment | chnamrc |
| 74 | Children with Other Dispositions | chothrc |
| 75 | Children with Unknown Dispositions | chunkrc |
| 76 | Total Child Victims | vicrc |
| 77 | Total Unique Count of Child Victims | vicc |
| 78 | Total Nonvictims | nonvicrc |
Counts from the Child File are based on report-child pairs. A child is counted each time he or she is subject of a report that is investigated or assessed. Report dispositional data were used for children for whom there was incomplete data if the report disposition was unsubstantiated. Children for whom there was incomplete data and the report disposition was not unsubstantiated were counted as unknown disposition. The total fields are based on data from the Child File. Total child victims and total nonvictims are based on report-child pairs. Total unique count of child victims is a child count.
Child Victims by Type of Maltreatment (Report-Child Pair Count)
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 79 | Victims of Physical Abuse | vphyrc |
| 80 | Victims of Neglect | vnegrc |
| 81 | Victims of Medical Neglect | vmedrc |
| 82 | Victims of Sex Abuse | vsexrc |
| 83 | Victims of Psychological or Emotional Abuse | vpsyrc |
| 84 | Victims of Other | vothrc |
| 85 | Victims of Unknown Maltreatment | vunkrc |
Counts from the Child File are based on report-child pairs. A child is counted for each maltreatment that is associated with a substantiated, indicated, or alternative response victim disposition. A child may be the victim of more than one type of maltreatment.
Child Victims by Type of Maltreatment (Child Count)
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 86 | Victims of Physical Abuse (unduplicated) | vphyc |
| 87 | Victims of Neglect (unduplicated) | vnegc |
| 88 | Victims of Medical Neglect (unduplicated) | vmedc |
| 89 | Victims of Sexual Abuse (unduplicated) | vsexc |
| 90 | Victims of Psychological or Emotional Abuse or Neglect (unduplicated) | vpsyc |
| 91 | Victims of Other Abuse (unduplicated) | vothc |
| 92 | Victims of Unknown Maltreatment (unduplicated) | vunkc |
Unduplicated counts were computed for States that submitted Child File data. Numbers are based on counting each child only once per maltreatment type. A child who was the victim of two different types of maltreatment is counted under each type of maltreatment.
Victims by Sex (Report-Child Pair Count)
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 93 | Males | vsexmrc |
| 94 | Females | vsexfrc |
| 95 | Sex Unknown | vsexunrc |
Counts from the Child File are based on report-child pairs.
Victims by Sex (Child Count)
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 96 | Males (unduplicated) | vsexmc |
| 97 | Females (unduplicated) | vsexfc |
| 98 | Sex Unknown (unduplicated) | vsexunc |
Counts from the Child File are based on counting each child only once.
Victims by Age (Report-Child Pair Count)
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 99 | Less than 1 year | vlt1rc |
| 100 | 1 year | v1rc |
| 101 | 2 years | v2rc |
| 102 | 3 years | v3rc |
| 103 | 4 years | v4rc |
| 104 | 5 years | v5rc |
| 105 | 6 years | v6rc |
| 106 | 7 years | v7rc |
| 107 | 8 years | v8rc |
| 108 | 9 years | v9rc |
| 109 | 10 years | v10rc |
| 110 | 11 years | v11rc |
| 111 | 12 years | v12rc |
| 112 | 13 years | v13rc |
| 113 | 14 years | v14rc |
| 114 | 15 years | v15rc |
| 115 | 16 years | v16rc |
| 116 | 17 years | v17rc |
| 117 | 18-21 years | v18_21rc |
| 118 | Unknown Age | vageunrc |
Counts from the Child File are based on report-child pairs.
Victims by Age (Child Count)
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 119 | Less than 1 year (unduplicated) | vlt1c |
| 120 | 1 year (unduplicated) | v1c |
| 121 | 2 years (unduplicated) | v2c |
| 122 | 3 years (unduplicated) | v3c |
| 123 | 4 years (unduplicated) | v4c |
| 124 | 5 years (unduplicated) | v5c |
| 125 | 6 years (unduplicated) | v6c |
| 126 | 7 years (unduplicated) | v7c |
| 127 | 8 years (unduplicated) | v8c |
| 128 | 9 years (unduplicated) | v9c |
| 129 | 10 years (unduplicated) | v10c |
| 130 | 11 years (unduplicated) | v11c |
| 131 | 12 years (unduplicated) | v12c |
| 132 | 13 years (unduplicated) | v13c |
| 133 | 14 years (unduplicated) | v14c |
| 134 | 15 years (unduplicated) | v15c |
| 135 | 16 years (unduplicated) | v16c |
| 136 | 17 years (unduplicated) | v17c |
| 137 | 18-21 years (unduplicated) | v18_21c |
| 138 | Unknown Age (unduplicated) | vageunc |
Counts from the Child File are based on counting each child only once.
Victims by Race/Ethnicity (Report-Child Pair Count)
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 139 | Black, African-American | vraarc |
| 140 | American Indian or Alaska Native | vraianrc |
| 141 | Asian | vrasrc |
| 142 | Pacific Islander | vrpirc |
| 143 | Asian and Pacific Islander | vraspirc |
| 144 | White | vrwhrc |
| 145 | Other | vrothrc |
| 146 | Multiple Race | vrmultrc |
| 147 | Unknown, Unable to Determine | vrunudrc |
| 148 | Hispanic | vhisprc |
To integrate ethnicity and racial data across the different collection tools and to maximize comparability of data, some adjustments were made. Data from the Child File were adjusted so that children of Hispanic ethnicity were counted only as Hispanic ethnicity. Based on data from the Child File, children of multiple racial backgrounds, but who are not Hispanic, were counted as multiple race. Counts by racial group, including multiple race, may be undercounts of children who are of a specific race. Data from the SDC were adjusted in that counts of Hispanic children were used to reduce the counts of children of unknown race, or unable to determine race. Unknown, and unable to determine were collapsed because of definitional variation by State and by type of submission. The race category of unknown, and unable to determine includes additional races reported by the SDC only. Data from the SDC may include children of multiple race or of Hispanic ethnicity in each of the race categories or under unknown race. The sum of percentages of children by race and ethnicity, reported through the SDC, may be more than 100 percent due to this unavoidable duplication.
Victims by Race/Ethnicity (Child Count)
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 149 | Black, African-American (unduplicated) | vraarc |
| 150 | American Indian or Alaska Native (unduplicated) | vraianc |
| 151 | Asian (unduplicated) | vrasc |
| 152 | Pacific Islander (unduplicated) | vrpic |
| 153 | Asian and Pacific Islander (unduplicated) | vraspic |
| 154 | White (unduplicated) | vrwhc |
| 155 | Other (unduplicated) | vrothc |
| 156 | Multiple Race (unduplicated) | vrmultc |
| 157 | Unknown, Unable to Determine (unduplicated) | vrunudc |
| 158 | Hispanic (unduplicated) | vhispc |
To integrate ethnicity and racial data across the different collection tools and to maximize comparability of data, some adjustments were made. Data on the unduplicated count of victims by race and ethnicity are not collected in the SDC. Data from the Child File were adjusted so that children of Hispanic ethnicity were counted only as Hispanic ethnicity. Based on data from the Child File, children of multiple racial backgrounds, but who are not Hispanic, were counted as multiple race. Counts by racial group, including multiple race, may be undercounts of children who are of a specific race. Unknown, and unable to determine were collapsed because of definitional variation by States. Each child is counted only once.
Child Fatalities (Child Count)
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 159 | Fatalities Reported in the Agency File | fatalag |
| 160 | Fatalities Reported in the Child File | fatalch |
| 161 | Fatalities Reported in the SDC | fatalsdc |
| 162 | Total Fatalities | fataltot |
| 163 | Fatalities in Foster Care in the Agency File | fatfcag |
| 164 | Fatalities in Foster Care in the Child File | fatfcch |
| 165 | Fatalities in Foster Care in the SDC | fatfcsdc |
| 166 | Total Fatalities in Foster Care | fatfctot |
| 167 | Fatalities Whose Families Received Family Preservation Within Last 5 Years | fatalfps |
| 168 | Fatalities Who had Been Reunified Within the last 5 years | fatalfr |
| 169 | Fatalities Whose Families Had Received Family Preservation Services within the last 5 Years, Reported in the Child File | ftlfpscf |
| 170 | Fatalities Who Had Been Reunited with Their Families in the Last 5 Years, Reported in the Child File | ftlcrucf |
Fatalities reported in the Agency File include those deaths not identified through the State’s child welfare information system and reported through the Child File. Fatalities in foster care include children who died as a result of maltreatment while in foster care (including foster homes, group homes, emergency shelters, residential care, and institutions) and attributed to the foster care provider. The perpetrator relationship fields were used in the Child File to identify children who died as a result of maltreatment while in foster care.
Children by Source of Preventive Services Funding
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 171 | Child Abuse and Neglect State Grant | psstgtc |
| 172 | Community-Based Family Resource and Support Grant | pscospc |
| 173 | Promoting Safe & Stable Families Program | pstlivbc |
| 174 | Social Services Block Grant | pstlxxc |
| 175 | Other Sources | psotherc |
A child may have been counted under multiple funding sources and more than once under a specific funding source.
Families by Source of Preventive Services Funding
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 176 | Child Abuse and Neglect State Grant | psstgtf |
| 177 | Community-Based Family Resource and Support Grant | pscospf |
| 178 | Promoting Safe & Stable Families Program | pstlivbf |
| 179 | Social Services Block Grant | pstlxxf |
| 180 | Other Sources | psotherf |
A family may have been counted under multiple funding sources and more than once under a specific funding source.
Postinvestigation Services
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 181 | Average Days from Start of Investigation to Postinvestigation Services Calculated from the Child File | srtimdcd |
| 182 | Average Hours from Start of Investigation to Provision of Services Reported in the SDC | srtimsdc |
| 183 | Children with Substantiated Dispositions Who Received Additional Services or Postinvestigation Services | sersubrc |
| 184 | Children with Indicated Dispositions Who Received Additional Services or Postinvestigation Services | serindrc |
| 185 | Children with Alternative Response Victim Dispositions Who Received Additional Services or Postinvestigation Services | serarvrc |
| 186 | Children with Alternative Response Nonvictim Dispositions Who Received Additional Services or Postinvestigation Services | srarnvrc |
| 187 | Children with Unsubstantiated Dispositions Who Received Additional Services or Postinvestigation Services | serunrc |
| 188 | Children with Intentionally False Dispositions Who Received Additional Services or Postinvestigation Services | serfalrc |
| 189 | Children whose Investigations Were Closed With No Finding Who Received Additional Services or Postinvestigation Services | sernorc |
| 190 | Children with No Alleged Maltreatment Who Received Additional Services or Postinvestigation Services | sernamrc |
| 191 | Children with Other Dispositions Who Received Additional Services or Postinvestigation Services | serothrc |
| 192 | Children with Unknown Dispositions Who Received Additional Services or Postinvestigation Services | serunkrc |
Data from the Child File are counted in terms of report-child pairs. Service counts may be undercounts if the State is unable to track specific types of services.
Children Removed from Their Home by Disposition (Report-Child Pair Count)
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 193 | Children with Substantiated Dispositions | remsubrc |
| 194 | Children with Indicated Dispositions | remindrc |
| 195 | Children with Alternative Response Victim Dispositions | remarvrc |
| 196 | Children with Alternative Response Nonvictim Dispositions | rmarnvrc |
| 197 | Children with Unsubstantiated Dispositions | remunrc |
| 198 | Children with Intentionally False Dispositions | remfalrc |
| 199 | Children Whose Investigations Were Closed With No Finding | remnorc |
| 200 | Children No Alleged Maltreatment Placed in Care | remnamrc |
| 201 | Children with Other Dispositions | remothrc |
| 202 | Children with Unknown Dispositions | remunkrc |
Data from the Child File are counted in terms of report-child pairs. Removals within 90 days of the disposition date are counted.
Additional Service Information
| Field | Data Element Long Name | Short Name |
|---|---|---|
| 203 | Victims Whose Families Received Family Preservation Services within the Past 5 Years | fp5yrs |
| 204 | Victims Who Had Been Reunified within the Past 5 Years | freun5yr |
| 205 | Victims Subject of a Juvenile Court Action or Petition | vjuvptrc |
| 206 | Victims Who Received a Court-Appointed Representative | vcrtrprc |
| 207 | Average Number of Times the Court-Appointed Representative Met with the Child Out-of-Court | contcars |
Combined Aggregate File Data Element List
To provide State-level statistics, case-level data were aggregated on key variables for those States that submitted the Child File. The aggregated numbers from the Child File, the Agency file, and the SDC were combined into one data file-the Combined Aggregate File (CAF). Creating this new file enabled the three data sources to be merged into one file that would provide State-level data for all the States. Three columns are listed in this table, the first indicates the field position of the data element, the second column indicates the name of the data element, and the third column indicates the abbreviated name of the data element. The data elements are grouped by subject (i.e. referrals, investigations, victims by sex, etc.) with technical notes listed beneath each subject, if necessary.
Return to Appendix C text
Return to Appendix C: Figures and Tables
