RSSP (Regional Safe School)
| 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 | reg.last_name | M | 30 | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Last Name field | |
| 4 | Legal First Name | reg.first_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 | Reason for Referral | reg_programs.program_value where field_number = 1 and reg_program_column.state_code_equiv = ILREFERRAL | M | 2 | iltb_rssp_referral | Registration > Entry & Reports > Student District Defined > ISBE RSSP: Reason for Referral field For the reference table, refer to Administration > General Setup > District > Validation Tables > for Applications prompt, select Illinois State Reporting > for Validation Table prompt, select RSSP Referral |
| 9 | Eligibility Status | reg_programs.program_value where field_number = 2 and reg_program_column.state_code_equiv = ILRSSPSTAT | M | 2 | iltb_rssp_status | Registration > Entry & Reports > Student District Defined > ISBE RSSP: Eligibility Status field For the reference table, refer to Administration > General Setup > District > Validation Tables > for Applications prompt, select Illinois State Reporting > for Validation Table prompt, select RSSP Eligibility |
| 10 | GED Instruction | reg_programs.program_value where field_number = 3 and reg_program_column.state_code_equiv = ILGEDINST | M | 2 | Registration > Entry & Reports > Student District Defined > ISBE RSSP: GED Instruction field | |
| 11 | Tutoring | reg_programs.program_value where field_number = 4 and reg_program_column.state_code_equiv = ILTUTOR | M | 2 | Registration > Entry & Reports > Student District Defined > ISBE RSSP: Tutoring field | |
| 12 | GED Test Complete | reg_programs.program_value where field_number = 5 and reg_program_column.state_code_equiv = ILGEDTEST | M | 2 | Registration > Entry & Reports > Student District Defined > ISBE RSSP: GED Test Complete field | |
| 13 | Curriculum Employment | reg_programs.program_value where field_number = 6 and reg_program_column.state_code_equiv = ILCURREMPL | M | 2 | Registration > Entry & Reports > Student District Defined > ISBE RSSP: Curriculum Employment field | |
| 14 | Date of AEP | reg_programs.program_value where field_number = 7 and reg_program_column.state_code_equiv = ILDATEAEP | M | 10 | Registration > Entry & Reports > Student District Defined > ISBE RSSP: Date of AEP field | |
| 15 | Behavior Mod Training | reg_programs.program_value where field_number = 8 and reg_program_column.state_code_equiv = ILMODTRAIN | M | 2 | Registration > Entry & Reports > Student District Defined > ISBE RSSP: Behavior Mod Training field | |
| 16 | Community Participation | reg_programs.program_value where field_number = 9 and reg_program_column.state_code_equiv = ILCOMMPART | M | 2 | Registration > Entry & Reports > Student District Defined > ISBE RSSP: Community Participation field | |
| 17 | Ind or Group Counseling | reg_programs.program_value where field_number = 10 and reg_program_column.state_code_equiv = ILRSSPCOUN | M | 2 | Registration > Entry & Reports > Student District Defined > ISBE RSSP: Ind or Group Counseling field | |
| 18 | Life Skill Training | reg_programs.program_value where field_number = 11 and reg_program_column.state_code_equiv = ILRSSPLS | M | 2 | Registration > Entry & Reports > Student District Defined > ISBE RSSP: Life Skill Training field | |
| 19 | Mentoring | reg_programs.program_value where field_number = 12 and reg_program_column.state_code_equiv = ILMENTOR | M | 2 | Registration > Entry & Reports > Student District Defined > ISBE RSSP: Mentoring field | |
| 20 | Parenting Classes | reg_programs.program_value where field_number = 13 and reg_program_column.state_code_equiv = ILPARENTS | M | 2 | Registration > Entry & Reports > Student District Defined > ISBE RSSP: Parenting Classes field | |
| 21 | Ref. to Social Services | reg_programs.program_value where field_number = 14 and reg_program_column.state_code_equiv = ILRSSPSS | M | 2 | Registration > Entry & Reports > Student District Defined > ISBE RSSP: Ref. to Social Services field | |
| 22 | School Work | reg_programs.program_value where field_number = 15 and reg_program_column.state_code_equiv = ILRSSPSW | M | 2 | Registration > Entry & Reports > Student District Defined > ISBE RSSP: School Work field | |
| 23 | School Year | Fiscal Year from Download ISBE Submission Files prompts | M | 4 | Regulatory > ISBE > ISBE > IL Download ISBE Submission Files: Fiscal Year prompt |