IAR
Field # | Field Name | eSchoolPLUS table.column | Required? | Field Length | Where in eSchoolPlus? | Notes |
---|---|---|---|---|---|---|
1 | Student ID | reg_personal.state_report_id | Y | 9 | ||
2 | SAP ID | reg_entry_with.student_id | N | 50 | ||
3 | Legal Last Name | Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name | Y | 30 | ||
4 | Legal First Name | Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name | Y | 30 | ||
5 | Birth Date | reg.birthdate | Y | 10 | Format mm/dd/yyyy | |
6 | RCDTS Home School | If student has an override, use reg_building.state_code_equiv where building equals reg_programs.program_value for program_id with reg_program_column.state_code_equiv = H_RCDTS Otherwise, use reg_building.state_code_equiv where building equals reg_programs.program_value for program_id with reg_program_column.state_code_equiv = ILALT. This is the same reg_building.state_code_equiv for the building stored in reg.alt_building. If there is no alternate building use reg_entry_with.building and map to the reg_building.state_code_equiv | Y | 15 | The download goes through these steps:
| |
7 | RCDTS Serving School | If student has an override, use reg_building.state_code_equiv where building equals reg_programs.program_value for program_id with reg_program_column.state_code_equiv = S_RCDTS Otherwise, use reg_entry_with.building and map to the reg_building.state_code_equiv | Y | 15 | For the override value, go to Registration > Entry & Reports > Student Demographic > Programs > click link for RCDTS - RCDTS Overrides: Serving School RCDTS Override Otherwise, reference Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Building | |
8 | RCDTS Testing School | If student has an override, use reg_building.state_code_equiv where building equals reg_programs.program_value for program_id with reg_program_column.state_code_equiv = T_RCDTS Otherwise, use reg_entry_with.building and map to the reg_building.state_code_equiv | Y | 15 | For the override value, go to Registration > Entry & Reports > Student Demographic > Programs > click link for RCDTS - RCDTS Overrides: Testing School RCDTS Override Otherwise, reference Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Building | |
9 | School Year | Use the Fiscal Year you entered when you ran the IAR Pre-ID download. | Y | 4 | Regulatory > ISBE > ISBE > IL IAR Pre-ID: Fiscal Year prompt | |
10 | Test Code | Students in grades 3 through 8 get two IAR Pre-ID records, one for their grade level's Mathematics test and one for the ELA/Literacy test. For example, a student in grade 5 gets a record for Test Code MAT05 and ELA05. | Y | 5 | System-assigned based on the student's Entry/Withdrawal grade level as of the School Year and Reporting Date you choose when you run the IAR Pre-ID download. | You can choose to exclude a student from IAR Pre-ID processing on the Exclude Students from State Reports district-defined page. In this case, the student does not get an IAR Pre-ID record for either Test Code. |
11 | Test Format | If the student has a record saved for reg_user where screen_number = 1061, then base Test Format on reg_user.field_value where field_number = 1 for the ELA Test Code record and where field_number = 4 for the MAT Test Code. If the field_value = N, report O for Online. If the field_value = Y, report P for Paper. If the student does not have a record for reg_user where screen_number = 1061, then use the IL IAR Pre-ID page's Default Test Format (ELA or MAT) for the Test Code reported. | Y | 1 | Registration > Student District Defined > ISBE IAR Pre-ID Test Selection: ELA Test Format - Paper/Pencil or MAT Test Format - Paper/Pencil depending on which Test Code is reported. | Important: The ISBE IAR Pre-ID option includes prompts for Default ELA Test Format and Default MAT Test Format. The download uses these values for any student missing the district-defined page ISBE IAR Pre-ID Test Selection. |
12 | Session Name | reg_user.field_value where screen_number = 1031 and field_number = 2 for the ELA Test Code or field_number = 5 for the MAT Test Code | N | 45 | Registration > Student District Defined > ISBE IAR Pre-ID Test Selection: ELA Session Location or MAT Session Location depending on which Test Code is reported. | |
13 | Class Name | reg_user.field_value where screen_number = 1031 and field_number = 3 for the ELA Test Code or field_number = 6 for the MAT Test Code | N | 38 | Registration > Student District Defined > ISBE IAR Pre-ID Test Selection: ELA Class Name or MAT Class Name depending on which Test Code is reported. | If Class Name is blank for the student on the district-defined page, the download uses the ISBE IAR Pre-ID page’s Class Name Same as Assessment Session Location prompt to determine if the field should be blank in the download record. |
14 | Placeholder 2 | N/A | Blank | N/A | N/A | |
15 | Accommodation 504 | reg_programs.program_value where program_id maps to reg_program_column.state_code_equiv = 504ACM | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE ELL and ELL Screener: 504 Accommodations field | |
16 | Placeholder 3 | N/A | Blank | N/A | N/A | |
17 | Alternative Representation Paper Test | For MAT Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 5 For ELA Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 31 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (MAT) Alt Rep Test field Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (ELA) Alt Rep Paper Test field | IDEA Services (IEP) Indicator or 504 Accommodation must be Yes. |
18 | Spanish Version of the Mathematics Assessment | reg_user.field_value where screen_number = 1050 and field_number = 24 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (MAT) Spanish Transadaptation field | The student must have a code of 01 – Yes for Accommodation EL. This is only valid for Math subject tests. If this field is 01 - Yes, the student must meet these criteria:
|
19 | Large Print | For MAT Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 14 For ELA Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 33 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (MAT) Large Print field Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (ELA) Large Print field | IDEA Services (IEP) Indicator or 504 Accommodation must be Yes. This is only valid for the P – Print Test Format. If this field is 01 - Yes, then Braille with Tactile Graphics must be 00 - None or blank |
20 | Answer Masking | For MAT Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 12 For ELA Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 35 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (MAT) Answer Masking field Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (ELA) Answer Masking field | |
21 | Color Contrast | For MAT Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 13 For ELA Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 32 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (MAT) Color Contrast field Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (ELA) Color Contrast field | If the code is any value from 01 to 06, the Test Format must be O – Online. If the code is 07, the Test Format must P – Print. |
22 | Text-to-Speech | For MAT Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 18 For ELA Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 45 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (MAT) Text-to-Speech field Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (ELA) Text-to-Speech field | If this field is 01 – Yes, the Test Format must be O – Online. If the record is for an ELA test, the student must have a value of 01 – Yes for either IDEA Services (IEP) Indicator or 504 Accommodation. If the record is for a Math test, the student needs an EL Indicator value of Yes If this value is 11 for an ELA test, the following fields must be No or None:
If this value is 12, 13, 14, or 15 for a Math test, the following fields must be No or None:
|
23 | Human Reader or Signer | For MAT Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 9 For ELA Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 43 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (MAT) Human Reader or Signer field Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (ELA) Human Reader or Signer field | If the record is for an ELA test, the student must have a value of 01 – Yes for either IEP Accommodation or 504 Accommodation. |
24 | ASL Video | For MAT Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 22 For ELA Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 42 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (MAT) ASL Video field Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (ELA) ASL Video field | If this field is 01 – Yes, Test Format must be O – Online. The student needs a 01 – Yes either for IDEA Services (IEP) Indicator or 504 Accommodation. If this is 01 – Yes, the following fields must be No or None:
|
25 | Assistive Technology - Screen Reader/Non-Screen Reader | For MAT Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 23 For ELA Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 44 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (MAT) AT Screen Reader App field Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (ELA) AT Screen Reader App field | If this field is 05 or 06, Test Format must be O – Online. The student needs a 01 – Yes either for IDEA Services (IEP) Indicator or 504 Accommodation. If this is 05 or 06, the following fields must be No or None: Text to Speech Human Reader or Signer ASL Video Closed Captioning for ELA/L Translation of the Mathematics Assessment in Spanish |
26 | Closed Captioning for ELA/L | reg_user.field_value where screen_number = 1050 and field_number = 27 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (ELA) Closed Caption field | If this field is 01 – Yes, Test Format must be O – Online. This is only valid for an ELA subject test. The student needs a 01 – Yes either for IDEA Services (IEP) Indicator or 504 Accommodation. If this is 01 – Yes, the following fields must be No or None:
|
27 | Refreshable Braille Display for ELA/L | reg_user.field_value where screen_number = 1050 and field_number = 28 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (ELA) Refreshable Braille Disp field | If this value is 01 – Yes, then the Test Format must be O – Online. This is only valid for an ELA subject test. The student needs a 01 – Yes either for IDEA Services (IEP) Indicator or 504 Accommodation. If this field is reported as 01 – Yes, the download also:
|
28 | Placeholder 1 | N/A | Blank | N/A | N/A | |
29 | Braille Response | For MAT Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 21 For ELA Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 39 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (MAT) Braille Response field Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (ELA) Braille Response field | The student needs a 01 – Yes either for IDEA Services (IEP) Indicator or 504 Accommodation. |
30 | Braille with Tactile Graphics | For MAT Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 15 For ELA Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 40 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (MAT) EBAE/English Braille field Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: EBAE/English Braille field | If this field is 01 – Yes, the Test Format must be P – Paper. The student needs a 01 – Yes either for IDEA Services (IEP) Indicator or 504 Accommodation. |
31 | Answers Recorded in Test Book | For MAT Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 20 For ELA Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 38 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (MAT) Answers Rec in Test Book field Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (ELA) Answers Rec in Test Book field | If this field is 01 – Yes, the Test Format must be P – Paper. The student needs a 01 – Yes either for IDEA Services (IEP) Indicator or 504 Accommodation. |
32 | Calculation Device and Mathematics Tools | reg_user.field_value where screen_number = 1050 and field_number = 8 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (MAT) Calculation Device field | The student needs a 01 – Yes either for IDEA Services (IEP) Indicator or 504 Accommodation. This is only valid for a Math subject test. |
33 | ELA/L Constructed Response | reg_user.field_value where screen_number = 1050 and field_number = 29 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (ELA) Constructed Response field | The student needs a 01 – Yes either for IDEA Services (IEP) Indicator or 504 Accommodation. This is only valid for an ELA subject test. |
34 | ELA/L Selected Response or Technology Enhanced Items | reg_user.field_value where screen_number = 1050 and field_number = 30 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (ELA) Selected Response field | The student needs a 01 – Yes either for IDEA Services (IEP) Indicator or 504 Accommodation. This is only valid for an ELA subject test. |
35 | Mathematics Response | reg_user.field_value where screen_number = 1050 and field_number = 25 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (MAT) Response field | The student needs a 01 – Yes either for IDEA Services (IEP) Indicator or 504 Accommodation. This is only valid for a Math subject test. |
36 | Monitor Test Response | For MAT Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 19 For ELA Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 37 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (MAT) Monitor Test Response field Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (ELA) Monitor Test Response field | The student needs a 01 – Yes either for IDEA Services (IEP) Indicator or 504 Accommodation. |
37 | Word Prediction for ELA/L | For MAT Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 11 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (ELA) Word Prediction for ELA/L field | The student needs a 01 – Yes either for IDEA Services (IEP) Indicator or 504 Accommodation. This is only for the ELA Test Format. |
38 | Mathematics Response – EL | reg_user.field_value where screen_number = 1050 and field_number = 26 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (MAT) Response EL field | The student needs a 01 – Yes for EL Indicator. This is only valid for a Math subject test. |
39 | Word to Word Dictionary (English/Native Language) | For MAT Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 10 For ELA Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 46 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (MAT) Dictionary Native Lang field Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (ELA) Dictionary Native Lang field | The student needs a 01 – Yes for EL Indicator. |
40 | Extended Time | For MAT Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 6 For ELA Test Code, use reg_user.field_value where screen_number = 1050 and field_number = 36 | N | 2 | Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (MAT) Extended Time field Registration > Entry & Reports > Student District-Defined > ISBE IAR Pre-ID Accommodations: (ELA) Extended Time field | The student needs a 01 – Yes either for IDEA Services (IEP) Indicator, EL Indicator, or 504 Accommodation. |
41 | Placeholder 4 | N/A | Blank | N/A | N/A | |
42 | Placeholder 5 | N/A | Blank | N/A | N/A | |
43 | Placeholder 6 | N/A | Blank | N/A | N/A | |
44 | New Arrival/First Year in United States | Set this field to 01 for Yes if the student meets these criteria: The student has reg_programs.program_value = Y as of the prompted Reporting Date for the program_id mapping to reg_program_column.state_code_equiv = ILELL The student's reg.us_enroll_date is within twelve months of the Reporting Date. If the student does not meet both criteria, use 02 for No. | Y | 2 | Registration > Entry & Reports > Student District-Defined > ISBE ELL and ELL Screener: ELL Program field Registration > Entry & Reports > Student Demographic > Registration > Other Enrollment panel: US Enrollment Date field |