Birth to 3

Field #	Field Name	eSchoolPLUS table.column	Required?	Field Length	Validation Table	Where in eSchoolPlus?
1	Student ID	reg_personal.state_report_id	M	9		Registration > Entry & Reports > Student Demographic > Personal > General panel: State ID
2	SAP ID	reg.student_id	O	50		Registration > Entry & Reports > Student Demographic > Registration > Student Information bar: ID
3	Legal Last Name	Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name	M	30		Registration > Entry & Reports > Student Demographic > Personal > Legal/Birth Information panel: Last Name Registration > Entry & Reports > Student Demographic > Registration > Student panel: Last Name
4	Legal First Name	Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name	M	30		Registration > Entry & Reports > Student Demographic > Personal > Legal/Birth Information panel: First Name Registration > Entry & Reports > Student Demographic > Registration > Student panel: First Name
5	Birth Date	reg.birthdate	M	10		Registration > Entry & Reports > Student Demographic > Registration > Student panel: Birth Date
6	RCDTS for Home School	reg_building.state_code_equiv for reg_programs.program_value where program_id = reg_program_column.program_id for state_code_equiv = H_RCDTS Or, reg_building.state_code_equiv for reg.alt_building Or, reg_building.state_code_equiv for reg_entry_with.building	M	15		The download goes through these steps: It checks to see if the student has an active program vector as of the Reporting Date for Home School RCDTS Override (Registration > Entry & Reports > Student Demographic > Programs > click link for RCDTS - RCDTS Overrides). If there is no active vector for this program, the download checks whether the student has an active Alternate Building program vector (Registration > Entry & Reports > Student Demographic > Registration > Other Enrollment panel: Alternate Building field). If there is also no Alternate Building, use the student’s Entry/Withdrawal Building (Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Building).
7	RCDTS for Serving School	reg_building.state_code_equiv for reg_programs.program_value where program_id = reg_program_column.program_id for state_code_equiv = S_RCDTS Or, reg_building.state_code_equiv for reg_entry_with.building	M	15		The download goes through these steps: It checks to see if the student has an active program vector as of the Reporting Date for Serving School RCDTS Override (Registration > Entry & Reports > Student Demographic > Programs > click link for RCDTS - RCDTS Overrides). If there is no active vector for this program, use the student’s Entry/Withdrawal Building (Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Building).
8	EI Number	reg_user.field_value where screen_number = 920 and field_number = 10	O	6		Registration > Entry & Reports > Student District Defined > ISBE Early Childhood: EI Number
9	Program Model	reg_user.field_value where screen_number = 995 and field_number = 1	M	2	iltb_programmodel	Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Program Model
10	Service Location (Modality) for Prevention Initiative Programs	reg_user.field_value where screen_number = 995 and field_number = 2	M	2	iltb_srvcloc	Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Birth to 3 Classroom
11	Screening for Eligibility Tool	reg_user.field_value where screen_number = 995 and field_number = 3	M	2	iltb_screenelig	Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Screening for Eligibility Tool
12	Total Number of Home Visits During the Year	reg_user.field_value where screen_number = 995 and field_number = 4	M	Num		Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Tot Home Visits During Year
13	Total Number of Parent Groups/Sessions Attended During the Year	reg_user.field_value where screen_number = 995 and field_number = 5	M	Num		Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Tot Parnt Grps-Sess Att Year
14	Total Number of Hours Student Spent in DCFS Licensed Child Care Center	reg_user.field_value where screen_number = 995 and field_number = 6	M	Num		Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Tot Hours in Child Care Center
15	Student Born with a Low Birth Weight	reg_user.field_value where screen_number = 995 and field_number = 7	M	2		Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Stu Born with Low Birth Weight
16	Is Student a Youth in Care	reg_user.field_value where screen_number = 995 and field_number = 8	M	2		Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Is Student a Youth in Care
17	Was Parent Married at Time of Student's Birth	reg_user.field_value where screen_number = 995 and field_number = 9	O	2		Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Parent Married at Stu's Birth
18	Biological Mother's Date of Birth	reg_user.field_value where screen_number = 995 and field_number = 10	O	10		Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Bio Mother's Date of Birth
19	Student's Family is Receiving Child Support	reg_user.field_value where screen_number = 995 and field_number = 11	M	2		Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Stu's Family Recv Child Supp
20	Student's Family is Receiving TANF	reg_user.field_value where screen_number = 995 and field_number = 12	M	2		Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Student Family Receives TANF
21	Student's Family is Receiving WIC	reg_user.field_value where screen_number = 995 and field_number = 13	M	2		Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Student Family Receives WIC
22	Student's Family is Receiving SNAP	reg_user.field_value where screen_number = 995 and field_number = 14	M	2		Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Student Family Receives SNAP
23	Student's Family is Receiving Housing Subsidy	reg_user.field_value where screen_number = 995 and field_number = 15	M	2		Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Student Family Recv Hous Sub
24	Household Income Criteria	reg_user.field_value where screen_number = 995 and field_number = 16	M	2	iltb_household_income_criteria	Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Household Income Criteria
25	Screening for Social and Emotional Development	reg_user.field_value where screen_number = 995 and field_number = 17	M	2	iltb_social_emotional_dev	Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Screening Social Emotional Dev
26	Child Welfare					Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Child Welfare
27	Child of Teen Parents					Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Child of Teen Parents
28	Number of Months Child was Breastfed					Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: No Months Child was Breastfed
29	Preterm Birth (before 37 weeks)					Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Preterm Birth (before 37 weeks)
30	Total Number of Hours Student Spent in DCFS					Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Tot no Hrs Stu spent in DCFS
31	Family Structure					Registration > Entry & Reports > Student District Defined > ISBE Birth to 3: Family Structure