Human Resources Reports - Excel

Document Sample
Human Resources Reports - Excel Powered By Docstoc
					                                                       Human Resources Reports
Agency/ Report ID Report Name              Report Description                    Navigation/Path           Run              Roles
Central                                                                                                Frequency
Agency/ APP004    Requisition   Extracts job posting data from the database Develop Workforce >       Batch - As    Ad Hoc Report Creator
Central           Posting       and formats it for merging into Microsoft   Recruit Workforce (GBL) > Needed        Agency HR Recruitment
                                Word documents.                             Report > Requisition                    Specialist
                                                                                                                    Agency HR Report
                                                                            Posting
                                                                                                                    Generator
                                                                                                                    Agency HR Specialist
                                                                                                                    Agency HR Specialist
                                                                                                                    (Correct Ability)
                                                                                                                    Central HR Exam Unit
                                                                                                                    Central HR Recruitment
                                                                                                                    Specialist
                                                                                                                    Central HR Report
                                                                                                                    Generator
                                                                                                                    Central HR Specialist
                                                                                                                    Central HR Specialist
                                                                                                                    (Correct Ability)
                                                                                                                    HR Auditor Functional
Agency/ APP005   Candidate      Combines job requisition information with a Develop Workforce >        Batch - As   Ad Hoc Report Creator
Central          Listing        list of candidates being interviewed for the Recruit Workforce (GBL) > Needed       Agency HR Recruitment
                                position. Groups requisitions by Department Report > Candidate Listing              Specialist
                                                                                                                    Agency HR Report
                                ID.
                                                                                                                    Generator
                                                                                                                    Agency HR Specialist
                                                                                                                    Agency HR Specialist
                                                                                                                    (Correct Ability)
                                                                                                                    Central HR Exam Unit
                                                                                                                    Central HR Recruitment
                                                                                                                    Specialist
                                                                                                                    Central HR Report
                                                                                                                    Generator
                                                                                                                    Central HR Specialist
                                                                                                                    Central HR Specialist
                                                                                                                    (Correct Ability)
                                                                                                                    HR Auditor Functional




                                                                1 of 11                                                      8/7/2012
                                                         Human Resources Reports
Agency/ APP011   Applicant      Lists, for each job requisition, the number of   Develop Workforce >       Batch - As   Ad Hoc Report Creator
Central          Summary by     applicants and percentage of total               Recruit Workforce (GBL) > Needed       Agency HR Recruitment
                 Requisition    applicants that applied, sorted by source        Report > Applicant Sum.                Specialist
                                                                                                                        Agency HR Report
                                type and specific source.                        by Requisition
                                                                                                                        Generator
                                                                                                                        Agency HR Specialist
                                                                                                                        Agency HR Specialist
                                                                                                                        (Correct Ability)
                                                                                                                        Central HR Exam Unit
                                                                                                                        Central HR Recruitment
                                                                                                                        Specialist
                                                                                                                        Central HR Report
                                                                                                                        Generator
                                                                                                                        Central HR Specialist
                                                                                                                        Central HR Specialist
                                                                                                                        (Correct Ability)
                                                                                                                        HR Auditor Functional
Agency/ APP012   Applicant      Lists the number of applicants and               Develop Workforce >       Batch - As   Ad Hoc Report Creator
Central          Summary by     percentage of total applicants, sorted by        Recruit Workforce (GBL) > Needed       Agency HR Recruitment
                 Source         source type and specific source (regardless      Report > Applicant Sum.                Specialist
                                                                                                                        Agency HR Report
                                of requisition).                                 by Source
                                                                                                                        Generator
                                                                                                                        Agency HR Specialist
                                                                                                                        Agency HR Specialist
                                                                                                                        (Correct Ability)
                                                                                                                        Central HR Exam Unit
                                                                                                                        Central HR Recruitment
                                                                                                                        Specialist
                                                                                                                        Central HR Report
                                                                                                                        Generator
                                                                                                                        Central HR Specialist
                                                                                                                        Central HR Specialist
                                                                                                                        (Correct Ability)
                                                                                                                        HR Auditor Functional
