Mount Hood

Newsletter – July 2014

Welcome to the Data Warehouse Newsletter

July 2014

As the Data Warehouse grows, UCS endeavors to keep all warehouse users updated with new data, new features and changes as they arise. This monthly newsletter is the beginning of that regular communication. It will also be posted to our WordPress site (click any of the links above to get there).

We are also actively working on a Data Dictionary. The Data Dictionary will allow all warehouse users to see the “definitions” of each star, cube, dimension and column. This will include the source system and column(s), as well as notes and special details when using specific columns of data.

Members of the Warehouse team have visited people in various areas on campus. We verified that each group of people could login to Cognos, run reports, etc…

Major updates during June & July:

(Note: if you see [QA] after an item below it is currently in testing, before being delivered to Production)

New data elements:

  • A flag has been added to Grade Code to indicate if it should be excluded from calculations. [QA]
  • Special Courses with a course # less than 100 [QA]
  • Sequence # added to Course/Section
  • Student advisor [QA]
  • International Student indicator, Full Name, Preferred First Name
  • HR data elements [QA]

New data areas:

  • Transfer Grades & Transfer Schools. [QA]
  • FIS: Index Codes!!!
  • Admissions: Test scores

New reports have been released into Production! Click the “Reports” link at the top of this document to see all reports. Check back often to see the new reports we continue to finish and release!

Questions?

If you can’t find data you need, or have questions about existing data or columns, PLEASE contact us at:
data-warehouse@mail.wou.edu

Hello world!

Welcome to WOU. This is your first post. Edit or delete it, then start blogging!