USPS Reports Guide –
USPS Reports by Number –
Report 557 Leave Payment Audit
The report automatically updates or inserts overtime paid (OTP), compensatory time paid (CTP), compensatory disaster paid (CDP), compensatory emergency paid (CEP), and leave without pay docked (LWD) transactions on HM9U1 based on payroll history (H0HHP and H0MSP). All OTP, CTP, CDP, CEP, and LWD entries on HM9U1 with a status (ST) of G (Generated) will be compared to the transactions found in history. Those with the same number of hours and a leave Start Date that falls within the pay period range will have the ST changed to a $. If an entry is not found that matches, then one will be inserted and the word PAID written to the HM9 REASN field. A list of these transactions will display on the report.
The report recognizes negative payment adjustments on H0H records and updates the corresponding HM9U1 record appropriately. If an HM9 transaction is found that has the same number of hours and a leave Start Date that falls within the pay period range, the status of the transaction will be changed from $ back to G to properly reflect the payment reversal. If Report 557 originally inserted the HM9 paid transaction, it will completely delete that transaction if it finds a related payment reversal. A list of all transactions that take place during the run will display on the report.
A new date field has been added to the Leave Summary Messages (HNKLM) screen. The field displays the system date when Report 557 was last run. This date is used to identify the H0H payments and negative adjustments that will be picked up on the subsequent run of Report 557.
Report 594 has been designed to work in conjunction with this process. It creates the payroll batch transactions from HM9U1 that are used to pay or dock the employee.
An August leave transaction must be paid with an August warrant date prior to leave accounting rollover in order for this report to update HM9.
Report 595 can also be run to determine if there are any remaining OTP, CTP, CDP, CEP or LWD transactions with a value of G in the status indicator field on HM9U1.
Report Criteria
Category | Leave Accounting | ||||||
---|---|---|---|---|---|---|---|
Distribution | Agency | ||||||
Frequency | Monthly | ||||||
Form | |||||||
Sort Sequence |
|
||||||
Page Break |
|
||||||
Parameters |
|
||||||
Databases Used | H0C, H0H, H0M, HID, HM8, HM9, HNK, HPR | ||||||
Selection Criteria | All payment records within the LA WARRANT START and LA END DATE; HM9 entries with a status of G. | ||||||
Produce Output? | Yes | ||||||
Request Screen | HNKLA | ||||||
Posting Report? | Yes – Updates HM9U1 | ||||||
Additional Notes | Online edit on HNKLA that prevents entry of WARRANT START and WARRANT END date for different fiscal years has been removed. This allows agencies to include warrant dates on Report 557 that cross fiscal years. The Leave Report Options (HPRLA) screen can be used to mask the Social Security number (SSN) and to select a valid sort and/or page break option. |
Report Headings
- WARRANTS FROM/THRU HNK.LAWARRST/HNK.LAWARREND
- Displays the beginning and ending warrant dates of the request period.
- ORGANIZATION HNH.ORGCODE
- Displays the employee's organization code.
- EMP SSN H0H.EMPLOYEENO
- Displays the employee's SSN (masked or entire SSN will display depending on the HPRLA selection).
- EMPLOYEE NAME HID.RPTNAME
- Displays the employee's name.
- ACTY HM9.LVTYPE and HM9.LVACTYCD
- Displays the leave accounting activity code for the leave paid or docked.
CDP Compensatory disaster paid CEP Compensatory emergency paid CTP Compensatory time paid OTP Overtime paid LWD Leave without pay dock - STAT HM9.LVACTYSTAT
- Displays a $ to indicate the entry was actually paid or docked on a payroll.
- START DATE HM9.STARTDT
- Displays the start date for the leave paid or docked or the first date of the request period, if this report generated the entry.
- START TIME HM9.STARTTM
- Displays the start for the leave paid or docked.
- HOURS HM9.LVTIME
- Displays the number of hours of the leave paid or docked.
- REASON HM9.LVREASCD
- Displays the reason code for the leave paid or docked.
- PAID
Displays when a new entry on HM9U1 is created.
- PAID
- MESSAGE GENERATED
- Displays the result of the payment audit.
- HM9 INSERTED - VERIFY
No match was found on HM9U1, so an entry was created to match the payroll payment. - MATCH FOUND B/T HOH AND HM9
A match was found between HM9U1 and HOHHP for the payment dock. - MATCH FOUND B/T HOM AND HM9
A match was found between HM9U1 and HOMSP for the payment or dock. - PMT CANCELLED - $ RESET TO G
An HM9 transaction status updated with a $ by Report 557 was changed back to G because payment was cancelled/reversed. - HM9 DELETED - BALANCE RESTORED
An HM9 transaction created by Report 557 was deleted and the HM8 balance restored.
- HM9 INSERTED - VERIFY
Sample Report
REPORT: 557 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1 AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX LEAVE PAYMENT AUDIT REPORT RUN TIME: 07:29:19 WARRANTS FROM 10/04/20XX THRU 10/08/20XX START ORGANIZATION EMP SSN EMPLOYEE NAME ACTY STAT START DATE TIME HOURS REASON MESSAGE 00000600300 XXX-XX-XXXX XXXXXXXXX, XXXXXX X OT P $ 09/01/20XX 00:01 6:00 PAID HM9 INSERTED-VERIFY XXX-XX-XXXX XXXXXXXXX, XXXXXX X CT P $ 09/01/20XX 00:02 5:00 PAID HM9 INSERTED-VERIFY XXX-XX-XXXX XXXXXXXXX, XXXXXX X CT P $ 09/01/20XX 00:02 5:00- HM9 DELETED-BALANCE RESTORED XXX-XX-XXXX XXXXXXXXX, XXXXXX X OT P $ 09/01/20XX 00:01 6:00- HM9 DELETED-BALANCE RESTORED XXX-XX-XXXX XXXXXXXXX, XXXXXX X OT P $ 09/01/20XX 00:01 8:00 PAID HM9 INSERTED-VERIFY XXX-XX-XXXX XXXXXXXXX, XXXXXX X CT P $ 09/01/20XX 00:02 6:00 PAID HM9 INSERTED-VERIFY XXX-XX-XXXX XXXXXXXXX, XXXXXX X OT P $ 09/15/20XX 00:03 4:00 PAID HM9 INSERTED-VERIFY XXX-XX-XXXX XXXXXXXXX, XXXXXX X CT P $ 09/15/20XX 00:04 4:00 PAID HM9 INSERTED-VERIFY YYY-YY-YYYY YYYYY, YYYYY Y LW D $ 09/01/20XX 00:02 6:00 PAID HM9 INSERTED-VERIFY YYY-YY-YYYY YYYYY, YYYYY Y LW D $ 09/01/20XX 00:04 6:00- HM9 DELETED-BALANCE RESTORED 00000600400 ZZZ-ZZ-ZZZZ ZZZZZ, ZZZZ ZZZZZZ LW D $ 09/01/20XX 00:02 6:00 PAID HM9 INSERTED-VERIFY ZZZ-ZZ-ZZZZ ZZZZZ, ZZZZ ZZZZZZ LW D $ 09/01/20XX 00:05 6:00- HM9 DELETED-BALANCE RESTORED ZZZ-ZZ-ZZZZ ZZZZZ, ZZZZ ZZZZZZ LW D $ 09/01/20XX 00:02 6:00 PAID HM9 INSERTED-VERIFY 00000601400 AAA-AA-AAAA AAAA, AAAAAAA A CT P $ 09/01/20XX 00:02 6:00 PAID HM9 INSERTED-VERIFY AAA-AA-AAAA AAAA, AAAAAAA A OT P $ 09/01/20XX 00:01 3:00 PAID HM9 INSERTED-VERIFY AAA-AA-AAAA AAAA, AAAAAAA A OT P $ 09/01/20XX 00:01 3:00- HM9 DELETED-BALANCE RESTORED AAA-AA-AAAA AAAA, AAAAAAA A CT P $ 09/01/20XX 00:02 6:00- HM9 DELETED-BALANCE RESTORED AAA-AA-AAAA AAAA, AAAAAAA A CT P $ 09/01/20XX 00:02 13:00 PAID HM9 INSERTED-VERIFY AAA-AA-AAAA AAAA, AAAAAAA A OT P $ 09/01/20XX 00:01 7:00 PAID HM9 INSERTED-VERIFY