Immigrant

Field #	Field Name	eSchoolPLUS table.column	Required?	Field Length	Validation Table	Where in eSchoolPlus?
1	Student ID	reg.student_id	M	9		Registration > Entry & Reports > Student Demographic > Personal > General panel: State ID field
2	SAP ID	reg_personal.state_report_id	O	50		Registration > Entry & Reports > Student Demographic > Registration > Student Information bar: ID field
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 field Registration > Entry & Reports > Student Demographic > Registration > Student panel: Last Name field
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 field Registration > Entry & Reports > Student Demographic > Registration > Student panel: First Name field
5	Birth Date	reg.birthdate	M	10		Registration > Entry & Reports > Student Demographic > Registration > Student panel: Birth Date field
6	RCDTS Home School	If student has an override, use reg_building.state_code_equiv where building equals reg_programs.program_value for program_id with reg_program_column.state_code_equiv = H_RCDTS Otherwise, use reg_building.state_code_equiv where building equals reg_programs.program_value for program_id with reg_program_column.state_code_equiv = ILALT. This is the same reg_building.state_code_equiv for the building stored in reg.alt_building. If there is no alternate building use reg_entry_with.building and map to the reg_building.state_code_equiv	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 Serving School	If student has an override, use reg_building.state_code_equiv where building equals reg_programs.program_value for program_id with reg_program_column.state_code_equiv = S_RCDTS Otherwise, use reg_entry_with.building and map to the reg_building.state_code_equiv	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	Country of Birth	reg_personal.birth_country converted to regtb_country.state_code_equiv	M	4	regtb_country	Registration > Entry & Reports > Student Demographic > Personal > General panel: Country of Birth field Administration > General Setup > District > Validation Tables > For Applications prompt, select Registration > For Validation Table prompt, select Countries: State Code Equiv field
9	First Date of Entry into a US School	reg.us_enroll_date	M	10		Registration > Entry & Reports > Student Demographic > Registration > Other Enrollment panel: US Enrollment Date field