COURSE_XLIST column definitions . Pennant Student Records Home . Data Warehouse Home

COURSE_XLIST table

(dwngss_ps.course_xlist)

Explanation

In the course catalog, there are primary courses and when another course is essentially the same it is called an "Also Offered As" course. This is sometimes referred to as cross-listing, although in Pennant the correct terminology is "Also Offered As".

The COURSE_XLIST table contains all of the partners in the "Also-Offered-As" familiy. One course in each family is considered the primary and all others are secondary.

Source

The warehouse COURSE_XLIST table is refreshed in batch mode from the Operational Data Store (ODS), which gets its data from the Banner database. The UPENN_ODS source tables are SATURN_SCBCRSE and SATURN_SCBSUPP. In the online Pennant system, the Also-Offered-As family number and primary/secondary indicator can be viewed on the SCADETL form, Supplemental Data tab, in the field "Course Identifier." Also-Offered-As relationships are maintained in the Course Inventory Management (CIM) system.

Common Uses

• Finding courses that belong to the same Also-Offered-As "family".
• Identifying primary "owner" course for an Also-Offered-As family of courses.

Cautions and notes

• Also-Offered-As courses are defined in the Curriculum Management system. When course sections are scheduled, the family relationships in the Course record are carried forward into the course section. However, departments are allowed to set up course sections that meet at the same time and place, taught by the same instructor, that are not identified in the Course record as Also-Offered-As. Course sections that meet together are "scheduled with" each other, and they share a "sheduled with group" ID. See the table CRSE_SECT_SCHED_WITH.

COURSE_XLIST column definitions . Pennant Student Records Home . Data Warehouse Home