Schedule Object

The Schedule object contains data concerning courses offered at the University of Oregon. This object contains one record for every course section for the terms/semesters included in the Student Data Warehouse.

---

CRN

Course reference number assigned to the course section. CRNs are no unique across academic years.

Data Type: 5 Characters

Example: 20986

Source: ssbsect_crn

Term

Code representing term course is offered. Format YYYYTT, where YYYY = academic year and TT = term or semester, 01 = Fall, 02 = Winter, 03 = Spring, 04 = Summer, 05 = Fall Semester, 06 = Spring Semester, 07 = Summer Semester.

Data Type: 6 Characters

Example: 199502

Source: ssbsect_term_code

Val Table: Term

Course Level

Level at which the course is offered. 'UG' = Undergraduate, 'GR' = Graduate/Professional, 'LW' = Law.

Data Type: 2 Characters

Example: 1

Source: scrlevl_levl_code

Val Table: Level

College Code

College offering the course.

Data Type: 2 Characters

Example: MU

Source: scbcrse_coll_code

Val Table: College

Dept Code

Department offering the course.

Data Type: 4 Characters

Example: MUE

Source: scbcrse_dept_code

Val Table: Department

Subj Code

Subject of course.

Data Type: 4 Characters

Example: MUE

Source: ssbsect_subj_code

Val Table: Subject

Course Numb

Course number of the course.

Data Type: 4 Characters

Example: 406

Source: ssbsect_crse_numb

Credit Coll Code

College code of the college given credit for offering the course (what college the actual instructor is in)

Data Type: 2 Characters

Credit Dept Code

Department code of the department given credit for offering the course (the department the instructor is in)

Data Type: 4 Characters

Credit Subj Code

Subject code of department given credit for offering the course.

Data Type: 4 Characters

Example: MUE

Source: ssbsect_credit_subj_code

Val Table: Subject

Title

Title of the course.

Data Type: 30 Characters

Example: Projects

Source: ssbsect_crse_title, scbcrse_title

Credit Hours Min

Specifies the number of credit hours for which the course may be taken. If Credit Hour Connector is not blank, this field specifies the minimum number of credits for which a variable credit course may be taken.

Data Type: 3 Digit number plus 2 decimal places

Example: 1

Source: scbcrse_credit_hr_low

Credit Hours Connector

Defines whether the course can be offered for variable credit. A 'TO' connector specifies a range of allowable credit hour values from minimum to maximum. Value is 'null' if variable credit hours are not allowed.

Data Type: 2 Characters

Example: TO

Source: scbcrse_credit_hr_ind

Credit Hours Max

Defines the highest credit hour value allowed for a variable credit course. A value will only be present if the Credit Connector is TO.

Data Type: 3 Digit number plus 2 decimal places

Example: 16

Source: scbcrse_credit_hr_high

Course Attribute Codes

Concatenation of all Attribute Codes for a course separated by '|' (pipe characters) . See the validation table for a list of all possible codes. Generally, codes 1-5 correspond to the General University Requirement group and math requirements; codes beginning with the letter 'R' are applicable toward one of the Multicultural requirements (old Race/Gender/Non-European-American requirement); WR identifies courses which count toward the Written English requirement. This field can be used to identify courses offered by your department which meet certain general university requirements.

Data Type: 99 Characters

Example: |WR|1|RIC|

Source: scrattr_attr_code

Val Table: Course Attribute

Course Attribute Descs

Concatenation of all Attribute Code Descriptions for a course enclosed in '|' (pipe characters).

Data Type: 250 Characters

Example: |WR|1|RIC|

Source: scrattr_attr_code

Val Table: Course Attribute

Prev Subj Code

Previous subject of course.

Data Type: 4 Characters

Example: MUE

Source: scbcrse_subj_code_prev

Val Table: Subject

Prev Course Numb

Previous course number of the course.

Data Type: 4 Characters

Example: 404

Source: scbcrse_crse_numb_prev

CIP Code

Classification of Instructional Program (CIP) code of the course.

Data Type: 6 Characters

Example: 404

Source: scbcrse_cipc_code

Section Status Code

Section status; 'A' denotes an Active section, 'C' indicates a Canceled section and 'I' Indicates an Inactive section.

Data Type: 1 Character

Example: O

Source: ssbsect_ssts_code

Val Table: Section Status

Section Status Desc

Description of Status of section.

Data Type: 30 Characters

Example: Open

Source: stvssts_desc

Val Table: Section Status

Section Type Code

Type of course; 'A' Activity, 'B' Lab, 'D' Discussion, 'E' Experiential , 'I' Individual Study, 'L' lecture, 'N' Individual Research, 'R' Recitation, 'S' Seminar, 'T' Teleconference.

Data Type: 1 Character

Example: E

Source: ssbsect_schd_code

Val Table: Section Schedule

Section Type Desc

Description of Type of course.

Data Type: 30 Characters

Example: Open

Source: stvssts_desc

Val Table: Section Schedule

Section Campus Code

Indicates the campus (location) where the section will be taught. Distance education sections are coded 'V' (computer access - Virtual campus).

Data Type: 1 Character

Example: E

Source: ssbsect_camp_code

Val Table: Campus

Section Campus Desc

Description of Campus Code.

Data Type: 30 Characters

Example: Eugene

Source: stvcamp_desc

Val Table: Campus

Section Prereq

Section prerequisites

Data Type: 35 Characters

Section Notes

Section notes

Data Type: 5 Characters

Ind Study Flag

Value of 'Y' indicates the section is an individualized study course

