|
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
D a t a D i c t i o n a r y
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
This page was last updated on July 15, 2005.
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
|
|
