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 |
|---|---|---|---|
|
ID |
15.10.3 |
Number(11,0) |
Primary Key for this table. |
|
UsersDCID |
15.10.3 |
Number(10,0) |
Foreign key that relates the child table to the [Users] table. |
|
EffectiveDate |
15.10.3 |
Date |
Future Use - The date this subject area qualification becomes applicable for the subject area. |
|
ExpirationDate |
15.10.3 |
Date |
Future Use - The date this subject area qualification ends and no longer applies to the subject area. |
|
HQPlanCmnt |
15.10.3 |
Varchar2(200) |
Comment describing the plan intended to make this teacher Highly Qualified for this course. Also used to explain why Reason Not Highly Qualified Code 9 (Other) was selected. |
|
HQStatusCd |
15.10.3 |
Varchar2(2) |
Code indicating the District determination of Highly Qualified Status for the staff member in the specific Subject Area. |
|
HQStatusCmnt |
15.10.3 |
Varchar2(200) |
Comments describing the Highly Qualified Status of the staff member. |
|
HQStatusCmntCd |
15.10.3 |
Varchar2(2) |
Code describing the Highly Qualified Status of the staff member. |
|
RsnNotHQCd |
15.10.3 |
Varchar2(2) |
Code indicating the reason the staff member teaching courses in this Subject Area is not Highly Qualified. |
|
SubjAreaID |
15.10.3 |
Number(11,0) |
Foreign Key that links this table to the [S_OR_CourseSubjArea_S] table. |
|
TSPCHQFg |
15.10.3 |
Varchar2(2) |
Flag documenting if TSPC records indicate a licensed/endorsed status for this staff member and Subject Area. |