Skip to content

USPS Reports Guide
USPS Reports by Number

Report 563 Employee Leave Balances

This report displays balance information on overtime, administrative, compensatory time, holiday compensatory time, vacation, and sick leave for all employees. Sick leave information on this report does not include sick leave awarded to the employee from the sick leave pool. Agencies also have the option to include up to five additional leave balances on this report. To include additional leave balances, an agency must submit a Letter of Authority (LOA) to change the BAL field on HMAU1 to R for the leave types to be included.

Report Criteria

Category Leave Accounting
Distribution Agency
Frequency Monthly – Before running Report 156
Form  
Sort Sequence
Options HPRLA
Sort
Org Code, Emp SSN 1
Org Code, Name 2
Page Break
Options HPRLA
Break
None N
Org Code Y
Parameters

HNKLA – LA PROCESS DATE (last day of current LA month), Report Fiscal Year

HPRLA – SSN MASK, SORT, BREAK OPT

HMAU1 - BAL field = R for additional leave balances to be included on report.

Databases Used H0B, H0C, HID, HM8, HNH, HNK, HPR
Selection Criteria All active employees as of the LA PROCESS DATE whose FYTDBALs are not equal to zero.
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 and to select a valid sort and/or page break option.

Report Headings

FISCAL YEAR DERIVED FROM HNK.FYEDT
Displays the fiscal year that the request is for.
ORGANIZATION CODE HNH.ORGCODE
Displays the employee's organization code.
EMP SSN H0B.EMPLOYENO
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.
OPT HOL OWED HM8.FYTDBAL(OH)
Displays the employee's optional holiday taken and not made up.
OT AVAIL HM8.FYTDBAL(OT)
Displays the employee's overtime balance. This will be 1.5 times the balance of overtime earned.
ADMIN LV HM8.FYTDBAL(AL)
Displays the employee's administrative leave balance.
HOLIDAY COMP HM8.FYTDBAL(HC)
Displays the employee's holiday compensatory balance.
REG COMP HM8.FYTDBAL(CT)
Displays the employee's compensatory time balance.
VAC HM8.FYTDBAL(VC)
Displays the employee's vacation leave balance.
SICK HM8.FYTDBAL(SL)
Displays the employee's sick leave balance. This does not include any sick leave awarded to the employee from the sick leave pool.
OPTIONAL BALANCES HM8.FYTDBAL(XX)
Agencies have the option to include up to five additional leave balances. An LOA is needed to update the HMAU1 screen to indicate the leave choices.
FLSA STATUS HNH.POFLSASTAT
Displays the employees FLSA status.
0Non-exempt
1Administrative-exempt
2Executive-exempt
3Professional-exempt
4Comp-exempt
SVC AS OF DERIVED FROM H0B.ADJEMPLDAT
Displays the number of years and months of service an employee has, including any service at other agencies. This will not include any time spent on leave without pay. If an * follows the amount of service, then this employee has county service months included (only for Agency 212).
TAKEN HM8.FYTDBAL(XX)
Displays the fiscal year to date hours taken for each leave type.

Sample Report

REPORT:   563                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1     
   AGENCY:   XXX                             XX XXXX XX XXX XXXXX XXXXXXXX XXXXX XXXXX                          RUN DATE: XX/XX/20XX
20060000000                                           EMPLOYEE LEAVE BALANCES                                   RUN TIME: 13:32:59  
                                                          FISCAL YEAR 20XX                                                        
   EMP SSN    EMPLOYEE NAME        OPT HOL  OT    ADMIN   HOLIDAY  REG      VAC    SICK      DONATE  EMERG   EMERG   JURY    SK POOL  
        FLSA  SVC AS OF 05/31/20XX  OWED   AVAIL  LV       COMP    COMP                      BLD     LEAVE   OTHER   SERVC   AW       
                                                                                                                                    
                                                                                                                                    
 XXX-XX-XXXX XXXXXXXXX, XXXXXXX            7:30    6:00   64:00    0:00  223:00   224:00    0:00    0:00    0:00    0:00    0:00    
          0     2/07        TAKEN:  0:00   0:00   10:00   10:00    0:00    0:00     0:00    0:00    0:00    0:00    0:00    0:00    
 XXX-XX-XXXX XXXXXXXXX, XXXX X             8:30    0:00    0:00    2:00  103:00   275:00    0:00    0:00    4:00-   0:00    0:00    
          0     3/06        TAKEN:  0:00  11:00    0:00    8:00    8:00   24:00     0:00    0:00    0:00    4:00    0:00    0:00    
 XXX-XX-XXXX XXXXXX, XXXX XXXXXXX         37:30    0:00   56:00    0:00   96:00    96:00    0:00    0:00    2:00-   0:00    0:00    
          0     1/02        TAKEN:  0:00   0:00    0:00    0:00    0:00    0:00     0:00    0:00    0:00    2:00    0:00    0:00