IL State Reporting Setup
On this page:
Illinois State Validation Tables
Menu path: Select Administration from the main menu, select General Setup submenu, select District, and then select Validation Tables. You must select Illinois State Reporting for Applications and <Validation table name> for Validation Table.
You can click on any Illinois validation table and it will open a list of all existing codes. The following list of tables will be pre-populated by PowerSchool with the State Defined codes. Tables that are new for school year 2010 are listed with their State Equivalency Codes for your information.
Validation Table | Database Table Name | eSchoolPlus Page Used On |
|---|---|---|
ELL Class Periods | Iltb_ell_period | Menu path: Registration > Entry & Reports > Student District Defined > ISBE EL with ELL Screener |
Test to be Taken | iltb_test_type | Menu path: Registration > Entry & Reports > Student District Defined > ISBE Pre-Id |
RCDTS Numbers | iltb_rcdts_num | Menu path: Registration > Entry & Reports > Student Demographic > Programs (used for the RCDTS Override Program – in case you need to override a Serving, Home, or Testing School) |
ELL Listening Scores | Iltb_wapt_l_score | Menu path: Registration > Entry & Reports > Student District Defined > ISBE EL with ELL Screener |
ELL Reading Scores | Iltb_wapt_r_score | Menu path: Registration > Entry & Reports > Student District Defined > ISBE EL with ELL Screener |
ELL Speaking Scores | Iltb_wapt_s_score | Menu path: Registration > Entry & Reports > Student District Defined > ISBE EL with ELL Screener |
ELL Writing Scores | Iltb_wapt_w_score | Menu path: Registration > Entry & Reports > Student District Defined > ISBE EL with ELL Screener |
Years in TBE TPI Program | iltb_prog_year | Menu path: Registration > Entry & Reports > Student District Defined > ISBE Pre-Id |
Years since exited TBE TPI Program | iltb_prog_exit | Menu path: Registration > Entry & Reports > Student District Defined > ISBE Pre-Id |
Early Childhood – Pre-K At Risk | iltb_prek_risk | Menu path: Registration > Entry & Reports > Student District Defined > ISBE Early Childhood |
Early Childhood – Preschool for All | iltb_pre_all | Menu path: Registration > Entry & Reports > Student District Defined > ISBE Early Childhood |
Early Childhood – Reason for Delay in Transition | iltb_del_reason | Menu path: Registration > Entry & Reports > Student District Defined > ISBE Early Childhood |
Early Childhood – Family Structure | iltb_family_struct | Menu path: Registration > Entry & Reports > Student District Defined > ISBE Early Childhood |
Early Childhood – Licensed Child Care | iltb_licensed_child_care | Menu path: Registration > Entry & Reports > Student District Defined > ISBE Early Childhood |
ECO Action | iltb_eco_action | Menu path: Registration > Entry & Reports > Student District Defined > ISBE ECO Rating |
ECO Assessment | iltb_eco_assessment | Menu path: Registration > Entry & Reports > Student District Defined > ISBE ECO Rating |
ECO Parent Involvement | iltb_eco_parent | Menu path: Registration > Entry & Reports > Student District Defined > ISBE ECO Rating |
ECO Pos Social Relationship | iltb_eco_relationship | Menu path: Registration > Entry & Reports > Student District Defined > ISBE ECO Rating |
ECO Use and Knowledge Skills | iltb_eco_know | Menu path: Registration > Entry & Reports > Student District Defined > ISBE ECO Rating |
Pre-K Followup Activities | iltb_pk_activities | Menu path: Registration > Entry & Reports > Student District Defined > ISBE Pre-K Followup |
Screening Type | medtb_screening_type | Menu path: Medical > All > Student > Exams: Hearing/Vision panels |
Diagnosis Code | medtb_diagnosis | Menu path: Medical > All > Student > Exams: Referral Detail section under Dental/Vision/Hearing panels |
Dental Status | medtb_dental_status | Menu path: Medical > All > Office > Dental |
SES Indicator | Iltb_ses | Menu path: Registration > Entry & Reports > Student District Defined > ISBE |
Course Grade Crosswalk | Iltb_grd_crosswalk | Used in the ISBE ISCS file |
Birth to Three Programs tables:
| iltb_btp_service_location iltb_btp_program_model iltb_btp_end_program iltb_btp_provider_type iltb_btp_provider_exit | Menu path: Registration > Entry & Reports > Student Demographic > Programs (used for the ISBE Birth to Three Program district-defined page, BRTH3 - ISBE Birth to 3, BTP01 - ISBE Birth to Three Early Head Start and BTP02 - ISBE Birth to Three Prevention Initiative program pages) |
Screening Type State Equivalency Codes
Description | State Code Equiv |
|---|---|
Not Applicable | N |
Re-screening | R |
Screening | S |
Threshold | T |
Diagnosis Codes State Equivalency Codes
Description | State Code Equiv |
|---|---|
Amblyopia | VAM |
Combination of Findings | VCF |
Muscle Balance | VMB |
Normal | VNR |
Pathology | VPA |
Ref-Astigmatism | VRA |
Ref-Hyperopia | VRH |
Ref-Myopia | VRM |
Ref-Other | VRO |
Cond Loss-Canal Obstruct | HA1 |
Cond Loss-Otits Media | HA2 |
Cond Loss-Other | HA3 |
Non-Organic | HB |
Sensorineural | HC |
Mixed | HD |
Normal Findings | HE |
Dental Status Codes State Equivalency Codes
Description | State Code Equiv |
|---|---|
No | N |
Yes | Y |
Unknown | U |
Course Grade Crosswalk
The Course Grade Crosswalk needs a record for each Mark you could potentially use as a Final course grade, either alpha or numeric. Define the mark value in the Code field, then associate this mark with the appropriate Final Grade Equiv and Course Grade Equiv values. Final Grade Equiv is reported in the ISCS file's Course Final Letter Grade/Completion Status field. Course Grade Equiv is reported in the Course Numeric Grade field.
ISCS Term to ELL Screener Semester List
Use this table to map ISCS Term codes to the appropriate Semester code for reporting in the ELL Screener file. To determine the ELL Screener file's Semester code, the ISBE download needs a way of translating State Equivalency Codes from the Registration Center's Marking Periods setup to its corresponding Semester code. The Marking Periods State Equivalency Codes align with Term codes for the Student Course Assignment collection.
Field | Description |
|---|---|
Code | ISCS Term code you are translating into an ELL Screener Semester code. You need a record for each Term code you use in Registration Center's Marking Periods State Equivalency Code field. |
Description | Description associated with the ISCS Term code. [Character/255] |
Sem Equiv | ELL Screener Semester code equivalent for the associated ISCS Term code. This needs to be either 01 for First Semester or 02 for Second Semester. For example, if the ISCS Code is T2 for Second Trimester, use Sem Equiv to indicate whether the Semester equivalent should be 01 or 02 in the ELL Screener file. |
When creating an ELL Screener record, the ISBE Download goes through these steps to determine the Semester field value:
- Begin with the Reporting Date you used when running the ISBE Download for ELL Screener.
- Determine which Marking Period includes the Reporting Date. Use the processed Building's Marking Periods setup in Registration Center.
- Find the State Equivalency Code tied to the Marking Period.
- Use the ISCS Term to ELL Screener Semester validation table to convert the Marking Periods setup's State Equivalency Code into a Semester code acceptable for the ELL Screener file.
PARCC Test Selection Overrides Reasons
Use this table to define reasons why a student's PARCC test assignments would need to be entered on the student-level ISBE PARCC Student Overrides page instead of getting handled through the student's scheduled courses. Examples of reasons could include Out-of-District student or Outplaced Course student.
This is an optional setup, but we recommend you use it so you can categorize students who are exceptions to the standard PARCC test assignment method, using State Course Codes tied to students' scheduled courses.
For this validation table, you can define State Code Equiv values however you choose. There are not ISBE-defined rules or eSchoolPlus system expectations. You could simply use the same value in the Code and State Code Equiv fields for each record.
Exclude Entry Codes from State Reporting
Menu path: Select Administration from the main menu, select General Setup submenu, select District District Defined, and then select Exclude Entry Codes from State Reports.
Use this screen to indicate to the system which Entry Codes indicate no break in enrollment.
