Penn Computing

University of Pennsylvania
Penn Computing << go backback

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

COURSE INVENTORY Table - Data Element Index


Data Element Mapping back to SRS Definition
Course_Final_Term RI110 FINAL TERM OFFERED
NATURAL ALIAS: L-TRM-OF-RI
appears on screen 125
The final term in which this definition of the course may be offered. A definition of a course is the combination of title, credit and activities.

Values:

Any valid term in the format YYYYT.

Course_First_Term

RI105 FIRST TERM OFFERED
NATURAL ALIAS: F-TRM-OF-RI

appears on screen 125


The first term in which this definition of the course may be offered.

Values:

Any valid term in the format YYYYT.

Course_Id

RI005 COURSE NUMBER
NATURAL ALIAS: CIF-ID-RI

appears in the context line of screen 125

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.

Course_Level

RI148 COURSE LEVEL INDICAT
NATURAL ALIAS: CRS-LEVEL-RI
appears on screen 125

A categorization of courses, indicating whether the course is
Introductory, Intermediate or Advanced (for undergraduates) or
Graduate level.

Values:

[null] - Not specified
1 - Introductory
2 - Intermediate
3 - Advanced
4 - Graduate

Course_Title

RI115 COURSE TITLE
NATURAL ALIAS: CRS-TITL-RI

appears on screen 125

The Inventory title of the course. Note that this is not necessarily the same as the title in the SRS Course Term File. For example, the title in the Inventory might be "Special Topics" and the title of a section of that course in the SRS Course Term File might be "Shakespeare's comedies."
See also the column Title in the COURSE_SECTION table.
Crosslisting_Count n/a

Count of the number of eligible crosslist partners that exist for this course in the Course Inventory.

See Crosslisting_1 through Crosslisting_5

Crosslisting_1 RI14A CROSS LISTING #1
NATURAL ALIAS: XLIST-1-RI
appears on screen 125

The Course Number of the first course -- if any -- that is eligible to be crosslisted with this course. Identifies eligible crosslist partners. Actual crosslisting takes place at the time of term scheduling, when specific sections are identified as participating in the crosslisting. No course section can be crosslisted unless the course inventory indicates that the course is eligible for crosslisting.

See also the COURSE_XLIST_INV table

Crosslisting_2 RI14B CROSS LISTING #2
NATURAL ALIAS: XLIST-2-RI
appears on screen 125

The Course Number of the second course -- if any -- that is eligible to be crosslisted with this course. Identifies eligible crosslist partners. Actual crosslisting takes place at the time of term scheduling, when specific sections are identified as participating in the crosslisting. No course section can be crosslisted unless the course inventory indicates that the course is eligible for crosslisting.

See also the COURSE_XLIST_INV table

Crosslisting_3 RI14C CROSS LISTING #3
NATURAL ALIAS: XLIST-3-RI
appears on screen 125

The Course Number of the third course -- if any -- that is eligible to be crosslisted with this course. Identifies eligible crosslist partners. Actual crosslisting takes place at the time of term scheduling, when specific sections are identified as participating in the crosslisting. No course section can be crosslisted unless the course inventory indicates that the course is eligible for crosslisting.

See also the COURSE_XLIST_INV table

Crosslisting_4 RI14D CROSS LISTING #4
NATURAL ALIAS: XLIST-4-RI
appears on screen 125

The Course Number of the fourth course -- if any -- that is eligible to be crosslisted with this course. Identifies eligible crosslist partners. Actual crosslisting takes place at the time of term scheduling, when specific sections are identified as participating in the crosslisting. No course section can be crosslisted unless the course inventory indicates that the course is eligible for crosslisting.

See also the COURSE_XLIST_INV table

Crosslisting_5 RI14E CROSS LISTING #5
NATURAL ALIAS: XLIST-5-RI
appears on screen 125

The Course Number of the fifth course -- if any -- that is eligible to be crosslisted with this course. Identifies eligible crosslist partners. Actual crosslisting takes place at the time of term scheduling, when specific sections are identified as participating in the crosslisting. No course section can be crosslisted unless the course inventory indicates that the course is eligible for crosslisting.

See also the COURSE_XLIST_INV table

Dept_Of_Record RI150 DEPARTMENT OF RECORD
NATURAL ALIAS: DEPT-REC-RI
appears on screen 125

The academic teaching unit (department) offering the course.
Multiple subject areas may be administered by one department.
Examples of Dept_Of_Record codes include BIOL (Biology), EE (Electrical Engineering), and INSR (Insurance).

See also Subject_Department and Section_Division in the
COURSE_SECTION Table.

Values:

Refer to the DEPARTMENT Table for values.

Distribution_Requirement RI158 DISTRIBUTION REQ.
NATURAL ALIAS: DIST-REQ-RI
appears on screen 125

Indicates whether a course fulfills a school-defined distribution
requirement for an academic discipline.

Values:

A - Arts & Letters Sector
B - Hum/Soc Sci or Nat Sci/Math Sector
C - General Requirement in Science Studies
F - General Requirement in Formal Reasoning & Analysis
H - History & Tradition Sector
I - Language Course
J - Other Langauge Course
L - Living World Sector
O - Humanities & Social Science Sector
M - Last Language Course
N - Natural Science & Math Sector
P - Physical World Sector
Q - Advanced Language Course
R - Writing Requirement Course
S - Society sector
T - General Requirement in Society
U - General Requirement in History & Tradition
V - General Requirement in Arts & Letters
W - General Requirement in Formal Reasoning & Analysis
X - General Requirement in Living World
Y - General Requirement in Physical World
Z - General Requirement in Science Studies
1* - Distributional course in Society (class of 09 and prior)
2*- Distributional course in History & Tradition (class of 09 and prior)
3* - Distributional course in Arts & Letters (class of 09 and prior)



