Accessing OHR Data Requests for authorization of data warehouse user access to the OHR data should be directed, via the Dean or Administrative Officer, to: Mike Hartman (mwh2@psu.edu) Manager of Information Systems and Records Office of Human Resources Upon approval of authorization, the request will be forwarded to the AIS Security Office for assignment of a Data Warehouse userID and password. You will then be notified of your access privileges, userID and password.  All OHR users will be automatically given access to all records on the EMPLOYEE, SECONDARY_APPT, and ACCESS_ID tables.   In order to grant access to any additional tables, more information must be specified.  Access to the additional tables is limited per Administrative Area number(s) and Department Mnemonic. The following information is required to process the request: Example: Please provide the following individual(s) access to the OHR database:     PERSONNEL INFORMATION         Name:  _____________________________________________________         Email:  _____________________________________________________         AIS ID:  ____________________________________________________         Administrative Area number(s): _________________________________         Department Mnemonic (upper case): _____________________________         (If the mnemonic contains blanks, indicate such with a lower case "b", e.g. ,IbFbS.)    TABLE ACCESS INFORMATION (check all that apply)         Default access (bi_ohropen):                       __X__         Affirmative Action access (bi_ohraffaction):  _____         Salary access (bi_ohrsalary):                      _____        Wage access (bi_ohrwage):                         _____ These individuals have an excellent understanding of OHR related data. These individuals have read and understand University policies AD-20 and AD-23 regarding the confidentiality of data. These individuals have an understanding of the University's IBIS system and of data analysis. By virtue of the fact that these individuals will be downloading Computerized Institutional Data to their own microcomputers or servers, they are now operating an Operational Computer Facility and agree to conform to the requirements of an Operational Computer Facility as outlined in University Policy AD-23 and University Guideline ADG-02.

Printer friendly view