S_MA_STC_WARDynamicOverride_X (ver 15.9.0)
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. |