Agency/ CMM007   Licenses,      Lists which employees need to renew a            Develop Workforce >       As Needed    Agency HR Specialist
Central          Certificates   license or certificate.                          Manage Competencies >                  Agency HR Specialist
                 Renewal                                                         Report > Licences and                  (Correct Ability)
                                                                                                                        Central HR Specialist
                                                                                 Certifications
                                                                                                                        Central HR Specialist
                                                                                                                        (Correct Ability)
                                                                                                                        HR Auditor Functional




                                                                  2 of 11                                                        8/7/2012
                                                           Human Resources Reports
Agency/ CTHRR005 Monthly Position This report produces a Monthly Position         Develop Workforce >       Batch -   Ad Hoc Report Creator
Central          Status Report    Status Summary Report and a Monthly             Manage Positions > Report Monthly   Agency HR Positions
                                  Position Detail Report:                         > Position Status                   Specialist
                                                                                                                      Central HR Position
                                                                                                                      Approver
                                     The Summary report provides Established,
                                                                                                                      HR Auditor Functional
                                     Paid Filled, Unpaid Filled, and Vacant
                                     Position Counts by Position Classification
                                     and Funding Source for the entire
                                     department being processed, and contains
                                     Position Classification subtotals, Funding
                                     Level Totals, and Department Grand Totals.

                                     The Detail report provides the Established,
                                     Paid Filled, Unpaid Filled, and Vacant
                                     Position Counts at a more detailed level.
                                     The detail report page breaks by Child
                                     Department and will order by Location,
                                     Funding Source, Position Classification,
                                     Jobcode, Position Number, Program, and
                                     Class Field. In addition to the counts, the
                                     detail report also display Jobcode
                                     Description, Position Number, Program,
                                     Class Field, Funding Percent, FTE for the
                                     employee from the Job record, and
                                     Employee Name. The detail report features
                                     Fund Level Subtotals, Child
                                     Department/Location Subtotals, Child
                                     Department Totals, and Parent Department
                                     Grand Totals.
Agency/ CTHRR006 Monthly Vacant      Selects position, department, job, personal, Develop Workforce >      Batch -    Agency HR Positions
Central          Position Report     and account Code as of a specified date on Manage Positions > Report Monthly     Specialist
                                     the custom run control page.                 > Vacant Position Report            Central HR Position
                                                                                                                      Approver
                                                                                                                      HR Auditor Functional




                                                                    3 of 11                                                    8/7/2012
                                                               Human Resources Reports
Agency/ CTHRR017 Rehired Retirees Contains information on cumulative hours             Administer Workforce >   Batch - Bi-   Ad Hoc Report Creator
Central          120 Days         worked for all persons in job code titles of         Capture Time and Labor > weekly        Agency HR Report
                 Worked Report Temporary Worker (Retiree) and Temporary                Reports > Retirees 120                 Generator
                                                                                                                              Agency HR Specialist
                                  Worker Retiree (Unclassified). This report           Day Report
                                                                                                                              Agency HR Specialist
                                  lists every agency employee in the two
                                                                                                                              (Correct Ability)
                                  retiree job code titles and their total hours                                               Agency TCD Timekeeper
                                  worked to date in the calendar year                                                         Specialist
                                  specified on the run control page.                                                          Agency Timekeeper
                                                                                                                              Agency Timekeeper
                                                                                                                              Specialist
                                                                                                                              Agency Time & Labor
                                                                                                                              Specialist
                                                                                                                              Central HR Report
                                                                                                                              Generator
                                                                                                                              Central HR Specialist
                                                                                                                              Central HR Specialist
                                                                                                                              (Correct Ability)
                                                                                                                              Central Time & Labor
                                                                                                                              Specialist
                                                                                                                              HR Auditor Functional
