S_MA_USR_StaffQualSubjectArea_C (ver 15.9.0)
This table is a child of the [Users] table and stores information related to subject area qualifications for staff members.
Column Name | Version | Data Type | Description |
|---|---|---|---|
UsersDCID | 15.9.0 | Number(10,0) | Foreign key that relates the child table to the [Users] table. |
| ID | 15.9.0 | Number(10,0) | Primary Key for this table. |
| S_MA_StaffQualSubjArea_SID | 15.9.0 | Number(11,0) | Foreign Key that links this table to the [S_MA_StaffQualSubjArea_S] table. |
| HighlyQualifiedStatus | 15.9.0 | Varchar2(2) | Code indicating the teacher/staff's highly qualified status for a referenced subject area. |
| SubjectMatterCompetency | 15.9.0 | Varchar2(2) | Code indicating the teacher/staff subject matter competency for a referenced subject area. |
| EffectiveDate | 15.9.0 | Date | The date this subject area qualification becomes applicable for the subject area. |
| ExpirationDate | 15.9.0 | Date | The date this subject area qualification ends and longer applies to the subject area. |