Adjusted Cohort Year (9-12)

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 > Personal > Legal/Birth Information panel: Last Name field 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 > Personal > Legal/Birth Information panel: First Name field 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	1st School Year in 9th Grade	First, use reg_academic.federal_grad_year If this is blank, use reg_academic.graduation_year and subtract 3 (For example, 2018 becomes 2015).	M	4		Registration > Entry & Reports > Student Demographic > Academic > Graduation panel: Adjusted Cohort Year (9-12) field Registration > Entry & Reports > Student Demographic > Academic > Graduation panel: Graduation Year field
9	Enrollment Exit Type	Convert reg_entry_with.withdrawal_code into regtb_withdrawal.state_code_equiv	M	2	regtb_withdrawal	Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Withdrawal Code field Administration > General Setup > District > Validation Tables > for Applications prompt, select Registration > for Validation Table prompt, select Withdrawals: State Code Equiv field