USPS Reports Guide –
USPS Reports by Number –
Report 197 Personnel Changes
This report displays all employees who have had any of the following reason codes: 001-003, 008-009, 020-031, A23, 034, and 040-049.
Report Criteria
Category | Personnel Management |
---|---|
Distribution | Agency |
Frequency | Runs with payrolls. |
Form | 111 |
Sort Sequence | Organization Code, Break field set to 0000 on H0XCR |
Page Break | Last two digits of Organization Code. |
Parameters | HNKPM – START DATE, END DATE |
Databases Used | HNK, H0C, H7O, HNH, HID, HML, H0B |
Selection Criteria | Dates on H0CUS screen when it automatically runs with payrolls. |
Produce Output? | Yes |
Request Screen | HSRPT |
Posting Report? | No |
Additional Notes | Agencies will need to send an LOA to setup HPRPT to print with month end reports. |
Report Headings
- FROM/TO HNK.PMSTDT/HNK.PMEDT
- Displays the beginning and ending dates of the reporting period.
- ORG CODE HNH.ORGCODE
- Displays the employee's organization code.
- ORG TITLE HNH.ORGTITLE
- Displays the title of the employee's organization code.
- EMPLOYEE SSN HNH.EMPLOYEENO
- Displays the employee's SSN.
- EMPLOYEE NAME HID.RPTNAME
- Displays the employee's name.
- POSITION HNH.POSITION
- Displays the employee's position number.
- OLD POS # HNH.POSITION
- Displays if the position number changed with the personnel action change processed.
- FTE/PCA
- Displays the full time equivalent and the Program Cost Account (PCA) of the employee. (*Will be generated if change in FTE and footnote will be displayed at the end of organizational total page as: *change in FTE.)
- JOB/FUNC JC HNH.JOBCLASS OR HNH.ACTFUNCLS
- Displays the employee's job class code or functional job class code, if applicable.
- JOB TITLE HML.FCTITLE OR H70.JCTITLE
- Displays the functional job class title corresponding to the position. If no functional job class title was assigned, the job class title will display.
- SAL/HRLY HNH.HSALARY/HNH.HHRLYRATE
- Displays the employee's salary or hourly rate.
- PREV AMT
- Displays the employee's salary/rate prior to the current action.
- CHG AMT
- Displays the pay difference in employee's salary/hourly rate after the personnel change.
- TB/GRP/STP HNH.ACTUALSTEP
- Displays the employee's salary table, pay group and step, if applicable.
- RSN/EXT RC HNH.HRISREASCD
- Displays the HRIS reason code reflecting the type of change, along with the extended reason code, if applicable.
- EFFECT DT HNH.HISTORYDT
- Displays the date of the personnel change.
- ORGANIZATIONAL TOTAL
- Displays the total number of personnel changes within each organization code.
- AGENCY TOTAL
- Displays the agency's total number of personnel changes.
Sample Report
REPORT: 197 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1 AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX PERSONNEL CHANGES RUN TIME: 22:21:21 FROM 06/01/20XX TO 06/30/20XX ORG CODE: 20302030203 WIP SERVICES EMPLOYEE EMPLOYEE POSITION FTE JC/FUNC JC SAL/HRLY PREV AMT TB/GRP/STP RSN/EXT RC SSN NAME OLD POS# PCA JOB TITLE CHG AMT EFFECT DT XXX-XX-XXXX XXXXX, XXX 02030040 1.000 1563/ 3000.00 2333.33 1B/09/ 020/ 01015002 P11100 PROG ADMIN I 666.67 06/21/20XX ORGANIZATIONAL TOTAL = 1