Pre-K Followup

Field #	Field Name	eSchoolPLUS table.column	Required?	Field Length	Validation Table	Notes
1	Student Id	reg_personal.state_report_id	M	9
2	SAP Id	reg.student_id	O	50
3	Legal Last Name	Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name	M	30
4	Legal First Name	Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name	M	30
5	Birth Date	reg.birthdate	M	10		Format mm/dd/yyyy
6	RCDTS for Home School	reg.alt_building - state_code_equiv (program tracked ILALT)	M	15		Note: default to the Serving School if none entered If no alt building – use Entry/With building… If anything for timeframe in Programs – RCDTS Overrides for Home School – this will override both Alt and E/W Building
7	RCDTS for Serving School	reg_entry_with.building – converted reg_building.state_code_equiv	M	15		If anything for timeframe in Programs – RCDTS Overrides for Serving School – this will override Entry/Withdrawal Building
8	Grade Level	Il_v_pk_followup.grade_level If blank – will use the converted Entry/Withdrawal grade level	M	2		Convert K = 15; 1 = 01; 2=02;
9	School Year	Prompted school year (only include records where il_v_pk_followup.school_year = prompted school year)	M	4		Set to Prompted School Year
10	Reading Activities	Il_v_pk_followup.reading_activity	M	2	Iltb_pk_activities	Default to 05 if blank (unknown)
11	Mathematics Activities	Il_v_pk_followup.math_activity	M	2		Default to 05 if blank (unknown)
12	Language Activities	Il_v_pk_followup.lang_activity	M	2		Default to 05 if blank (unknown)