Agency/ CTHRR052 Applicant Flow       Contains information about all applicants for    Develop Workforce >       Batch - As   Ad Hoc Report Creator
Central          Report               each job filled at a State agency. This report   Recruit Workforce (GBL) > Needed       Agency HR Recruitment
                                      specified the job requisition number, the        Report > Applicant Flow                Specialist
                                                                                                                              Agency HR Regulatory
                                      jobcode, position number, Department ID,         Report
                                                                                                                              Req Specialist
                                      and name of each applicant, each
                                                                                                                              Agency HR Regulatory
                                      applicant’s race, sex, referral source,                                                 Req Viewer
                                      interview date, interviewer’s(s’)                                                       Agency HR Report
                                      recommendation, interview comments                                                      Generator
                                      overall and hire date.                                                                  Agency HR Specialist
                                                                                                                              Agency HR Specialist
                                                                                                                              (Correct Ability)
                                                                                                                              Central HR Examination
                                                                                                                              Unit
                                                                                                                              Central HR Recruitment
                                                                                                                              Specialist
                                                                                                                              Central HR Report
                                                                                                                              Generator
                                                                                                                              Central HR Specialist
                                                                                                                              Central HR Specialist
                                                                                                                              (Correct Ability)
                                                                                                                              HR Auditor Functional

                                                                        4 of 11                                                       8/7/2012
                                                             Human Resources Reports
Agency/ CTHRR101 CT Personnel        Selects job data transactions with a job         Administer Workforce >    Batch - Daily   Ad Hoc Report Creator
Central          Actions History     action date between the specified from and       Administer Workforce                      Agency HR Report
                 Report              thru dates on the custom run control page        (GBL) > Report >                          Generator
                                                                                                                                Agency HR Specialist
                                     for the specified action codes.                  Personnel Actions History
                                                                                                                                Agency HR Specialist
                                                                                                                                (Correct Ability)
                                                                                                                                Central HR Report
                                                                                                                                Generator
                                                                                                                                Central HR Specialist
                                                                                                                                Central HR Specialist
                                                                                                                                (Correct Ability)
Agency/ CTHRR102 Working Test        Lists the agency employees who are in a          Administer Workforce >   Batch - Bi-      Agency HR Specialist
Central          Period Report       working test period or in durational status so   Administer Workforce     weekly           Agency HR Specialist
                                     that performance evaluations can be              (GBL) > Report > Working                  (Correct Ability)
                                                                                                                                Central HR Specialist
                                     performed and certain rights and benefits of     Test Period
                                                                                                                                Central HR Specialist
                                     permanency can be extended in a timely
                                                                                                                                (Correct Ability)
                                     manner.                                                                                    HR Auditor Functional
Agency/ CTHRR110 Seniority Report Selects Job Data, Personal Data, and                Administer Workforce >     Batch - As     Ad Hoc Report Creator
Central                           Employment information consisting of union          Administer Workforce       Needed         Agency HR Report
                                  code, employee job code, job title, employee        (GBL) > Report > Seniority                Generator
                                                                                                                                Agency HR Specialist
                                  ID, employee record number, employee                Report
                                                                                                                                Agency HR Specialist
                                  name, department ID, department
                                                                                                                                (Correct Ability)
                                  description, seniority years, months, and                                                     Central HR Report
                                  days. This report also selects position job                                                   Generator
                                  code and position job title from Position                                                     Central HR Specialist
                                  Data to identify those positions that are not                                                 Central HR Specialist
                                  filled at their established levels (i.e.                                                      (Correct Ability)
                                  underfills, trainee positions). This report                                                   HR Auditor Functional
                                  sorts by union code, employee job code,
                                  and seniority years, months and days, and
                                  page break by union.

Agency/ CTHRB301 Longevity           Use the Longevity Processed and Longevity        Compensate Employees > Batch -            Central Payroll Supervisor
Central          Reports             Exception tables to generate a Longevity         Manage Payroll Process    2x/Year         Agency Payroll Specialist
                                     Processed Report of employees processed          U.S. > Report > Longevity                 Agency HR Specialist
                                                                                                                                Central Payroll Supervisor
                                     by the Longevity Process SQR, and a              Report
                                                                                                                                (Correct Ability)
                                     Longevity Exception Report of employees
                                     who need to be processed manually.



                                                                       5 of 11                                                            8/7/2012
                                                           Human Resources Reports
