ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Position From
Position To
Description
2
13Enter numeric 615 all the time
3
49Sequential Record Number (1, 2, 3, etc.)
4
1017claim.create_time in MMDDYY format
5
1823contents of sponsor_identification_number before the comma
6
2487Sponsor Legal Name
7
8892contents of sponsor_identification_number after the comma
8
9394claim_date in MM format
9
9598claim_date in YYYY format
10
99162Site Name (not site legal name)
11
163178facility license number for license valid for claim month
12
179190site_identification_number
13
191206food_contracting_entity_id
14
207213if claim.tier_status = tier I, then participant_tier_i_count, else blank
15
214220if claim.tier_status is not tier I, then participant_tier_i_count, else blank
16
221227if claim.tier_status is not tier I, then participant_tier_ii_count, else blank
17
228234if claim.tier_status = tier I, then days_open, else blank
18
235241if claim.tier_status is not tier I AND participant_tier_i_count >0, then days_open, else blank
19
242248if claim.tier_status is not tier I AND participant_tier_ii_count>0, then days_open, else blank
20
249255if claim.tier_status = tier I, then average_daily_attendance, else blank
21
256262
if claim.tier_status is not tier I AND participant_tier_i_count >0, then [total_attendance_tier_i divided by days_open], else blank
22
263269
if claim.tier_status is not tier I AND participant_tier_ii_count>0, then [total_attendance_tier_ii divided by days_open], else blank
23
270276if claim.tier_status = tier I, then tier_i_count_breakfast, else blank
24
277283if claim.tier_status is not tier I AND participant_tier_i_count >0, then tier_i_count_breakfast, else blank
25
284290if claim.tier_status is not tier I AND participant_tier_ii_count>0, then tier_ii_count_breakfast, else blank
26
291297if claim.tier_status = tier I, then tier_i_count_amsnack, else blank
27
298304if claim.tier_status is not tier I AND participant_tier_i_count >0, then tier_i_count_amsnack, else blank
28
305311if claim.tier_status is not tier I AND participant_tier_ii_count>0, then tier_ii_count_amsnack, else blank
29
312318if claim.tier_status = tier I, then tier_i_count_lunch, else blank
30
319325if claim.tier_status is not tier I AND participant_tier_i_count >0, then tier_i_count_lunch, else blank
31
326332if claim.tier_status is not tier I AND participant_tier_ii_count>0, then tier_ii_count_lunch, else blank
32
333339if claim.tier_status = tier I, then tier_i_count_pmsnack, else blank
33
340346if claim.tier_status is not tier I AND participant_tier_i_count >0, then tier_i_count_pmsnack, else blank
34
347353if claim.tier_status is not tier I AND participant_tier_ii_count>0, then tier_ii_count_pmsnack, else blank
35
354360if claim.tier_status = tier I, then tier_i_count_supper, else blank
36
361367if claim.tier_status is not tier I AND participant_tier_i_count >0, then tier_i_count_supper, else blank
37
368374if claim.tier_status is not tier I AND participant_tier_ii_count>0, then tier_ii_count_supper, else blank
38
375381if claim.tier_status = tier I, then tier_i_count_evesnack, else blank
39
382388if claim.tier_status is not tier I AND participant_tier_i_count >0, then tier_i_count_evesnack, else blank
40
389395if claim.tier_status is not tier I AND participant_tier_ii_count>0, then tier_ii_count_evesnack, else blank
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100