PA PIMS Report - Staff Assignments
The default file name for the Staff Assignment File is <Administrative Unit Number>_staff_assignment_<YYYYMMDDhhmm>.csv.
The following table shows the columns, data items, descriptions, formats, and data sources or valid values for the Staff Assignment file.
Column | Data Item | Description | Format | Location |
|---|---|---|---|---|
A | District Code | The unique, nine-digit Administrative Unit Number (AUN) assigned by the Pennsylvania Department of Education (PDE). | Numeric(9) | hrmstate.state2 (first nine characters) |
B | Staff ID | A unique identifier for each staff member. Use the seven-digit Professional Personnel ID (PPID) for all certified and non-certified staff. Do not use leading zeros or spaces. | Numeric(7) | pa_pims_assignment.ppid |
C | Assignment Code | Code for the certified or non-certified assignment. | Char(4) | pa_pims_assignment.code |
D | Location Code | The PDE-defined, four-digit school code identifying the staff member's primary school of employment. | pa_pims_assignment.location | |
E | School Year Date | For the 20xx-20yy school year, you should populate this field with 20yy-06-30. The format is YYYY-MM-DD | Char(10) | “20”,fam_prof.yr,”-06-30” |
F | Assignment Date | If the assignment is a continuation of the previous school year, enter the date the employee began the assignment. For staff assignments within the current school year, enter the actual start date of the staff assignment. The format is YYYY-MM-DD | Char(10) | pa_pims_assignment.asn_date |
G | Completion Date | Assignment exit date or the date an employee left a specific assignment to move to another assignment in the same Local Education Agency (LEA), or the date an employee was terminated from the LEA. The format is YYYY-MM-DD. | Char(10) | pa_pims_assignment.comp_date |
H | Not Used | Not Applicable | Not Applicable | Not Applicable |
I | Not Used | Not Applicable | Not Applicable | Not Applicable |
J | Not Used | Not Applicable | Not Applicable | Not Applicable |
K | Not Used | Not Applicable | Not Applicable | Not Applicable |
L | Not Used | Not Applicable | Not Applicable | Not Applicable |
M | Not Used | Not Applicable | Not Applicable | Not Applicable |
N | Not Used | Not Applicable | Not Applicable | Not Applicable |
O | Not Used | Not Applicable | Not Applicable | Not Applicable |
P | Not Used | Not Applicable | Not Applicable | Not Applicable |
Q | Not Used | Not Applicable | 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. For example, you should enter a Full-Time Equivalent (FTE) of 90% as 90, not 0.90. | Numeric(3) | pa_pims_assignment.fte * 100 |
S | Not Used | Not Applicable | Not Applicable | Not Applicable |
T | Not Used | Not Applicable | Not Applicable | Not Applicable |
U | Not Used | Not Applicable | Not Applicable | Not Applicable |
V | Not Used | Not Applicable | Not Applicable | Not Applicable |
W | Not Used | Not Applicable | Not Applicable | Not Applicable |
X | Not Used | Not Applicable | Not Applicable | Not Applicable |
Y | Not Used | Not Applicable | Not Applicable | Not Applicable |
Z | Primary Assignment | The primary assignment indicator for each position. | Char(1) | pa_pims_assignment.primary_asn |