The Pennsylvania State University - Administrative Information Services, a unit of Information Technology Services

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:

Steve Selfe 
(srs1@psu.edu)
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):                         _____

Please provide a reason/rational for this request to include the specific user needs and uses of this data.

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.

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.

Content Questions: AIS Support | Support Questions: AIS Support