Filetype Excel XLSX | Posted on 10 Aug 2022 | 4 years ago
Authentication
digital resources
285x Filetype XLSX File size 0.08 MB Source: www.core-ct.state.ct.us
Time and Labor Reports
Last Update: November 2018
Report Report Report ID Report Name Navigation Path Report Description Report Columns Run Report Used For TRC Programs Role Security Access
Run By Viewed Frequency Value List
By
Central Central CTBNB450 TL_COMPLEAV_T Main Menu > Core-CT This report is run in Batch on a nightly basis excluding EmplID Batch - Nightly The TL Quantity can become incorrect when leave time is entered on the timesheet and then V450 CT CNTRL TL SPECIALIST
BL TL_QUANTITY HRMS > Benefits > confirm night. The Timesheet balance is updated if the Empl Rcd changed or deleted a number of times. It can also become incorrect when leave time is posted
CORRECTION Manage Leave Accruals > TL Quantity is incorrect. Comp Plan in a future period and the monthly accruals are run before that future period is confirmed. This
Update CompLeave TL Correct TL Quantity process will calculate the correct TL Quantity and update the CompLeave table based on the
Quantity Current TL Quantity TRCs listed in the TRC Program with a payable status of 'PD', 'NA', 'ES' or 'TP'.
End Bal
The program compares the sum of reported time to the sum of payable time. It will look at the
TL Quantity on rows dated from the last confirmed check to 112 days in the past. It will also
zero out the TL Quantity for any entries that are posted more than 2 pay periods in the future.
Agency Agency CTHRR017 Rehired Retirees Main Menu > Core-CT Run by Department and calendar year this report lists JobCode Title As Needed To keep track of hours worked by a rehired retiree in order to ensure that they do not exceed CT AGY HR SPECIALIST
120 Days Worked HRMS > Time and Labor > each 120 day rehired retiree along with their maximum Name the calendar year maximum. CT AGY HR REPORT
Report Reports > 120 Day Rehired hours, how many have been worked to date and how EmplID GENERATOR
Ret. CTHRR017 many hours remain. Empl Rcd # Employees with Empl_Class of 'RR' or in Jobcodes CT AGY TCD TIMEKEEPER
Job Entry Dt '0438V1','0438VR','1373VR','1373V1','1320VR','1320V1','1371VR','1372VR' will be selected by SPEC
Std Hours/Day the report. CT AGY TIMEKEEPER
Max Hours/Yr SPECIALIST
Dept Hrs to Date Payable Time of REG or REG equivalent is reported. If no payable time is found, the report will CT AGY TL SPECIALIST
Oth Hrs to Date look for hours paid on Additional Pay entries. CT AGY TL REPORT
Hours Remaining GENERATOR
CT AGY TL TIME APPROVER
CT CNTRL HR SPECIALIST
CT CNTRL HR REPORT
GENERATOR
CT CNTRL TL SPECIALIST
Central Agency CTHRR312 Working Condition Main Menu > Core-CT Core-CT runs this report upon request of an agency. Employee Name As Needed This process can be run for an entire Department based on Union Code or Job Code. It is used CT AGY TL SPECIALIST
Stipend HRMS > Time and Labor > Report shows all employees who will receive the EmplID to create Additional Pay entries for a specific one-time earning such as stipends, shoe
Central Reports > Wrkg Condition payment. It is first run in Report mode and must be Empl Rcd allowance, etc. Additional Pay records are created for all employees in the Department, Union CT CNTRL TL SPECIALIST
Stpnd CTHRR312 reviewed by the agency. Upon verification it is run in Status or Job Code selected. The agency needs to manually delete transactions for those employees
Update mode and Additional Pay records are created. EarnCd meeting the criteria who are not entitled to the payment.
Union
Dept ID
Amount
Total Employees by Dept
Total Amount by Dept
Total Employees
Total Amount
Agency Agency CTHRR460 TRC Usage Report Main Menu > Core-CT This report can be run by Department, Group or Employee Name As Needed An example of its use would be to report on overtime or comp time usage over a specific period CT AGY HR REPORT
HRMS > Time and Labor > Employee. It allows for the reporting of specific TRCs EmplID of time. The report can be set up using a unique Run Control ID for specific TRCs such as Sick GENERATOR
Reports > TRC Usage or Override Reason Code during the period specified. Empl Rcd Family, Workers' Comp or REG (for FMLA purposes). This report only shows payable time with CT AGY HR SPECIALIST
Report - CTHRR460 The report will display Reported Time, Scheduled Union Code a status of TP (Taken - Used by Payroll), PD (Paid - Labor Distributed) or CL (Closed). Leaving CT AGY TCD TIMEKEEPER
Time and Adjust Paid Time. Date Under Report the TRC criteria blank will return all TRCs for the period selected. SPEC
TRC CT AGY TIMEKEEPER
Description Select Show Details to display all payable time hours. Deselect Show Details to display a SPECIALIST
Hours summary of hours by TRC. The summary report does not total all employees if more than one CT AGY TL REPORT
Override Reason employee or a group of employees is selected. GENERATOR
Total by TRC CT AGY TL SPECIALIST
CT AGY TL TIME APPROVER
CT CNTRL HR REPORT
GENERATOR
CT CNTRL HR SPECIALIST
CT CNTRL TL REPORT
GENERATOR
CT CNTRL TL SPECIALIST
1
Time and Labor Reports
Report Report Report ID Report Name Navigation Path Report Description Report Columns Run Report Used For TRC Programs Role Security Access
Run By Viewed Frequency Value List
By
Central Central CTHRR906 Override Rounding Main Menu > Core-CT This report is run after every pay confirm. It displays Emplid Biweekly This report show who was not updated by the Founding PRogram process CTHRB906. CT AGY PY SPECIALIST
Exception Report HRMS > Reporting Tools > those employees who have not had override rates Empl Rcd Agencies should review the report to ensure that employee's are being paid at the proper CT AGY TL SPECIALIST
Agency Report Manager populated on the Timesheet by the State's rounding Name hourly rate for those hours with an override rate entered on the Timeheet. In addition to CT AGY TL REPORT
program. Job Hrly Rate inserting an updated override rate, this process also inserts COVRP in the Updated Hourly GENERATOR
Override Rate Rate field. The Rounding Program will not process prior pay period adjustments, part time
Override Hours employees or employees in a 261 day salary plan.
Override Reason
Date Under Report Messages displayed:
TRC Unapproved or Reject Time - the Rounding Program did not insert an updated hourly rate as
Exception this time will not be paid
Required Data not Available - the program cannot find the required data such as Paygroup
Required Rates for Calculation were not Available - the program could not find the required
rates
Manual Override - an override rate was manually entered
Mid Period Pay Rate Change - employee has a mid-period pay rate change
Central Central CTT359PL Part Time My Reports This report is run in Update mode following pay Name Batch - Bi-weekly The process prorates PL time for part time employees hired during the year based on the CT AGY TIMEKEEPER
Employees PL Pro- OR confirm for the same pay period. The process pro- Emplid requirements of the plan. When employees become eligible for PL time in their first year of CT AGY TL SPECIALIST
Agency Rate Report HRMS Reporting Tools > rates PL time for those part time employees who Empl Rcd employment, this process will prorate the PL time awarded to the percentage set up on the CT AGY TL LEAVE PLAN SPEC
Report Manager become eligible to earn PL during the pay period. Plan Type plan (50%, 60%, etc.).
Descr CT CNTRL TL LEAVE PLAN
Leave Plan If employees had any adjustments, the adjusted amount is deducted from the full time accrual SPEC
Proc Mtd first, then the percentage is applied. CT CNTRL TL SPECIALIST
Accrual Percent
Monthly Full Time Accrual
Adjusted Empl Monthly
Accrual
Leave Balance
Message
Central Central CTTLB103 Leave Plan Hours Main Menu > Core-CT The conversion process is run nightly and a report of Emplid Batch - Nightly Agencies having bargaining units that report time in days should review the report to ensure CT AGY TL SPECIALIST
Conversion HRMS > Reporting Tools > employees updated is produced. The process will Empl Rcd that employee records were converted correctly. Employees with a leave plan and schedule CT AGY TL LEAVE PLAN SPEC
Agency Report Manager update any employee that is enrolled in a Leave Plan Union Cd change will have the CT_LEAVE_CNV_FLG set to 'Y' on the Leave Plan table. The Conversion CT AGY TL REPORT
that reports time in days and had a leave plan and Jobcode SetID process will pick up any employee where the flag is set to 'Y' and the Employee Status on Job GENERATOR
schedule changed with an effective date that is within Jobcode Data is 'A', 'P', or 'L' during the next nightly batch. The employee's Standard Hours are
the last seven days. Sick, Vacation and PL time is Plan Type obtained from the Leave Conversion table. CT CNTRL TL SPECIALIST
converted and the employee's balances are updated. Prior Plan
Prior Effdt The process will not pick up Terminated employees, employees switching to/from the no
Note: Comp and Holiday conversion is handled by the Prior Std Hrs accrual plans or employees in BU 67 and Job codes 2272Sc or 2261SC.
CTTLR395 report. Information on that report is noted Current Plan
below. Current Effdt Example: An employee with a balance of 40 hours switched from a 7.25 hour plan/schedule to
Current Std Hrs an 8.25 hour plan/schedule.
Accrual Date 40 prior hrs / 7.25 prior std hr workday = 5.51724 prior days
Carryover Hrs 5.51724 prior days * 8.25 new std hr workday = 45.51723 new accumulated hrs
Earned Ytd
Taken Ytd Example: An employee with a balance of 40 hours switched from an 8.25 plan/schedule to a
Adjust Ytd 7.25 plan/schedule.
Taken Unproc 40 prior hrs / 8.25 prior std hr workday = 4.848485 prior days
Adjust Unproc 4.848485 prior days * 7.25 new std hr workday = 35.151515 new accumulated hrs
2
Time and Labor Reports
Report Report Report ID Report Name Navigation Path Report Description Report Columns Run Report Used For TRC Programs Role Security Access
Run By Viewed Frequency Value List
By
Agency Agency CTTLB103ALeave Accruals Main Menu > Core-CT This report is for the specific use of agencies having Employee Name As Needed Agency users can run this report to review and verify employee leave accrual balances for CT AGY TL REPORT
Balance in Days HRMS > Time and Labor > bargaining units that report accruals in days such as EmplID those bargaining units that require these balances to be reported in days. The report can be GENERATOR
Report Reports > Leave Accrual the Department of Corrections and Department of Rcd# run by Set ID and Department or by Group. Users can also choose to identify those employees CT AGY TL LEAVE PLAN SPEC
Bal DaysCTTL103A Public Safety. Plan Type that are within a specified percentage of reaching the maximum allowed balance. The default CT AGY TL REPORT
Benefit Plan percentage is 95% and can be changed. GENERATOR
Proc Date CT AGY TL SPECIALIST
Carry Over CT AGY TL TIME APPROVER
YTD Days Earned
YTD Days Taken CT CNTRL PY SUPERVISOR
YTD Days Adjust CT CNTRL TL REPORT
Bal Days GENERATOR
Near Max CT CNTRL TL SPECIALIST
Dept/Group Total
Central Central CTTLB353 Leave Accrual Main Menu > Core-CT Lists all employees who have had ('Update' mode) or Name Batch - Monthly Agency Payroll Specialist needs to review this report to identify those employees who will have VPACC CT AGY TIMEKEEPER
Shutoff Audit HRMS > Reporting Tools > will have ('Report' mode) their leave accruals updated. Emplid Once in 'Report' mode a negative balance as a result of the Accrual Shut Off Process. Attendance corrections need to CT AGY TL SPECIALIST
Agency Report Report Manager The accrual balance shown reflects what the balances Empl Rcd Once in 'Update' mode be made for these employees prior to pay confirm to ensure that the employee will no longer CT AGY TL LEAVE PLAN SPEC
will be after the leave balance is updated by the Plan Type have a negative balance after the Accrual Shut Off Process is run in 'Update' mode.
Accrual Shut Off Process. Descr CT CNTRL TL LEAVE PLAN
Leave Balance The dates the report is run can be found on each year's Accrual Calendar on the Core-CT web SPEC
Part Time Accruals for sick and vacation time are Number of Rows Updated page. This process is run in 'Report' mode each night during confirm week for the pay period CT CNTRL TL SPECIALIST
calculated using the Jobcode Std Hrs x Job Data FTE. for Department which contains the first of the month. It is run in 'Update' mode following pay confirm which will
The row used is the effective dated row in effect as of Total Negative Balance for shut off (remove) the accrual.
the date the accruals are run (i.e., 3/1/17). In this Department
example, the Jobcode and Job Data row used by the
program will be the max effective date prior to 3/1/17.
Agency Agency CTTLB355 Leave Accruals Main Menu > Core-CT This report summarizes, as of the date selected, Employee Name As Needed Run this report to see a year-to-date summary of the activity by employee in each leave plan in CT AGY TL REPORT
Balances HRMS > Time and Labor > information on Sick, Vacation and PL leave activity for EmplID which they are enrolled. It can be used to see which employees are approaching the maximum GENERATOR
Reports > Leave Accrual each plan in which the employee is enrolled. It can be Rcd# number of vacation hours that they are entitled to. The report is defaulted to flag those CT AGY TL SPECIALIST
Bal - CTTLB355 run by Department or Group. Plan Type employee who are within 95% of the maximum vacation hours. This percentage can be CT AGY TL LEAVE PLAN SPEC
Ben Plan changed. CT AGY TL TIME APPROVER
Proc Date
Carry Over The report also provides a total balance of Sick, Vacation and PL hours for the entire CT CNTRL TL SPECIALIST
YTD Hours Earned Department or Group.
YTD Hours Taken
YTD Hours Adjust
Bal Hours
Near Max
Dept/Group Total
3
Time and Labor Reports
Report Report Report ID Report Name Navigation Path Report Description Report Columns Run Report Used For TRC Programs Role Security Access
Run By Viewed Frequency Value List
By
Central Central CTTLB359 Part Time Accruals My Reports Report is run in either Report or Update mode. For Name Monthly The report is run during pay confirm week for the pay period which contains the last day of the VPT01 CT AGY TIMEKEEPER
OR employees in leave plans based on scheduled hours, Emplid month. Refer to the Accrual Calendar on the Core-CT web page for the exact date. Each CT AGY TL SPECIALIST
Agency HRMS Reporting Tools > the report is run in both Report and Update modes on Empl Rcd month, when the accruals are awarded, every employee enrolled in a leave plan receives the CT AGY TL LEAVE PLAN SPEC
Report Manager the same day as the regular monthly accruals are run. Plan Type full time accrual for that plan. This process adjusts the full time accrual based on the part time
Employees that are enrolled in leave plans based on Descr method for the employee's leave plan (scheduled hours or hours worked). A report is generated CT CNTRL TL LEAVE PLAN
hours worked will have this process run in Report Leave Plan as a result of the process. This report will give the employee's balance AFTER the accrual is SPEC
mode at the same time as Pay Calc for the pay period Proc Mtd adjusted. CT CNTRL TL SPECIALIST
which contains the last day of the month. It is run in Accrual Percent
Update mode following pay confirm for the same pay Monthly Full Time Accrual This report is especially useful for those employees whose balance is approaching zero and
period. The employee's part time status is obtained Adjusted Empl Monthly who post attendance based on the full time accrual award. For those employees, a negative
from Job Data as of the 1st of the month being Accrual accrual balance will be displayed on this report and the attendance must be adjusted. The
prorated. Leave Balance process looks at any payable time with a status of CL, TP or PD for the current pay period to
Message determine the balance after adjustment.
Report error messages:
EE has negative Leave Balance - this indicates that the employee will have a negative leave
balance after the accrual is prorated. Update the attendance in the current pay period to
reduce the amount of hours posted.
Actual Hrs worked not found/Zero - the employee did not have any hours worked for the
month. No accrual will be awarded.
Scheduled Hours not found/Zero - the employee is in a zero hour schedule. No accrual will be
awarded.
Part Time Accrual Calculation:
Obtain Scheduled or Worked Hours for the prior month
Obtain Jobcode Standard Hours for the month (Standard Hours / 5 x workdays in prior month)
Obtain Full Time accrual based on employee's leave plan and Benefit Service Date
Calculation: Scheduled or Worked Hours / Full time job code hours x Full Time accrual
Central Central CTTLB361 Service Workers' HRMS Reporting Tools > For employees enrolled in the S80BPW sick leave Nams Biweekly after Pay The CTTLB361 process is for employees entitled to sick leave under PA 11-52 Connecticut SSWR2 CT AGY TL SPECIALIST
Sick Leave Accrual Report Manager plan, this report will display those employees who Emplid Confirm Paid Sick Leave Law. The CTTLB361 process runs biweekly only and calculates the number of CT AGY TL LEAVE PLAN SPEC
Agency Report earned time in the current pay period greater than . Empl Rcd sick hours worked based on one hour earned for every 40 hours worked. The process is run
000001 hours. Plan Type after pay confirm and after the normal accrual program. The process includes payable time CT CNTRL TL SPECIALIST
Descr with a status of CL, TP or PD and frozen date equal to the current pay period end. CT CNTRL TL LEAVE PLAN
Leave Plan SPEC
Amount Accrued Messages displayed:
Leave Balance EE has negative leave balance - the employee has a negative sick balance
Message EE has earned max allowed for calen: the employee has exceeded 40 hours earned in a
calendar year (Earned Year-to-date plus Adjusted Year-to-Date.)
4
no reviews yet
Please Login to review.
