This Document Describes the File Layout for Uploading Site Claim Records Into the Cnpweb

Technical Specifications
Dynamic Internet Solutions / File Upload Layout for
Child and Adult Care Food Program
Provider/Center Claim

Utah - Child and Adult Care Food Program (CACFP)

This document describes the file layout for uploading CACFP Provider and Center claim records into the CNPweb Child Nutrition Management System. Each file will consist of a header to identify the claiming sponsor and a detail record for each provider and center reporting meals.

If you have technical questions regarding the file upload process, please contact the following:

Dynamic Internet Solutions

7155 West Campo Bello Dr. Bldg. C, Suite 125

Glendale, AZ 85308

Office - (623) 825-0795

Fax - (623) 825-0901

Steve Brooks –

The business rules governing the file layout are listed below:

File name format will be the program name followed by your sponsor number followed with a CSV extension. For example if you are uploading data for the Child and Adult Care Food Program, and your sponsor number is K096, the file name would be “CACFPK096.CSV”

The file type is ASCII text file.

Only original claims will be processed through the file upload system.

Any error that occurs during the file upload will abort the entire process.

All fields will be variable length comma delimited.

A terminator character will be included at the end of each record the terminator character chosen will be a Pipe Character |.

The Record ID for distinguishing a Provider Claim record is “P”, and the Record ID for distinguishing a Center claim record is “C”.

Each record should be on a separate text line.

The next set of requirement(s) apply to center claims only:

If you have already submitted your first claim with enrollment data then set the value of Fields 4 thru 6 to 0.

Enter only the total meals for each meal category in Fields 30 thru 35 of the Center record. After Program Year 2017, fields 9 through 26 (Free/Reduced/Paid meal counts) should be set to zero.

The next set of requirement(s) apply to provider claims only:

If you have already submitted your first claim with enrollment data then set the value of Fields 32and 33 to 0.

Enter only the total meals for each meal category in Fields 26 thru 31 of the provider record. After Program Year 2017, fields 8 through 25 (Tier specific meal counts) should be set to zero.

Batch Header Record (1 per file for identifying the sponsor)

Batch Header Record Layout

Field / Description / Max
Length / Data Type / Format / Default Value
1 / Record ID / 1 / Character / Uppercase / H
2 / Program ID / 5 / Character / Uppercase / CACFP
3 / Sponsor Number / 15 / Character / N/A / N/A
4 / Claim Period / 6 / Character / YYYYMM / N/A
5 / FDCH Monthly Expenses / 10,2 / Numeric / 99999999.99 / 0
6 / FDCH Admin Income / 10,2 / Numeric / 99999999.99 / 0
7 / Record Terminator / 1 / Character / N/A / |

Batch Detail Record (1 Per Center Per Program)

Batch Detail Center Record Layout

