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.
- HNKPA – FY Start Date
- HNKLA – End Date
- HPRLA – SSN Mask, Break OPT
|
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.
0 | Non-exempt |
1 | Administrative-exempt |
2 | Executive-exempt |
3 | Professional-exempt |
4 | Comp-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