Data Type: 2 Characters

Self Support Flag

Value of 'Y' indicates the section is funded by course fees only. Non self-support course will have a value of 'N'.

Data Type: 2 Characters

Example: Y

Source: ssbsect_tuiw_ind

UO Grading Mode Code

Grading mode for which the course is offered. 'G' = Graded, 'P' = Optional, '*' = Pass/No Pass Only.

Data Type: 1 Character

Example: P

Source: ssbsect_gmod_code

UO Grading Mode Desc

Description of Course Grade Mode.

Data Type: 30 Characters

Example: Pass/ No Pass

Source: stvgmod_desc

Major Grading Mode Code

Grading mode is not recommended for majors. This is provided for informational purposes only and is not enforced by the registration system. 'G' = Graded, 'P' = Optional, '*' = Pass/No Pass Only.

Data Type: 1 Character

Example: P

Source: ssbsect_mmod_code

Major Grading Mode Desc

Description of Major Grade Mode.

Data Type: 30 Characters

Example: Pass/No Pass

Source: stvgmod_desc

Spec Approval Code

If present, used to specify the type of special approval a student must have to register. If the code is not null, the course requires pre-authorization before registration is allowed.

Data Type: 2 Characters

Example: D

Source: ssbsect_sapr_code

Val Table: Special Approval

Spec Approval Desc

Description of Special Approval Code.

Data Type: 30 Characters

Example: Departmental Approval

Source: stvsapr_desc

Val Table: Special Approval

Cross List Code

Arbitrary code indicating that this section is dual-listed with another section. Sections which have the same cross-list code are offered in the same room at the same time. To identify cross-listed courses for your department, you could qualify all sections for which the Cross List Code is not null. Sorting on the Cross List Code will group cross-listed courses together on your list.

Data Type: 4 Characters

Example: 0201

Source: ssrxlst_xlst_group

Self Support Flag

Value of 'Y' indicates the section is funded by course fees only. Non self-support course will have a value of 'N'.

Data Type: 2 Characters

Example: Y

Source: ssbsect_tuiw_ind

Fee Detail Codes

Codes representing account numbers, separated by '|' (pipe characters). Can be used to determine type of fee.

Data Type: 20 Characters

Example: |736|

Source: ssrfees_detl_code

Val Table: Fee Detail

Fee Detail Descs

Descriptions of Fee Detail Codes, separated by '|' (pipe characters).

Data Type: 200 Characters

Example: |Workshop Fee|

Source: tbbdetc_desc

Val Table: Fee Detail

Fee Amounts

Dollar amounts of fees for a section, separated by '|' (pipe characters).

Data Type: 30 Characters

Example: |30.00|150.00|

Source: ssrfees_amount

Fee Indicators

Codes indicating how fees are charged, separated by '|' (pipe characters). 'C' = per credit hour, 'F' = flat fee.

Data Type: 10 Characters

Example: |C|

Source: ssrfees_fee_ind

Instructor IDs

Instructor Identification Numbers, separated by '|' (pipe characters).

Data Type: 45 Characters

Example: |135389450|

Source: spriden_id

Instructor Names

Instructor's names formatted as: "Last name, First name Middle name". If the person has only one name, a comma is not included. Seperated by '|' (pipe characters).

Data Type: 250 Characters

Example: |Kassner, Michael E|

Source: derived

Instructor Dept Codes

Instructor's home department, seperated by '|' (pipe characters).

Data Type: 25 Characters

Example: |ANTH|

Source: derived

Enroll Proj

The anticipated enrollment (seats) in this section.

Data Type: Number

Example: 0

Source: ssbsect_proj_enrl

Enroll Max

The maximum enrollment (seats) for this section.

Data Type: Number

Example: 100

Source: ssbsect_max_enrl

Enroll Actual

Current-enrollment (seats occupied) in this section.

Data Type: Number

Example: 47

Source: ssbsect_enrl

Seats Available

Seats remaining (unoccupied) in the section. Calculated by subtracting the actual enrollment from the maximum enrollment. May be less than zero!

Data Type: Number

Example: 53

Source: ssbsect_seats_avail

Enrolled Credit Hours

Enrolled Credit Hours is the product of the Enroll Actual times the Min. number of Credits for the class.

Data Type: Number

Example: 15

Source: ssbsect_tot_credit_her

ample: 53

Source: ssbsect_seats_avail

Waitlist Count

Number of students enrolled in the section with waitlist status.

Data Type: Number

Example: 3

Source: ssbsect_wait_count

Section Codes

Section codes, separated by '|' (pipe characters).

Data Type: 10 Characters

Example: |S|W|

Source: derived from ssrflag_flag

Section Descs

Text Descriptions of Section Flags, separated by '|' (pipe characters).

Data Type: 120 Characters

Example: |Self-support course|

Source: stvflag_desc

Val Table: none

Section Link Code

A code which links lectures to associated labs and discussions. For example, 10 = the first lecture of a class. All labs, discussions, and any other sections are coded 11. If another lecture exists for the same course, then it's link code will be 20, and the labs and discussions for this second lecture will be 21.

Data Type: 2 Characters

Example: 11

Source ssbsect_link_ident

SCID

Course ID from Banner (New August 2003)

Data Type: Up to 8 characters

Source: ssbsect_scid

Special Approval Start Date

The effective start date for instructor or departmental approval

Data Type: Date

Source: ssbsect_approval_start_date

Special Approval Thru Date

The effective end date for instructor or department approval

Data Type: Date

Source: ssbsect_approval_thru_date