HR Workforce Data

The HR/Payroll Datamart (HRPYDM) provides self-service access for departments to certain workforce data, in addition to several commonly requested pre-written reports. HR will continue to develop new reports, and the expansion of data and capabilities of HRPYDM is underway.

This first phase of HRPYDM contains workforce data, such as job information (e.g., department, job title, full-time status, leave status, union and employee type), basic personal and demographic information, and other similar data.

Employees with a clear and explicit business need may request access to HRPYDM via Kuali Build. Users access HRPYDM via the WebFOCUS reporting tool. Due to the nature of the data, HR will limit access to HRPYDM and will review all justifications for access. Credentialed users must take a 15-minute WebFocus training.

Available HR and Payroll Reporting (HRPYDM) Standard Reports

CoreCT job data begins in 9/16/2016 and is updated nightly.

All Employees

Employee History
List of all CoreCT job rows for one employee at a time.

  • Prompts:
    • Employee ID (123456) - Six (6) digit CoreCT Employee ID (with leading zeroes)
    • History
      • All – All job history rows
      • Corrected – Only display the newest job row for each Effective Date (aka job rows with max Effective Sequence by Employee ID, Employee Record & Effective Date)
    • Output
      • HTML
      • Excel

Employee Lookup
Lookup Employee by Employee Number, NetID or Name.
Note: Output always runs to HTML.

 

  • Prompts:
    • Run Report By:
      • Employee ID (123456) - Six (6) digit CoreCT Employee ID (with leading zeroes)
      • NetID (abc12345) – UConn NetID
      • Name (Last, First) – Legal Name
    • Enter Value – Type the corresponding value for what you selected in the “Run Report by” prompt. For example, if you select “Name (Last, First)” enter “Husky, Jonathan”

Roster – Current – All Employees
List of basic job-related information for all current employees.

  • Prompts:
    • Department
      • Drop down list of Department ID and Name
    • Include All Org Levels?
      • Y – Include all Departments that report to the selected Department
      • N – Only include the selected Department
    • Employee Group - Select one or more of the following:
      • Select All
      • Classified (UCL)
      • Unclassified (UNCL)
      • Grads (UGR) – Graduate Assistants & Graduate Professional Interns
      • Special – Time Reporters (USPT)
      • Special – Non-Time Reporters (USPN) – Includes Adjuncts
      • Student Labor (USL)
      • Work Study (UWS)
    • Output
      • HTML
      • Excel

Roster – Point in Time – All Employees
List of basic job-related information for all employees as of a user-specified date (9/16/16 or later).

  • Prompts:
    • Department
      • Drop down list of Department ID and Name
    • Include All Org Levels?
      • Y – Include all Departments that report to the selected Department
      • N – Only include the selected Department
    • As of Effective Date – User-specified date
    • Include Rows Posted After As of Date?:
      • Y – Include Retroactive job rows (i.e. job rows where the Action Effective Date is less than the Action Posted Date)
      • N – Exclude Retroactive job rows
    • Employee Group(s) - Select one or more of the following:
      • Select All
      • Classified (UCL)
      • Unclassified (UNCL)
      • Grads (UGR) – Graduate Assistants & Graduate Professional Interns
      • Special – Time Reporters (USPT)
      • Special – Non-Time Reporters (USPN) – Includes Adjuncts
      • Student Labor (USL)
      • Work Study (UWS)
    • Output
      • HTML
      • Excel

Classified Employees

Roster – Current – Classified Compensation
List of basic job-related information for all current classified employees, including salary.

  • Prompts:
    • Department
      • Drop down list of Department ID and Name
    • Include All Org Levels?
      • Y – Include all Departments that report to the selected Department
      • N – Only include the selected Department
    • Output
      • HTML
      • Excel

Roster – Point in Time – Classified Compensation
List of basic job-related information for all classified employees, including salary as of a user-specified date (9/16/16 or later).

  • Prompts:
    • Department
      • Drop down list of Department ID and Name
    • Include All Org Levels?
      • Y – Include all Departments that report to the selected Department
      • N – Only include the selected Department
    • As of Effective Date – User-specified date
    • Include Rows Posted After As of Date?:
      • Y – Include Retroactive job rows (i.e. job rows where the Action Effective Date is less than the Action Posted Date)
      • N – Exclude Retroactive job rows
    • Output
      • HTML
      • Excel

 

Graduate Assistants & Grad Prof Interns

Roster – Current – Grad Compensation
List of basic job-related information for all current graduate employees, including hourly rate and estimated pro-rated annual salary.

  • Prompts:
    • Department
      • Drop down list of Department ID and Name
    • Include All Org Levels?
      • Y – Include all Departments that report to the selected Department
      • N – Only include the selected Department
    • Output
      • HTML
      • Excel

