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 |
|
||||||
| 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