Agency/ CTHRR302 Employees on   Selects employees who have leave              Administer Workforce >   Batch - As   Ad Hoc Report Creator
Central          Leave of       transactions on Job Data within the specified Administer Workforce     Needed       Agency HR Report
                 Absence Report department.                                   (GBL) > Report >                      Generator
                                                                                                                    Agency HR Specialist
                                                                              Employees on Leave of
                                                                                                                    Agency HR Specialist
                                                                              Absence
                                                                                                                    (Correct Ability)
                                                                                                                    Central BN Administrator
                                                                                                                    Central HR Report
                                                                                                                    Generator
                                                                                                                    Central HR Specialist
                                                                                                                    Central HR Specialist
                                                                                                                    (Correct Ability)
                                                                                                                    Central OPM Budget
                                                                                                                    Specialist
                                                                                                                    Central OPM Refill
                                                                                                                    Specialist
                                                                                                                    Central Payroll Supervisor
                                                                                                                    Central Payroll Supervisor
                                                                                                                    (Correct Ability)
                                                                                                                    HR Auditor Functional




Agency/ CTHRR303 Emergency       Selects the emergency contact information Administer Workforce >      Batch - As   Ad Hoc Report Creator
Central          Contacts Report from the Emergency Contacts record for     Administer Workforce       Needed       Agency HR Report
                                 employees within the specified department. (GBL) > Report >                        Generator
                                                                                                                    Agency HR Specialist
                                                                            Emergency Contacts By
                                                                                                                    Agency HR Specialist
                                                                            Dept
                                                                                                                    (Correct Ability)
                                                                                                                    Central HR Report
                                                                                                                    Generator
                                                                                                                    Central HR Specialist
                                                                                                                    Central HR Specialist
                                                                                                                    (Correct Ability)
                                                                                                                    HR Auditor Functional




                                                                   6 of 11                                                    8/7/2012
                                                              Human Resources Reports
Agency/ CTHRR305 Passport/Visa       Selects employees who have passports,             Administer Workforce >     Batch - As   Ad Hoc Report Creator
Central          Expiration          visas, or work permits on file that will expire   Administer Workforce       Needed       Agency HR Report
                 Report              in the next 90 days from the report run date      (GBL) > Report >                        Generator
                                                                                                                               Agency HR Specialist
                                     within the specified department.                  Passport/Visa Expiration
                                                                                                                               Agency HR Specialist
                                                                                                                               (Correct Ability)
                                                                                                                               Central HR Report
                                                                                                                               Generator
                                                                                                                               Central HR Specialist
                                                                                                                               Central HR Specialist
                                                                                                                               (Correct Ability)
                                                                                                                               HR Auditor Functional
Agency/ CTHRR306 Citizenship/Cou Selects all employees whose citizenship               Administer Workforce >     Batch - As   Ad Hoc Report Creator
Central          ntry/Visa Audit status, country of citizenship, and visa              Administer Workforce       Needed       Agency HR Report
                 Report          records contain any of six possible                   (GBL) > Report >                        Generator
                                                                                                                               Agency HR Specialist
                                 discrepancies.                                        Citiznship/Country/Visa
                                                                                                                               Agency HR Specialist
                                                                                       Audit
                                                                                                                               (Correct Ability)
                                     Please note that this report can only be run                                              Central HR Report
                                     by individual departments. For example, if                                                Generator
                                     your agency has 10 departments, this report                                               Central HR Specialist
                                     will need to be run 10 times.                                                             Central HR Specialist
                                                                                                                               (Correct Ability)
                                                                                                                               HR Auditor Functional
Central   CTHRR307 Monthly Union     Selects employee Job and Employment               Administer Workforce >     Batch - As   Ad Hoc Report Creator
                   Employees         information for employees in a selected           Administer Workforce       Needed       Central HR Report
                   Report            union and lists in order of job code and          (GBL) > Report > Union                  Generator
                                                                                                                               Central HR Specialist
                                     bargaining unit date.                             Employee Activity Report
                                                                                                                               Central HR Specialist
                                                                                                                               (Correct Ability)
                                                                                                                               HR Auditor Functional




                                                                        7 of 11                                                         8/7/2012
                                                              Human Resources Reports
