ID Family Child Care

	A	B	C	D	E	F	G	H	I
1	Field Seq.	Position From	Position To	Description	Field Size	Field Type	Required	Notes	CCG Comment
2	1	1	3	Upload Form ID	3	N(3,0)	Y	Value = 625 for every record
3	2	4	9	Serial Number	6	N(6,0)	Y	Sequential Record Number (1, 2, 3, etc.)
4	3	10	17	Process Date	8	N(8,0)	N	MMDDYYYY - Date the Sponsor processed the data. This is for informational purposes only for the sponsor and is not used by the claim in TX-UNPS.	We don't do anything with this nor do we care about it.
5	4	18	23	Vendor Number	6	C(6)	N	Sponsor Vendor Number Example (B26600), Do not include dashes. Leave Blank
6	5	24	87	CE Name	64	C(64)	Y	Name of CE
7	6	88	92	CE ID Number	5	C(5)	Y	Unique TX-UNPS system generated sponsor number Do not include dashes; zero fill from left e.g. 01234
8	7	93	94	Claim Month	2	N(2,0)	Y	Enter the month the claim is being submitted for: Calendar month number (01, 02, …. 11, 12)
9	8	95	98	Claim Year	4	N(4,0)	Y	Enter the year the claim is being submitted for:
10	9	99	130	Provider First Name	32	C(32)	Y	First Name of Provider
11	10	131	162	Provider Last Name	32	C(32)	Y	Last Name of Provider
12	11	163	178	License Number	16	C(16)	N	Current License Number of the provider
13	12	179	190	Provider ID	12	N(12)	Y	Unique TX-UNPS system generated provider ID. This is the value displayed in the header above the provider’s name. Unique ID (for a given sponsor) that will be used as the provider record locator when importing the data. (Note: if the value cannot be found, the record will not be uploaded.)
14	13	191	206	Alternate Provider ID Not In Use for TDA	16	C(16)	N	Unique ID identifying the provider and will be used to identify the provider record in the system. This field will be used as the provider record locator when importing the data. Leave Blank
15	14	207	213	Number of Homes Participating Tier I	7	N(7,0)	N	If not claiming Tier I, leave blank
16	15	214	220	Number of Homes Participating Tier II High	7	N(7,0)	N	If not claiming Tier II High, leave blank
17	16	221	227	Number of Homes Participating Tier II Low	7	N(7,0)	N	If not claiming Tier II Low, leave blank
18	17	228	234	Number of Homes Participating Tier II Mix	7	N(7,0)	N	If not claiming Tier II Mix, leave blank
19	18	235	241	Number of Days Meals Served Tier I	7	N(7,0)	N	If not claiming Tier I, leave blank
20	19	242	248	Number of Days Meals Served Tier II High	7	N(7,0)	N	If not claiming Tier II High, leave blank
21	20	249	255	Number of Days Meals Served Tier II Low	7	N(7,0)	N	If not claiming Tier II Low, leave blank
22	21	256	262	Number of Days Meals Served Tier II Mix	7	N(7,0)	N	If not claiming Tier II Mix, leave blank
23	22	263	269	Average Daily Attendance Tier I	7	N(7,0)	N	If not claiming Tier I, leave blank
24	23	270	276	Average Daily Attendance Tier II High	7	N(7,0)	N	If not claiming Tier II High, leave blank
25	24	277	283	Average Daily Attendance Tier II Low	7	N(7,0)	N	If not claiming Tier II Low, leave blank
26	25	284	290	Average Daily Attendance Tier II Mix	7	N(7,0)	N	If not claiming Tier II Mix, leave blank
27	26	291	297	Breakfast Tier I Meals Served	7	N(7,0)	N	If not claiming Tier I, leave blank
28	27	298	304	Breakfast Tier II High Meals Served	7	N(7,0)	N	If not claiming Tier II High, leave blank
29	28	305	311	Breakfast Tier II Low Meals Served	7	N(7,0)	N	If not claiming Tier II Low, leave blank
30	29	312	318	AM Snack Tier I Meals Served	7	N(7,0)	N	If not claiming Tier I, leave blank
31	30	319	325	AM Snack Tier II High Meals Served	7	N(7,0)	N	If not claiming Tier II High, leave blank
32	31	326	332	AM Snack Tier II Low Meals Served	7	N(7,0)	N	If not claiming Tier II Low, leave blank
33	32	333	339	Lunch Tier I Meals Served	7	N(7,0)	N	If not claiming Tier I, leave blank
34	33	340	346	Lunch Tier II High Meals Served	7	N(7,0)	N	If not claiming Tier II High, leave blank
35	34	347	353	Lunch Tier II Low Meals Served	7	N(7,0)	N	If not claiming Tier II Low, leave blank
36	35	354	360	PM Snack Tier I Meals Served	7	N(7,0)	N	If not claiming Tier I, leave blank
37	36	361	367	PM Snack Tier II High Meals Served	7	N(7,0)	N	If not claiming Tier II High, leave blank
38	37	368	374	PM Snack Tier II Low Meals Served	7	N(7,0)	N	If not claiming Tier II Low, leave blank
39	38	375	381	Supper Tier I Meals Served	7	N(7,0)	N	If not claiming Tier I, leave blank
40	39	382	388	Supper Tier II High Meals Served	7	N(7,0)	N	If not claiming Tier II High, leave blank
41	40	389	395	Supper Tier II Low Meals Served	7	N(7,0)	N	If not claiming Tier II Low, leave blank
42	41	396	402	Evening Snack Tier I Meals Served	7	N(7,0)	N	If not claiming Tier I, leave blank
43	42	403	409	Evening Snack Tier II High Meals Served	7	N(7,0)	N	If not claiming Tier II High, leave blank
44	43	410	416	Evening Snack Tier II Low Meals Served	7	N(7,0)	N	If not claiming Tier II Low, leave blank
45	44	417	428	Total Administrative Costs	12	N(10,2)	N	This should be left blank.
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