• Course_Final_Term
• Course_First_Term
• Course_Id
• Course_Level
• Course_Title
• Course Admin Code
• Crosslisting Count
• Crosslisting 1
• Crosslisting 2
• Crosslisting 3
• Crosslisting 4
• Crosslisting 5

• Dept_Of_Record
• Distribution_Requirement
• EAS_Credit_Factor_Code
• New_Course_ID
• Old_Course_ID
• Register_Print_Flag
• Cross-list Partner
• Scheduling_Priority
• Terms Offered

Values:

Any valid term in the format YYYYT.

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

appears on screen 125

Values:

Any valid term in the format YYYYT.

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

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

RI115 COURSE TITLE
NATURAL ALIAS: CRS-TITL-RI

appears on screen 125

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

See Crosslisting_1 through Crosslisting_5

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

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

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

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

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

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.

Indicates whether a course fulfills a school-defined distribution requirement for an academic discipline. Only one Distribution Requirement can be entered in SRS per course inventory definition. All course term sections that fall under the inventory definition of a course will be associated with the Distribution Requirement on that course.

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)

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

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.

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.

Indicates whether or not the course is printed in the course register. The course register is a publication of the Registrar's Office describing most courses offered at Penn. It is published twice a year prior to Advance Registration.

Valid Values:
NULL = print in Course Register
N = Do not print in register

Field re-purposed in Spring 2019: This indicates which course controls a set of courses that are cross-listed with each other. There can be multiple secondary owner courses, but only one primary owner course. The primary course will control changes via the Curriculum Management system.

Values are: PO = Primary Owner
SO = Secondary Owner

Field no longer used, as of Spring 2019. (Previously, this was the 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.)

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

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.

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