S_AK_STU_TechAssessment_C (ver 17.6.0)
This table is a child of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
unique_ID | 17.6.0 | Number(11,0) | Primary Key. Migrated from [VirtualTablesData.uniqueID] |
schoolID | 17.6.0 | Number(11,0) | School_number value of the school to which this record belongs. Migrated from [VirtualTablesData.schoolID]. |
foreignKey | 17.6.0 | Number(11,0) | ID value of the students record to which this record is linked. Migrated from [VirtualTablesData.foreignKey]. |
foreignKey_alpha | 17.6.0 | Varchar2(31) | Reserved for future use. Migrated from [VirtualTablesData.foreignKey_alpha]. |
| courseSection | 17.6.0 | Number(11,0) | ID value of the section in which this assessment was taken. Migrated from [VirtualTablesData.user_defined_integer]. |
| schoolYear | 17.6.0 | Number(25,10) | YearID value of the currently selected term. Migrated from [VirtualTablesData.user_defined_numeric]. |
| techAssessmentCode | 17.6.0 | Varchar2(6) | Coded value of technical skill assessment taken by student. Migrated from [VirtualTablesData.user_defined_text]. |
| techAssessmentPassed | 17.6.0 | Varchar2(1) | Y/N indicator of whether student passed the assessment. Migrated from [VirtualTablesData.user_defined_text2]. |