CDD-801A Electronic File Format Specifications

1

Report month and year

C

7

Yes

Required format is mm/yyyy. Example: January 2012 must be entered as 01/2012.

2

Vendor number/submission code1

C

Max. 8

Yes

Example: Vendor number Z987 and submission code 000 is entered as Z987000.

3

Family Identification/Case Number (FICN)

C

Max. 15

Yes

Only letters A-Z (both upper and lower case are acceptable) and numbers 0-9 are allowed. For each family you must report the FICN.

Head-of-Household Last Name

C

Max. 50; Min. 1

Yes

Only letters, hyphens, spaces, and apostrophes are allowed.

5

Head-of-Household First Name

C

Max. 50; Min. 1

Yes

Only letters, hyphens, spaces, and apostrophes are allowed.

6

Head-of-Household Middle Initial

C

1

No

This field must be included in the file, even if it is blank.

7

Head-of-Household Zip Code

N

9

Yes

Numbers only; do not include dash. Example: 999999999 (Five digit Zip Code + 4 digit extension)

8

TANF/CalWORKs Cash Aid Recipient?

C

1

Yes

3 valid entries are: Y (yes), N (no), or U (unknown).

9

Family Income Greater Than 85 Percent of the State Median Income Level?

C

1

Yes

3 valid entries are: Y (yes), N (no), or U (unknown).

12

Reason for Receiving Services

C

1

Yes

Only 14 valid entries: A, B, C, D, E, F, G, H, J, Q, R, S, U, V.

13

Head-of-Household FIPS Code

N

5

Yes

This field must contain five digits. Example: 06001, 06003. Leading zero must be included.

14

Family Start Date

Date

10

Yes

Required format is mm/dd/yyyy (include the slashes). Example: September 2, 2012, must be entered as 09/02/2012.

15

Child's Last Name

C

Max. 50; Min. 1

Yes

Only letters, hyphens, spaces, and apostrophes are allowed.

16

Child's First Name

C

Max. 50; Min. 1

Yes

Only letters, hyphens, spaces, and apostrophes are allowed.

17

Child's Middle Initial

C

1

No

This field must be included in the file, even if it is blank.

25

Child's Date of Birth

Date

10

Yes

Required format is mm/dd/yyyy (include the slashes). Example: September 2, 2012, must be entered as 09/02/2012.

26

Child has an IEP or IFSP

C

1

Yes

2 valid entries: Y (yes) or N (no).

Child Start Date

Date

10

Yes

Required format is mm/dd/yyyy (include the slashes). Example: September 2, 2012, must be entered as 09/02/2012.

31

Provider FEIN/SSN

N

9

Yes

Numbers only; do not include dashes (-).

The field must contain a single digit.
The ten valid entries are:
0 - No. Provider is eligible but does not participate in a QRIS.
1 - Yes. Provider does participate in a QRIS and tier rank is 1.
2 - Yes. Provider does participate in a QRIS and tier rank is 2.
3 - Yes. Provider does participate in a QRIS and tier rank is 3.
4 - Yes. Provider does participate in a QRIS and tier rank is 4.
5 - Yes. Provider does participate in a QRIS and tier rank is 5.
6 - Yes. Provider does particiapte in a QRIS but is not rated yet.
7 - The State has an operating QRIS in the Provider's area, but the Provider is not eligible to participate.
8 - The State does not have an operating QRIS in the Provider area.
9 - The State has an operating QRIS in the Provider's area but information is currently unavailable at the Provider level.

36

Type of Child Care

N

2

Yes

This field must contain 2 digits. Example: 02, 04, etc. Leading zero must be included.

37

Program Code 1

C

4

Yes

Program Code 1 is required.

38

Program Code 2

C

4

No

This field should only contain data if the child receives services from more than one program code. This field must be included in the file, even if it is blank.

Program Code 3

C

4

No

This field should only contain data if the child receives services from more than two program codes. This field must be included in the file, even if it is blank.

40

Services Date

Date

10

Yes

Required format is mm/dd/yyyy (include the slashes). Example: September 2, 2012, must be entered as 09/02/2012.