S_OH_STU_ASSESSMENT_C ver 17.8.0
This table is a child table of the [Students] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 17.8.0 | Number(10) | Primary key that relates the extended table back to the Students table. |
| ForeignKey | 17.8.0 | Number(11) | The Student ID associated with the student for this record. Migrated from [Oh_Student_Assessment.foreignKey]. |
| Assessment_Area | 17.8.0 | Varchar2(4) | A one to four character code that identifies the test or subject area of the assessment administered. Migrated from [OH_Student_Assessment.assessment_area]. |
| Import_ID | 17.8.0 | Number(11) | Used by the FA Import functionality to remove tests. Migrated from [OH_Student_Assessment.user_defined_integer]. |
| Performance_Level | 17.8.0 | Varchar2(1) | The Performance Level achieved. Used for Grad Pathways and not state reportable. Migrated from [OH_Student_Assessment.performance_level]. |
| Promotion_status_yn | 17.8.0 | Varchar2(1) | Indication of student's status for promotion based on test results. Obsolete prior to FY17. Migrated from [OH_Student_Assessment.promotion_status]. |
| Required_Test_Type | 17.8.0 | Varchar2(3) | The type of test/form of the assessment reported on the record. Migrated from [OH_Student_Assessment.required_test_type]. |
| Schoolid | 17.2.0 | Number(11) | The School building associated with the assessment. Migrated from [OH_Student_Assessment.schoolid]. |
| Score | 17.8.0 | Varchar2(3) | A three character field containing the score on the reported assessment. Migrated from [OH_Student_Assessment.score]. |
| Score_not_Reported | 17.8.0 | Varchar2(1) | Identifies the reason why the student did not take the required assessment and/or does not have a score to report. Migrated from [OH_Student_Assessment.score_not_reported]. |
| Student_Grade_Level | 17.8.0 | Varchar2(2) | The grade level of the student at the time the reported assessment was administered. Migrated from [OH_Student_Assessment.student_grade_level]. |
| Test_Type | 17.8.0 | Varchar2(2) | Two letter code that identifies the test. Migrated from [OH_Student_Assessment.test_type]. |
| Test_Grade_Level | 17.8.0 | Varchar2(2) | The grade level of the assessment administered. Migrated from [OH_Student_Assessment.test_grade_level]. |
| Test_Date | 17.8.0 | Varchar2(6) | The date the test was administered in year and month (YYYYMM). Migrated from [OH_Student_Assessment.test_date]. |
| Test_Day | 17.8.0 | Number(11) | The day of the month the test was administered. Migrated from [OH_Student_Assessment.test_day]. |
| Type_of_Accommodation | 17.8.0 | Varchar2(2) | The accommodation received by the student, if any. Migrated from [OH_Student_Assessment.type_of_accommodation]. |
| Exclude_from_FA | 17.9.0 | Boolean | This is used to exclude a record from the FA Student Assessment Report. |