Penn Computing

University of Pennsylvania
Penn Computing << go backback

COURSE LIST Table - Data Element Index . Tables and Data Elements . Academic Planning Worksheet Data Home . Data Warehouse Home

COURSE LIST Table

Explanation

Provides the courses associated with a specific course list id and course list name used by Requirements to identify a specific list of courses that can be used to fulfill the requirement.

Common Uses

  • Find the list of courses that can be used to satisfy a given requirement.
  • Find whether a specific course is in a specific list.
Primary Key Indexed Data Elements Related Tables
COURSE_LIST_ID, COURSE_ID OWNER_DIVISION, OWNER_DEPT REQUIREMENT
REQUIREMENT_VALID

 

Cautions

  • Selecting a condition on one of the Owner columns will return the lists maintained by that Division or Department, but not necessarily the lists used by that Division or Department. In REQBUILD, requirement builders may reference any list in their component lines, whether or not they maintain the list.

COURSE LIST Table - Data Element Index . Tables and Data Elements . Academic Planning Worksheet 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