This table is a child of the [Users] table and stores information related to static (non-teaching) work assignment records.
|
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. |
|
AssignmentStartDate |
15.9.0 |
Date |
The date this work assignment record becomes active for reporting. |
|
AssignmentEndDate |
15.9.0 |
Date |
The date this work assignment ends and the record is no longer valid for reporting. |
|
DistrictAssignment_DistrictID |
15.9.0 |
Number(11,0) |
The district or sub-district ID if this is a district level assignment. |
|
AssignmentLocationSchoolID |
15.9.0 |
Number(11,0) |
The local code for this assignment. |
|
Override_AssignmentLocCode |
15.9.0 |
Varchar2(8) |
The district or school location code for this assignment if the location code has been manually overridden. |
|
JobClassificationCode |
15.9.0 |
Varchar2(4) |
The four digit job classification code that best describes the type of assignment. |
|
AssignmentCode |
15.9.0 |
Varchar2(3) |
The three digit code that specifies the specific educational or support activity involved in this assignment. |
|
Grade |
15.9.0 |
Varchar2(4) |
The grade level this assignment applies to, if applicable. |
|
SubjectAreaCourseCode |
15.9.0 |
Varchar2(7) |
The NCES or CIP code that defines the subject area of this assignment, if applicable. |
|
ClassSection |
15.9.0 |
Varchar2(20) |
The unique class/section identifier for this assignment, if applicable. |
|
FTE |
15.9.0 |
Number(25,10) |
The full time equivalent percentage this assignment represents in relation to all assignments for this person. |
|
InstructionalParaproQual |
15.9.0 |
Varchar2(2) |
Code that denotes the level of paraprofessional training the teacher/staff has for this assignment, if applicable. |
|
HighlyQualifiedStatus |
15.9.0 |
Varchar2(2) |
Code indicating the teacher/staff's highly qualified status for this assignment, if applicable. |
|
SubjectMatterCompetency |
15.9.0 |
Varchar2(2) |
Code indicating the teacher/staff subject matter competency for this assignment, if applicable. |
|
CourseTerm |
15.9.0 |
Varchar2(2) |
The two digit state assigned code that defines the length or type of term the assignment is associated with. |
|
TermStatus |
15.9.0 |
Varchar2(2) |
Status code indicating if the term is active or not at the time the data is derived or reported. |
|
ExcludeFromWARReport |
15.9.0 |
Number(1,0) |
Indicates whether or not this work assignment record should be excluded from the Work Assignment Record Report. |