Data Warehouse

• Information Technology
  • Data Warehouse
    • News / Status
      • Ethnic Origin Change
    • Help
      • Migrating Documents to version 12.x
      • Uploading version 12.x Documents
    • Query and Reporting Tools
    • Download
      • Install steps
    • Links
    • Student Data
      • Access Procedure
      • Data Refresh Schedule
      • Documentation
    • Financial Data
      • Access Procedure
      • Data Refresh Schedule
      • Documentation
    • Peer Review

Student Data

The Student Data Warehouse was the first data warehouse to be developed at WSU. It consists of demographic information about students as well as the courses in which they are enrolled. The warehouse also contains enrollment statistics for each course offering (section). In addition, the data necessary to support this information is also stored in the warehouse.

Below is a list of the major classes of data currently in the student data warehouse:

• Academic Course
• Academic Degree Conferment
• Academic Section
• Address
• Course Section Snapshot
• Email Address
• Snapshot Generation
• Student
• Student Center Snapshot
• Student Certificate
• Student Course Snapshot
• Student Course Transcript
• Student NCATE Endorsement
• Student Snapshot
• Student Transcript
• Supporting Data

For more details on these classes and the data objects that they contain see the data warehouse universe documentation.

Data Use

1. Access to data for departmental and college use only.
2. • Must be for official use only
   • Should not be shared with third parties (even directory information)
   • Personally identifiable information cannot be shared outside the university
   • Reports cannot be shared outside the university until the figures have been checked by Institutional Research to make certain they are consistent with official university figures
3. Published reports must not include personally identifiable information.
4. Access to the Data Warehouse must be protected from unauthorized use.
5. Departments and colleges should generally access only their students' data.
6. • Mailings should be restricted to those students within the college or department
   • Reports should be restricted to student data within the college or department
   • Institutional Research should be consulted for university-wide studies
7. Enrollment reporting is the domain of Institutional Research and the Registrar's Office.
8. • Departments and colleges should not report enrollment using the Data Warehouse
   • Questions regarding perceived enrollment discrepancies, should be directed to Institutional Research or the Registrar's Office
   • Enrollment and FTE reports should be for internal use and should be considered estimates

Information Technology Services, PO Box 641222, Washington State University, Pullman WA 99164-1222 509-335-4357, Contact Us