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