S_OH_STU_FN_SNAP_C (ver 16.7.0)
This table is a child table of the [STUDENTS] table.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 16.7.0 | Number(10,0) | Primary Key. |
| SnapShotRunID | 16.7.0 | Number(11,0) | A unique ID assigned to an individual snapshot to distinguish snapshots, when multiple snapshots are completed. |
| StudentsDCID | 16.7.0 | Number(10,0) | Foreign key that relates the child table back to the STUDENTS table. |
| Accountability_IRN | 16.7.0 | VarChar2(20) | The building IRN within the district that is responsible for the student’s performance measures, as of the snapshot. |
| CORE_Arts | 16.7.0 | VarChar2(1) | Indicates if a student has met the CORE Fine Arts requirement, as of the snapshot. |
| CORE_Econ | 16.7.0 | VarChar2(1) | Indicates if a student has met the CORE Economics and Financial Literacy requirement, as of the snapshot. |
| CORE_Grad_Req_Exemp | 16.7.0 | VarChar2(20) | The Ohio CORE exemption status of a student, as of the snapshot. |
| Courses_Completed_Date | 16.10.0 | Date | The month and year in which the student completed the course requirements for a diploma. |
| Courses_Completed_IRN | 16.10.0 | VarChar2(6) | The IRN of the district in which the student completed the course requirements for a diploma. |
| CTE_Program | 16.7.0 | VarChar2(20) | The primary CTE Workforce Development Program for which a student has met the requirements to be considered a concentrator, as of the snapshot. |
| Diploma_Date | 16.7.0 | Date | The date the student received his/her diploma, as of the snapshot. |
| Diploma_Type | 16.7.0 | VarChar2(20) | The type of diploma received by the graduating student, as of the snapshot. |
| Exempted_Physical | 16.7.0 | VarChar2(1) | Indicates if the district has adopted a policy to exempt certain students from the Physical Education graduation credit requirement and if the student has met the policy’s requirements, as of the snapshot. |
| FiscalYear | 16.7.0 | Number(11,0) | Fiscal year to which data are applicable. |
| Fiscal_9 | 16.7.0 | VarChar2(4) | The fiscal year in which the student first began ninth grade, as of the snapshot. |
| FLICS_IRN | 16.7.0 | VarChar2(6) | District IRN Attended Last October (FLICS), as of the snapshot. |
| Grad_Alt | 16.7.0 | Number(1,0) | Identifies that passage on one graduation test was met using the alternative criteria, as of the snapshot. |
| LEP_Reclassified_Date | 16.7.0 | VarChar2(6) | The date on which the student is considered “no longer LEP”, as of the snapshot. |
| Majority_Att_IRN | 16.7.0 | VarChar2(20) | The IRN of the building or district where a student is continuously en-rolled from the Friday of the first full week of October through the spring test administration date, as shown in the table located in the re-porting instructions, as of the snapshot. |
| Math_Diag_Result_Code | 16.7.0 | VarChar2(20) | Result of the student’s math diagnostic assessment, as of the snapshot. |
| Military_CompGrad_Alt | 16.7.0 | VarChar2(20) | Identifies that the requirement to take one or more graduation tests was met using the military compact alternative criteria, as of the snapshot. |
| Next_School | 16.7.0 | VarChar2(20) | The state assigned six-digit information retrieval number (IRN) of the building that the student would be attending the following school year, as of the snapshot. |
| Next_Year_Grade | 16.7.0 | VarChar2(20) | Indicates the grade level to which a student has been promoted, or the grade level in which a student will be retained the following school year, as of the snapshot. |
| Reading_Diag_Result_Code | 16.7.0 | VarChar2(20) | Result of the student’s reading diagnostic assessment, as of the snapshot. |
| Retained_Status | 16.7.0 | VarChar2(20) | Indicates if a student was retained at the end of a school year and whether he/she will advance to the next grade level, as of the snapshot. |
| UpDated_IEP | 16.7.0 | VarChar2(20) | Least Restrictive Environment (LRE) outcome as of October 31 for a student whose IEP currently on file with ODE does not reflect the current LRE for a student with a disability, as of the snapshot. |
| Writing_Diag_Result_Code | 16.7.0 | VarChar2(20) | Result of the student’s writing diagnostic assessment, as of the snapshot. |
| Yearend_SSID | 16.7.0 | VarChar2(9) | The state assigned unique identifier for a graduate as of the close of yearend reporting, as of the snapshot. |
| Military_Student | 17.9.0 | VarChar2(1) | Identifies student with a parent or legal guardian who is an active member of the Armed Forces or National Guard. |