EAS_Credit_Factor_Code

RI146 EAS CRED FACTOR CODE
NATURAL ALIAS: EAS-FCTR-RI

appears on screen 125

This Course Inventory field in SRS was originally used by the School of Engineering and Applied Science to identify courses that contribute to Design and/or Science Degree Requirement. SEAS no longer uses the code but data still exists from that period.  In August 2010, other schools began using the field to identify administrative divisions.  The warehouse load has been changed to load the “section admin” data into the new Section Admin Code field.  The logic used is anything not matching 0% is moved to the new field.

Values:
- NO DESIGN/SCIENCE CREDIT
06 - 100% DESIGN, 0% SCIENCE
02 - 25% DESIGN, 75% SCIENCE
03 - 50% DESIGN, 50% SCIENCE
04 - 75% DESIGN, 25% SCIENCE
05 - 0% DESIGN, 100% SCIENCE

See also SECTION_ADMIN_CODE

New_Course_ID RI147 NEW COURSE NUMBER
NATURAL ALIAS: NEWCR-ID-RI
appears on screen 125

Data in this column indicates that a new course number has been
assigned in SRS, and all degree requirements have been restated in terms of the new course number.

Values:

See COURSE_ID.

Old_Course_ID n/a

If a course has been re-numbered, the number that was previously used to identify it will be in Old_Course_Id.

Values:

See COURSE_ID.

Register_Subgroup_1 RI156 REGISTER SUBGROUP 1
NATURAL ALIAS: SUBGRP-1-RI
appears on 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.

Subgroup_1_Title RJ210 TEXT
NATURAL ALIAS: TEXT-RJ
appears on screen 1D2
The title of the Course Register subgroup 1 for this course.
Register_Subgroup_2 RI157 REGISTER SUBGROUP 2
NATURAL ALIAS: SUBGRP-2-RI
appears on 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.

Subgroup_2_Title RJ210 TEXT
NATURAL ALIAS: TEXT-RJ
appears on screen 1D3
The title of the Course Register subgroup 2 for this course.

Scheduling_Priority

RI151 SCHEDULING PRIORITY
NATURAL ALIAS: PRTY-RUL-RI

appears on screen 125

The priority rule in effect for this course during Advance Registration. Affects how the Advance Registration Scheduler will process requests for sections of this course. For example, the Law School priority rule give preference to student requests in the following order: Third year Law students, Second year Law students, First year Law students, all other students.

Values:

[null]- not subject to batch scheduling
A - undergrad seniority & major preference
B - undergrad major preference
C - undergrad seniority preference
D - undergrad distribution preference
E*- CGS preference; non-science courses
F*- CGS preference; science courses
F*- Benjamin Franklin Seminars preference
H - gr/prof majrs/gr grp, othr gr/prof, then A
I - gr/prof majrs/gr grp, othr gr/prof, then C
J - gr/prof majrs, ug majrs, othr gr/prof, othr ug
K - Law preference
L – WHG preference
M - all gr/prof, then A
N - gr/prof div pref, then A
O - CGS preference, then A
P - WHG seniority preference
Q - Grad/prof major/seniority preference
R - Communications major preference - original
S - Communications major preference - revised
T - WH undergrad distribution preference
U - WH undergrad seniority preference
V - WH undergrad seniority & major preference
W - WH undergrad major preference
X - random order

Course Admin Code

RI146 EAS CRED FACTOR CODE
NATURAL ALIAS: EAS-FCTR-RI

appears on screen 125

This code is loaded from the EAS Credit Factor code field in SRS Course Inventory when the data value doesn’t start with 0.  The field is used to identify administrative sub-units within a school that have budgetary and academic responsibility for courses. This is most notably used in Schools which in all courses are one subject area, (i.e. NURS, EDUC).  School of Arts and Sciences is using the field to identify groups of courses. 

The data for this field is entered on Screen 125.  Schools may request codes from the registrar, using the convention of the first digit representing their budget range, ie. SAS is using the 2s, Nursing uses 6s.  Using letters and numbers for the second position, a school can identify up to 36 administrative divisions.

This code will be added to the Tuition Distribution collection, but may be used for other course-related reporting projects.

Valid values appear in the COURSE_ADMIN_CODE lookup table.

Terms Offered

RI140 TERMS OFFERED
NATURAL ALIAS: TRMS-OFF-RI

appears on SRS screen 125

The academic term (Fall/Spring/Summer) or pattern of terms in which the course is normally offered.

Values:

[NULL] - Not specified
A - Course usually offered in Fall term
B - Course usually offered in Spring term
C - One-term course offered either term
D - Two-term course. Student may enter either term. Credit given for either term.
E - Two-term course. Students must enter first term; credit given only upon completion of both terms.
F - Two-term course. Student may enter either term. Credit given only on completion of both terms.
G - Two-term course. Student must enter first term; credit given for first term even if second term not completed.
H - Course offered Fall; even-numbered years
I - Course offered Fall; odd-numbered years
J - Course offered Spring; even-numbered years
K - Course offered Spring; odd-numbered years
L - Course usually offered Summer term only
M - Course not offered every year

 

COURSE INVENTORY 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