PA PIMS Safe School Reports - Staff Assignments
The default file name for the Safety Staff Assignments file is <Administrative Unit Number>_staff_assignment_<YYYYMMDDhhmm>.csv.
For the latest file layout information, search for and refer to the current file specification documents on the Pennsylvania Department of Education (PDE) website.
The following table shows the columns, data items, descriptions, formats, and data sources or valid values for the Safety Staff Assignments file.
Column | Data Item | Description | Format | Data Source or Valid Values |
---|---|---|---|---|
A | District Code | The unique nine-digit Administrative Unit Number (AUN) assigned by the Pennsylvania Department of Education (PDE). | Numeric(9) | For a list of valid values, refer to the PDE’s Educational Names and Addresses (EdNA) website. Retrieved from the hrmstate.state2 field (first nine characters). |
B | Staff ID | The unique identifier for each staff member. Use the seven-digit Professional Personnel ID (PPID) for all certificated staff and non-certificated staff. For school security personnel who have a PPID, report the PPID. For school security personnel without a PPID, use the 5- or 6-digit Municipal Police Officer Training ID (MPTID) preceded by SS; or if the school security personnel does not have an MPTID, the LEA must assign the individual a unique and consistent 5- or 6-digit ID preceded by SS. For example, SS12345. | Char(7) | Retrieved from the pa_pims_ssassign.empl_no field (preceded by SS). |
C | Assignment Code | The code for the certificated or non-certificated assignment. | Char(4) | The valid value for school security staff is 9998. For a list of valid values, refer to Appendix B - Staff Assignment Codes in the PIMS Manual Vol. 2. Retrieved from the pa_pims_ssassign. code field. |
D | Location Code | The PDE-defined four-digit code identifying the school where the staff member is assigned. | Char(4) | For a list of valid values, refer to the PDE’s Educational Names and Addresses (EdNA) website. Retrieved from the pa_pims_ssassign. location field. |
E | School Year Date | The last day of the current school year, indicating the whole school year. For the 20xx-20yy school year, you should populate this field with 20yy-06-30. | Char(10) | The valid value is “20”,fam_prof.yr,”-06-30”. |
F | Assignment Date | The date the employee started the assignment. If the assignment is a continuation from the previous school year, enter July 1 of the current school year. For staff assignments within the current school year, enter the actual start date of the staff assignment. For school security staff only, you may use 2009-07-01 if the actual start date during the year is unknown. | Char(10) | Retrieved from the pa_pims_ssassign.asn_date field. |
G | Completion Date | The date the employee left a specific assignment to move to another assignment in the same LEA, or the date an employee was terminated from the LEA. This field does not apply to school security staff. | Char(10) | Not Applicable |
H - Q | Not Used | Leave columns H through Q blank. | Not Applicable | Not Applicable |
R | Percent Time Assigned | The actual number of hours worked in a position divided by the maximum number of hours the position allows. The total percent of time for all assignments for the entire school year should equal 100 for full-time staff. Accurate values must be reported for all staff, including school security staff. You should enter an FTE of 90% as 90, not 0.90. | Numeric(3) | Retrieved from the pa_pims_ssassign.fte field. |
S - Y | Not Used | Leave columns S through Y blank. | Not Applicable | Not Applicable |
Z | Primary Assignment Indicator | Indicates whether this is the staff member’s main assignment. | Char(4) | Valid values:
|