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. |