Penn Computing

University of Pennsylvania
Penn Computing << go backback

COURSE INV_DESC_TEXT Table . Tables and Data Elements . Student Records Data Home . Data Warehouse Home

COURSE INV DESC TEXT Table - Data Element Index

 
 
Data Element Mapping back to SRS Definition
Course_Id

RI005 COURSE NUMBER

Natural alias: CIF-ID-RI

part of the context line for SRS screen 1D4

The unique identifier of each course offered by Penn. A course, in contrast to a course_section, is not specific to a particular term. A course must exist at the inventory level for a section of that course to be offered in a term.

POSITIONS 1-4: Subject Area -- The academic discipline under which a course is offered. Each academic discipline is associated with a department.
POSITIONS 5-7:
100-399 UNDERGRADUATE COURSES
400-499 MIXED UNDERGRAD/GRAD COURSES PRIMARILY FOR UNDERGRADS
500-599 MIXED UNDERGRAD/GRAD COURSES PRIMARILY FOR GRAD AND
PROFESSIONAL STUDENTS
600-989 GRAUDATE/PROFESSIONAL COURSES
990-999 GRADUATE/PROFESSIONAL INDIVIDUAL STUDY COURSES

Paragraph_Number

RJ007 DESCRIPTION ITEM

NATURAL ALIAS: ITEM-RJ

part of the context line for SRS screen 1D4

Only inventory course description text from the "paragraph" items are extracted to the warehouse. A course description can have up to 4 paragraphs. The SRS description items 6, 7, 8, and 9 correspond to Paragraph Numbers 1, 2, 3, and 4, respectively.

Course_Description

RJ210 TEXT

NATURAL ALIAS: TEXT-RJ

appears on SRS screen 1D4

The text that describes the course, for a specified paragraph from the inventory description.

COURSE INV DESC_TEXTTable . Tables and Data Elements . Student Records 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