Child Care Bureau: Child Care and Development Fund (CCDF)

Child Care and Development Fund

Technical Bulletin #4

Please Note: Technical Bulletin Number Four has been superseded by a revision of Technical Bulletin Number Four, published March 2002.

ACF-801 Case-Level File Format (also in Word and PDF)
REVISED: March 20, 2000

Note: This Technical Bulletin lists formatting guidance for the ACF 801 data submission file prior to the recent changes in reporting requirements. Technical Bulletin 4r (Revised), now includes revised formatting guidance for submitting the ACF 801 data submission file.

I. Introduction: Technical Bulletin #4 describes the requirements for formatting the ACF-801 data submission file. All states and territories should follow these formatting guidelines when creating the file for electronic submission to the Administration for Children and Families (ACF). The formatting standards for each item required in the ACF-801 are listed below. All questions about the file format should be directed to the Child Care Automation Resource Center. This Technical Bulletin also includes the revised guidance to States unable to submit data in a variable record length format.

The ACF-801 data submission contains information required on the ACF-801: Child Care Quarterly Case Record Form. States have the option to submit either a sample or the complete population of the children receiving federal child care subsidies. States also have the option to submit data for either one month or quarterly (3 months at once). However, regardless of whether the State submits a sample or the full population, or chooses to submit data monthly or quarterly, the guidelines in this bulletin apply.

The file format portion of this document is organized into the following sections:

Contents of ACF-801 Data Submission: Lists the types of records that are included in the electronic file.
Order of Records in the ACF-801 Data Submission: Gives the order of records in the file.
The Monthly Summary Record: Describes the format of the monthly summary record.
Records on families and children receiving subsidized child care: Describes the format of the records containing information on families receiving federal child care subsidies.
Missing and Numeric Data Elements in Family Records: Explains how missing data elements should be handled in the records on families and children receiving subsidized child care.
Footnotes: Describes the format of optional explanatory footnotes.
Summary of Record and File Delimiters: Lists all delimiters to be included in the file and explains their use.

II. File Format: Contents of ACF-801 Data Submission:The data submission is made up of two or, at the States option, three types of records:

The monthly summary record. This is required.
Records on families and children receiving subsidized child care. These are required.
Footnotes. These are optional.

The data is submitted in a flat file with variable length records.Order of Records in the ACF-801 Data Submission:Records should be ordered as listed below. For example, if the State chooses to submit the data only for April 1998, the order of records in the file would be:

April's monthly summary record.
Records on families and children receiving subsidized child care during April 1998.
Footnotes commenting on April's data elements.
The & file delimiter indicating the end of the data submission.

The record order is repeated if the State submits data quarterly. For example, if the State submits data for April, May, and June 1998 at one time, the record order would be:

April's monthly summary record.
Records on families and children receiving subsidized child care during April 1998.
Footnotes commenting on April's data elements.
May's monthly summary record.
Records on families and children receiving subsidized child care during May 1998.
June's monthly summary record.
Records on families and children receiving subsidized child care during June 1998.
Footnotes commenting on June's data elements.
The & file delimiter indicating the end of the data submission.

Please note that the above example does not include footnotes for May, as footnotes are optional. If the State had elected to submit footnotes with the May data, the footnote records would immediately follow 5. Records on families and children receiving subsidized child care during May 1998 and precede 6. June's monthly summary record. Also note that only one & file delimiter is included in either example.The following sections of this technical bulletin describe the formats of the three types of records, including delimiter placement.

The Monthly Summary Record: Each month's data begins with a record containing the following data:

Data Element Description	Format	Length	Comment
Delimiter	M	1	This delimiter identifies the following record as a monthly summary record.
Report Period	YYYYMM	6	This data element identifies the month being reported. For example, if the report covers April 1998, this element would be "199804".
Families Receiving Subsidized Child Care	Number	7	The number of families receiving subsidized child care in your State for the reported month. The number should be right-justified within the field and padded with zeros. For example, 25,387 would be formatted as "0025387".
Number of Children in Pre-K Child Care	Number	7	The number of children (or estimated number if actual count is unavailable) receiving subsidized pre-K child care services in your State for the report month. The number should be right-justified within the field and padded with zeros. For example, 5,247 would be formatted as "0005247".
Delimiter	#	1	Identifies the following data as contact information.
State Contact Name	Character	No limit	The name of the State child care contact who is designated to receive the data reports.
Delimiter	#	1	Identifies the following data as contact information.
State Contact Telephone Number	Character	No limit	The telephone number of the State child care contact.
Delimiter	#	1	Identifies the following data as contact information.
State Contact Fax Number	Character	No limit	The fax number of the State child care contact.
Delimiter	#	1	Identifies the following data as contact information.
State Contact E-mail Address	Character	No limit	The e-mail address of the State child care contact
Record Delimiter	$	1	This delimiter indicates the end of the record.

