University of Oregon

Data Warehouse FAQ

Audience
Faculty/Staff
Researcher
Student
GTF
How do I select students who are enrolled in a given course in the SIS DWHS?

The Registration object contains not just enrollments, but also records of course drops, complete withdrawls, etc. In addition to constructing the query you want, using data from the Person and Students objects, for example, do the following:

  • To select students who are actually taking a course for credit, qualify the Credit Hours attribute in the Registration object to be >0
  • To select students who are officially enrolled, including audits, no-refund drops and withdrawals, qualify the Count in Enrollment attribute in the Registration object to be = Y.

Was this helpful?

My Rating:
Average Rating:
4
How do I identify Self Support courses in SIS DWHS?

Self Support courses are identified in the Schedule object. Qualify the Self Support Flag to be = Y in the Schedule object.

To identify Self Support courses in either the Transcript or Registration objects, you need to join them with the Schedule object, and qualify the Self Support Flag to be = Y.

Was this helpful?

My Rating:
Average Rating:
4
Label Generation in SIS DWHS

Typicaly one selects from the Address object, the following fields:

  • FML Name
  • Address Line 1
  • Address Line 2

and you would probably want to qualify on the Address Code Type, at least. In addition, some further selection criteria might be desired, for example sorting by a field such as Zip Code (Address object) or Last Name (Person object). To accomplish this, you select (so that the field has the "blue dot") the field you would like to sort, Last Name for example. After you retrieve all of the records, you hide the Last Name column and then click on Results -> Show as Report -> Labels.

Was this helpful?

My Rating:
Average Rating:
0