PA PIMS Report - Maintain Data - Position Information

The following table describes the fields on the Position Information tab of the PA PIMS Report - Employee Information page.

Field	Description	Load logic - Data source and Valid values
Staff Type	The employee's staff type.	Valid values: F - Full Time P - Part Time The field value is retrieved from the Part Time Status field on the Personnel tab of the Employee Information page. This field value overrides the Part Time Status field value on the Personnel tab of the Employee Information page.
Current Service Date	The employee's hire date for the position.	The field value is retrieved from the Hire Date field on the Employment tab of the Employee Information page. This field value overrides the Hire Date field value on the Employment tab of the Employee Information page.
Exit Date	The employee's last working day.	The field value is retrieved from the Term Date field on the Payroll Information - State Required page. If the Term Date field on the Payroll Information - State Required page is blank, the field value is retrieved from the Last Day Worked field on the Terminate Employee page. This field value overrides the Term Date and Last Day Worked field values.
Salary	The employee's annual salary. Secondary rates defined on the PA PIMS Report - Setup page will be added to the primary.	Calculated during the data load process. The calculated value represents the employee's annual salary, determined through the following logic: The system first retrieves the employee's primary payrate annual salary (payrate.annl_sal where primary = 'P'). If PIMS pay codes are defined in the pa_pims_codes table, the system sums all additional active payrates where the pay code matches the PIMS codes and primary <> 'P'. The total salary equals the primary payrate plus the sum of all additional matching pay rates. If the employee has a termination date, the salary is set to 0. The system can also use the override value from the Annual Salary field on the Payroll Information - State Required page, if populated. This field value overrides the Annual Salary field on the Payroll Information - State Required page.
Active/Inactive Indicator	Indicates if the employee is active or inactive.	Calculated during the data load process. The calculated value represents the employee's active/inactive status using Pennsylvania state codes, determined through the following logic: The system first queries person.status and joins with the user_ref table (where the prefix is "AI") to retrieve the state code description. The value is then validated against acceptable codes: A (Active) T (Terminated) H (Charter School) M (Military Leave) S (Sabbatical Leave) U (Suspension) W (Workers' Compensation) O (Other) If the value is invalid or null, the system applies defaulting logic: If the employee has a termination date, the value defaults to "T" (Terminated). If no termination date exists, the value defaults to "A" (Active). Additional validation ensures that if the status is "T" but no termination date exists, the status is changed to "A". This field value overrides the calculated field value. The values in the drop-down list are retrieved from the user-defined table AI.
Employee Positions	Displays the PA PIMS Report - Employee Positions page.	Not applicable
Term Code	The employee's termination code.	Calculated during the data load process. The calculated value represents the Pennsylvania state termination code, determined through the following logic: This field is only populated if the employee has a termination date. The system first checks if the Term Code field on the Payroll Information - State Required page contains a local termination code. If not found, it uses the Termination Code field value from the Terminate Employee page. The local termination code is then looked up in the tertable to retrieve the corresponding state_term_code. This field value overrides the Term Code and Termination Code field values. The values in the drop-down list are retrieved from the user-defined table AO.
Employment Basis	The employee's PIMS employment basis.	Valid values: CP - College Professor NTPE - Non-teaching Professional Employee PE - Teaching Professional Employee PPE - Professional Principal Employee SC - Subcontracted Employee SP - Substitute other than Professional or Temporary Professional SPE - Substitute TPE - Temporary Professional Employee The field value is retrieved from the Emplymnt Basis field on the Payroll Information - State Required page. This field value overrides the Emplymnt Basis field value on the Payroll Information - State Required page.
Total Years Experience	The employee's total years of experience.	Calculated during the data load process. The calculated value represents the employee's total years of experience in education, determined through the following logic: The system retrieves the value from the Years in Total field on the Employment tab of the Employee Information page. If the value equals 0, it is automatically adjusted to 1 (minimum one year of experience). This field value overrides the Years in Total field value on the Employment tab of the Employee Information page.
Years Experience District	The employee's total years of experience within the school district.	Calculated during the data load process. The calculated value represents the employee's years of experience within the current school district, determined through the following logic: The system retrieves the value from the Years in State field on the Employment tab of the Employee Information page. If the value equals 0, it is automatically adjusted to 1 (the minimum of one year). This field value overrides the Years in State field on the Employment tab of the Employee Information page.
Local Contract	Indicates if the employee has a current contract.	Calculated during the data load process. The calculated value represents whether the employee has a current local contract, determined through the following logic: This field is only calculated if the Local Contract option on the PA PIMS Report - PIMS Load page is selected. If the Local Contract option on the PA PIMS Report - PIMS Load page is selected, the system checks the Local Contract field on the Payroll Information - State Required page: If the first character equals "N", local_contract is set to "N". Otherwise, local_contract is set to "Y". If the Local Contract option on the PA PIMS Report - PIMS Load page is not selected, all employees get local_contract set to "N". This field value overrides the calculated field value.

Employee Positions

The PA PIMS Report - Employee Positions page is displayed when you select Employee Positions. Use this page to manage the specific position/assignment details that are separate from the general employee demographic and position information.

An employee can have multiple assignment records if they work in different positions, locations, or have split assignments. The combination of all assignments should accurately represent the employee's total workload and FTE allocation.

The following table describes the fields on the PA PIMS Report - Employee Positions page.

Field	Description	Load logic - Data source and Valid values
Report Date	The date on which the PIMS data is being reported to the state. This is the snapshot date that determines which employee and assignment information is included in the report. This field is view-only.	The field value is retrieved from the Report Date field on the Demographic Information tab on the PA PIMS Report - Employee Information page.
School ID	The state-assigned location code (building/school identifier) where the employee is assigned for this particular position. Allows tracking of employees who work across multiple school locations within the district.	The field value is retrieved by looking up the state location code from the position's location.
Code	The PDE (Pennsylvania Department of Education) Assignment Code that identifies the specific type of position or role the employee holds. This is a state-defined classification code used for standardized reporting of staff assignments (e.g., teacher, counselor, administrator).	The field value is retrieved from the user-defined assignment field (first four characters). For a list of valid values, refer to Appendix B - Staff Assignment Codes 2025-2026.xlsx on the Pennsylvania Department of Education (PDE) website.
FTE	The employee’s Full Time Equivalency, representing the percentage of a full-time position that this assignment represents. The FTE is expressed as a decimal value between 0 and 1. For example: 1.0 = 100% full-time position 0.5 = 50% or half-time position 0.25 = 25% or quarter-time position	The field value is retrieved from the position payrate table.
Start Date	The date when the employee began working in this specific assignment/position. This may differ from the employee's overall hire date if they changed positions or were reassigned during their employment.	Calculated during the data load process, using hierarchical business logic.
Completion Date	The date when the employee's assignment in this position ended (if applicable). This field: remains blank/null for current, ongoing assignments. is used to track historical assignments and position changes.	The field value is retrieved from the position history end date.
Primary Assignment Indicator	Indicates which assignment is the employee's primary or main position when they hold multiple assignments. Only one assignment per employee should be marked as the primary one. This is typically the assignment with the highest FTE and is used for primary reporting purposes when the employee works in multiple positions or locations.	Calculated during the data load process, based on payrate status and FTE comparison.