The delimiters, report period, subsidized child care population, and contact information is required. However, if the State does not have certain contact information, such as e-mail addresses, the field may be skipped, although all delimiters should be included.

For example, following is a monthly summary record containing the following data:

Report Period:	April 1998
Population:	72,384
Pre-K:	4,629
Contact name:	Jane Smith
Contact Telephone:	(703) 555-1234 ext. 684
Contact Fax:	(703) 555-9876
Contact E-mail:	jsmith@dhr.anystate.us

The monthly summary record would be formatted as follows (delimiters are in Bold):
M19980400723840004629#Jane Smith#(703) 555-1234 ext. 666#(703) 555-9876#jsmith@dhr.anystate.us$

However, if the State did not have a fax number available, the formatted record would look like this (note the two # delimiters together, indicating that no fax number was included):
M19980400723840004629#Jane Smith#(703) 555-1234 ext. 684##jsmith@dhr.anystate.us$

The monthly summary record is immediately followed by the records on families and children receiving subsidized child care.

Records on families and children receiving subsidized child care: One record is included for each family.

Each record contains:

family data, information which applies to the family as a whole and,
dependent children receiving child care data, information on each child receiving child care assistance and all subsidized child care settings for that child.

The format for family data will be the same for each record. An F delimiter is placed before each family's data to identify the information. Record positions 1 through 59 will always contain family data as detailed in the following table:

Data Element Number/Description	Data Format	Length
Delimiter identifying family data	F	1
01:Sample Month/Year of Report Period	YYYYMM	6
02:Unique State Identifier (Optional)	Character	15
03:Social Security Number	Number	9
04:FIPS Code	Number	5
05:Single Parent?	Number	1
06:Reason For Receiving Subsidize Child Care	Number	1
07:Total Monthly Child Care Copayment by Family	Number	4
08:Month/Year Child Care Assistance Started	YYYYMM	6
09:Total Monthly Income for Determining Eligibility	Number	5
10:Employment Income, Including Self-Employment	Number	1
11:Title IV of the Social Security Act (TANF)	Number	1
12:State Program for Which State Spending is Counted Towards TANF MOE	Number	1
13:Housing Voucher or Cash Assistance	Number	1
14:Assistance Under the Food Stamps Act of 1977	Number	1
15:Other Federal Cash Income	Number	1
16: Family Size	Number	2

The format for dependent children receiving child care will differ from record to record depending on the number of children receiving assistance per family, and the number of child care settings per child. This data always begins at record position 62 and continues until all of the information for each child receiving child care assistance is recorded. Delimiters are used to identify children and settings. C precedes each child's data and S precedes setting data. Additional settings for the same child follow the same format; they start with a S. The child and setting format is repeated for each child receiving assistance in the family. Finally, a $ delimiter is placed after the last child's final setting to mark the end of the family's record. The following table gives the details of this format:

Data Element Number/Description	Data Format	Length
Delimiter identifying child data	C	1
17:Child #1 SSN (optional)	Character	9
18: Is Child #1 Hispanic or Latino?	Number	1
19: Is Child #1 American Indian or Alaskan Native?	Number	1
20: Is Child #1 Asian?	Number	1
21: Is Child #1 Black or African American?	Number	1
22: Is Child #1 Native Hawaiian or Other Pacific Islander?	Number	1
23: Is Child #1 White?	Number	1
24: Gender of Child #1	Number	1
25: Month/Year of Birth of Child #1	YYYYMM	6
*Add first child care setting.*
Delimiter identifying setting data	S	1
26: Type of Child Care (Setting #1) for Child #1	Number	2
27: Total Monthly Amount Paid to Provider (Setting #1) for Child #1	Number	4
28: Total hours of Child Care per Month (Setting #1) for Child #1	Number	3
*If second child care setting exists, add record.*
Delimiter identifying setting data	S	1
26: Type of Child Care (Setting #2) for Child #1	Number	2
27: Total Monthly Amount Paid to Provider (Setting #2) for Child #1	Number	4
28: Total hours of Child Care per Month (Setting #2) for Child #1	Number	3
*If third child care setting exists, add record.*
Delimiter identifying setting data	S	1
26: Type of Child Care (Setting #3) for Child #1	Number	2
27: Total Monthly Amount Paid to Provider (Setting #3) for Child #1	Number	4
28: Total hours of Child Care per Month (Setting #3) for Child #1	Number	3
*If fourth child care setting exists, add record.*
Delimiter identifying setting data	S	1
26: Type of Child Care (Setting #4) for Child #1	Number	2
27: Total Monthly Amount Paid to Provider (Setting #4) for Child #1	Number	4
28: Total hours of Child Care per Month (Setting #4) for Child #1	Number	3
*Repeat for each additional child care setting for this child.*
*If second child is receiving child care assistance, add record.*
Delimiter identifying child data	C	1
17: Child #2 SSN (Optional)	Character	9
18: Is Child #2 Hispanic or Latino?	Number	1
19: Is Child #2 American Indian or Alaskan Native?	Number	1
20: Is Child #2 Asian?	Number	1
21: Is Child #2 Black or African American?	Number	1
22: Is Child #2 Native Hawaiian or Other Pacific Islander?	Number	1
23: Is Child #2 White?	Number	1
24: Gender of Child #2		1
25: Month/Year of Birth of Child #2	YYYYMM	6
*Add first child care setting.*
Delimiter identifying setting data	S	1
26: Type of Child Care (Setting #1) for Child #2	Number	2
27: Total Monthly Amount Paid to Provider (Setting #1) for Child #2	Number	4
28: Total hours of Child Care per Month (Setting #1) for Child #2	Number	3
*If second child care setting exists, add record.*
Delimiter identifying setting data	S	1
26: Type of Child Care (Setting #2) for Child #2	Number	2
27: Total Monthly Amount Paid to Provider (Setting #2) for Child #2	Number	4
28: Total hours of Child Care per Month (Setting #2) for Child #2	Number	3
*If third child care setting exists, add record.*
Delimiter identifying setting data	S	1
26: Type of Child Care (Setting #3) for Child #2	Number	2
27: Total Monthly Amount Paid to Provider (Setting #3) for Child #2	Number	4
28: Total hours of Child Care per Month (Setting #3) for Child #2	Number	3
*If fourth child care setting exists, add record.*
Delimiter identifying setting data	S	1
26: Type of Child Care (Setting #4) for Child #2	Number	2
27: Total Monthly Amount Paid to Provider (Setting #4) for Child #2	Number	4
28: Total hours of Child Care per Month (Setting #4) for Child #2	Number	3
*Repeat for each additional child care setting for this child.*
*Repeat until all of the children receiving assistance are included.*
Delimiter indicating the end of family's entire data record	$	1

This format is repeated for each family included in the data submission. On the following page are two examples of family, children, and setting data:

Examples of Case Record Submissions

Example 1:
Suppose a family of four has two children receiving child care assistance during the month. The first child is in one child care setting during the month. The second child is in two settings, with the second setting missing the information for 28:Total hours of Child Care per Month (Setting #2).

data

Example 2: Suppose a family of three has one child receiving child care assistance during the month. This child is in one child care setting.

A record having the following format would be submitted:

data

The last submitted record on families and children receiving subsidized child care is either followed by:

the optional footnotes for this month, if the State chooses to submit footnotes; or
the monthly summary file for the successive month, if the State is submitting three months at once; or
the & file delimiter if this is the last record in the ACF-801 data submission.

Missing and Numeric Data Elements in Family Records:
Although the number of families, children, and settings will vary in each submission, the space allocated to each group of elements remains the same. The family data is always allotted 61 positions; each child is allotted 23 positions and each setting 10. If the State is missing a data element for a record, blanks should be inserted in its place. For example, if the State is missing data element 09: Month/Year Child Care Assistance Started for one family, 6 spaces should be included in the record. Likewise, if element 28: Total Hours of Care Provided in Month were unavailable for one setting, the State would insert three blanks. This rule also applies to optional data elements such as 17: Child's Social Security Number. If the State does not provide a child's social security number, nine blanks should be inserted into the record immediately following the C.

Numeric data such as counts or dollars should be right justified in the space allocated for the element and padded with zeros to fill the field. For example, element 09: Total Monthly Family Income for Determining Eligibility is allocated 5 positions. If, for example, family income were $ 980, the amount would be formatted as '00980'. This standard also is used for element 02:Unique State Identifier; if this optional data element is supplied, the characters should be right justified and padded with zeros to fill out the 15 spaces allocated for the element. In summary, this formatting standard applies to the following elements:

02: Unique State Identifier
07: Total Monthly Child Care Copayment by Family
10: Total Monthly Family Income for Determining Eligibility
16: Family Size
27: Total Monthly Amount Paid to Provider
28: Total Hours of Care Provided in Month

Footnotes:Footnotes are included at the States' option. States are encouraged to submit footnotes to clarify the data. Each footnote has the following format:

Data Element Description	Format	Length	Comment
Delimiter identifying footnote	N	1	This delimiter identifies the following record as a footnote.
Footnote Reference	Number	2	This references the data element on which the State is submitting an explanation. It can range from '01' for the first data element in the ACF-801 (the report period) to '28' for the last data element (Total Hours of Care Provided in a Month). States can also submit footnotes that refer to the whole file. In this case, the reference is '00'.
Footnote Body	Character	No limit	The text of the State remarks.
Record Delimiter	%%	2	These characters indicate the end of a footnote record.

Following is an example of a correctly formatted footnote (delimiters are in Bold):N17This State does not currently collect information on ethnicity as a separate data element from race.%%
Summary of Record and File Delimiters: As the records in the ACF-801 data submission can be of varying lengths, delimiters are used to:

identify related groups of data or individual data elements,
mark the end of records, and
determine the length of the file and verify that all data the state intended to transmit was received.

The following table describes all the delimiters that are used in the ACF-801 data submission:

Delimiter	Use
M	This is the first character in the file. It signals that a monthly summary record follows.
#	Identifies a State contact data element in the monthly summary record.
F	Identifies the ACF-801 family data (elements 1-16) for one family.
C	Identifies the ACF-801 child data (elements 17-25) for one child.
S	Identifies the ACF-801 setting data (elements 26-28) for one setting.
$	Marks the end of either a monthly summary record or the complete family, child(ren) and setting(s) record for one family.
N	Marks the beginning of a footnote.
%%	Marks the end of a footnote.
&	Marks the end of the data submission file. Only one & is included with each submission, even if the submission includes three months of data.

Formatting Guidance For States Unable To Submit Data In A Variable Record Length Format
Some States employ software tools that will not allow child care data to be formatted in the variable length format described above. ACF gives these States the option to allocate fixed fields for every submitted record and submit ACF-801 data in the alternative format described below:

Data for each family, child, and setting must follow the formatting rules described previously in this document. Data elements must be in the same order, and the same delimiters ("F", "C", "S", and "$") used. See above for additional information about the standard delimiters.
The State should define each record so that it includes:

allocation for one family.
allocation for a maximum of 15 children per family. The State may allocate space for fewer than 15 children if desired.
allocation for a maximum of 5 settings per child. The State may allocate space for fewer than 5 settings per child if desired.

Each record should begin with the family information, followed by the first child and the five associated settings, followed by the second child and the five associate settings. This allocation continues up to the 15^th child (if the State chooses to allocate that much space per family). This space is allocated even if not used for a specific family.
A new delimiter, an asterisk "*", is used to mark all allocated but unused space for children and settings. Unused space should be filled with blanks or zeros and be the correct length for a child (22) or setting (9).

Following is an example of a State's (or Territory's) family record in a fixed record length. The maximum allowable record space is allocated. The first child has three settings and the second child has two settings:F (60 characters of data)C (22 characters of data for child 1)S(9 characters of data for setting 1)S(9 characters of data for setting 2)S(9 characters of data for setting 3)*(9 blanks for setting 4) )*(9 blanks for setting 5)C (22 characters of data for child 2)S(9 characters of data for setting 1)S(9 characters of data for setting 2)*(9 blanks for setting 3)*(9 blanks for setting 4)*(9 blanks for setting 5)*(22 blanks for child 3)*(9 blanks for setting 1)*(9 blanks for setting 2) *(9 blanks for setting 3) *(9 blanks for setting 4) *(9 blanks for setting 5)133.. *(22 blanks for child 15)*(9 blanks for setting 1)*(9 blanks for setting 2) *(9 blanks for setting 3) *(9 blanks for setting 4) *(9 blanks for setting 5)$

This is a Historical Document.