S_OH_District_Testing_S ver 17.8.0
This table is a standalone table and stores student counts for assessments that are non-state reportable.
Column Name | Version | Data Type | Description |
|---|---|---|---|
Unique_ID | 17.8.0 | Number(10) | System generated Primary Key. |
SchoolID | 17.8.0 | Number (10) | ID for school associated with the record. Migrated from [OH_District_Testing.schoolid] |
ForeignKey | 17.8.0 | VarChar2 | Contains a valid school or district ID related to the record. Migrated from [OH_District_Testing.foreignkey] |
Accommodations_yn | 17.8.0 | VarChar2(1) | Indicates if students with special needs received accommodations on the assessment. Migrated from [OH_District_Testing.Accom]. |
| Alt_assessment_yn | 17.8.0 | VarChar2(1) | Indicates if an alternate assessment was provided for students with special needs. Migrated from [OH_District_Testing.AltAsmt]. |
| Assessment_number | 17.8.0 | Number(11) | Locally defined number. Migrated from [OH_District_Testing.AssmntNum]. |
| Count_accommodations | 17.8.0 | Number(11) | Count of student who took the assessment with accommodations. Migrated from [OH_District_Testing.AccomCnt]. |
| Count_alt_assessment | 17.8.0 | Number(11) | Count of students who took the alternate assessment. Migrated from [OH_District_Testing.AltAsmtCnt]. |
| Count_disabilities | 17.8.0 | Number(11) | Count of students with disabilities who took the assessment. Migrated from [OH_District_Testing.NumAsdDis]. |
| Count_students | 17.8.0 | Number(11) | Count of students who took the assessment. Migrated from [OH_District_Testing.NumAsd]. |
| Fiscal_Year | 17.8.0 | Number(11) | Fiscal Year the assessment was administered. Migrated from [OH_District_Testing.FiscalYr]. |
| Grade | 17.8.0 | Varchar2(2) | Grade level of students to whom the assessment was administered. Migrated from [OH_District_Testing.Grade]. |
| Subdistrict_ID | 17.8.0 | Number(11) | Used to identify sub-districts within a database. Migrated from [OH_District_Testing.user_defined_integer]. |
| User_ID | 17.8.0 | Number(10) | ID of person who created the record. Migrated from [OH_District_Testing.user_defined_numeric]. |