Penn Computing

University of Pennsylvania
Penn Computing << go backback

COURSE INVENTORY DESC Table . Tables and Data Elements . Student Data Home . Data Warehouse Home

COURSE INVENTORY DESC Table - Data Element Index

 
Data Element Mapping back to SRS Definition
Course_Id

RI005 COURSE NUMBER

Natural alias: CIF-ID-RI

used in the context line for all SRS course inventory screens

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

Course_Title

RJ210 TEXT

Natural alias: TEXT-RJ

appears on SRS screen 1D4, when the "Item" is entered in the context line = 1.

The title of the course as it appears in the Course Register publication. This may not be the same as the course title found in the COURSE_TERM table. For example, the title in COURSE_INVENTORY_DESC might be "Special Topics" and the title of a section of that course in the COURSE_TERM might be "Shakespeare's comedies."
Course_Instructors

RJ210 TEXT

Natural alias: TEXT-RJ

appears on SRS screen 1D4, when the "Item" is entered in the context line = 2.

The full names of the instructor or instructors, as entered (free-form text, with no validation by PennID or ssn against the employee data) on SRS screen 1D4, and as it appears in the Course Register publication. This may not be the same as the instructor found in the COURSE_TERM table. For example, the instructor name is often listed as "staff" in the COURSE_INVENTORY_DESC table, and specific names are assigned to the various sections of the course only in the COURSE_TERM table.

Course_Prerequisites

RJ210 TEXT

Natural alias: TEXT-RJ

appears on SRS screen 1D4, when the "Item" is entered in the context line = 3.

The text description of any prerequisite courses that must be taken prior to taking this course. This is the text that appears in the Course Register publication. Note that prerequisites are not systemically enforced in SRS.

Course_Corequisites

RJ210 TEXT

Natural alias: TEXT-RJ

appears on SRS screen 1D4, when the "Item" is entered in the context line = 4.

The text description of any corequisite courses that must be taken at the same time as taking this course. This is the text that appears in the Course Register publication.

Course_Notes

RJ210 TEXT

Natural alias: TEXT-RJ

appears on SRS screen 1D4, when the "Item" is entered in the context line = 5.

The text of any notes entered by the department that administers the course, that is to appear along with the text description of the course in the Course Register publication. For example: "General Honors students only."

Register_Print_Flag

RI155 COURSE REGISTER

Natural alias: CRS-RG-F-RI

appears on SRS screen 125

Indicates whether or not the course is printed in the Course Register. The Course Register is a publication of the University Registrar's Office, describing most courses offered at Penn. It is published twice a year prior to Advance Registration. The Course Register print flag is used to prevent special courses from appearing in the publication, for example, courses taught to private companies at the company's location.

Values:


  - Print in the Course Register
N - No, do not print in the Course Register

Register_Subgroup_1

RI156 REGISTER SUBGROUP 1, Natural alias: SUBGRP-1-RI

appears on SRS screen 125

First level of grouping of courses within a department. Used to group courses in the Course Register publication in an order other than simply by subject area.

Register_Subgroup_2

RI157 REGISTER SUBGROUP 2, Natural alias: SUBGRP-2-RI

appears on SRS screen 125

Second level of grouping of courses within a department. Used to group courses in the Course Register publication in an order other than simply by subject area.

COURSE INVENTORY DESC Table . 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