Staff Assignment Template (EWS)
Contents
Introduction
This template will be used to designate staff assignments. There is no limit to the number of staff assignments that can be included here. Please include all assignments for each staff member.
Assignments should exist for all staff included on the Staff Snapshot Template. Include substitutes ONLY where filling a vacancy or where the instructor will be granted access to the Educator Dashboard application.
Staff assignments in the Dashboard application are location specific, if a staff members works at multiple locations they must have an assignment record at each location where they will be granted access to class sections or cohort groups.
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 report selects records from the S_PA_SSF_Staff_Assign_C based on the following criteria:
- One record per District Code / Staff ID / Location Code / Assignment Code
- Staff must not be excluded from EWS Reporting.
- Must have the same School Year Date in the Assignment record that is specified when running the report, e.g. 2016-06-30
- Based on the Report Start Date, the report will include staff who have NO exit date or the exit date is Later than or equal to this date.
- Based on the Report End Date, the report will include staff who have NO Current Service Date or Current Service Date is EARLIER than or equal to this date.
- The Assignment Date and Completion Date do not need to fall within the selected School Year.
Report Input
For help with report navigation and generation, see How to Find and Generate a Report.
Field | Description |
Schools to Include* | Indicate which schools to include in the report by selecting from the following options: If sub-districts are not enabled:
If sub-districts are enabled:
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. |
Report Start Date* | Enter the start date using the format mm/dd/yyyy for the first day of the reporting period. |
Report End Date* | Enter the end date using the format mm/dd/yyyy for the last day of the reporting period. |
Last Submission Date* | Enter the last submission date using the format mm/dd/yyyy. |
Field Delimiter | Choose the field delimiter for the extract file from the pop-up menu. |
Include Header Labels in output file? | Choose Yes or No to indicate whether to include column headings in the extract file. Including column headers provides a heading for each type of data extracted in the report. |
Scheduling | Select when to run the report.
|
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.
Item # | Data Element | Description | [Table]FieldName | Field Type | Req’d |
1 | DISTRICT CODE | The unique, 9-digit Administrative Unit Number (AUN) assigned by the Pennsylvania Department of Education. For the list of all LEA and School codes, visit the Pennsylvania Department of Education's wesite. | [Prefs]District_Number If subdistricts are configured: | Numeric | R |
2 | STAFF ID | A unique identifier for each staff member; use the 7-digit Professional personnel ID (State_Staff_ID) for all certificated staff and non-certificated staff. Use the 5-digit Municipal Police Officer Training ID (MPTID) for school security staff preceded by SS. The Staff ID must be consistent in all templates. Note: Do not use leading zeros or spaces in PPIDs. | [S_PA_USR_X]State_Staff_ID | Numeric | R |
3 | ASSIGNMENT CODE | Code for the certificated or non-certificated assignment. Valid Values: See the full list of Staff Assignment Codes in Appendix H in Volume 2 of the EWS User Manual. | [S_PA_SSF_Staff_Assign_C]Assignment_Code | Numeric | R |
4 | LOCATION CODE | The PDE-defined, 4-digit code identifying the school. For the list of all LEA and School codes, visit the Pennsylvania Department of Education's wesite. | [Schools]School_Number If sub-districts are enabled: [CST_SchoolSubDistricts]SchoolID | Numeric | R |
5 | SCHOOL YEAR DATE | A single date indicating the whole school year. June 30, at the end of the standard school year, is used to designate a school year. Thus, the 2019-2020 school year would be indicated by 2020-06-30. | [Terms] static value based on the current year | Date | R |
6 | ASSIGNMENT DATE | The date an employee began a specific assignment. If the assignment is a continuation from the previous school year, enter the actual date the employee began an assignment. For staff assignments within the current school year, enter the actual start date of the staff assignment. For school security only, you may use 2015-07-01 if the actual start date is unknown. | [S_PA_SSF_Staff_Assign_C]Assignment_Date | Date | R |
7 | COMPLETION DATE | Assignment exit date - the date an employee left a specific assignment to move to another assignment in the same LEA, or the date an employee was terminated from the LEA. Note: This field does not apply to school security staff. | [S_PA_SSF_Staff_Assign_C]Completion_Date | Date | R |
12 | ASSIGNMENT PROGRAMS CODE | The name of the program for which the individual is assigned. Valid Values:
| [S_PA_SSF_Staff_Assign_C] EWS_Assignment_Programs_Code | Numeric | R |
25 | ASSIGNMENT TITLE | Description of the staff member’s assignment. | [S_PA_SSF_Staff_Assign_C]EWS_Assignment_Title | AlphaNumeric | O |
