Demographic/Early Childhood
Field # | Field Name | eSchoolPLUS table.column | Required? | Field Length | Validation Table | Where in eSchoolPlus? | Notes |
---|---|---|---|---|---|---|---|
1 | SID | 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 | All special chars removed | ||||
4 | Legal First Name | Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name | All special chars removed | ||||
5 | Legal Middle Name | Use reg_legal_info.legal_middle_name if it has a value. If not, use reg.middle_name | * if blank All special chars removed | ||||
6 | Lineage (Suffix) | reg.generation converted using state_code_equiv | |||||
7 | Mother's Maiden Name | reg_personal.mother_maiden | All special chars removed | ||||
8 | Race | reg_personal.fed_race_ethic + 10 | |||||
9 | Gender | Use reg_legal_info.gender if it has a value. Otherwise, use reg.gender | |||||
10 | Birth Date | reg.birthdate | Formated mm/dd/yyyy | ||||
11 | Birth Place | reg_personal.birth_city + birth_state OR reg_personal.birth_city + birth_country | The city space state OR The city space country | ||||
12 | Reading First Indicator | reg_user - screen 900 - field 8 (Program tracked ILREAD) (il_v_stu_demo.reading_first) | 01 = Yes, 02 = No (defaults to 02) | ||||
13 | Reading Improvement Block Grant Indicator | reg_user - screen 900 - field 9 (Program tracked ILREADBL) (il_v_stu_demo.reading_grant) | 01 = Yes, 02 = No (defaults to 02) | ||||
14 | Title I Indicator | reg_user - screen 900 - field 10 (Program tracked ILTITLE) (il_v_stu_demo.title_1) | 01 = Yes, 02 = No (defaults to 02) | ||||
15 | Eligible for Immigrant Education Program | reg_programs where program_id=’ELL’ and field_number=’3’, state_code_equiv=’IMMED’ | Registration > Entry & Reports > Student District-Defined > ISBE ELL and ELL Screener: Immigrant Education Program field | ||||
16 | Home Language | reg.language (converted to regtb_language.state_code_equiv) | |||||
17 | Native Language | Reg.native_language (converted to regtb_language.state_code_equiv) | Regtb_language | ||||
18 | Homeless Indicator | reg_personal.homeless_status (converted to regtb_homeless.state_code_equiv) | |||||
19 | Migrant Indicator | reg_personal.migrant (Program tracked ILMIG) | 01 = Yes, 02 = No (defaults to 02) | ||||
20 | Private School Student | reg_programs.program_value where program_id = PSS and field_number maps to reg_program_column with state_code_equiv = ILPSS | |||||
21 | Military Connected Student | System-calculated based on reg_programs.program_value where program_id = MLTRY and field_number maps to reg_program_column with state code equiv = ILPARARMED Or, reg_programs.program_value where program_id = MLTRY and field_number maps to reg_program_column with state_code_equiv = ILPARACTIV | |||||
22 | SES Indicator | reg_user - screen 900 - field 3 (Program tracked ILSES) (il_v_stu_demo.ses) | 01 = Yes, 02 = No (defaults to 02) | ||||
23 | LEP Indicator | reg_user - screen 900 - field 1 (Program tracked ILLEP) (il_v_stu_demo.lep) | 01 = Yes, 02 = No (defaults to 02) | ||||
24 | IDEA Services | reg_user - screen 900 - field 4 (program tracked ILIEP) (il_v_stu_demo.iep) | |||||
25 | Dual Language | reg_programs.program_value converted to iltb_dual_language.state_code_equiv where program_id = ELL and field_number = 21 | iltb_dual_language | Registration > Entry & Reports > Student District Defined > ISBE EL with ELL Screener: Dual Language | Default 03 - Not a Participant in Dual Language Program | ||
26 | Language of Instruction | reg_programs.program_value converted to regtb_language.state_code_equiv where program_id = ELL and field_number = 22 | regtb_language | Registration > Entry & Reports > Student District Defined > ISBE EL with ELL Screener: Language of Instruction | Required if Dual Language = 01 This field is ignored if Dual Language = 03 | ||
27 | FRL/Low Income | reg_programs - (converted to state code equiv) (Program Tracked ILFRL) | |||||
28 | Century 21 Indicator | reg_user - screen 900 - field 6 (il_v_stu_demo.century21) | 01 = Yes, 02 = No (Defaults to 02) | ||||
29 | Enrollment/Entry Type | reg_entry_with.entry_code - converted to state code equiv | First attendance code for current year (for current building) | ||||
30 | Enrollment/Entry Date | reg_entry_with.entry_date | First date of attendance for current year MM/DD/YYYY | ||||
31 | 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 | ||||
32 | RCDTS for Serving School | Reg_entry_with.building converted using reg_building - state_code_equiv | If anything for timeframe in Programs – RCDTS Overrides for Serving School – this will override Entry/Withdrawal Building | ||||
33 | Entry / Grade Level | reg_entry_with.grade | |||||
34 | School Year | prompted school year | |||||
35 | FTE | reg_user - screen 900 - field 7 (Program Tracked) (il_v_stu_demo.fte) | Defaults to 1.00 if blank | ||||
36 | Tuition-In Indicator | reg_programs.program_value where program_id = TUIT and field_number = 1 | Registration > Entry & Reports > Student District Defined > ISBE: Tuition In | Only report the value 01 (Yes) if the student is in a K-12 grade level. Do not mark Private School Students with the 01 (Yes) value. Private School Student is tracked on the ISBE student page. | |||
37 | Classroom Location | reg_programs.program_value where program_id = CHILD and field_number maps to reg_program_column with state_code_equiv = ILLEARNENV | iltb_learning_environment | ||||
38 | Preschool for All Classrooms | Reg_user where screen_number = 920 and field_number = 2 | ILTB_PRE_ALL | ||||
39 | IDEA Services Received | reg_programs.program_value where program_id = CHILD and field_number maps to reg_program_column with state_code_equiv = ILIDEASERV | iltb_idea_services | ||||
40 | In Classroom IDEA | reg_programs.program_value where program_id = CHILD and field_number maps to reg_program_column with state_code_equiv = ILINCIEP | |||||
41 | Preschool for All Expansion | reg_programs.program_value where program_id = CHILD and field_number maps to reg_program_column with state_code_equiv = ILPRESCHEX | iltb_preschool_expansion | ||||
42 | Head Start Funding | Reg_user where screen_number = 920 and field_number = 3 | 01 = Yes 02 = No | ||||
43 | CPS Value Preschool | reg_programs.program_value where program_id = CHILD and field_number maps to reg_program_column with state_code_equiv = ILCPSPRESC | |||||
44 | Pre-K Title I | Reg_user where screen_number = 920 and field_number = 4 | 01 = Yes 02 = No | ||||
45 | IDEA Funding | reg_programs.program_value where program_id = FUND and field_number maps to reg_program_column with state_code_equiv = ILPRSCHFUN | iltb_preschool_funding | ||||
46 | Local District Funding | reg_programs.program_value where program_id = FUND and field_number maps to reg_program_column with state_code_equiv = ILDISTFUND | iltb_preschool_funding | ||||
47 | Tuition Based Funding | reg_programs.program_value where program_id = FUND and field_number maps to reg_program_column with state_code_equiv = ILTUITFUND | iltb_preschool_funding | ||||
48 | Previous Enrollment in Early Childhood Program | reg_programs.program_value where program_id = CHILD and field_number maps to reg_program_column with state_code_equiv = ILPASTCHEN | |||||
49 | Early Head Start (Birth to 3) | Reg_user where screen_number = 920 and field_number = 6 | |||||
50 | Prevention Initiative (Birth to 3) | Reg_user where screen_number = 920 and field_number = 7 | 01=Yes, 02=No (default to 02) | ||||
51 | Early Intervention (Birth to 3) | Reg_user where screen_number = 920 and field_number = 8 | Checkbox – convert to 01/02 in file creation 01=Yes, 02=No (default to 02) | ||||
52 | Child Care | reg_programs.program_value where program_id = CHILD and field_number maps to reg_program_column with state_code_equiv = ILCHILDCARE | |||||
53 | Referral by CFC | Reg_user where screen_number = 920 and field_number = 9 | Checkbox – convert to 01/02 in file creation 01=Yes, 02=No (default to 02) Required if Early Intervention and Referral by CFC = Yes (01) Mandatory if Early Intervention is 'Yes' | ||||
54 | EI Number | Reg_user where screen_number = 920 and field_number = 10 | Alpha/Numeric – must be exactly 6 digits if entered. Required if Early Intervention and Referral by CFC = Yes (01) Mandatory If Early Intervention and Referral by CFC is 'Yes' | ||||
55 | Eligibility Determination Date | Reg_user where screen_number = 920 and field_number = 11 | Format mm/dd/yyyy Mandatory If Early Intervention and Referral by CFC is 'Yes' | ||||
56 | Reason for Delay in Transition | Reg_user where screen_number = 920 and field_number = 12 | ILTB_DEL_REASON | Mandatory If Early Intervention and Referral by CFC is 'Yes' | |||
57 | IEP Completion Date | Reg_user where screen_number = 920 and field_number = 13 | Format mm/dd/yyyy. This may change to a program tracked vector. Mandatory If Early Intervention, Referral by CFC and IEP Indicator is 'Yes' | ||||
58 | Date Services Began | Reg_user where screen_number = 920 and field_number = 14 | IEP indicator is program tracked vector. (reg_user where screen_number = 900 and field_number = 4) | Format mm/dd/yyyy. Mandatory If Early Intervention, Referral by CFC and IEP Indicator is 'Yes' | |||
59 | Meets At-risk Criteria | Reg_user where screen_number = 920 and field_number = 15 | Checkbox – convert to 01/02 in file creation 01=Yes, 02=No (default to 02) | ||||
60 | Family Structure | Reg_user where screen_number = 920 and field_number = 17 | ILTB_FAMILY_STRUCT | ||||
61 | Meets PFA Household Income Criteria | Reg_user where screen_number = 920 and field_number = 16 | Checkbox – convert to 01/02 in file creation 01=Yes, 02=No (default to 02) | ||||
62 | Child Welfare Involvement within the Past Year | reg_programs.program_value where program_id = FUND and field_number maps to reg_program_column with state_code_equiv = ILWELFSERV | |||||
63 | Child has been a Youth in Care | reg_programs.program_value where program_id = FUND and field_number maps to reg_program_column with state_code_equiv = ILSTUYCARE | |||||
64 | Family has an Open Intact Family Services Case | reg_programs.program_value where program_id = FUND and field_number maps to reg_program_column with state_code_equiv = ILSERVCASE | |||||
65 | Child's Parent is a Youth in Care | reg_programs.program_value where program_id = FUND and field_number maps to reg_program_column with state_code_equiv = ILPRNTCARE | |||||
66 | Student's Family is Receiving TANF | reg_user.field_value where screen_number = 920 and field_number = 32 | |||||
67 | Student's Family is Receiving WIC | reg_user.field_value where screen_number = 920 and field_number = 33 | |||||
68 | Student's Family is Receiving SNAP | reg_user.field_value where screen_number = 920 and field_number = 34 | |||||
69 | Student's Family is Receiving Housing Subsidy | reg_user.field_value where screen_number = 920 and field_number = 35 |