Student Participant Demographic

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 field
2	SAP ID	reg.student_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 > 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 > 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 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	Caregiver SID	reg_user.field_value where screen_number = 1005 and field_number = 1	O	9		Registration > Entry & Reports > Student District Defined: Caregiver SID field
9	Caregiver Last Name	reg_user.field_value where screen_number = 1005 and field_number = 2	O	30		Registration > Entry & Reports > Student District Defined: Caregiver Last Name field
10	Caregiver First Name	reg_user.field_value where screen_number = 1005 and field_number = 3	O	30		Registration > Entry & Reports > Student District Defined: Caregiver First Name field
11	Birth Date of Caregiver	reg_user.field_value where screen_number = 1005 and field_number = 4	M	10		Registration > Entry & Reports > Student District Defined: Caregiver Birthdate field
12	Caregiver's Relationship to Child	reg_user.field_value where screen_number = 1005 and field_number = 5	M	2	iltb_care_relation	Registration > Entry & Reports > Student District Defined: Relationship to Child field
13	Caregiver's Race	reg_user.field_value where screen_number = 1005 and field_number = 6	M	2	regtb_ethnicity	Registration > Entry & Reports > Student District Defined: Caregiver Race field
14	Educational Background of Caregiver	reg_user.field_value where screen_number = 1005 and field_number = 7	M	2	iltb_care_edustatus	Registration > Entry & Reports > Student District Defined: Educational Background field
15	Current Employment Status of Caregiver	reg_user.field_value where screen_number = 1005 and field_number = 8	M	2	iltb_care_empstatus	Registration > Entry & Reports > Student District Defined: Employment Status field