Field / Description / Max
Length / Data Type / Format / Default Value
1 / Record ID / 1 / Character / Uppercase / C
2 / Program Type (See Table 1 Below) / 3 / Character / Uppercase / N/A
3 / Site Number (Center) / 15 / Character / N/A / N/A
4 / Free Enrollment / 6 / Numeric / 999999 / 0
5 / Reduced Enrollment / 6 / Numeric / 999999 / 0
6 / Paid Enrollment / 6 / Numeric / 999999 / 0
7 / Number of Operating Days / 2 / Numeric / 99 / 0
8 / Total Monthly Attendance / 6 / Numeric / 999999 / 0
9 / Free Breakfast / 6 / Numeric / 999999 / 0
10 / Free AM Snack / 6 / Numeric / 999999 / 0
11 / Free Lunch / 6 / Numeric / 999999 / 0
12 / Free PM Snack / 6 / Numeric / 999999 / 0
13 / Free Supper / 6 / Numeric / 999999 / 0
14 / Free Evening Snack / 6 / Numeric / 999999 / 0
15 / Reduced Breakfast / 6 / Numeric / 999999 / 0
16 / Reduced AM Snack / 6 / Numeric / 999999 / 0
17 / Reduced Lunch / 6 / Numeric / 999999 / 0
18 / Reduced PM Snack / 6 / Numeric / 999999 / 0
19 / Reduced Supper / 6 / Numeric / 999999 / 0
20 / Reduced Evening Snack / 6 / Numeric / 999999 / 0
21 / Paid Breakfast / 6 / Numeric / 999999 / 0
22 / Paid AM Snack / 6 / Numeric / 999999 / 0
23 / Paid Lunch / 6 / Numeric / 999999 / 0
24 / Paid AM Snack / 6 / Numeric / 999999 / 0
25 / Paid Supper / 6 / Numeric / 999999 / 0
26 / Paid Evening Snack / 6 / Numeric / 999999 / 0
27 / Total Title XX Beneficiaries / 6 / Numeric / 999999 / 0
28 / Free/Reduced-Price Eligible Children / 6 / Numeric / 999999 / 0
29 / Current Enroll/Site Capacity / 6 / Numeric / 999999 / 0
30 / Total Breakfast / 6 / Numeric / 999999 / 0
31 / Total AM Snack / 6 / Numeric / 999999 / 0
32 / Total Lunch / 6 / Numeric / 999999 / 0
33 / Total PM Snack / 6 / Numeric / 999999 / 0
34 / Total Supper / 6 / Numeric / 999999 / 0
35 / Total Evening Snack / 6 / Numeric / 999999 / 0
36 / Record Terminator / 1 / Character / N/A / |
Table 1
Code / Program Type
CCC / Child Care Centers
OSHC / Outside School Hours
HS / Head Start
HLS / Homeless Shelters
At-Risk / At-Risk Snack
ADC / Adult Day Care

Batch Detail Record (1 Per Home Per Program)

Batch Detail Center Record Layout

Field / Description / Max
Length / Data Type / Format / Default Value
1 / Record ID / 1 / Character / Uppercase / P
2 / Program ID / 5 / Character / Uppercase / CACFP
3 / Provider Number / 15 / Character / Required
4 / Number of Operating Days / 2 / Numeric / 99 / 0
5 / Tier I Attendance / 6 / Numeric / 999999 / 0
6 / Tier II High Attendance / 6 / Numeric / 999999 / 0
7 / Tier II Low Attendance / 6 / Numeric / 999999 / 0
8 / Tier I Breakfast / 6 / Numeric / 999999 / 0
9 / Tier I AM Snack / 6 / Numeric / 999999 / 0
10 / Tier I Lunch / 6 / Numeric / 999999 / 0
11 / Tier I PM Snack / 6 / Numeric / 999999 / 0
12 / Tier I Supper / 6 / Numeric / 999999 / 0
13 / Tier I Evening Snack / 6 / Numeric / 999999 / 0
14 / Tier II High Breakfast / 6 / Numeric / 999999 / 0
15 / Tier II High AM Snack / 6 / Numeric / 999999 / 0
16 / Tier II High Lunch / 6 / Numeric / 999999 / 0
17 / Tier II High PM Snack / 6 / Numeric / 999999 / 0
18 / Tier II High Supper / 6 / Numeric / 999999 / 0
19 / Tier II High Evening Snack / 6 / Numeric / 999999 / 0
20 / Tier II Low Breakfast / 6 / Numeric / 999999 / 0
21 / Tier II Low AM Snack / 6 / Numeric / 999999 / 0
22 / Tier II Low Lunch / 6 / Numeric / 999999 / 0
23 / Tier II Low PM Snack / 6 / Numeric / 999999 / 0
24 / Tier II Low Supper / 6 / Numeric / 999999 / 0
25 / Tier II Low Evening Snack / 6 / Numeric / 999999 / 0
26 / Total Breakfast / 6 / Numeric / 999999 / 0
27 / Total AM Snack / 6 / Numeric / 999999 / 0
28 / Total Lunch / 6 / Numeric / 999999 / 0
29 / Total PM Snack / 6 / Numeric / 999999 / 0
30 / Total Supper / 6 / Numeric / 999999 / 0
31 / Total Evening Snack / 6 / Numeric / 999999 / 0
32 / TierIILoEnrollment (Daily) / 6 / Numeric / 999999 / 0
33 / TierIIHiEnrollment(Daily) / 6 / Numeric / 999999 / 0
34 / Record Terminator / 1 / Character / N/A / |
Last Updated - 9/5/2017 2:41:00 PM / - 1 -