Classic View: PA State Reporting > PIMS Extracts > Staff Assignment Template
Search Terms: PIMS Extracts
The Staff Assignment Template reports each staff member who is actively employed on the Reporting Date entered on the extract editor. There is no limit to the number of staff assignments that can be reported.
See the PIMS Reporting article for additional PIMS Reporting information.
Report Logic
- When the Exclude checkbox is marked on the District Assignment tab, the staff person does not report.
- For the October reporting period, when the District Employment Qualification field on the District Employment editor is populated, the staff person does not report.
- For the June reporting period, all current staff reporting, including those with the District Employment Qualification field populated.
Generate the Staff Assignment Template
- Select Staff Assignment Template from the Extract Type from the dropdown list.
- Select the desired Reporting Period.
- Enter the Effective Date of the extract in mmddyy format or use the calendar icon to select a date.
- Select the Format of the extract.
- Optional: Mark the FTE Whole Numbers checkbox.
- Optional: Mark the Terminated Staff checkbox.
- Optional: Mark the Terminated PIL Staff checkbox.
- Optional: Select a Staff Ad hoc Filter.
- Select the appropriate Calendar(s) from which to include data on the extract.
- Click the Generate Extract button or the Submit to Batch button, when available. The extract displays in the selected format.
Staff Assignment Template, HTML Format
Staff Assignment Template, CSV Format
Report Layout
| Data Element | Description | Campus Interface |
|---|---|---|
| District Code | State District Number. Reports the district number of the reporting school unless there is a different district located in the Serving District field. Numeric, 9 digits | System Administration > Resources > District Information > State District Number Student Information > General > Enrollments > State Reporting Fields > Serving District District.number |
| Staff ID | Reports the staff person's state-assigned identification number. For the October reporting period, staff who have the District Employment Qualification field populated do not report. This field reports from the Staff State ID field. For the June reporting period, all current staff report, including those with the District Employment Qualification field populated.
Numeric, 9 digits | Census > People > Demographics > Person Identifiers > Staff State ID Census > People > District Employment > License Number Identity.staffID Employment.licenseNumber |
| Assignment Code | Reports the assigned Assignment Code of the staff person. Numeric, 4 digits | Census > People > District Assignments > Assignment Code EmploymentAssignment.assignmentCode |
| Location Code | State School Number of the reporting school. This code reports from the Alt School Number field on the School editor. When that field is not populated, the State School Number field on the School editor is used. Numeric, 4 digits | System Administration > Resources > School > Alt School Number, State School Number School.altNumber School.number |
| School Year Start Date | Reports June 30 of the reporting year. Date Field, 10 characters, YYYY-06-30 | System Administration > Calendar > Calendar > Calendar Info > End Date Calendar.endDate |
| Assignment Date | Reports the staff person's start date of the district assignment. When the assignment is a continuation from the previous school year, the actual date the employee began the assignment reports. For staff assignments within the current school year, the actual start date of the staff assignment is used. Date field, 10 characters, YYYY-MM-DD | Census > People > District Assignment > Start Date EmploymentAssignment.startDate |
| Completion Date | Reports the date the staff person ended the district assignment. Date field, 10 characters, YYYY-MM-DD | Census > People > District Assignment > End Date EmploymentAssignment.endDate |
| Filler Field 8-17 | These fields report blank. | N/A |
| Percent Time Assigned | Reports the staff person's FTE as a percentage. When the FTE Whole Numbers checkbox is marked, this field reports the FTE as a whole number instead of a percentage. Numeric, 4 digits | Census > People > District Assignment > FTE of Assignment EmploymentAssignment.fte |
| Filler Field 19-25 | These fields report blank. | N/A |
| Primary Assignment Indicator | Indicates whether the assignment is the staff member's main assignments. Alphanumeric, 1 character, Y or N | Census > People > District Assignments > Employment Assignment Detail > Primary District Assignment DistrictAssignment.primary |
Previous Versions
PIMS Staff Assignment Template (Pennsylvania) [.2327 and previous]
