ACADEMIC_PROG_STATUS_STOUT

This view contains information about academic programs offered at Stout.

Data is refreshed nightly.

Curriculum Development - 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 web site InfoAccess home page.

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

1/07 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)

Number (15)

Automatically generated sequence number

Varchar2 (15)

Academic program code

Varchar2 (1)

Status of academic program
A  =  Active
D  =  Discontinued/Dropped
I    =  Inactive
P   =  Pending

Date

Date this status was put on the program

Varchar2 (50)

Description of Status

Varchar2 (50)

Name of agency that approved the program
UW-STOUT

Date

Date this program was approved

Date

The date and time these data were extracted.Format : YYYYMMDD HH24:MI:SS