Exit Enrollment
Field # | Field Name | eSchoolPLUS table.column | Required? | Field Length | Validation Table | Where in eSchoolPlus? | Notes |
---|---|---|---|---|---|---|---|
1 | Student Id | reg_personal.state_report_id | |||||
2 | SAP Id | reg.student_id | |||||
3 | Legal Last Name | Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name | |||||
4 | Legal First Name | Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name | |||||
5 | Birth Date | reg.birthdate | |||||
6 | RCDTS for Home School | reg.alt_building - state_code_equiv (program tracked ILALT) | If no alternate building – uses Entry/Withdrawal building… If anything for timeframe in Programs – RCDTS Overrides for Home School – this will override both Alternate and Building | ||||
7 | RCDTS for Serving School | reg.building converted (state_code_equiv) | If anything for timeframe in Programs – RCDTS Overrides for Serving School – this will override Entry/Withdrawal Building | ||||
8 | Placeholder | N/A | |||||
9 | Placeholder | N/A | |||||
10 | Placeholder | N/A | |||||
11 | Enrollment Exit Date | reg_entry_with.withdrawal_date | Formatted MM/DD/YYYY Important: To be included in the Exit Enrollment file, the student needs a Withdrawal Date meeting the parameter you select in the download page Include Withdrawn Students prompt. | ||||
12 | Enrollment Exit Status | reg_entry_with.withdrawal_code using dropout_code | regtb_withdrawal | If the dropout_code is set to 'Y' for that code, then set to 01=Permanent; otherwise set to 02 (Temporary) | |||
13 | Enrollment Exit / Withdrawal Type | reg_entry_with.withdrawal code converted using state_code_equiv | regtb_withdrawal | If the withdrawal code does not convert - then it will not be included. | |||
14 | Result Code | ||||||
15 | Result Message |