Exit Enrollment

Field #	Field Name	eSchoolPLUS table.column	Validation Table	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