Penn Computing

University of Pennsylvania
Penn Computing << go backback

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

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania