1 / 10

Human Resources Data Warehouse

Human Resources Data Warehouse. January 9, 2007. What is the HR data warehouse?.

geraldine
Download Presentation

Human Resources Data Warehouse

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Human Resources Data Warehouse January 9, 2007

  2. What is the HR data warehouse? • It is a collection of tables and views containing information that is either stored or can be derived from Banner and the HR forms. It contains only current personal information on an employee and his/her job(s). The data warehouse is refreshed from Banner every day except for the weekends and holidays.

  3. Who can use it? • Anyone can request it but they must already have HR Banner Authorization and Org Security. The HR data warehouse request form can be found at • http://www.is.mcgill.ca/minerva/reporting/reqdatawarehouse.htm . The HR data warehouse security is based on Org security. The Finance data warehouse is based on both Fund and Org security and this allows for Research directors to report on their funds. However, the HR data warehouse is based solely on Org security and thus, we only grant access to those employees who are responsible for their whole department or faculties and who already have the necessary HR authorization to see the HR Banner forms.

  4. Why is the HR data warehouse used? • It is used for reporting in general. It is useful for departmental level reporting up to governmental reports. It can be used for statistics, headcounts, mailing labels, etc.

  5. How can you access the HR data warehouse? • It requires a reporting tool as it is NOT directly on Banner. In this presentation, you will see Microsoft Access used but almost any reporting tool can be used. We will also look at the Minerva Reports Menu. • The three major tables / views that you will need in general are: • DWH.HR_PERS – contains employee personal info + major job details • DWH.HR_JOB – contains job related information • DWH.HR_LBD – contains labour distribution information • The HR Data Warehouse data model and dictionary can be found at http://www.mcgill.ca/hr/forms/ under Records & Systems / Data Model.

  6. Who can you contact if you are having problems with the HR data warehouse? • If they are technical problems, please contact your LAN Administrator or the ICS help desk. If it is concerning the data or fields on the HR data warehouse, please contact Nancy Wong, Human Resources at local 2223.

  7. Appendix A – MS Access Data warehouse

  8. Appendix B – MS Access Set Up

  9. Appendix B – cont’d

  10. Appendix C – Minerva HR Data Warehouse Query

More Related