| 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. |