Agency/ CTHRR460 Time Reporting        Provides the Agency Time and Labor,           Administer Workforce >   As Needed      Ad Hoc Report Creator
Central          Code                  Human Resources, or Payroll Specialists the   Capture Time and Labor >                Agency HR Report
                 Requirements          ability to report on TRCs that have been      Reports > TRC Usage                     Generator
                                                                                                                             Agency HR Specialist
                 Report                utilized during the reporting period. This    Report
                                                                                                                             Agency HR Specialist
                                       report is useful for the reporting
                                                                                                                             (Correct Ability)
                                       requirements of workers’ compensation                                                 Agency TCD Timekeeper
                                       codes for OSHA reporting, federal FMLA                                                Specialist
                                       codes, state family leave (C.G.S. 5-248a),                                            Agency Timekeeper
                                       LAW codes for leave of absence, and a                                                 Agency Timekeeper
                                       multiple of other reporting requirements.                                             Specialist
                                                                                                                             Agency TL Report
                                                                                                                             Generator
                                                                                                                             Agency Time & Labor
                                                                                                                             Specialist
                                                                                                                             Central HR Report
                                                                                                                             Generator
                                                                                                                             Central HR Specialist
                                                                                                                             Central HR Specialist
                                                                                                                             (Correct Ability)
                                                                                                                             Central TL Report
                                                                                                                             Generator
                                                                                                                             Central TL Specialist
                                                                                                                             HR Auditor Functional
Central   CTHRR905 Worker's Comp Workers Compensation Third Party                    Monitor Workplace >     Batch - Daily   Central HR Workers
                   TPA Financials Administration financial information will be       Monitor Health Safety                   Comp Specialist
                   Error Report   loaded into Core-CT. If information is not         (GBL) > Process >
                                  found, the row will be written to this report.     Worker's Comp Inbnd
                                                                                     Interface




                                                                       8 of 11                                                       8/7/2012
                                                            Human Resources Reports
Agency/ CTHRR906 Override           Lists, by department, the Employee              Administer Workforce >   Batch - Bi-   Ad Hoc Report Creator
Central          Rounding           ID/employee record combination selected         Capture Time and Labor > weekly        Central HR Report
                 Exception          for hourly rate rounding or recalculation not   Reports > Rounding                     Generator
                                                                                                                           Agency HR Specialist
                 Report             updated by the batch. This report lists the     Exception Report
                                                                                                                           Agency HR Report
                                    following exceptions: (1) employees who
                                                                                                                           Generator
                                    were selected for hourly rate rounding, but                                            Agency HR Specialist
                                    whose override rates were already                                                      (Correct Ability)
                                    populated, (2) employees who were                                                      Central Payroll Supervisor
                                    selected for docked rate re-calculation, but                                           Central Payroll Supervisor
                                    whose override rate was already populated,                                             (Correct Ability)
                                    and (3) employees who were selected for                                                Central HR Specialist
                                    docked rate re-calculation, but whose                                                  (Correct Ability)
                                    required rates and standard hours were not                                             Agency TCD Timekeeper
                                                                                                                           Specialist
                                    populated prior to batch execution.
                                                                                                                           Central TL Specialist
                                                                                                                           Central TL Report
                                                                                                                           Generator
                                                                                                                           Agency TL Report
                                                                                                                           Generator
                                                                                                                           Agency TL Specialist
                                                                                                                           HR Auditor Functional



Agency/ OHS009    Incident Detail   Lists, in addition to the occurrence            Monitor Workplace >       Batch - As   Central HR - WC
Central                             information, all causes and related             Monitor Health Safety     Needed       Specialist
                                    corrective actions, witnesses, involved         (GBL) > Report > Incident              Central HR - WC
                                                                                                                           Manager
                                    persons (including detailed injury              Detail
                                    information), OSHA information, lost work,
                                    and physician information.
Agency/ OHS010    Incident          Summarizes health and safety incidents that     Monitor Workplace >       Batch - As   Central HR - WC
Central           Summary           have occurred within a specified date range.    Monitor Health Safety     Needed       Specialist
                                    This report lists all involved persons and      (GBL) > Report > Incident              Central HR - WC
                                                                                                                           Manager
                                    indicates whether an OSHA report was filed      Summary
                                    related to a person's involvement.




                                                                      9 of 11                                                        8/7/2012
                                                           Human Resources Reports
Agency/ OHS011   Location      Summarizes the incidents that occurred at            Monitor Workplace >       Batch - As   Central HR - WC
Central          Incident      specific locations and within the specified          Monitor Health Safety     Needed       Specialist
                 Summary       date range. This report lists all persons            (GBL) > Report > Location              Central HR - WC
                                                                                                                           Manager
                               involved in the incident and indicates               Incident Summary
                               whether or not they received an OSHA
                               reportable illness or injury.
