Staff Assignment Template - RE
Contents
Introduction
This report is used to track point-in-time information on staff assignments. One record is reported for each assignment and assigned to staff members. Create work assignment records in PowerSchool via Start Page > Staff > Select a Staff Member > Edit Information > Staff Assignment Template Record.
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.
- The staff member must be enrolled in a school that the report is run for.
- The staff member cannot be excluded from state reporting.
- The staff member must be in a school building that is included in state reports.
The staff/teachers 'School Year Date' data element must reconcile with the 'School Year' option on the report submission page.
Report Input
For help with report generation and navigation, 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:
|
Report End Date | From the pop-up option list, choose the school year that you running the report for. |
Field Delimiter | Select the field delimiter for the extract file. |
Show Column Field Headers | 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. |
Run From Extract Viewer | Choose one of the following from the pop-up menu:
Note: Use the extract viewer to view and edit records before submitting the file to the state. |
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 | Field Length |
1 | District Code | The unique 9-digit Administrative Unit Number assigned by the PDE. This field is extracted from Start Page > District Setup > District Information. | [Prefs]Value where [Prefs]Name=PA_districtAUN If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number | Alpha-numeric | 9 |
2 | Staff Id | The staff member’s 7-digit PPID. This field is extracted from Start Page > Staff Selection > Edit Information > Staff Template and Staff Snapshot Record. This value should not be entered for non-certified staff. If the value is blank, then the staff member’s social security number is reported. | [Users]state_teachernumber [Users]SSN | Alpha-numeric | 9 |
3 | Assignment Code | The staff member’s certificated assignment or non-certificated assignment. This field is extracted from Start Page > Staff Selection > Edit Information > Staff Assignment Template Record. | [S_PA_SSF_Staff_Assign_C]Assignment_Code | Alpha-numeric | 4 |
4 | Location Code | The 4-digit PDE defined school number. This field is extracted from the Location Code in the Staff Assignment record. If that field is blank, then the PIMS location code on the Edit School page at the district is extracted. If that field is blank as well, then the school number is reported. | [S_PA_SSF_Staff_Assign_C]location_Code [S_PA_SCH_X]PIMS_Location_Code [Schools]School_Number If sub-districts are enabled: [CST_SchoolSubDistricts]SchoolID | Alpha-numeric | 4 |
5 | School Year Date | The 10-digit school year date. This field is extracted from Start Page > Staff Selection > Edit Information > Staff Assignment Template Record. | [S_PA_SSF_Staff_Assign_C]School_Year_Date | Numeric | 10 |
6 | Assignment Date | The standard reporting date as of which the assignment is valid. | [S_PA_SSF_Staff_Assign_C]Assignment_Date | Numeric | 10 |
7 | Completion Date | The assignment exit date. This field is extracted from Start Page > Staff Selection > Edit Information > Staff Assignment Template Record. | [S_PA_SSF_Staff_Assign_C]Completion_Date | Numeric | 10 |
8 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
9 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
10 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
11 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
12 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
13 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
14 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
15 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
16 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
17 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
18 | Percent Time Assigned | The ratio between the hours of work expected in the staff member’s position and the hours of work normally expected in a full-time position in the same setting. This field is extracted from Start Page > Staff Selection > Edit Information > Staff Assignment Template Record. | [S_PA_SSF_Staff_Assign_C]Percent_Time_Assign | Numeric | 4 |
19 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
20 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |