Skip to content

USPS Reports Guide
USPS Reports by Number

Report 574 Compensable Leave Report For Fiscal Year CCYY

This report provides expendable trust funds/long term debt information needed by agencies for the Annual Financial Report. Only the last page listing agency long-term debt is needed for reporting purposes. The remainder of the report provides the details needed to support the agency balances during an audit. Every employee who has had a balance of compensatory time, overtime, or vacation leave during the requested fiscal year will be included. The report shows balance information at the beginning of the fiscal year, and the current balance will be displayed along with basic personnel information (assignment, longevity, salary, etc.). For each balance, the monetary value is also listed.

Report Criteria

Category Leave Accounting
Distribution Agency
Frequency Annually at Fiscal Year-End
Form  
Sort Sequence
Options HPRLA
Sort
GAAP Fund, D23 Fund, PCA, Org Code, Emp SSN 1
GAAP Fund, D23 Fund, PCA, Org Code, Name 2
Page Break  
Parameters

HNKLA – CURR FY END DATE

HPRLA – SSN MASK, SORT

Databases Used H0C, H0B, HID, HM8, HNH, HNK, HPR
Selection Criteria Shows information on all employees who have had a balance record on HM8U2 for either compensatory time, overtime, or vacation leave, for the fiscal year reported. Terminated employees will be included.
Produce Output? Yes
Request Screen HNKLA
Posting Report? No
Additional Notes

To comply with reporting requirements, ending vacation balances are calculated before excess vacation is converted to sick leave.

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

FOR FISCAL YEAR HNK.FYEDT
Displays the end date of the fiscal year.
PCA HNH.PRIMLABCD
Displays the employee's primary labor code.
ORGANIZATION HNH.ORGCODE
Displays the organization code.
EMP SSN HID.EMPLOYEENO
Displays the employee's SSN (masked or entire SSN will display depending on the HPRLA selection).
POSITION HNH.POSITION
Displays the employee's primary position number.
CLASS HNH.JOBCLASS
Displays the job class code.
EMPLOYEE NAME HID.RPTNAME
Displays the employee's name.
GR/ST HNH.PAYGRP/HNH.ACTUALSTEP
Displays the pay group and step, if applicable.
SERIVCE (MM/YY) DERIVED FROM H0B.ADJEMPLDAT
Displays the employee's state service time as of the CURR FY END DATE.
PAY SALARY HNH.HSALARY
Displays the pay period salary for the employee.
PAY RATE DERIVED FROM HNH.HSALARY OR HHRLYRATE
Displays the employee's hourly rate.
LEAVE TYPE HM8U1 LEAVE TYPE
Displays the type of leave being reported.
VC Vacation leave
OT Overtime
CT Compensatory time (this includes Holiday, Disaster and Emergency Compensatory time)
BEGINNING BALANCE HOURS HM8.BEGBAL
Displays the employee's balance at the beginning of the fiscal year for the leave type indicated.
BEGINNING BALANCE AMOUNT HM8.FYBEGBAL * PAY RATE
Displays the monetary value of the leave balance at the beginning of the year for the leave type indicated based on the employee's most recent salary.
ADDITIONS HOURS HM8.FYTDEARND
Displays the number of hours the employee earned during the fiscal year for the leave type indicated. (Accrued, converted, or transferred in.)
ADDITIONS AMOUNT HM8.FYTDEARND * PAYRATE
Displays the monetary value of the hours added to the employee's balance based on the employee's most recent salary.
DELETIONS HOURS HM8.FYTDTAKEN + HM8FYTDLOST + HM8.FYTDPD
Displays the number of hours the employee used during the fiscal year for the leave type indicated. (Took, lost, or was paid for.)
DELETIONS AMOUNT DELETIONS HRS * PAY RATE
Displays the monetary value of the hours removed from the employee's balance based on the employee's most recent salary.
ENDING BALANCE HOURS HM8.FYTDBAL
Displays the employee's current balance for the leave type indicated.
ENDING BALANCE AMOUNT HM8.FYTDBAL * PAYRATE
Displays the monetary value of the current leave balance for the leave type indicated based on the employee's most recent salary.
ORG TOTALS DERIVED
Displays a monetary value by leave type for each labor code with an organization code.
PCA/INDEX TOTALS DERIVED
Displays a monetary value by leave type for each labor code.
AGENCY TOTALS DERIVED
Displays a monetary value by leave type for the agency.

