Human Resources Data Store (HRDS)
Overview
The Human Resources Data Store (HRDS) contains data from the People@Columbia (PAC) system as well as other HR related systems such as TalentLink and PageUp (recruitment). PAC is used by the Human Resources Department to maintain the University's personnel records. HR keeps information on regular employees and retirees accurate and up-to-date by registering personnel changes as they occur. HRDS contains employment status information for individual employees and retirees. Data is updated daily and is available from 1995 to present.
Available Data
Predefined HRDS reports are available from a wide cross section of subject areas including:
- Employee Actions
- Employee Personal Data
- Job Data
- Labor Accounting (LA)
- Payroll
- Recruitment
- Vacation Accrual
- Workforce Demographics
HRDS Reports
Reports are written in either Crystal Reports or Web Intelligence (Webi). The BI Launch Pad is the entry point to accessing of all your provisioned reports. Reports are organized into folders by functional area. Examples of frequently used HRDS reports include:
- Report Name
- Active Positions Report
- Short Description
- Shows all active University positions that are vacant or filled. Data is sorted by Department, Job Code and Position Number.
- Report Name
- Active Positions and Incumbents Report
- Short Description
- Shows all active University positions (vacant or filled) and the names of staff filling any of the positions. Data is sorted by Department, Job Code and Position Number.
- Report Name
- Department Administrator Report
- Short Description
- Extract of salient data for those whose UNIs, as received from the PAC system, identify them as authorized Department Administrators.
- Report Name
- Employee Overtime/Casual Data
- Short Description
- By selected administrative department,earnings and position-related data for overtime workers and casual employees, respectively, as recorded on PAC.
- Report Name
- Post-Docs Demographic Report
- Short Description
- Shows demographics for all first time post-docs by department and title effective date.
- Report Name
- Recertification Reports
- Short Description
- Extracts salient personnel data to support faculty recertification within four professional categories: tenured and non-tenured Officers of Instruction, Officers of Research and Officers of the Library.
- Report Name
- Salary Planning Report
- Short Description
- Extract of annual salary increases and other personnel information for verification of automated HR process.
- Report Name
- Termination Report
- Short Description
- Shows details of terminated employees based upon department range and Position Effective Date or Termination Action Date.
- Report Name
- Upcoming/Past Visa/Permit Expiration Date Report
- Short Description
- Summary data for all employees who have a visa whose expiration date occurs within three months from the date of the extract's run.
- Report Name
- Upcoming/Past Appointment End Date Report
- Short Description
- Summary data for all employees whose appointment end date occurs within three months from the date of the extract's run.
- Report Name
- Vacation Accrual Report
- Short Description
- Report is generated annually at the end of the University fiscal year for Departmental Administrators. It is designed to track vacation accrual of employees within an administrator's authorized department(s).
Data Refresh Schedule and Frequency
The HRDS data refresh cycle runs daily starting from approximately 12 midnight and completing at approximately 7am. During this refresh period, the HRDS is loaded and refreshed with current data.
Getting Access
Access to the HRDS Reports is governed by the role(s) that a person has in PAC. The Manager Self-Service, Enhanced Manager Self-Service and Management Reporting roles are the primary ones that grant this access. The link to the PAC access form as well as to ELM training can be found here.
Once access is granted, HRDS reports are available by logging on to my.columbia.edu, clicking on the Enterprise Reports tab, and then clicking BI Launch Pad icon.
Training and Job Aids
- Quick Guide: Accessing and Generating HR Data Reports - details how to navigate the reporting platform to access and generate HR Manager/Data reports.
- HR Data Reports Training Guide - provides guidance for accessing and generating HR Data Reports.