This table is an extension of the [SectionTeacher] table and is used to store overridden field values for Dynamic Work Assignment record data when the derived or calculated values need to be modified.
|
Column Name |
Version |
Data Type |
Description |
|---|---|---|---|
|
SectionTeacherID |
15.9.0 |
Number(10,0) |
Primary key that relates the extended table to the [SectionTeacher] table. |
|
AssignmentLocationCode |
15.9.0 |
Varchar2(8) |
The overridden state assigned district/school code if different than the derived section location code. |
|
JobClassificationCode |
15.9.0 |
Varchar2(4) |
The overridden four digit job classification code that best describes the type of assignment if different than the derived classification code associated with the teaching role. |
|
AssignmentCode |
15.9.0 |
Varchar2(3) |
The overridden three digit code that specifies the specific educational or support activity involved in this assignment if different than the derived assignment code. |
|
Grade |
15.9.0 |
Varchar2(4) |
The overridden grade level of the course section if different than the grade level defined at the section. |
|
SubjectAreaCourseCode |
15.9.0 |
Varchar2(7) |
The overridden NCES or CIP code that defines the subject area of this course if different than the code assigned to the course or section. |
|
ClassSection |
15.9.0 |
Varchar2(20) |
The overridden unique class/section identifier if different than the derived or configured class/section identifier. |
|
FTE |
15.9.0 |
Number(25,10) |
The overridden full time equivalent percentage this assignment represents in relation to all of the teacher's assignments if different than the report calculated value. |
|
InstructionalParaproQual |
15.9.0 |
Varchar2(2) |
Overridden code that denotes the level of paraprofessional training the teacher has for this assignment if different than the derived code. |
|
HighlyQualifiedStatus |
15.9.0 |
Varchar2(2) |
Overridden code indicating the teacher's highly qualified status for this assignment if different than the derived code. |
|
SubjectMatterCompetency |
15.9.0 |
Varchar2(2) |
Overridden code indicating the teacher's subject matter competency for this assignment if different than the derived code. |
|
CourseTerm |
15.9.0 |
Varchar2(2) |
The overridden two digit state assigned code that defines the length or type of term the course is associated with if different than the term the section is assigned to. |
|
TermStatus |
15.9.0 |
Varchar2(2) |
Overridden 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 or included in the Work Assignment Record Report. |