Homeless

Field #	Field Name	eSchoolPLUS table.column	Required?	Field Length	Validation Table	Notes
1	Student ID	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 Home School	reg.alt_building - state_code_equiv (program tracked ILALT)	M	15		Note: default to the Serving School if none entered If no alt building – use Entry/With building… If anything for timeframe in Programs – RCDTS Overrides for Home School – this will override both Alt and E/W Building
7	RCDTS Serving School	reg_entry_with.building – converted 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	Unaccompanied Youth Status	reg_programs.program_value where state_code_equiv = ILYOUTH	M	2
9	Primary Nighttime Residence	reg_programs.program_value where state_code_equiv = ILNIGHT	M	2	Iltb_nightres
10	Tutoring and Other Instructional Support	reg_programs.program_value where state_code_equiv = ILTUTINS	M	2
11	Expedited Evaluations	reg_programs.program_value where state_code_equiv = ILEXPEVAL	M	2
12	Staff Professionals Development and Awareness	reg_programs.program_value where state_code_equiv = ILPROSTAFF	M	2
13	Referrals for Medical, Dental, and other Health Services	reg_programs.program_value where state_code_equiv = ILREFM	M	2
14	Early Childhood Programs	reg_programs.program_value where state_code_equiv = ILECHILD	M	2
15	Assistance with Participation in School Programs	reg_programs.program_value where state_code_equiv = ILASSP	M	2
16	Before-School, After-School, Mentoring, Summer Programs	reg_programs.program_value where state_code_equiv = ILSUMP	M	2
17	Obtaining or Transferring Records Necessary for Enrollment	reg_programs.program_value where state_code_equiv = ILOBTM	M	2
18	Parent Education Related to Rights and Resources for Children	reg_programs.program_value where state_code_equiv = ILPAEDN	M	2
19	Coordination between Schools and Agencies	reg_programs.program_value where state_code_equiv = ICOSCH	M	2
20	Counseling	reg_programs.program_value where state_code_equiv = ILCOUNSEL	M	2
21	Addressing Needs Related to Domestic Violence	reg_programs.program_value where state_code_equiv = ILADDNS	M	2
22	Clothing to Meet a School Requirement	reg_programs.program_value where state_code_equiv = ILCLNDS	M	2
23	School Supplies	reg_programs.program_value where state_code_equiv = ILSCHSU	M	2
24	Referral to Other Programs and Services	reg_programs.program_value where state_code_equiv = ILREFOT	M	2
25	Emergency Assistance Related to School Attendance	reg_programs.program_value where state_code_equiv = ILEMRASS	M	2
26	Other (Services and Activities Provided by the McKinney-Vento Subgrant Program)	reg_programs.program_value where state_code_equiv = ILOTHSERV	M	2
27	Eligibility for Homeless Services	reg_programs.program_value where state_code_equiv = ILELLHM	M	2
28	School Selection	reg_programs.program_value where state_code_equiv = ILSCHSEL	M	2
29	Transportation	reg_programs.program_value where state_code_equiv = ILTRANS	M	2
30	School Records	reg_programs.program_value where state_code_equiv = ILSCHREC	M	2
31	Immunizations or Other Medical Records	reg_programs.program_value where state_code_equiv = ILIMOTH	M	2
32	Other (Barriers to the Education of Homeless Children and Youths)	reg_programs.program_value where state_code_equiv = ILOTHBA	M	2