Skip to content

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
Options HPRLA
Sort
Org Code, Emp SSN, Payment Date, Check Sequence 1
Org Code, Name, Payment Date, Check Sequence 2
Page Break
Options HPRLA
Break
None N
Org Code Y
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.
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.

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