USPS Reports Guide –
USPS Reports by Number –
Report 153 Position Payment Posting Report
This report posts payment expenditures to the position (HNP) row after each final payroll run. The Last Paid Date on HNP is also updated.
Report 911 will recalculate Projected Lapse on each position (HNP) row during Month-End Reports.
Report Criteria
Category | Position Control | ||||
---|---|---|---|---|---|
Distribution | Agency | ||||
Frequency | Runs with final payrolls. | ||||
Form | 111 | ||||
Sort Sequence |
|
||||
Page Break |
|
||||
Parameters | HNKPC – Report 153 - S - Summary Information Only D - Detail Information |
||||
Databases Used | H0H, H0C, HNK, H0M, HNP, HNO, HMP, HNH, HID, HO9 | ||||
Selection Criteria | All positions paid on payroll. | ||||
Produce Output? | Yes | ||||
Request Screen | HPRPT – Set up to run automatically with each final payroll. | ||||
Posting Report? | Yes | ||||
Additional Notes | This report can be requested in summary or detail mode by setting the desired switch on HNKPC. |
Report Headings
- POSITION HMP.POSITION
- The position number.
- POSEFF DT HNP.HISTORY DT
- The position effective date.
- NAME HID.RPTNAME
- Displays the employee's name.
- SSN HOH.EMPLOYEENO
- The employee number or social security number.
- ACTUAL H0H.REG + H0H.VACATION + H0H.SICK
- Displays the total of regular, vacation, and sick pay posted.
- OT H0H.OTIME1
- Displays the total of overtime pay posted.
- LUMPSUM H0M.SPECPAY(18,19,20)
- Displays the total of lump sum pay posted.
- LONG H0M.SPECPAY(06)
- Displays the total of longevity pay posted.
- HAZ DUTY H0M.SPECPAY(05)
- Displays the total of hazardous duty pay posted.
- BONUS H0M.SPECPAY(16,22,24,72)
- Displays the total of bonus pay posted.
- ADD'L PAY H0M.SPECPAY(42,46,54,56,58,66,68,76,78,82,84)
- Displays the total of additional pay posted.
- UPD LST PAY DT DERIVED
- Values are Y (for yes) or N (for no) indicating whether the transactions posted
To pay history required an update to the last pay date field on the position record. - PY PERIOD END DT HOH.PERIODEND
- The Pay Period End Date posted to pay history.
- ORG TOTALS DERIVED
- Displays the total amount of updates separated by pay type for the organization code.
- NUMBER OF UPDATES FOR ORG DERIVED
- Displays the number of positions updated within the organization code.
Note: Multiple transactions using the same position number is counted as one update. For example, a cancellation and a reissue would be one update.
- DIVISION TOTALS DERIVED
- Displays the total amount of updates separated by pay type for the division.
- NUMBER OF UDATES FOR DIVISION DERIVED
- Displays the number of positions updated within the division.
- AGENCY TOTALS DERIVED
- Displays the total amount of updates separated by pay type for the agency.
- NUMBER OF UPDATES FOR AGENCY DERIVED
- Displays the number of positions updated within the agency.
Sample Report
REPORT: 153 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 4 AGENCY: XXX XXXXXXXXX XXXXXXXXXXXXXX XXXXXX RUN DATE: XX/XX/20XX POSITION PAYMENT POSTING REPORT RUN TIME: 16:44:09 PAYROLL RUN DATE: XX/XX/20XX POSITION POS EFF DT ACTUAL OT LUMPSUM LONG HAZ DUTY BONUS ADD'L PAY UPD LST PY PERIOD END DT NAME SSN 000000236 09/01/20XX 10,331.45 0.00 0.00 140.00 0.00 0.00 0.00 N 02/28/20XX XXXXXXX, XXXXXX X XXX-XX-XXXX 000000027 09/01/20XX 4,822.94 0.00 0.00 140.00 0.00 0.00 0.00 N 02/28/20XX XXXXXXX, XXXXXX X XXX-XX-XXXX ORG TOTALS 00001F00000 COMMUNICATIONS 15,154.35 NUMBER OF UPDATES FOR ORG 2
REPORT: 153 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 4 AGENCY: XXX XXXXXXXXX XXXXXXXXXXXXXX XXXXXX RUN DATE: XX/XX/20XX POSITION PAYMENT POSTING REPORT RUN TIME: 16:44:09 PAYROLL RUN DATE: XX/XX/20XX ACTUAL OT LUMPSUM LONG HAZ DUTY BONUS ADD'L PAY UPD LST PY PERIOD END DT ORG TOTALS 00001F00000 COMMUNICATIONS 1,309.11 0.00 0.00 0.00 0.00 0.00 0.00 N 02/28/20XX 0NUMBER OF UPDATES FOR ORG 1 ORG TOTALS 00006C00000 INFORMATION SYSTEMS SUPPORT 3,520.87 0.00 0.00 0.00 0.00 0.00 0.00 N 02/28/20XX NUMBER OF UPDATES FOR ORG 1 ORG TOTALS 00007P00000 SECURITY & SAFETY 2,963.58 0.00 0.00 0.00 0.00 0.00 0.00 N 02/28/20XX NUMBER OF UPDATES FOR ORG 4 DIVISION TOTALS 000 7,793.56 0.00 0.00 0.00 0.00 0.00 0.00 Y 01/31/20XX NUMBER OF UPDATES FOR DIVISION 6 AGENCY TOTALS BONUS ADD'L PAY 7,793.56 0.00 0.00 0.00 0.00 0.00 0 .00 N 02/28/20XX