EL Screener
Field # | Field Name | eSchoolPLUS table.column | Required? | Field Length | Validation Table | Where in eSchoolPlus? | Notes |
---|---|---|---|---|---|---|---|
1 | Student Id | reg_personal.state_report_id | Registration > Entry & Reports > Student Demographic > Personal > General panel: State ID field | ||||
2 | SAP Id | reg.student_id | 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 | 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 | 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 | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Birth Date field | Formatted mm/dd/yyyy | |||
6 | RCDTS for Home School | Registration > Entry & Reports > Student Demographic > Programs: RCDTS Overrides program for Home School in reporting timeframe Or, reg.alt_building - state_code_equiv program tracked ILALT Or, reg_entry_with.building | The download goes through these steps:
| 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 | Grade Level at Time of Screener | reg_entry_with.grade | Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Grade field as of Reporting Date | ||||
8 | Semester | reg_mp_weeks.state_code_equiv converted to iltb_sem_crosswalk.sem_equiv | Administration > Registration Setup > Calendars > Marking Periods: State Code Equivalent value for the Reporting Date you enter on the Download ISBE Submission Files page. Convert to Administration > General Setup > District > Validation Tables > For Applications prompt, select Illinois State Reporting > For Validation Table prompt, select ISCS Term to ELL Screener Semester: Sem Equiv field | ||||
9 | ELL Screener Test Taken | reg_user.field_value where screen_number=’915’ and field_number=’26’ | Registration > Entry & Reports > Student District-Defined > ISBE ELL and ELL Screener: ELL Screener Test Taken field | ||||
10 | Date ELL Screener Test Taken | reg_user.field_value where screen_number=’915’ and field_number=’19’ | Registration > Entry & Reports > Student District-Defined > ISBE ELL and ELL Screener: ELL Screener Test Date field | ||||
11 | Placeholder 1 | ||||||
12 | Placeholder 2 | ||||||
13 | Placeholder 3 | ||||||
14 | Placeholder 4 | ||||||
15 | Listening Raw Score/Level | reg_user.field_value where screen_number=’915’ and field_number=’20’ | Registration > Entry & Reports > Student District-Defined > ISBE ELL and ELL Screener: Listening Raw Score/Level field | ||||
16 | Listening Proficiency Level | reg_user.field_value where screen_number=’915’ and field_number=’27’ | Registration > Entry & Reports > Student District-Defined > ISBE ELL and ELL Screener: Listening – Proficiency Level field | ||||
17 | Speaking Raw Score/Level | reg_user.field_value where screen_number=’915’ and field_number=’21’ | Registration > Entry & Reports > Student District-Defined > ISBE ELL and ELL Screener: Speaking Raw Score/Level field | ||||
18 | Speaking Proficiency Level | reg_user.field_value where screen_number=’915’ and field_number=’28’ | Registration > Entry & Reports > Student District-Defined > ISBE ELL and ELL Screener: Speaking – Proficiency Level field | ||||
19 | Reading Raw Score/Level | reg_user.field_value where screen_number=’915’ and field_number=’22’ | Registration > Entry & Reports > Student District-Defined > ISBE ELL and ELL Screener: Reading Raw Score/Level field | ||||
20 | Reading Proficiency Level | reg_user.field_value where screen_number=’915’ and field_number=’29’ | Registration > Entry & Reports > Student District-Defined > ISBE ELL and ELL Screener: Reading – Proficiency Level field | ||||
21 | Writing Raw Score/Level | reg_user.field_value where screen_number=’915’ and field_number=’23’ | Registration > Entry & Reports > Student District-Defined > ISBE ELL and ELL Screener: Writing Raw Score/Level field | ||||
22 | Writing Proficiency Level | reg_user.field_value where screen_number=’915’ and field_number=’30’ | Registration > Entry & Reports > Student District-Defined > ISBE ELL and ELL Screener: Writing – Proficiency Level field | ||||
23 | Literacy Proficiency Level | reg_user.field_value where screen_number=’915’ and field_number=’31’ | Registration > Entry & Reports > Student District-Defined > ISBE ELL and ELL Screener: Literacy Proficiency Level field | ||||
24 | Oral Proficiency Level | reg_user.field_value where screen_number=’915’ and field_number=’32’ | Registration > Entry & Reports > Student District-Defined > ISBE ELL and ELL Screener: Oral Proficiency Level field | ||||
25 | Overall or Composite Proficiency Level | reg_user.field_value where screen_number=’915’ and field_number=’24’ | Registration > Entry & Reports > Student District-Defined > ISBE ELL and ELL Screener: Overall/Composite Prof Level field | ||||
26 | Final Determination of LEP Status | reg_programs.program_value where state_code_equiv=’ILELL’ | Registration > Entry & Reports > Student District-Defined > ISBE ELL and ELL Screener: LEP Indicator field. Program Value on Reporting Date | ||||
27 | Result Code | ||||||
28 | Result message codes |