USPS Reports Guide –
USPS Reports by Number –
Report 594 Payroll Transactions Generated
Note: If you are running Report 594 for the first time, it is important that you contact your USPS representative.
This report automatically generates payroll batch transactions based on overtime paid (OTP), compensatory time paid (CTP), compensatory disaster paid (CDP), compensatory emergency paid (CEP), and leave without pay (LWD) entries made on HM9U1. Batch transactions will be made based on the following chart.
| HUEU1 | 9012 | Full/Part Time | CDP/CEP | Monthly |
|---|---|---|---|---|
| HUEU1 | 9013 | Full/Part Time | CDP/CEP | Semi-Monthly |
| HUAU1 | 9000 | Full Time | CTP | Monthly |
| HUAU1 | 9001 | Full Time | CTP | Semi-Monthly |
| HUAU1 | 9004 | Full Time | OTP | Monthly |
| HUAU1 | 9005 | Full Time | OTP | Semi-Monthly |
| HUAU1 | 9006 | Part Time | CTP | Monthly |
| HUAU1 | 9007 | Part Time | CTP | Semi-Monthly |
| HUAU1 | 9010 | Part Time | OTP | Monthly |
| HUAU1 | 9011 | Part Time | OTP | Semi-Monthly |
| HUEU1 | 9002 | Full Time | LWD | Monthly |
| HUEU1 | 9003 | Full Time | LWD | Semi-Monthly |
| HUEU1 | 9008 | Part Time | LWD | Monthly |
| HUEU1 | 9009 | Part Time | LWD | Semi-Monthly |
The information used in these transactions, such as labor code and position number, is taken from the employee's primary assignment. Hours and dates are taken from the HM9U1 entry and the calculation is based on non-banked time. If a different value is desired, the transaction can be manually adjusted on the batch. These batches must be released by the agency before the payroll will be affected.
A list of these transactions will display on the report.
The ST indicator on HM9U1 will be updated when these transactions are generated. This field will change from a P (posted) to a G (generated). After these transactions are processed through payroll, Report 557 should be requested to change the G to a $ to indicate that the transaction has been completed.
Report Criteria
| Category | Leave Accounting | ||||||
|---|---|---|---|---|---|---|---|
| Distribution | Agency | ||||||
| Frequency | Upon Request | ||||||
| Form | |||||||
| Sort Sequence |
|
||||||
| Page Break | |||||||
| Parameters | HNKLA – LA PROCESS DATE (last day of the month) HPRLA – SSN MASK, SORT |
||||||
| Databases Used | H0B, H0C, H7O, HID, HM9, HNH, HNK, HRS, HUA, HUE, HPR | ||||||
| Selection Criteria | All OTP, CTP, CDP, CEP, and LWD transactions with a status of P and a START DATE less than or equal to the LA PROCESS DATE. | ||||||
| Produce Output? | Yes | ||||||
| Request Screen | HNKLA | ||||||
| Posting Report? | Yes – creates payroll batches | ||||||
| Additional Notes | This report can be requested as many times as needed. Additional transactions will be added to the existing batches unless the batch has been released, at which time the transaction would error. Entries can not be added to a batch that has been released and is pending a payroll run; however, a manual entry can be made directly online. The Leave Report Options (HPRLA) screen can be used to mask the Social Security number (SSN) and to select a valid sort option. |
Report Headings
- AS OF HNK.LVPRDT
- Displays the end date of the request period.
- BATCH HUA.BATCH, HUE.BATCH
- Displays the batch number generated by the report.
- PAGE HUA.PAGENO, HUE.PAGENO
- Displays the page number generated by the report.
- TRAN NO
- Displays the payroll transaction number for the type of payment or dock being generated.
700 Overtime or compensatory time payment 712 LWOP dock pay 913 Compensatory emergency payment 926 Compensatory disaster payment - ORGANIZATION HNH.ORGCODE
- Displays the employee's organization code.
- EMP SSN HM9.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, HM9.LVACTYCD
- Displays the leave type and activity which was paid or docked.
CDP Compensatory disaster paid CEP Compensatory emergency paid CTP Compensatory time paid OTP Overtime paid LWD Leave without pay dock - ACTIVITY DATE HM9.STARTDT
- Displays the beginning date of leave activity.
- START TIME HM9.STARTTM
- Displays the start time for the leave activity being paid or docked. This will be blank if no start time was entered.
- LEAVE HOURS HM9.LVTIME
- Displays the number of hours to be paid or docked. Time is displayed in minutes.
- PAY HOURS HM9.LVTIME
- Displays the number of hours paid or docked. Time is displayed in hundredths.
- PCA/INDEX HNH.PRIMLABCD
- Displays the employee's primary labor code.
- MESSAGE
- Displays the results of the batch generation.
- PROCESSED
- The transaction was successfully created.
- FATAL
- Transaction errored because the batch already existed and was released.
- BATCH TOTALS DERIVED
- Displays the totals for the batches just created.
Sample Report
REPORT: 594 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXXXX XX XXX XXXXXXXX XXXXXXX RUN DATE: XX/XX/20XX
PAYROLL TRANSACTIONS GENERATED RUN TIME: 23:16:19
AS OF 02/28/20XX
TRAN ACTIVITY START LEAVE PAY PCA/
BATCH PAGE NO ORGANIZATION EMP SSN EMPLOYEE NAME ACTY DATE TIME HOURS HOURS INDEX MESSAGE
09004 1 700 611CS6FOOCS XXX-XX-XXXX XXXXXX XXX OT P 08/31/20XX 05:00 8:00 8.000 P10343 PROCESSED
09004 1 700 792CI2AM2AM XXX-XX-XXXX XXXXXX,XXXXX XXXXXXX OT P 02/28/20XX 9:00 9.000 P15202 PROCESSED
09004 1 700 792CI2AM2AM XXX-XX-XXXX XXX, XXXXXX XXXXXX OT P 02/28/20XX 9:00 9.000 P15202 PROCESSED
09004 1 700 792CI2AM2AM XXX-XX-XXXX XXXXXXXX, XXXXXXXXXX OT P 02/28/20XX 15:30 15.500 P15202 PROCESSED
09004 1 700 866TLDLG1LG XXX-XX-XXXX XXXXXX, XXXXXXX X OT P 02/01/20XX 0:40 0.670 P10103 PROCESSED
09004 1 700 883GAGLG6LG XXX-XX-XXXX XXXXX, XXXXXXXXXXX X OT P 01/31/20XX 05:00 19:00 19.000 P16007 PROCESSED
09004 2 700 883GAGLG6LG XXX-XX-XXXX XXXXX, XXXXXXXXXXXXX OT P 02/28/20XX 10:00 10.000 P16007 PROCESSED
09004 2 700 883GAGLG6LG XXX-XX-XXXX XXXXXXXX, XXXXXX OT P 01/31/20XX 05:00 24:00 24.000 P16007 PROCESSED
09004 2 700 883GAGLG6LG XXX-XX-XXXX XXXXXXXXXXXX, XX OT P 02/28/20XX 11:00 11.000 P16007 PROCESSED
09004 2 700 883GAGLG6LG XXX-XX-XXXX XXXXXXXXX, XXXXXXX OT P 02/28/20XX 10:00 10.000 P16007 PROCESSED
09004 2 700 894CIDLG6LG XXX-XX-XXXX XXXXX,XXXXXXXXXX XXX OT P 01/31/20XX 4:00 4.000 P10531 PROCESSED
09004 2 700 894CIDLG6LG XXX-XX-XXXX XXXXX, XXXXXXIXXX XX OT P 02/28/20XX 18:00 18.000 P10531 PROCESSED
09004 3 700 894CIDLG6LG XXX-XX-XXXX XXX, XXXXXX X OT P 02/28/20XX 28:30 28.500 P10531 PROCESSED
09004 3 700 894CIDLG6LG XXX-XX-XXXX XXXXXXX, XXXXXX OT P 01/31/20XX 3:00 3.000 P10531 PROCESSED
09004 3 700 894CIDLG6LG XXX-XX-XXXX XXXXXX XXXXXXX X OT P 12/31/20XX 7:00 7.000 P10531 PROCESSED
09004 3 700 894CIDLG6LG XXX-XX-XXXX XXXXXX, XXXXXXX X OT P 01/31/20XX 4:00 4.000 P10531 PROCESSED
09004 3 700 894CIDLG6LG XXX-XX-XXXX XXXX, XXXXXX X OT P 01/31/20XX 2:00 2.000 P10531 PROCESSED
09004 3 700 894CIDLG6LG XXX-XX-XXXX XXXX,XXXXXXXXX OT P 02/28/20XX 2:00 2.000 P10531 PROCESSED
09004 4 700 894CIDLG6LG XXX-XX-XXXX XXXX,XXXXXXX OT P 01/31/20XX 05:00 7:00 7.000 P10531 PROCESSED
09004 4 700 894CIDLG6LG XXX-XX-XXXX XXXX, XXXXXXX OT P 02/28/20XX 19:00 19.000 P10531 PROCESSED
09004 4 700 903GSILG6LG XXX-XX-XXXX XXXXXXXX, XXXXXXXXXX OT P 01/31/20XX 1:30 1.500 P10162 PROCESSED
09004 4 700 903GSILG6LG XXX-XX-XXXX XXXXXXXX, XXXXXXXXXX OT P 02/28/20XX 6:30 6.500 P10162 PROCESSED
09004 4 700 903GSILG6LG XXX-XX-XXXX XXXXXXXX, XXXXXX OT P 02/28/20XX 21:00 21.000 P10162 PROCESSED
09004 4 700 913GHMLG6LG XXX-XX-XXXX XXXXXXX, XXXXX XXXXX OT P 02/28/20XX 26:00 26.000 P10076 PROCESSED
09004 5 700 916GSBLG6LG XXX-XX-XXXX XXXXXX,XXXXXXXX X OT P 02/28/20XX 33:00 33.000 P16050 PROCESSED
09004 5 700 916GSBLG6LG XXX-XX-XXXX XX XX XXXX, XXXXX OT P 02/28/20XX 30:00 30.000 P16050 PROCESSED
09004 5 700 916GSBLG6LG XXX-XX-XXXX XXXXXX, XXXX OT P 02/28/20XX 35:00 35.000 P16050 PROCESSED
09004 5 700 930MCFMF6MF XXX-XX-XXXX XXXXXX, XXXXXXXXXXX OT P 01/20/20XX 24:00 24.000 P10680 PROCESSED
9000 BATCH TOTAL 0.000
9001 BATCH TOTAL 0.000
9002 BATCH TOTAL 0.000
9003 BATCH TOTAL 0.000
9004 BATCH TOTAL 387.670
9005 BATCH TOTAL 0.000
9006 BATCH TOTAL 0.000
9007 BATCH TOTAL 0.000
9008 BATCH TOTAL 0.000
9009 BATCH TOTAL 0.000
9010 BATCH TOTAL 0.000