Sample Report

    REPORT:   574                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1    
    AGENCY:   XXX                                        XXXXXXXXXXXXXXXXXXX                                     RUN DATE: XX/XX/20XX
                                            COMPENSABLE LEAVE REPORT FOR FISCAL YEAR 20XX                        RUN TIME: 22:57:22 
                                                                                                                                    
 ORG. CODE     EMP SSN       EMPLOYEE NAME                08/31/20XX SALARY & RATE    08/31/20XX SALARY & RATE   SALARY RATE CHANGE 
 LV TYP  BEGIN BALANCE        ADDITIONS       SALARY          DELETIONS         END BALANCE         CURRENT           NON-CURRENT   
        HOURS    AMOUNT    HOURS    AMOUNT    ADJUSTMENT   HOURS    AMOUNT    HOURS    AMOUNT    HOURS    AMOUNT    HOURS    AMOUNT 
                                                                                                                                    
 00222200200    XXX-XX-XXXX   XXX, XXXXXXXX XX                6,916.66  39.90381       7,470.00  43.09615        553.34   3.19234   
 (VC)  191:00   7,621.63  165:00   7,110.86     609.73    356:00  15,342.23    0:00        .00    0:00        .00    0:00        .00
 (OT)    0:00        .00    0:00        .00        .00      0:00        .00    0:00        .00    0:00        .00    0:00        .00
 (CT)    2:00      79.81   19:00     818.83       6.38     21:00     905.02    0:00        .00    0:00        .00    0:00        .00
 00222200200    XXX-XX-XXXX   XXXX, XXXX X                    5,368.48  30.97200       5,368.48  30.97200           .00    .00000   
 (VC)  453:00  14,030.32  156:00   4,831.63        .00    166:00   5,141.35  443:00  13,720.60  156:00   4,831.63  287:00   8,888.97
 (OT)    0:00        .00    0:00        .00        .00      0:00        .00    0:00        .00    0:00        .00    0:00        .00
 (CT)   24:00     743.33   76:30   2,369.36        .00     57:00   1,765.40   43:30   1,347.28   43:30   1,347.28    0:00        .00
 00222200200    XXX-XX-XXXX   XXXXXXX, XXXXX X                3,954.16  22.81246       4,230.95  24.40933        276.79   1.59687   
 (VC)  251:30   5,737.33  180:00   4,393.68     401.62    128:00   3,124.39  303:30   7,408.23  180:00   4,393.68  123:30   3,014.55
 (OT)    0:00        .00    0:00        .00        .00      0:00        .00    0:00        .00    0:00        .00    0:00        .00
 (CT)    7:00     159.69   40:00     976.37      11.18     40:00     976.37    7:00     170.87    7:00     170.87    0:00        .00
 00222200200    XXX-XX-XXXX   XXXX, XXXXX X                   5,646.15  32.57394       5,646.15  32.57394           .00    .00000   
 (VC)  244:15   7,956.18   55:00   1,791.57        .00    299:15   9,747.75    0:00        .00    0:00        .00    0:00        .00
 (OT)    0:00        .00    0:00        .00        .00      0:00        .00    0:00        .00    0:00        .00    0:00        .00
 (CT)   16:00     521.18   18:00     586.33        .00     34:00   1,107.51    0:00        .00    0:00        .00    0:00        .00
 00222200200    XXX-XX-XXXX   XXXXXX, XXXXX XXXXXXX           4,500.00  25.96154       4,806.00  27.72692        306.00   1.76538   
 (VC)   85:00   2,206.73   96:00   2,661.78     150.06     24:00     665.45  157:00   4,353.13   96:00   2,661.78   61:00   1,691.35
 (OT)    0:00        .00    0:00        .00        .00      0:00        .00    0:00        .00    0:00        .00    0:00        .00
 (CT)   43:45   1,135.82   89:30   2,481.56      77.23     78:00   2,162.70   55:15   1,531.91   55:15   1,531.91    0:00        .00
 > > > >  TOTALS: PCA/INDEX P08392 -- D23 FUND  0860   -- GAAP FUND 0860    < < < < < < < < < < < < < < < < < < < < < < < < < < < < 
 (VC)          37,552.19          20,789.52   1,161.41            34,021.17          25,481.96          11,887.09          13,594.87
 (OT)                .00                .00        .00                  .00                .00                .00                .00
 (CT)           2,639.83           7,232.45      94.79             6,917.00           3,050.06           3,050.06                .00