Skip to main content
Skip table of contents

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


Data Type





Foreign key that relates the child table to the [Users] table.

ID15.9.0Number(10,0)Primary key for this table.
AssignmentStartDate15.9.0DateThe date this work assignment record becomes active for reporting.
AssignmentEndDate15.9.0DateThe date this work assignment ends and the record is no longer valid for reporting.
DistrictAssignment_DistrictID15.9.0Number(11,0)The district or sub-district ID if this is a district level assignment.




The local code for this assignment.

Override_AssignmentLocCode15.9.0Varchar2(8)The district or school location code for this assignment if the location code has been manually overridden.
JobClassificationCode15.9.0Varchar2(4)The four digit job classification code that best describes the type of assignment.
AssignmentCode15.9.0Varchar2(3)The three digit code that specifies the specific educational or support activity involved in this assignment.
Grade15.9.0Varchar2(4)The grade level this assignment applies to, if applicable.
SubjectAreaCourseCode15.9.0Varchar2(7)The NCES or CIP code that defines the subject area of this assignment, if applicable.
ClassSection15.9.0Varchar2(20)The unique class/section identifier for this assignment, if applicable.
FTE15.9.0Number(25,10)The full time equivalent percentage this assignment represents in relation to all assignments for this person.
InstructionalParaproQual15.9.0Varchar2(2)Code that denotes the level of paraprofessional training the teacher/staff has for this assignment, if applicable.
HighlyQualifiedStatus15.9.0Varchar2(2)Code indicating the teacher/staff's highly qualified status for this assignment, if applicable.
SubjectMatterCompetency15.9.0Varchar2(2)Code indicating the teacher/staff subject matter competency for this assignment, if applicable.
CourseTerm15.9.0Varchar2(2)The two digit state assigned code that defines the length or type of term the assignment is associated with.
TermStatus15.9.0Varchar2(2)Status code indicating if the term is active or not at the time the data is derived or reported.
ExcludeFromWARReport15.9.0Number(1,0)Indicates whether or not this work assignment record should be excluded from the Work Assignment Record Report.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.