FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

USPS Reports Guide
Report 567 Fiscal Year End Excess Vacation Leave

Updated July 25, 2008 - View Changes

This report lists all employees who had vacation leave converted to sick leave at fiscal year-end. Vacation and sick leave balances, before converted and after the conversion, the amount converted, and their state service time will all display.

This report can be run the same night as Report 158.

Report Criteria

Category Leave Accounting
Distribution Agency
Frequency Annually at Fiscal Year-End
Form  
Sort Sequence
Options HPRLA
Sort
Emp SSN
1
Name
2
Page Break  
Parameters

HNKLA – REPORT FISCAL YEAR (New FY), LA PROCESS DATE (9/30/XXX-New FY)

HPRLA – SSN MASK, SORT

Databases Used

HØB, HØC, HID, HM8, HM9, HNH, HNK, HPR

Selection Criteria All employees with vacation converted (VCC) to sick leave (SLC) with an effective date equal to CURR FY END DATE.
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 option.

Report Headings

ROLL DATE HNK.LVPRDT
Displays the effective date of the conversion.
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.
SERVICE (YY/MM) FROM HØB.ADJEMPLDAT
Displays the employee's state service time as of the LA PROCESS DATE. If an * follows the amount of service time, then this employee has county service months included (only for Agency 212) if HØB Adjusted Accrual Date is not present for the employee.
YR END VACATION HM8.FYBEGBAL(VC)
Displays the employee's beginning fiscal year balance prior to the conversion.
NEW VAC BALANCE HM8.FYBEGBAL(VC) EXCESS CONVERTED
Displays the employee's balance after the conversion.
EXCESS CONVERTED DERIVED FROM HM9U1
Displays the total amount of vacation leave converted to sick leave (SLC).
YR END SICK HM8.FYBEGBAL(SL)
Displays the employee's beginning fiscal year balance prior to the conversion.
NEW SICK BALANCE HM8.FYBEGBAL(SL) + EXCESS CONVERTED
Displays the employee's balance after the conversion.

Sample Report

    REPORT:   567                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1    
    AGENCY:   XXX                                       XXXXXXXXXXXXXXXXXXXXXX                                   RUN DATE: XX/XX/20XX
                                                FISCAL YEAR END EXCESS VACATION LEAVE                            RUN TIME: 21:39:37 
                                                                                                                                    
                                                        ROLL DATE 09/01/20XX                                                        
                                                                                                                                    
                                                                SERVICE     YR END     NEW VAC       EXCESS      YR END     NEW SICK
    ORGANIZATION  EMP SSN        EMPLOYEE NAME                  (YY/MM)    VACATION    BALANCE      CONVERTED     SICK      BALANCE 
                                                                                                                                    
    00100100100   XXX-XX-XXXX  XXXXXX, XXXXX X                   18/07      424:00      340:00        84:00     1500:30     1584:30 
    00100100100   XXX-XX-XXXX  XXXXXX, XXXXXXX                   06/11      274:30      268:00        06:30      133:30      140:00 
    00100100100   XXX-XX-XXXX  XXXXX, XXXXXX                     13/07      296:30      292:00        04:30      833:30      838:00 
    00100100100   XXX-XX-XXXX  XXXXXX, XXXXXX X                  10/10      398:00      292:00       106:00     1171:00     1277:00 
    00100100100   XXX-XX-XXXX  XXXXX, XXXXX XXX                  20/03      494:00      388:00       106:00     1589:30     1695:30 
    00100100100   XXX-XX-XXXX  XXXXXX, XXXXX X                   12/00      416:45      292:00       124:45      822:15      947:00 
    00100100100   XXX-XX-XXXX  XXXXXX, XXXXXX X                  04/11      352:00      244:00       108:00      515:30      623:30 
    00100100100   XXX-XX-XXXX  XXXXXX, XXXXXXX X                 14/01      397:00      292:00       105:00      587:30      692:30 
    00100100100   XXX-XX-XXXX  XXXXXXXXXX, XXXXXXX X             04/11      266:00      244:00        22:00      100:30      122:30 
    00100100100   XXX-XX-XXXX  XXXXXX, XXXXX X                   28/01      480:30      436:00        44:30     1447:30     1492:00 
    00100100100   XXX-XX-XXXX  XXXXXXXX, XXXXXXX X               16/06      363:30      340:00        23:30      708:00      731:30 
    00100100100   XXX-XX-XXXX  XXXXX, XXXXXXX XXXXXXX            08/04      336:00      268:00        68:00      613:45      681:45 
    00100100100   XXX-XX-XXXX  XXXXXXXXXXXXX, XXXXX X            14/11      324:00      292:00        32:00      867:30      899:30 
    00100100100   XXX-XX-XXXX  XXXXXXX, XXXXXX X                 04/00      246:00      244:00        02:00      179:00      181:00 
    00100100100   XXX-XX-XXXX  XXXXXXXX, XXXXXX X                26/02      520:30      436:00        84:30     1016:15     1100:45
Changes to this Document
07/25/08 ACR 24137 added the option to mask Social Security numbers (SSNs) and simplified the selection for sort and break options, where applicable.
Glenn Hegar
Texas Comptroller of Public Accounts
Questions? Contact statewide.accounting@cpa.texas.gov
Comptroller.Texas.Gov | FMX
FMX Sitemap | Contact FM
Accessibility Policy | Privacy and Security Policy