Penn Computing

University of Pennsylvania
Penn Computing << go backback

COURSE INV DESC TEXT Table - Data Element Index . Tables and Data Elements . Student Data Home . Data Warehouse Home

COURSE_INV_DESC_TEXT Table

(dwadmin.course_inv_desc_text)

The Course Inventory Description Text table has the full text of the course description as it appears in the Course Register publication. These descriptions are entered in SRS on screen 1D4, and can be defined as belonging to separate paragraphs for publication printing. There can be up to four paragraphs per course ID.

Common Uses

  • List all courses where the text string "data analysis " appears in the paragraphs of the course description in the Course Register.
  • Find all courses that do not have a course description in the Course Register.
Primary Key Indexed Data Elements Related Tables
COURSE_ID, PARAGRAPH_NUMBER COURSE_INVENTORY COURSE_INVENTORY_DESC

Cautions

  • Only data from the "paragraph" items in the SRS Course Descriptions are extracted to the warehouse. Courses with nothing in the items # 6, 7, 8, or 9 on SRS screen 1D4 will not have description data in this table.
  • A course can have up to 4 paragraphs in its description; these are stored in separate rows in the COURSE INV DESC TEXT table, one row per paragraph per course_id.
  • Although there can be more than one entry in the COURSE_INVENTORY table for a given course, it should be assumed that the description paragraphs belong to the most recent entry for that Course_Id in the COURSE_INVENTORY table.

COURSE INV DESC TEXT 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