Work Assignment Record (WAR) Extract - Legacy
Introduction
This extract creates a file with job related information for the state department of education.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
Staff Selection
- The staff member must belong to one of the schools in the current selection or that the report is being run for.
- The staff member must not be excluded from state reporting or EPIMS.
- The school associated with the staff member must not be excluded from state reporting.
- There must be a record for the staff member in the MA_War virtual table. The table is populated by manually entering Work Assignment Records at Start Page > Staff > Select A Staff Member > Edit Information > Work Assignment Records > New/Edit Work Assignment record or by running the War Record Builder at Start Page > Reports > Reports (State) > WAR Record Builder.
Prerequisite
You must complete the Years and Terms Mapping interface to map the local Term IDs to the state-required Term IDs for each school in your district prior to extracting the Work Assignment Records (WAR records). You can find this option via Start Page > District Setup > Schools/School Info > Edit School. Scroll to the Massachusetts State Information area at the bottom of the page. Refer to the District Setup section above for more information.
For example, for the 2010-2011 school year, the Term ID "2010-2011 School Year", needs to be mapped to the state-assigned term, "Full School Year (FULL) (01)". You must enter a record to designate the state assigned Term Code to extract for that term.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Use | If run at the district level, choose one of the following from the pop-up menu:
If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
Records to Include | Indicate which records to include in the report by selecting one of the following options:
Note: If running the report for a single record, or group of records, select the records prior to running report. |
Processing Options | Choose a time to run the report from the pop-up menu:
|
Specific Date/Time | Enter a date using the format mm/dd/yyyy or mm-dd-yyyy in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM : 05. |
Select Schools to be Reported for one Sub District. | Select the schools you want to include in the extract for the sub district. Use this field only for Regional School Districts with Sub Districts. Select multiple schools using the command key. Note: If your organization runs a single version of PowerSchool with multiple districts, you must use the Sub-district Configuration option to create the Regional School List displayed on this report interface page. |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Note: MA_WAR is a virtual table where Work Assignment Records are stored in the database. See the Appendix for more information.
Item # | Data Element | Description | [Table]FieldName | Field Type | Field Length |
|---|---|---|---|---|---|
WA01 | MEPID | The MEPID of the staff member. This field is entered on the Edit Information, Start Page > Staff > Select A Staff Member > Edit Information > MEPID Assign Record > SR01 MEPID. | [MA_WAR]WA01 [Teachers]MA_mepid or [S_MA_USR_X]MEPID | Alpha-numeric | 8 |
WA02 | Local Employee Number | The staff member's employee number assigned by the school or district. This field is entered via Start Page > Staff > Select A Staff Member > Edit Information > MEPID Assign Record > ID07 Local Employee Number. | [MA_WAR]WA02 [Teachers]MA_local_employee_num or [S_MA_USR_X]LocalEmpNum | Alpha-numeric | 20 |
WA03 | First Name | The first name of the staff member. This field is entered via Start Page > Staff > Select A Staff Member > Edit Information > Name. | [MA_WAR]WA03 [Teachers]First_Name | Alpha-numeric | 30 |
WA04 | Middle Name/Initial | The middle name of the staff member. This field is entered via Start Page > Staff > Select A Staff Member > Edit Information > Name. | [MA_WAR]WA04 [Teachers]MA_middle_name or [Teachers]Middle_Name | Alpha-numeric | 30 |
WA05 | Last Name | The last name of the staff member. This field is entered via the Start Page > Staff > Select A Staff Member > Edit Information > Name. | [MA_WAR]WA05 [Teachers]Last_Name | Alpha-numeric | 30 |
WA06 | District/School ID | The 8-digit code for the district and school, entered via Start Page > Staff > Select Staff Member > Edit Information > Work Assignment Records > WA06 District/School Identification Number. | [MA_WAR]WA06 | Alpha-numeric | 8 |
WA07 | Job Classification | The job classification code assigned to this staff member, entered via Start Page > Staff > Select A Staff Member > Edit Information > Work Assignment Record > WA07 Job Classification. | [MA_WAR]WA07 | Alpha-numeric | 4 |
WA08 | Teacher/Paraprofessional Assignment | The teacher/paraprofessional assignment associated with this staff member, entered via Start Page > Staff > Select A Staff Member > Edit Information > Work Assignment Record > WA08 Teacher/Paraprofessional Assignment. | [MA_WAR]WA08 | Alpha-numeric | 3 |
WA09 | Grade | The grade level this staff member current teaches, entered via Start Page > Staff > Select A Staff Member > Edit Information > Work Assignment Record > WA09 Grade. | [MA_WAR]WA09 | Alpha-numeric | 4 |
WA10 | Subject Area/Course | The subject area of the courses that the staff member teaches, entered via Start Page > Staff > Select A Staff Member > Edit Information > Work Assignment Record > WA10 Subject Area. | [MA_WAR]WA10 | Alpha-numeric | 7 |
WA11 | Class Section | The class section that the staff member teaches, entered via Start Page, > Staff > Select A Staff Member > Edit Information > Work Assignment Record > WA11 Class Section. | [MA_WAR]WA11 | Alpha-numeric | 20 |
WA12 | Full Time Equivalent (FTE) | The full time equivalency percentage for this staff member, entered via Start Page > Staff > Select A Staff Member > Edit Information > Work Assignment Record > WA12 Full Time Equivalent. | [MA_WAR]WA12 | Numeric | 5 with 3 decimal places |
WA13 | Instructional Paraprofessional Qualification | The instructional paraprofessional qualification of this staff member, entered via Start Page > Staff > Select A Staff Member > Edit Information > Work Assignment Record > WA13 NCLB Instructional Paraprofessional Requirements. | [MA_WAR]WA13 | Alpha-numeric | 2 |
WA14 | Highly Qualified Status | The code identifying the staff member as highly qualified, entered via Start Page > Staff > Select A Staff Member > Edit Information > Work Assignment Record > WA14 Highly Qualified Status. | [MA_WAR]WA14 | Alpha-numeric | 2 |
WA15 | Subject Matter Competency | The staff member's competency in the subject matter taught by that staff member, entered via Start Page > Staff > Select A Staff Member > Edit Information > Work Assignment Record > WA15 Subject Matter Competency. | [MA_WAR]WA15 | Alpha-numeric | 2 |
WA16 | Course Term | The course term assigned to this work assignment. This field is entered via Start Page > Staff > Select A Staff Member > Edit Information > Work Assignment Record > WA16 Course Term. | [MA_WAR]WA16 | Numeric | 2 |
WA17 | Term Status at Time of Data Collection | The code identifying the course term status at the time of data collection. This field is entered via Start Page > Staff > Select A Staff Member > Edit Information > Work Assignment Record > WA17 Term Status at Time of Data Collection. | [MA_WAR]WA17 | Numeric | 2 |