Skip to content

USPS Reports Guide
USPS Reports by Number

Report 199 FLSA O.T./Comp Time Activity

This report provides a monthly breakdown of overtime and compensatory time activity and balance information. It is designed to help track whether an employee is earning too much overtime or compensatory time. This report shows, by month, the compensatory time and overtime beginning and ending balances, and the amount of leave earned, taken, paid, or lost for every employee who had activity during the requested time frame. This report cannot be requested for prior fiscal years.

Report Criteria

Category Leave Accounting
Distribution Agency
Frequency Monthly – After running Reports 597 and 537, but before beginning month-end procedures.
Form 111
Sort Sequence Org Code, Name, Employee SSN, Leave Type
Page Break
Options HPRLA Break
None N
Org Code Y
Parameters This screen pulls a start date from one screen and an end date from another screen.
Databases Used H0B, H0C, HID, HM8, HM9, HNH, HNK, HPR
Selection Criteria All HC, CT, and OT paid or taken with a start date in the current Fiscal Year for all employees with a termination date greater than or equal to the END DATE or null.
Produce Output? Yes
Request Screen HSRPT
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 page break on organization code.

Report Headings

FISCAL YEAR XXXX for MONTH ENDING HNK.LAEDT
Displays the fiscal year and ending date of the reporting period.
EMPLOYEE NAME HID.RPTNAME
Displays the employee's name.
EMP SSN HMC.EMPLOYEENO
Displays the employee's SSN (masked or entire SSN will display depending on the HPRLA selection).
JOB CLASS HNH.JOBCLASS
Displays the employee's job class code.
FLSA STATUS HNH.POFLSASTAT
Displays the FLSA status that governs the employee's overtime eligibility.
0Non-exempt
1Administrative-exempt
2Executive-exempt
3Professional-exempt
4Comp-exempt
ORG CODE HNH.ORGCODE
Displays the employee's organization code.
BEGIN COMP TIME BAL DERIVED HM8.FYBEGBAL (CT, HC)
Displays the beginning year compensatory balance for the month of September. For all other months, the ending balance of the previous month serves as the beginning month balance.
COMP TIME EARNED DERIVED FROM HM9 (CTE, CTI, HCE, HCI)
Displays the total compensatory time earned or transferred in during the month.
COMP TIME TAKEN DERIVED FROM HM9 (CTO, CTT, HCO, HCT)
Displays the total compensatory time taken or transferred out during the month.
COMP TIME LOST DERIVED FROM HM9 (CTL, HCL)
Displays the total compensatory time lost during the month.
COMP TIME PAID DERIVED FROM HM9 (CTP)
Displays the total compensatory time paid during the month.
END COMP TIME BAL DERIVED
Displays the balance of compensatory time at the end of the month. (BEGIN COMP TIME BAL ADD COMP TIME EARNED SUBTRACT COMP TIME TAKEN, COMP TIME LOST AND COMP TIME PAID).
BEGIN FLSA OT BAL DERIVED HM8.FYBEGBAL (OT)
Displays the beginning year overtime balance for the month of September (at the 1.5 rate). For all other months, the ending balance of the previous month serves as the beginning month balance.
FLSA OT EARNED DERIVED FROM HM9 (OTE, OTI)
Displays the total overtime earned or transferred in during the month (at the 1.5 rate).
FLSA OT TAKEN DERIVED FROM HM9 (OTO, OTT)
Displays the total overtime taken or transferred out during the month (at the straight time rate).
FLSA OT PAID DERIVED FROM HM9 (OTP)
Displays the total overtime paid during the month (at the 1.5 rate).
END FLSA OT BAL DERIVED
Displays the balance of overtime at the end of the month (at the 1.5 rate). (Begin FLSA OT Bal add FLSA OT Earned subtract FLSA OT Taken and FLSA OT Paid).

Sample Report

    REPORT: USPXXXU    VERSION:20060426 232330 HIERARCHY CODE:                               PAGE:   108       ROW:  1   COL:  1     
    REPORT:   199                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1    
    AGENCY:   XXX                                   XXXXX XXXXX XXXXXXXXXXX XXXXXX                               RUN DATE: XX/XX/20XX
 XXXXXXXXXXX                                         FLSA O.T./COMP TIME ACTIVITY                                RUN TIME: 21:24:15 
                                            FISCAL YEAR 20XX  FOR MONTH ENDING 08/31/20XX                                           
  EMPLOYEE NAME                              JOB    FLSA                                                                            
                                   EMP SSN  CLASS   STAT                                                                            
                                                                                                                                    
  XXXXX XXX, XXXXXXXXXXX STEV  XXX-XX-XXXX   XXXX     3                                                                             
                             SEP      OCT      NOV      DEC      JAN      FEB      MAR      APR      MAY      JUN      JUL      AUG 
   BEGIN COMP TIME BAL     23:15    27:15    13:45    11:00    12:15    15:45    15:45    31:45    31:45    31:45    31:45    31:45 
      COMP TIME EARNED     04:00    00:00    04:30    02:00    08:00    00:00    16:00    00:00    00:00    00:00    00:00    00:00 
      COMP TIME TAKEN      00:00    13:30    07:15    00:45    04:30    00:00    00:00    00:00    00:00    00:00    00:00    00:00 
      COMP TIME LOST       00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00 
      COMP TIME PAID       00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00 
   END COMP TIME BAL       27:15    13:45    11:00    12:15    15:45    15:45    31:45    31:45    31:45    31:45    31:45    31:45 
   BEGIN FLSA OT BAL       00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00 
      FLSA OT EARNED       00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00 
      FLSA OT TAKEN        00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00 
      FLSA OT PAID         00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00 
   END FLSA OT BAL         00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00 
                                                                                                                                    
   XXXXX, XXXXXX X              XXX-XX-XXXX   XXXX     3                                                                             
                             SEP      OCT      NOV      DEC      JAN      FEB      MAR      APR      MAY      JUN      JUL      AUG 
   BEGIN COMP TIME BAL     32:00    32:00    34:00    38:00    41:00    25:00    25:00    17:00    17:00    17:00    17:00    17:00
      COMP TIME EARNED     00:00    02:00    04:00    08:00    08:00    00:00    08:00    00:00    00:00    00:00    00:00    00:00 
      COMP TIME TAKEN      00:00    00:00    00:00    05:00    24:00    00:00    16:00    00:00    00:00    00:00    00:00    00:00 
      COMP TIME LOST       00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00 
      COMP TIME PAID       00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00 
   END COMP TIME BAL       32:00    34:00    38:00    41:00    25:00    25:00    17:00    17:00    17:00    17:00    17:00    17:00 
   BEGIN FLSA OT BAL       00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00 
      FLSA OT EARNED       00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00 
      FLSA OT TAKEN        00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00 
      FLSA OT PAID         00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00 
   END FLSA OT BAL         00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00    00:00