The DQU checks each element to ensure that it meets certain minimum standards. These standards are based on Children's Bureau policy. The standards used by the DQU are somewhat stricter than those used by the Data Compliance Utility.
Table 1, below, indicates the standards by which the DQU measures each of the 66 foster care data elements including the expanded six character race elements. There are five columns in the table:
Each element has one of three types.
For code elements the specific values that are allowed and their corresponding meaning are given. For uncoded and date elements, the allowable range is given. All dates must also be valid dates (e.g., the month must be between 01 - 12 and the day must be not exceed the number of days in the month).
Also, all uncoded elements must be right-justified and padded with zeros. Each of the four components of the date element (the century, the year, the month, and the day) must also be right-justified and padded with zeros (e.g., the date March 3, 1901 should appear this way: 19010301). If the element contains a value that is not included in this column, the element will be marked as out of range by the DQU.
Data Element |
Element Type/Size |
Missing Data Standard |
Allowable Values |
Inconsistency Check Group Involvement |
#1 State |
Code (2) |
no nulls |
see list of allowable State FIPS Codes (Appendix B) |
none |
#2 Report Period End Date |
Date (6: CCYYMM) |
no nulls |
CCYY > 1995 Care Consistency Group MM = 03 or 09 |
group #1 |
#3 Local FIPS Code |
Code (5) |
no nulls |
see list of allowable Local FIPS codes (Appendix B); must be valid within State |
none |
#4 Record Number |
Encrypted or Sequential Number (12) |
nulls permitted |
any ASCII characters allowed except @, #, $, or % |
none |
#5 Date of Most Recent Periodic Review |
Date (8: CCYYMMDD) |
nulls permitted |
valid date
> 1/1/1900 Care Consistency Group
> system dateCare Consistency Group
Care Consistency Group |
group #1
group #6 |
#6 Child's Birth Date |
Date (8: CCYYMMDD) |
no nulls |
valid date
> 1/1/1900Care Consistency Group
> system dateCare Consistency Group
Care Consistency Group |
group #1 |
#7 Child's Sex |
Code (1) |
no nulls |
1 = male
2 = female |
none |
#8a Child's Race - American Indian or Alaska Native |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #13 |
#8b Child's Race - Asian |
Code(1) |
no nulls |
0 = does not apply
1 = applies |
group #13 |
#8c Child's Race - Black or African American |
Code(1) |
no nulls |
0 = does not apply
1 = applies |
group #13 |
#8d Child's Race - Native Hawaiian or Other Pacific Islander |
Code(1) |
no nulls |
0 = does not apply
1 = applies |
group #13 |
#8e Child's Race - White |
Code(1) |
no nulls |
0 = does not apply
1 = applies |
group #13 |
#8f Child's Race - Unable to Determine |
Code(1) |
no nulls |
0 = does not apply
1 = applies |
group #13 |
#9 Child's Hispanic or Latino Origin |
Code (1) |
no nulls |
1 = yes
2 = no
3 = unable to determine |
none |
#10 Has Child Been Diagnosed with Disability |
Code (1) |
no nulls |
1 = yes
2 = no
3 = not yet determined |
group #2 |
#11 Child Has Been Diagnosed with Mental Retardation |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #2 |
#12 Child Has Been Diagnosed as Visually/Hearing Impaired |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #2 |
#13 Child Has Been Diagnosed as Physically Disabled |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #2 |
#14 Child Has Been Diagnosed as Emotionally Disturbed |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #2 |
#15 Child Has Been Diagnosed with Other Medical Condition |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #2 |
#16 Has Child Been Adopted Prior to the Current Episode |
Code (1) |
no nulls |
1 = yes
2 = no
3 = unable to determine |
group #3 |
#17 Child's Age at Adoption Prior to the Current Episode |
Code (1) |
nulls permitted |
0 = not applicable
1 = less than 2 years old
2 = 2-5 years old
3 = 6-12 years old
4 = 13 years or older
5 = unable to determine |
group #3 |
#18 Date of First Removal from Home |
Date (8: CCYYMMDD) |
no nulls |
valid date
> 1/1/1900Care Consistency Group
> system dateCare Consistency Group
Care Consistency Group |
group #1
group #4 |
#19 Total Number of Removals from Home |
Uncoded (2) |
no nulls |
>00
right-justified |
group #4 |
#20 Date of Discharge from Previous Episode |
Date (8: CCYYMMDD) |
nulls permitted |
valid date
> 1/1/1900Care Consistency Group
> system dateCare Consistency Group
Care Consistency Group |
group #4 |
#21 Date of Latest Removal from Home |
Date (8: CCYYMMDD) |
no nulls |
valid date
> 1/1/1900Care Consistency Group
> system dateCare Consistency Group
Care Consistency Group |
group #1
group #4
group #5
group #6
group #10 |
#22 Transaction Date of Latest Removal from Home |
Date (8: CCYYMMDD) |
no nulls |
valid date
> 1/1/1900Care Consistency Group
> system dateCare Consistency Group
Care Consistency Group |
group #1 |
#23 Date of Placement |
Date (8: CCYYMMDD) |
no nulls |
valid date
> 1/1/1900Care Consistency Group
> system dateCare Consistency Group
Care Consistency Group |
group #1
group #5 |
#24 Number of Placements in Current Episode |
Uncoded (2) |
no nulls |
>00
right-justified |
group #5 |
#25 Manner of Removal |
Code (1) |
no nulls |
1 = voluntary
2 = court ordered
3 = not yet determined |
group #6 |
#26 Condition Associated with Removal - Physical Abuse (alleged/reported) |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #7 |
#27 Condition Associated with Removal - Sexual Abuse (alleged/reported) |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #7 |
#28 Condition Associated with Removal - Neglect (alleged/reported) |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #7 |
#29 Condition Associated with Removal - Parent Alcohol Abuse |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #7 |
#30 Condition Associated with Removal - Parent Drug Abuse |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #7 |
#31 Condition Associated with Removal - Child Alcohol Abuse |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #7 |
#32 Condition Associated with Removal - Child Drug Abuse |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #7 |
#33 Condition Associated with Removal - Child Disability |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #7 |
#34 Condition Associated with Removal - Child Behavior Problem |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #7 |
#35 Condition Associated with Removal - Death of Parent |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #7 |
#36 Condition Associated with Removal - Incarceration of Parent |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #7 |
#37 Condition Associated with Removal - Caretaker Inability to Cope |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #7 |
#38 Condition Associated with Removal - Abandonment |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #7 |
#39 Condition Associated with Removal - Relinquishment |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #7 |
#40 Condition Associated with Removal - Inadequate Housing |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #7 |
#41 Current Placement Setting |
Code (1) |
no nulls |
1 = pre-adoptive home
2 = foster family home (relative)
3 = foster family home (non-relative)
4 = group home
5 = institution
6 = supervised independent living
7 = runaway
8 = trial home visit |
group #9 |
#42 Is Placement Out of State? |
Code (1) |
no nulls |
1 = yes
2 = no |
none |
#43 Most Recent Case Plan Goal |
Code (1) |
no nulls |
1 = reunify with parent(s) or principal caretaker(s)
2 = live with other relative(s)
3 = adoption
4 = long term foster care
5 = emancipation
6 = guardianship
7 = not yet established |
group #6
group #10 |
#44 Primary Caretaker Family Structure |
Code (1) |
no nulls |
1 = Married Couple
2 = Unmarried Couple
3 = Single Female
4 = Single Male
5 = Unable to Determine |
group #8 |
#45 1st Primary Caretaker's Birth Year |
Date (4: CCYY) |
nulls permitted |
> 1900 Care Consistency Group
< system year
Care Consistency Group |
group #1
group #8 |
#46 2nd Primary Caretaker's Birth Year |
Date (4: CCYY) |
nulls permitted |
> 1900 Care Consistency Group
< system year
Care Consistency Group |
group #1
group #8 |
#47 Date of Termination of Mother's Parental Rights |
Date (8: CCYYMMDD) |
nulls permitted |
> 1/1/1900 Care Consistency Group
> system dateCare Consistency Group
Care Consistency Group |
group #1
group #10 |
#48 Date of Termination of Father's Parental Rights |
Date (8: CCYYMMDD) |
nulls permitted |
> 1/1/1900 Care Consistency Group
> system dateCare Consistency Group
Care Consistency Group |
group #1
group #10 |
#49 Foster Family Structure |
Code (1) |
nulls permitted |
0 = not applicable
1 = Married Couple
2 = Unmarried Couple
3 = Single Female
4 = Single Male |
group #9 |
#50 1st Foster Caretaker's Birth Year |
Date (4: CCYY) |
nulls permitted |
> 1900 Care Consistency Group
< system year
Care Consistency Group |
group #1
group #9 |
#51 2nd Foster Caretaker's Birth Year |
Date (4: CCYY) |
nulls permitted |
> 1900 Care Consistency Group
< system year
Care Consistency Group |
group #1
group #9 |
#52a 1st Foster Caretaker's Race - American Indian or Alaska Native |
Code (1) |
nulls permitted |
0 = does not apply
1 = applies |
group #9
group #13 |
#52b 1st Foster Caretaker's Race - Asian |
Code (1) |
nulls permitted |
0 = does not apply
1 = applies |
group #9
group #13 |
#52c 1st Foster Caretaker's Race - Black or African American |
Code (1) |
nulls permitted |
0 = does not apply
1 = applies |
group #9
group #13 |
#52d 1st Foster Caretaker's Race - Native Hawaiian or Other Pacific Islander |
Code (1) |
nulls permitted |
0 = does not apply
1 = applies |
group #9
group #13 |
#52e 1st Foster Caretaker's Race - White |
Code (1) |
nulls permitted |
0 = does not apply
1 = applies |
group #9
group #13 |
#52f 1st Foster Caretaker's Race - Unable to Determine |
Code (1) |
nulls permitted |
0 = does not apply
1 = applies |
group #9
group #13 |
#53 1st Foster Caretaker's Hispanic or Latino Origin |
Code (1) |
nulls permitted |
0 = not applicable
1 = yes
2 = no
3 = unable to determine |
group #9 |
#54a 2nd Foster Caretaker's Race |
Code (1) |
nulls permitted |
0 = does not apply
1 = applies |
group #9
group #13 |
#54b 2nd Foster Caretaker's Race - Asian |
Code (1) |
nulls permitted |
0 = does not apply
1 = applies |
group #9
group #13 |
#54c 2nd Foster Caretaker's Race - Black or African American |
Code (1) |
nulls permitted |
0 = does not apply
1 = applies |
group #9
group #13 |
#54d 2nd Foster Caretaker's Race - Native Hawaiian or Other Pacific Islander |
Code (1) |
nulls permitted |
0 = does not apply
1 = applies |
group #9
group #13 |
#54e 2nd Foster Caretaker's Race - White |
Code (1) |
nulls permitted |
0 = does not apply
1 = applies |
group #9
group #13 |
#54f 2nd Foster Caretaker's Race - Unable to Determine |
Code (1) |
nulls permitted |
0 = does not apply
1 = applies |
group #9
group #13 |
#55 2nd Foster Caretaker's Hispanic or Latino Origin |
Code (1) |
nulls permitted |
0 = not applicable
1 = yes
2 = no
3 = unable to determine |
group #9 |
#56 Date of Discharge |
Date (8: CCYYMMDD) |
nulls permitted |
valid date
> 1/1/1900 Care Consistency Group
> system dateCare Consistency Group
Care Consistency Group |
group #1
group #6
group #13 |
#57 Transaction Date of Discharge |
Date (8: CCYYMMDD) |
nulls permitted |
valid date
> 1/1/1900 Care Consistency Group
> system date Care Consistency Group
Care Consistency Group |
group #1
group #13 |
#58 Reason for Discharge |
Code (1) |
nulls permitted |
0 = not applicable
1 = reunification with parent(s) or principal caretaker(s)
2 = living with other relative(s)
3 = adoption
4 = emancipation
5 = guardianship
6 = transfer to another agency
7 = runaway
8 = death of child |
group #10
group #11 |
#59 Sources of Federal Support - Title IV-E (Foster Care) |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #12 |
#60 Sources of Federal Support - Title IV-E (Adoption Assistance) |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #12 |
#61 Sources of Federal Support - Title IV-A (AFDC) |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #12 |
#62 Sources of Federal Support - Title IV-D (Child Support) |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #12 |
#63 Sources of Federal Support - Title XIX (Medicaid Eligible) |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #12 |
#64 Sources of Federal Support - SSI and Other Social Security Act |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #12 |
#65 Sources of Federal Support - None of the Above |
Code (1) |
no nulls |
0 = does not apply
1 = applies |
group #12 |
#66 Amount of Monthly Subsidy (All Sources) |
Uncoded (5) |
no nulls |
right-justified |
group #12 |