COURSE_STOUT

This view contains information data elements for every course offered at UW-Stout.  These data elements are used in course scheduling, degree audits, and transcripts, as well as Graduate and Undergraduate Bulletins, curriculum websites, and all course reporting.

The data is refreshed every night

Curriculum Manager, Provost’s Office – Tricia Aspen

You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to the Infoaccess home page.

None.

Contact:  Division of Information Technology Help Desk
Phone:  264-4357 (HELP)

02/02 Data view created
04/02 Data Dictionary created .

Primary Key Columns are identified with an asterisk(*)

VARCHAR2( N)  (N) = maximum length. Field contains letters and/or numbers. Trailing blanks are eliminated.
Example: VARCHAR2 (5) could contain ‘ABC12’ or  ‘ABC’ or ‘A’

NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) =  format for numbers with decimal positions
X = total number of digits Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12 

DATE  - Date can be in various formats. Date functions available with your query tool can be used to format the date. 
Examples:  DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)

VARCHAR2(8)

Each course record has a unique Course ID, even though two courses may be defined by the same name.

VARCHAR2(150)

Full course title

VARCHAR2 (5)

Code indicating the department the course belongs to.  Courses can belong to more than one department.

VARCHAR2 (30)

Description of the department code

VARCHAR2 (1)

Identifies the course as credit or non-credit, which is used for billing and grading.

VARCHAR2 (15)

Combines subject and course number

VARCHAR2 (3)

Terms the course is intended to be offered

VARCHAR2(500)

Description of course content published in the university bulletin

VARCHAR2 (30)

30-character version of the course title used in the Timetable and on students’ printed schedule

VARCHAR2 (8)

Curriculum subject area that makes up part of the course name

VARCHAR2 (4)

UW System curricular area code converted from Subject

NUMBER(6,2)

If variable credit, this is the minimum number of credits for which a course can be taken; if fixed credit, this is the minimum and maximum credits for which a course can be taken.

NUMBER(6,2)

Highest number of credits that a variable credit course is worth

VARCHAR2 (10)

The number that makes up part of the course name; the number implies the level of the course

VARCHAR2 (1)

Activity status: the course may be active, pending, inactive, discontinued or approved temporarily.

VARCHAR2(1000)

Tells which terms the course is scheduled or has been offered.

DATE(19)

The date proposers indicate the course will begin; dates are usually a few days earlier in case the course begins before the term start date.

DATE(19)

The date the course was dropped or inactivated, or the last date the course can be offered.

VARCHAR2 (20)

Multi-valued field used to list General Education, Ethnic Studies, and Global Perspective category codes.

VARCHAR2 (5)

Categorizes a course designed for specific purposes, such as Distance Ed, Study Abroad.

VARCHAR2 (2)

Denotes graduate or undergraduate course

VARCHAR2 (5)

Denotes lower level, upper level, graduate level and is based on CDR levels reported.

VARCHAR2 (5)

Determines which grades are valid for the course and how they are calculated in a student record.

NUMBER(6,2)

Number of hours per week the class meets for the specific instructional method; used to calculate teaching loads

NUMBER(6,2)

Number of hours per week the class meets in another instructional method (ex: lecture, lab) and calculated in teaching load.

VARCHAR2 (20)

Instructional method used to teach the course, such as lecture, lab, field experience.  Multi-valued.

VARCHAR2(20)

Instructional method used to teach the course, such as lecture, lab, field experience.  Multi-valued.

VARCHAR2(2500)

This is space allocated for special notes about the course and its history.  These are for information only and used in any report or printout.

VARCHAR2 (8)

Identifies equivalent course(s).

VARCHAR2 (8)

Identifies equivalent course(s).

VARCHAR2 (8)

Identifies equivalent course(s).

VARCHAR28)

Identifies equivalent course(s).

VARCHAR2 (3)

Yes or No: Indicates whether or not the course is repeatable for credit.

VARCHAR2 (3)

Yes or No: Indicates whether or not the course is open for auditors without approval.

VARCHAR2 (3)

Yes or No: Indicates whether or not the course can be taken Pass/No pass without approval.

VARCHAR2 (3)

Yes or No: Indicates whether grade scheme is Pass/No pass only (not used at UW-Stout)

VARCHAR2 (7)

Year term course was first available for offering

VARCHAR2 (7)

Last term course was available for offering

VARCHAR2 (9)

UW System CAC code for previous course number

VARCHAR2 (2)

UW System lab type indicator for UG sciences

VARCHAR2 (1)

X = do not submit course record on TIS submission

VARCHAR2 (3)

Approved for IP or OSU grades

VARCHAR2 (7)

Field selected from TERMS_OFFERED for reporting