Student College and Career Readiness Indicator
The College and Career Readiness Indicator submission record pulls data from the student ISBE College Career Readiness Indicator page, which is reg_user.screen_number = 1110.
| Field # | Field Name | eSchoolPLUS table.column | Required? | Field Length | Validation Table |
|---|---|---|---|---|---|
| 1 | Student ID | reg_personal.state_report_id | M | 9 | |
| 2 | SAP ID | reg.student_id | O | 50 | |
| 3 | Legal Last Name | reg.last_name | M | 30 | |
| 4 | Legal First Name | reg.first_name | M | 30 | |
| 5 | Birth Date | reg.birthdate | M | 10 | |
| 6 | RCDTS for Home School | reg_building.state_code_equiv for reg_programs.program_value where program_id = reg_program_column.program_id for state_code_equiv = H_RCDTS Or, reg_building.state_code_equiv for reg.alt_building Or, reg_building.state_code_equiv for reg_entry_with.building | M | 15 | iltb_rcdts_nums |
| 7 | School Year | reg_entry_with.school_year | M | 4 | regtb_school_year |
| 8 | GPA | GPA is a calculated field for grades 11 and 12 based on the GPA Setup defined on the district-level page ISBE CCRI Setup. For students in grades 9 and 10, GPA will always be 00. Returns one of these values: | M | 2 | iltb_months |
| 9 | Identify a Career Area of Interest by the End of Sophomore Year | reg_user.field_value where screen_number = 1110 and field_number = 1 | M | 4 | regtb_school_year |
| 10 | One Academic Indicator ELA | reg_user.field_value where screen_number = 1110 and field_number = 3 | M | 5,3 | |
| 11 | One Academic Indicator Math | reg_user.field_value where screen_number = 1110 and field_number = 5 | M | 5,3 | |
| 12 | Minimum ACT or SAT Subject Scores - English, Reading, and Writing | Use reg_user.field_value where screen_number = 1110 and field_number = 7 if there is a value. If the student page has no value for this field, the download uses the calculation described in the section Calculating Minimum ACT and SAT Scores. | M | 5,3 | |
| 13 | Minimum ACT or SAT Subject Scores - Math | Use reg_user.field_value where screen_number = 1110 and field_number = 9 if there is a value. If the student page has no value for this field, the download uses the calculation described in the section Calculating Minimum ACT and SAT Scores. | M | 5,3 | |
| 14 | Career Development Experience | reg_user.field_value where screen_number = 1110 and field_number = 11 | M | 5,3 | |
| 15 | Industry Credential | reg_user.field_value where screen_number = 1110 and field_number = 13 | |||
| 16 | Military Service or an ASVAB Score of 31 or Higher | reg_user.field_value where screen_number = 1110 and field_number = 15 | |||
| 17 | Attaining and Maintaining Consistent Employment for a Minimum of 12 Months | reg_user.field_value where screen_number = 1110 and field_number = 17 | |||
| 18 | Consecutive Summer Employment | reg_user.field_value where screen_number = 1110 and field_number = 19 | |||
| 19 | 25 Hours of Community Service | reg_user.field_value where screen_number = 1110 and field_number = 21 | |||
| 20 | Two or More Organized Co-curricular Activities | reg_user.field_value where screen_number = 1110 and field_number = 23 |
Calculating Minimum ACT and SAT Scores
English, Reading, and Writing
For the Minimum ACT or SAT Subject Scores - English, Reading, and Writing field, the download first checks the student's ISBE College Career Readiness Indicator page's Minimum ACT or SAT Score ERW field. If there is no value for this field, the download determines the Yes (01) or No (02) setting using student Test History records. This can be part of the district setup to look at exams (AP and IB) by SCE, district page to have list of SCE accepted. Will retrieve the records indicated from the setup page and compare against threshold to determine a yes/no, only needs to meet on record, but calculate for both ACT and SAT.
Math
For the Minimum ACT or SAT Subject Scores - Math field, the download first checks the student's ISBE College Career Readiness Indicator page's Minimum ACT or SAT Score MATH field. If there is no value for this field, the download determines the Yes (01) or No (02) setting using student Test History records. This can be part of the district setup to look at exams (AP and IB) by SCE, district page to have list of SCE accepted. Will retrieve the records indicated from the setup page and compare against threshold to determine a yes/no, only needs to meet on record, but calculate for both ACT and SAT.