Governor Ned Lamont
 
LOGIN

SELF-SERVICE
HRMS
FINANCIALS
EPM
SECURITY
TRAINING
DAILY MAIL
CATALOG OF REPORTS
STARS
 

 
Get Adobe Reader

Catalog of Online Reports

Choosing Queries in Core-CT

If you want to: Then run this report:
Determine service time for managers Manager Service Time
Display workforce analysis data Workforce Analysis
Display workforce analysis data, detailed version Workforce Analysis detail
Find accrued hours dollar liability for employees with 5+ years of service Leave Bal,hrs/$ for ee's >5yrs
Find accrued hours dollar liability for employees with less than 5 years of service Leave Bal,hrs/$ for ee's <5yrs
Find active employees and active, unfilled postions by department Activ Posns & Activ Ees only
Find address information for active employees in your agency All EE addresses by Dept
Find all employees not set up the deduction codes for Retiree Health Fund employee and/or matching employer share contributions Retiree Health Fund Missing Deductions
Find daily and biweekly employee compensation rate EE daily & biweekly pay rates
Find email and phone information for current employees All current ee Email/Phone
Find employee driver's license information Drivers license information
Find employee emergency contact information Emergency Contacts for active Ees
Find military service and job information for active employees Military Service Information
Find position action audit information Position Activity Query
Identify all voluntary leave reduction time taken by department and employee VLRP Days & Amounts
Identify positions which have been recycled or denied RecycledDeniedPositions
Review notepad entries by employee Employee Notepad
This query will retrieve all job data rows for a specified employee.(3% withholding) Job data rows by emplid
To assist agencies impacted by HIPPA requirements for training. Restricted to LMS using agencies. Replication of CT_DOIT_LMS_VW
To facilitate implementation of Comptroller's Memo 2010-11 (3% withholding) 3Pct Deduction Returns
To find a list of all employees participating in the Retirement Incentive Program 2009 with no additional pay entries RIP Addl Pay Missing Entries
To find a list of employees participating in the Retirement Incentive Program without future deductions RIP Deductions Audit
To find active employees and associated SOC code for IPEDS reporting. IPEDS Reporting Audit
To find active employees by agency and name of supervisor as identified on the job information tab in job data EE Supervisor
To find active employees with hire/rehire job data rows effective dated equal to or greater than 7-01-2009. Hire/Rehire date > 7-1-2009
To find active employees, last AI date, and next AI date List of ee's AI
To find Additional Pay out entries for 2012 and 2014, for employees participating in the Retirement Incentive Program 2009 Addl Pay set up audit RIP 2009
To find all employees set up with the deduction codes RGSERS, RGJUD or RGSHY per comptroller's memorandum 2013-04 ee'S by agency w/RGSERS deduct
To find all employees with the status of leave of absence with or without pay and the expected return date Expected Return Date for Employees
To find all terminated employees by department and effective date range All terminated ee's
To find provides a list of employees participating in the Retirement Incentive Program without future deductions RIP Deduction Missing Entries
To find returns job data profile for employees participating in the Retirement Incentive Program 2009 RIP Job Data Audit
To find sick and vacation hours and dollar liability for retired employees RIP leave accrual liability
To find when an employee has utilized four or more hours (paid or unpaid) for five or more consecutive work days Sick Use Audit Query
To find whether an employee's address and contact information has been protected from disclosure Active Empls Waive Data Setup
To hire or rehire job rows for all active employees with hire dates between 7-01-2004 and 7-01-2009 Hire/Rehire7-01-04 to 7-01-09
To identify active employee position and chartfield data. Employee, Positn,Chrtfld Data
To return job data actions along with any associated notes for a Department during a specified Effective Date range Job Data Audit Tool w/Notes

Back to Catalog of Online Financial Reports: Choosing EPM Queries