Early Childhood

Field #	Field Name	eSchoolPLUS table.column	Required?	Field Length	Validation Table	Notes
1	SID	reg_personal.state_report_id	M	9
2	SAP Id	reg.student_id	O	50
3	Legal Last Name	Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name	M	30
4	Legal First Name	Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name	M	30
5	Birth Date	reg.birthdate	M	10		Format mm/dd/yyyy
6	RCDTS for Home School	reg.alt_building - state_code_equiv (program tracked ILALT)	M	15		If no alternate building – uses Entry/Withdrawal building… If anything for timeframe in Programs – RCDTS Overrides for Home School – this will override both Alternate and Building
7	RCDTS for Serving School	Reg_entry_with.building converted using reg_building - state_code_equiv	M	15		If anything for timeframe in Programs – RCDTS Overrides for Serving School – this will override Entry/Withdrawal Building
8	Classroom Location	reg_programs.program_value where program_id = CHILD and field_number maps to reg_program_column with state_code_equiv = ILLEARNENV	M	2	iltb_learning_environment
9	Preschool for All Classroom	Reg_user where screen_number = 920 and field_number = 2	M	2	ILTB_PRE_ALL
10	IDEA Services Received	reg_programs.program_value where program_id = CHILD and field_number maps to reg_program_column with state_code_equiv = ILIDEASERV	M	2	iltb_idea_services
11	In Classroom IDEA	reg_programs.program_value where program_id = CHILD and field_number maps to reg_program_column with state_code_equiv = ILINCIEP	M	2
12	Preschool for All Expansion	reg_programs.program_value where program_id = CHILD and field_number maps to reg_program_column with state_code_equiv = ILPRESCHEX	M	2	iltb_preschool_expansion
13	Head Start	Reg_user where screen_number = 920 and field_number = 3	M	2		01 = Yes 02 = No
14	CPS Value Preschool	reg_programs.program_value where program_id = CHILD and field_number maps to reg_program_column with state_code_equiv = ILCPSPRESC	O	2
15	Pre-K Title 1	Reg_user where screen_number = 920 and field_number = 4	M	2		01 = Yes 02 = No
16	IDEA Funding	reg_programs.program_value where program_id = FUND and field_number maps to reg_program_column with state_code_equiv = ILPRSCHFUN	M	2	iltb_preschool_funding
17	Local/Other	Reg_user where screen_number = 920 and field_number = 5	M	2		01 = Yes 02 = No
18	Tuition Based Funding	reg_programs.program_value where program_id = FUND and field_number maps to reg_program_column with state_code_equiv = ILTUITFUND	M	2	iltb_preschool_funding
19	Previous Enrollment in an Early Childhood Program	reg_programs.program_value where program_id = CHILD and field_number maps to reg_program_column with state_code_equiv = ILPASTCHEN	M	2
20	Early Head Start(Birth to 3)	Reg_user where screen_number = 920 and field_number = 6	M	2
21	Prevention Initiative(Birth to 3)	Reg_user where screen_number = 920 and field_number = 7	M	2		01=Yes 02=No (default to 02)
22	(Birth to 3) Early Intervention (Infants and Toddlers with disabilities (DHS)	Reg_user where screen_number = 920 and field_number = 8	M	2		Checkbox – convert to 01/02 in file creation 01=Yes 02=No (default to 02)
23	Child Care	reg_programs.program_value where program_id = CHILD and field_number maps to reg_program_column with state_code_equiv = ILCHILDCARE	M	2
24	Referral By CFC	Reg_user where screen_number = 920 and field_number = 9	Valid only when Early Intervention = 01	2		Checkbox – convert to 01/02 in file creation 01=Yes 02=No (default to 02) Required if Early Intervention and Referral by CFC = Yes (01) Mandatory if Early Intervention is 'Yes'
25	EI Number	Reg_user where screen_number = 920 and field_number = 10	Valid only when Early Intervention and Referral by CFC = 01	6		Alpha/Numeric – must be exactly 6 digits if entered. Required if Early Intervention and Referral by CFC = Yes (01) Mandatory If Early Intervention and Referral by CFC is 'Yes'
26	Eligibility Determination Date	Reg_user where screen_number = 920 and field_number = 11	Valid only when Early Intervention and Referral by CFC = 01	10		Format mm/dd/yyyy Mandatory If Early Intervention and Referral by CFC is 'Yes'
27	Reason for Delay in transition	Reg_user where screen_number = 920 and field_number = 12	Valid only when Early Intervention and Referral by CFC = 01	2	ILTB_DEL_REASON	Mandatory If Early Intervention and Referral by CFC is 'Yes'
28	IEP Completion Date	Reg_user where screen_number = 920 and field_number = 13	Valid only when Early Intervention, Referral by CFC, and IDEA Services Received = 01	10		Format mm/dd/yyyy. This may change to a program tracked vector. Mandatory If Early Intervention, Referral by CFC and IEP Indicator is 'Yes'
29	Date Services Began	Reg_user where screen_number = 920 and field_number = 14	Valid only when Early Intervention, Referral by CFC, and IDEA Services Received = 01	10	IEP indicator is program tracked vector. (reg_user where screen_number = 900 and field_number = 4)	Format mm/dd/yyyy. Mandatory If Early Intervention, Referral by CFC and IEP Indicator is 'Yes'
30	Meets at Risk Criteria	Reg_user where screen_number = 920 and field_number = 15	M	2		Checkbox – convert to 01/02 in file creation 01=Yes 02=No (default to 02)
31	Family Structure	Reg_user where screen_number = 920 and field_number = 17	M	2	ILTB_FAMILY_STRUCT
32	Meets PFA Household Income Criteria for EC Programs	Reg_user where screen_number = 920 and field_number = 16	M	2		Checkbox – convert to 01/02 in file creation 01=Yes 02=No (default to 02)
33	Child Welfare Involvement within the Past Year	reg_programs.program_value where program_id = FUND and field_number maps to reg_program_column with state_code_equiv = ILWELFSERV	M	2
34	Child has been a Youth in Care	reg_programs.program_value where program_id = FUND and field_number maps to reg_program_column with state_code_equiv = ILSTUYCARE	M	2
35	Family has an Open Intact Family Services Case	reg_programs.program_value where program_id = FUND and field_number maps to reg_program_column with state_code_equiv = ILSERVCASE	M	2
36	Child's Parent is a Youth in Care	reg_programs.program_value where program_id = FUND and field_number maps to reg_program_column with state_code_equiv = ILPRNTCARE	M	2
37	Student's Family is Receiving TANF	reg_user.field_value where screen_number = 920 and field_number = 32	M	2
38	Student's Family is Receiving WIC	reg_user.field_value where screen_number = 920 and field_number = 33	M	2
39	Student's Family is Receiving SNAP	reg_user.field_value where screen_number = 920 and field_number = 34	M	2
40	Student's Family is Receiving Housing Subsidy	reg_user.field_value where screen_number = 920 and field_number = 35	M	2