InfoAccess

  

DATA VIEW NAME

ACADEMIC_PROGRAM_STOUT

OVERVIEW 

This view contains information about academic programs offered at Stout.

LOAD FREQUENCY

Data is refreshed nightly.

DATA CUSTODIAN

Curriculum Development - Tricia Aspen

AUTHORIZATION

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.

SPECIAL CONSIDERATIONS

None.

QUESTIONS

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

LAST UPDATED

12/06  Data dictionary created

DATA FORMATS

Primary Key Columns are identified with an asterisk(*)

Alphanumeric Data

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’

Numeric Data

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  - 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)

 

Column Name

Format

Description

*Catalog_Year

Number (4)

Catalog year the academic program is offered.

*Academic_Program

Varchar2(15)

Academic program code.

Academic_Program_Title

Varchar2(50)

Title of the academic program.

Degree_Objective

Varchar2(4)

The degree objective associated with the academic program.
BA
BFA
BS
EDS
MS
MSED

Degree_Type

Varchar2(4)

GR
UG

Major

Varchar2(5)

Major code associated with this academic program.

Major_Desc

Varchar2(50)

Major description.

Concentration

Varchar2(10)

Concentration associated with this academic program.

Concentration_Desc

Varchar2(50)

Concentration description.

Minor

Varchar2(10)

Minor associated with this academic program.

Minor_Desc

Varchar2(50)

Minor description.

Teacher_Ed

Varchar2(10)

Indicates Teacher education program
TE

Teacher_Ed_Desc

Varchar2(30)

Teacher education

Specialization

Varchar2(10)

Specialization associated with this academic program.

Specialization_Desc

Varchar2(50)

Specialization description

Department_No

Number (5)

Department number
Valid values are:
5120
5130
5200
5230
5300
5330
5340
5400
5740

Department_Desc

Varchar2(50)

Department description

Student_Select_Flag

Varchar2 (1)

 Says whether or not this academic program can be used by a person in evaluating an academic program change. Some academic programs may be set up as templates or basic requirements, but no one is to actually enroll in those. For that type of academic program this field would be N for no. Regular programs that should be useable by students would have this field set to Y for yes.
Valid value are:
blank
Y - yes
N - no

Start_Date

Date

Start date for academic program

End_Date

Date

End date for academic program

Comments

Varchar2(1024)

Comments related to this academic program

Grade_Scheme

Varchar2(5)

Grading scheme
GRALL  Graduate all grades
UGALL  Undergraduate all grades

Grade_Scheme_Desc

Varchar2(50)

Grading scheme description

Allow_Graduation_Flag

Varchar2(1)

Flag to allow graduation

Classification_Instr_Prog_Code

Varchar2(9)

Classification instructor program code

Classification_Instr_Prog_Desc

Varchar2(100)

Classification instructor program code description

Transcript_Grouping

Varchar2(2)

Grouping for transcripts
UG  undergraduate
GR  graduate

Local_Govt_Code

Varchar2(5)

Local IDs

Local_Govt_Desc

Varchar2(50)

Local IDs  description

Create_Application_Flag

Varchar2(1)

Flag to create application Y/N

Last_Update_Date_Time

Date

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