IAR Pre-ID PAN (Pearson Access Net) Extract
| Field # | Field Name | eSchoolPLUS table.column | Notes |
|---|---|---|---|
| 1 | State Abbreviation | This value is always IL. | |
| 2 | Testing District Code | First, the download determines which building's State Code Equiv to use. 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 The Testing District Code is the leftmost 11 digits from the State Code Equiv followed by 0000 | |
| 3 | Testing School Code | 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 | |
| 4 | Home District Code | First, the download determines which building's State Code Equiv to use. 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 The Home District Code is the leftmost 11 digits from the State Code Equiv followed by 0000 | |
| 5 | Home School Code | 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 | |
| 6 | State Student Identifier | reg_personal.state_report_id | |
| 7 | Local Student Identifier | reg_entry_with.student_id | |
| 8 | Unique Pearson Student ID | Blank | |
| 9 | Last Name or Surname | Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name | |
| 10 | First Name | Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name | |
| 11 | Middle Name | reg.middle_name | |
| 12 | Birth Date | reg.birthdate | Format mm/dd/yyyy |
| 13 | Sex | reg.gender | |
| 14 | State Field 1 | Blank | |
| 15 | Grade Level When Assessed | reg_entry_with.grade | |
| 16 | Hispanic or Latino Ethnicity | reg_personal.hispanic | |
| 17 | American Indian or Alaska Native | The eSchoolPlus extract leaves this field blank. The ISBE SIS updates the field for the student when you run the upload to PAN. | |
| 18 | Asian | The eSchoolPlus extract leaves this field blank. The ISBE SIS updates the field for the student when you run the upload to PAN. | |
| 19 | Black or African American | The eSchoolPlus extract leaves this field blank. The ISBE SIS updates the field for the student when you run the upload to PAN. | |
| 18 | Native Hawaiian or Other Pacific Islander | The eSchoolPlus extract leaves this field blank. The ISBE SIS updates the field for the student when you run the upload to PAN. | |
| 19 | White | The eSchoolPlus extract leaves this field blank. The ISBE SIS updates the field for the student when you run the upload to PAN. | |
| 20 | Filler | Blank | |
| 21 | Two or More Races | The eSchoolPlus extract leaves this field blank. The ISBE SIS updates the field for the student when you run the upload to PAN. | |
| 22 | English Learner (EL) | The eSchoolPlus extract leaves this field blank. The ISBE SIS updates the field for the student when you run the upload to PAN. | |
| 23 | Title III Limited English Proficient Participation Status | The eSchoolPlus extract leaves this field blank. The ISBE SIS updates the field for the student when you run the upload to PAN. | |
| 24 | Gifted and Talented | The eSchoolPlus extract leaves this field blank. The ISBE SIS updates the field for the student when you run the upload to PAN. | |
| 25 | Migrant Status | The eSchoolPlus extract leaves this field blank. The ISBE SIS updates the field for the student when you run the upload to PAN. | |
| 26 | Economic Disadvantage Status | The eSchoolPlus extract leaves this field blank. The ISBE SIS updates the field for the student when you run the upload to PAN. | |
| 27 | Students with Disabilities | This is calculated based on two reg_programs.program_values:
| Use value B if the student's program_value = 1 for both programs. If program_value = 1 only for ILACM, use value IEP. If program_value = 1 only for 504ACM, use value 504. |
| 28 | Primary Disability Type | reg_disability.disability where disability_order = 1. Convert to regtb_disability.state_code_equiv | The ISBE IAR Pre-ID PAN extract converts the state_code_equiv values to the appropriate Personal Needs Profile values used by Pearson Access Net. |
| 29 | State Field 2 | Blank | |
| 30 | State Field 3 | Blank | |
| 31 | State Field 4 | Blank | |
| 32 | State Field 5 | Blank | |
| 33 | State Field 6 | Blank | |
| 34 | State Field 7 | Blank | |
| 35 | State Field 8 | Blank | |
| 36 | State Field 9 | Blank | |
| 37 | State Field 10 | Blank | |
| 38 | State Field 11 | Blank | |
| 39 | State Field 12 | Blank | |
| 40 | State Field 13 | Blank | |
| 41 | State Field 14 | Blank | |
| 42 | State Field 15 | Blank | |
| 43 | 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 | |
| 44 | 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 | 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. |
| 45 | Test Administrator | Blank | |
| 46 | Staff Member Identifier | Blank | |
| 47 | 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. | 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. |
| 48 | 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. | 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. |
| 49 | Retest | Blank | |
| 50 | Filler | Blank | |
| 51 | Frequent Breaks | Blank | |
| 52 | Separate/Alternate Location | Blank | |
| 53 | Small Group Testing | Blank | |
| 54 | Specialized Equipment or Furniture | Blank | |
| 55 | Specified Area or Setting | Blank | |
| 56 | Time of Day | Blank | |
| 57 | 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 | A download value of 01 gets converted to Y. Otherwise, leave blank. |
| 9 | School Year | Use the Fiscal Year you entered when you ran the IAR Pre-ID download. | |
| 14 | Placeholder 2 | N/A | |
| 15 | Accommodation 504 | reg_programs.program_value where program_id maps to reg_program_column.state_code_equiv = 504ACM | |
| 16 | Placeholder 3 | 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 | 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 | 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 | 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 | |
| 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | |
| 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | The student needs a 01 – Yes either for IDEA Services (IEP) Indicator, EL Indicator, or 504 Accommodation. |
| 41 | Placeholder 4 | N/A | |
| 42 | Placeholder 5 | N/A | |
| 43 | Placeholder 6 | 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. |