Service Provider

Field #	Field Name	eSchoolPLUS table.column	Required?	Field Length	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	Service Provider RCDTS	reg_building.state_code_equiv for reg_programs.program_value where program_id = reg_program_column.program_id for state_code_equiv = P_RCDTS	M	15	Registration > Entry & Reports > Student Demographic > Programs > click link for RCDTS - RCDTS Overrides: Service Provider RCDTS field