USPS Reports Guide –
USPS Reports by Number –
Report 595 Leave Payroll Reconciliation Report
This report displays all overtime paid (OTP), compensatory time paid (CTP), compensatory disaster paid (CDP), compensatory emergency paid (CEP), or leave without pay dock (LWD) transactions with a G or a $ in the ST indicator on HM9U1.
Use this report to aid in reconciling OTP, CTP, CDP, CEP, and LWD transactions between HM9U1 and payroll history. For example, if an overtime transaction that has been generated using Report 594 is modified prior to being paid, it will cause the transaction to not match the original HM9U1 entry. Therefore, a second record must be entered. The initial HM9U1 record will need to be canceled because the balance would have been decremented twice.
Report Criteria
| Category | Leave Accounting | ||||||
|---|---|---|---|---|---|---|---|
| Distribution | Agency | ||||||
| Frequency | Upon Request | ||||||
| Form | |||||||
| Sort Sequence |
|
||||||
| Page Break |
|
||||||
| Parameters | HNKLA – START DATE, END DATE, REPORT FISCAL YEAR, Required HPRLA – SSN MASK, SORT, BREAK OPT |
||||||
| Databases Used | H0C, HID, HM9, HNH, HNK, HPR | ||||||
| Selection Criteria | All OTP, CTP, CDP, CEP, and LWD transactions with a status of G (regardless of date) or any $ sign found within the START DATE and END DATE entered on HNKLA goes with Report 594. | ||||||
| Produce Output? | Yes | ||||||
| Request Screen | HNKLA | ||||||
| Posting Report? | No | ||||||
| Additional Notes | 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. |
Report Headings
- 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.
OTP Overtime paid CDP Compensatory disaster paid CEP Compensatory emergency paid CTP Compensatory time paid LWD Leave without pay dock - STAT HM9.LVACTYSTAT
- Displays the status of the transaction.
S Paid G Generated a batch transaction - START DATE HM9.STARTDT
- Displays the beginning date of the leave activity.
- TIME HM9.STARTTM
- Displays the start time for the leave activity being paid or docked.
- HOURS HM9.LVTIME
- Displays the numbers of hours of the leave activity.
- REASON HM9.LVREASCD
- Displays the reason for the leave, if applicable.
- OPER ID HM9.OPERID
- Displays the identification number of the user who last updated the transaction.
Sample Report
REPORT: 595 UNIFORM STATEWIDE PAYROLL/ PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX
LEAVE PAYROLL RECONCILIATION RUN TIME: 23:44:35
PAID TRANSACTIONS FROM 09/01/20XX TO 08/31/20XX
ORGANIZATION EMP SSN EMPLOYEE NAME ACTY STAT START DATE TIME HOURS REASON OPERID
13000113333 XXX-XX-XXXX XXXXXXX, XXXX X OT E G 12/01/20XX 4:00 ABC987
13000113333 XXX-XX-XXXX XXXXXXX, XXXX X OT E G 02/01/20XX 9:00 ABC987
13000113333 XXX-XX-XXXX XXXXXXX, XXXX X CT E G 04/01/20XX 6:30 ABC987
13000113333 XXX-XX-XXXX XXXXXXX, XXXX X CT E G 05/01/20XX 10:30 ABC987
13000113333 XXX-XX-XXXX YYYYYYYYY, YYYYYY CT E G 09/01/20XX 9:30 ABC987
13000113333 XXX-XX-XXXX YYYYYYYYY, YYYYYY OT E G 12/01/20XX 7:00 ABC987
13000113333 XXX-XX-XXXX YYYYYYYYY, YYYYYY OT E G 02/01/20XX 5:30 ABC987
13000113333 XXX-XX-XXXX YYYYYYYYY, YYYYYY CT E G 03/01/20XX 7:00 ABC987