|
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 |
