COURSE
XLIST INVENTORY Table - Data Element Index . Tables
and Data Elements . Student
Data Home . Data Warehouse Home
COURSE XLIST INVENTORY Table
(dwadmin.course_xlist_inventory)
Explanation
List of possible courses that can be crosslisted with a primary course, as
defined in the SRS Course Inventory.
Common Uses
- Find all the courses that can be cross-listed with a particular course.
Primary Key |
Indexed Data Elements |
Related Tables |
COURSE_ID, COURSE_FIRST_TERM |
COURSE_FINAL_TERM, XLIST_COURSE_ID |
COURSE_INVENTORY |
Cautions
- Not every course in the inventory has crosslistings. If you want to get
courses from the inventory, and only some of them have crosslistings but you
want to see all of them in your report, you will have to use an outer join.
(Business Objects users: the join between Course Inventory and Course Xlist
Inventory is already set as an outer join in the STDTCANQ universe.)
- Just because a course *can* be crosslisted, as defined in the inventory,
does not mean it always *is* crosslisted in any given term.
COURSE
XLIST INVENTORY Table - Data Element Index . Tables
and Data Elements . Student
Data Home . Data Warehouse Home
Questions about this page? Email us at da-staff@isc.upenn.edu
|