Seal of Biliteracy Awards
| Field # | Field Name | eSchoolPLUS table.column | Required? | Field Length | Validation Table | Where in eSchoolPlus? | Notes |
|---|---|---|---|---|---|---|---|
| 1 | Student Id | reg_personal.state_report_id | Y | 9 | Personal > General panel: State ID field | ||
| 2 | SAP Id | reg.student_id | N | 50 | Registration > Student Information bar: ID field | ||
| 3 | Legal Last Name | reg.last_name | Y | 30 | Registration > Student panel: Last Name field | ||
| 4 | Legal First Name | reg.first_name | Y | 30 | Registration > Student panel: First Name field | ||
| 5 | Birth Date | reg.birthdate | Y | 10 | Registration > Student panel: Birth Date field | Formatted mm/dd/yyyy | |
| 6 | RCDTS for 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:
| Note: default to the Serving School if none entered 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 | School Year | Fiscal Year prompt from IL Download ISBE Submission Files page. | Y | 4 | IL Download ISBE Submission Files: Fiscal Year | ||
| 8 | Seal or Commendation | reg_user.field_value where screen_number = 1080 and field_number = 20 | Y | 2 | IL Seal of Biliteracy: Seal/Commendation |
| |
| 9 | Language of Award | reg_user.field_value where screen_number = 1080 and field_number = 10 | Y | 3 | regtb_language | IL Seal of Biliteracy: Language | The download will not create a record with Language = 000 - English. |
| 10 | Method of Demonstrating English Proficiency | reg_user.field_value where screen_number = 900 and field_number = 16 | Y | 2 | iltb_english_proficiency | ISBE: Biliteracy English Proficiency | |
| 11 | Method of Demonstrating Proficiency in Language Other than English | reg_user.field_value where screen_number = 1080 and field_number = 25 | Y | 2 | iltb_language_proficiency | IL Seal of Biliteracy: Method of Language Proficiency |