Roster – Point in Time – Grad Compensation
List of basic job-related information for all graduate employees, including hourly rate and estimated pro-rated annual salary as of a user-specified date (9/16/16 or later).

  • Prompts:
    • Department
      • Drop down list of Department ID and Name
    • Include All Org Levels?
      • Y – Include all Departments that report to the selected Department
      • N – Only include the selected Department
    • As of Effective Date – User-specified date
    • Include Rows Posted After As of Date?:
      • Y – Include Retroactive job rows (i.e. job rows where the Action Effective Date is less than the Action Posted Date)
      • N – Exclude Retroactive job rows
    • Output
      • HTML
      • Excel

Special Payroll (including Adjuncts)

Roster – Current – SpecPay Stipends
List of basic job-related information for all current Special Payroll employees, including Stipend Amounts and Hourly Rate for USPT.

  • Prompts:
    • Department
      • Drop down list of Department ID and Name
    • Include All Org Levels?
      • Y – Include all Departments that report to the selected Department
      • N – Only include the selected Department
    • Stipends
      • Current – Special Payroll job rows that are active in CoreCT and the Stipends are currently active
      • All – Special Payroll jobs that are active in CoreCT even if the Stipends have expired or have not started yet
    • Employee Group - Select one or more of the following:
      • Select All
      • Special Payroll Non-Time Reporters (USPN)
      • Special Payroll Time Reporters (USPT)
    • Output
      • HTML
      • Excel

Roster – Point in Time – SpecPay Stipends
List of basic job-related information for all current Special Payroll employees, including Stipend Amounts and Hourly Rate for USPT as of a user-specified date (9/16/16 or later).

  • Prompts:
    • Department
      • Drop down list of Department ID and Name
    • Include All Org Levels?
      • Y – Include all Departments that report to the selected Department
      • N – Only include the selected Department
    • As of Effective Date – User-specified date
    • Include Rows Posted After As of Date?
      • Y – Include Retroactive job rows (i.e. job rows where the Action Effective Date is less than the Action Posted Date)
      • N – Exclude Retroactive job rows
    • Stipends
      • Current – Special Payroll job rows that are active in CoreCT and the Stipends are currently active
      • All – Special Payroll jobs that are active in CoreCT even if the Stipends have expired or have not started yet
    • Include Gratis?
      • Y – Gratis included
      • N – Gratis excluded
    • Employee Group - Select one or more of the following:
      • Select All
      • Special Payroll Non-Time Reporters (USPN) – Includes Adjuncts
      • Special Payroll Time Reporters (USPT)
    • Output
      • HTML
      • Excel

Student Employees

Roster – Current – Student Employment Compensation
List of basic job-related information for all current student employees, including hourly rate.

  • Prompts:
    • Department
      • Drop down list of Department ID and Name
    • Include All Org Levels?
      • Y – Include all Departments that report to the selected Department
      • N – Only include the selected Department
    • Employee Group - Select one or more of the following:
      • Select All
      • Student Labor (USL)
      • Work Study (UWS)
    • Output
      • HTML
      • Excel

Roster – Point in Time – Student Employment Compensation
List of basic job-related information for all current student employees, including hourly rate as of a user-specified date (9/16/16 or later).

  • Prompts:
    • Department
      • Drop down list of Department ID and Name
    • Include All Org Levels?
      • Y – Include all Departments that report to the selected Department
      • N – Only include the selected Department
    • As of Effective Date – User-specified date
    • Include Rows Posted After As of Date?:
      • Y – Include Retroactive job rows (i.e. job rows where the Action Effective Date is less than the Action Posted Date)
      • N – Exclude Retroactive job rows
    • Employee Group - Select one or more of the following:
      • Select All
      • Student Labor (USL)
      • Work Study (UWS)
    • Output
      • HTML
      • Excel

Unclassified

Roster – Current – Unclassified Compensation
List of basic job-related information for all current unclassified employees, including all salary components.

  • Prompts:
    • Department
      • Drop down list of Department ID and Name
    • Include All Org Levels?
      • Y – Include all Departments that report to the selected Department
      • N – Only include the selected Department
    • Output
      • HTML
      • Excel

 

Roster – Point in Time – Unclassified Compensation
List of basic job-related information for all current unclassified employees, including all salary components as of a user-specified date (9/16/16 or later).

  • Prompts:
    • Department
      • Drop down list of Department ID and Name
    • Include All Org Levels?
      • Y – Include all Departments that report to the selected Department
      • N – Only include the selected Department
    • As of Effective Date – User-specified date
    • Include Rows Posted After As of Date?:
      • Y – Include Retroactive job rows (i.e. job rows where the Action Effective Date is less than the Action Posted Date)
      • N – Exclude Retroactive job rows
    • Output
      • HTML
      • Excel

Staff

BUSINESS INTELLIGENCE (BI) & DATA REPORTING

Contact HRIS

Rob Boncoddo
Lead Data & Reporting Analyst

Benjamin Alejandro
Data & Reporting Analyst

Maureen Palmer-Lavoie
Data Management Coordinator

Additional HR Data Requests