Penn State mark   AIS Header AIS Home Page link ITS Home Page link
in:
AIS Home > Data Warehouse > DW Access

Data Warehouse Access


  1. If you do not already have an AIS Account, request one through your Access and Security Representative (ASR). 


  2. Select the database from the list below and submit a request to the assigned Data Steward.

     For Access To:  Database Name
    ASR Data -- access security representative user information.  asr
    Facility Data -- specific information on classrooms and scheduling.  facility
    Dickinson School of Law Student Data  student
    IBIS Financial Data   ibisfin
    IBIS Human Resources Data  ohr
    IBIS Pay & Effort Data  payeffort

    IBIS Position Information

     position
    IBIS Vendor Data  vendor
    ISIS Bursar Data -- student billing information.  bursar
    ISIS Certificates Data - certificates information   certificates
    ISIS Degree Audit Data - review program defintions for majors, minors and entrance to major.  degreeaud
    ISIS DUS Data -- Department of Undergraduate Studies information.  dus
    ISIS Enrollment Data -- weekly student enrollment information.  enrollment
    ISIS Admissions Data -- undergraduate applicant information.  ugapplic
    ISIS Graduate Applicant Data -- graduate applicant data.  gradappl
    ISIS Housing Data -- Housing & Food Services data.  housing
    ISIS NonCredit Data -- noncredit student data.  noncredit
    ISIS Officially Reported Student Data  official
    ISIS Retention Data -- student retention and progression information.  retention
    ISIS Student Adult Learner Data  student

    ISIS Student Athletic Data

     student
    ISIS Student Data  student
    ISIS Student Emergency Contact Information Data  student
    PCard Data - purchasing card information  pcard
    PSUIDCHG - PSU ID Change information  psuidchg
    Scholars Data  scholars
    SRTE Data  srte
    ULRC Data  ulrc

    For additional information on each database see Penn State's Data Warehouse Database Documentation.

    • Tech Support Personnel Access.  If you need a userID and password to test connectivity, please send a request to your Area Security Representative (ASR) for approval. Your ASR will then forward the approved request to the Administrative Security Office with a note specifying who you are and what organization(s) you support.

      The Security Office will issue you a userID and password for the warehouse. This will not give you access to production data, but will allow you to test connectivity to the data warehouse and know that data can be returned to the microcomputer.

         



      Questions: AIS Support
      Printer friendly view



      The Pennsylvania State University © 2008 | Copyright | Privacy and Legal Statements | Alternative Media - Nondiscrimination Statement
      This site is maintained by Administrative Information Services, a unit of Information Technology Services.
      Provide site feedback to AIS-webmaster@psu.edu. Can't find it? Ask AIS
      Last revised: Wednesday, May 14, 2008 16:16