Agency/ OHS012   Claim Summary Summarizes claims that have been logged              Monitor Workplace >       Batch - As   Central HR - WC
Central          Overview      within a specified date range. This report           Monitor Health Safety     Needed       Specialist
                               itemizes by amounts within a Charge Type,            (GBL) > Report > Claim                 Central HR - WC
                                                                                                                           Manager
                               subtotals by Charge Type, subtotals by               Summary Overview
                               claim, and then calculates a grand total of all
                               charges within the reporting period.

Agency/ OHS013   Employees in     Summarizes employees involved in                  Monitor Workplace >       Batch - As   Central HR - WC
Central          Incidents        incidents that have occurred within a             Monitor Health Safety     Needed       Specialist
                                  specified date range, and notes whether the       (GBL) > Report >                       Central HR - WC
                                                                                                                           Manager
                                  employee has suffered an injury or illness.       Employees In Incidents

Agency/ OHS015   Incident Claim   Lists the claims filed for a specific incident,   Monitor Workplace >       Batch - As   Central HR - WC
Central          Detail           the employee filing the claim, provider           Monitor Health Safety     Needed       Specialist
                                  information related to the claim, and detailed    (GBL) > Report > Incident              Central HR - WC
                                                                                                                           Manager
                                  charges (by charge type) related to the           Claim Detail
                                  claim. This report subtotals by charge type
                                  within a claim, subtotals by the claim itself,
                                  and then provides a grand total of all claim
                                  charges for the incident.

Agency/ OHS018   OSHA 300         Lists the case numbers and details of each        Monitor Workplace >       As Needed    Agency HR - WC
Central          Incident Log     injury and illness that occurred during a         Report Regulations (US) >              Specialist
                                  particular calendar year.                         Report > OSHA 300
                                                                                    Incident Log
Agency/ OHS019   OSHA 300A        Summarizes the OSHA incidents that                Monitor Workplace >       As Needed    Agency HR - WC
Central          Annual           occurred during a particular calendar year.       Report Usa Regulations >               Specialist
                 Summary                                                            Report > OSHA 300A
                                                                                    Annual Summary




                                                                    10 of 11                                                       8/7/2012
                                                              Human Resources Reports
Central   PER031   EEO-4 State       Provides employment counts in the                Monitor Workplace >      Batch -           Ad Hoc Report Creator
                   and Local         prescribed format for state and local            Report Usa Regulations > Annually          Central HR Regulatory
                   Government        governments.                                     Report > EEO-4 State and                   Req Specialist
                                                                                                                                 Central HR Report
                   Information                                                        Local Govt
                                                                                                                                 Generator
                                                                                                                                 HR Auditor Functional
Central   PER538   Accomplishment Lists all defined accomplishments.                  Develop Workforce >           Batch - As   Central HR Specialist
                   Listing                                                            Manage Competencies           Needed       Central HR Specialist
                                                                                      (GBL) > Report >                           (Correct Ability)
                                                                                      Accomplishment Listing
Agency/ POS002     Active/Inactive   Lists the current position-related data for      Develop Workforce >           Batch - As   Central HR Position
Central            Positions         active positions, inactive positions, or both,   Manage Positions > Report     Needed       Approver
                                     depending on which you select to run.            > Active/Inactive Positions                Central OPM Budget
                                                                                                                                 Specialist
                                                                                                                                 Central OPM Section
                                                                                                                                 Director
Agency/ POS003     Incumbent         Lists, by position, all current and former       Develop Workforce >       Batch - As       Central HR Position
Central            History           incumbents in Core-CT, beginning with the        Manage Positions > Report Needed           Approver
                                     current incumbent for each position and          > Incumbent History                        Central OPM Budget
                                                                                                                                 Specialist
                                     going back in time. This report prints entry
                                                                                                                                 Central OPM Section
                                     and exit dates for each incumbent, and
                                                                                                                                 Director
                                     starting and ending salaries.




                                                                        11 of 11                                                          8/7/2012

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:120
posted:8/8/2012
language:Latin
pages:11