Service Provider
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:
| |
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:
| |
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 |