InfoAccess

  

DATA VIEW NAME

PPST_STUDENT_STOUT

OVERVIEW 

Includes students who have an active education program currently or had one in the past terms.

LOAD FREQUENCY

Data is refreshed weekly

DATA CUSTODIAN

Debbie Hass, School of Teacher Ed

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 InfoAccess home page

SPECIAL CONSIDERATIONS

None

QUESTIONS

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

LAST UPDATED

05/2005 – New view 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

*PERSON_ID

Varchar2(7)

* Person ID – Key to file

CURRENT_STUDENT_TYPE

Varchar2(5)

Current student type.
Valid types are:
UG – Undergraduate, 
UL – Undergraduate Level –Laptop,
ULE – Undergrad MSEP Participant,
GR – Graduate,
GL – Graduate Per Credit
GLE _ Grad MSEP Participant

FIRST_TERM_ENROLLED

Varchar2(7)

First Term the student was enrolled at Stout

LAST_TERM_ENROLLED

Varchar2 (7)

Last Term the student was enrolled at Stout

ACADEMIC_PROGRAM_ACTIVE1

Varchar2(15)

First currently active program

ACADEMIC_PROGRAM_ED_CODE1

Varchar2 (2)

First currently active teacher ed code

ACADEMIC_PROGRAM_ACTIVE2

Varchar2(15)

2nd currently active program

ACADEMIC_PROGRAM_ED_CODE2

Varchar2 (2)

2nd currently active teacher ed code

ACADEMIC_PROGRAM_ACTIVE3

Varchar2(15)

3rd currently active program

ACADEMIC_PROGRAM_ED_CODE3

Varchar2 (2)

3rd currently active teacher ed code

ACADEMIC_PROGRAM_ENDED1

Varchar2(15)

1st Program that has ended

ACAD_PROGRAM_ENDED_START_DATE1

Date 19

Start date of 1st program that has ended.

ACAD_PROGRAM_ENDED_END_DATE1

Date 19

End date of 1st program that has ended.

ACAD_PROGRAM_ENDED_STATUS1

Varchar2(3)

Status of 1st program that has ended.

ACADEMIC_PROGRAM_ENDED2

Varchar2(15)

2nd Program that has ended

ACAD_PROGRAM_ENDED_START_DATE2

Date 19

Start date of 2nd program that has ended.

ACAD_PROGRAM_ENDED_END_DATE2

Date 19

End date of 2nd program that has ended.

ACAD_PROGRAM_ENDED_STATUS2

Varchar2(3)

Status of 2nd program that has ended.

ACADEMIC_PROGRAM_ENDED3

Varchar2(15)

3rd Program that has ended

ACAD_PROGRAM_ENDED_START_DATE3

Date 19

Start date of 3rd program that has ended.

ACAD_PROGRAM_ENDED_END_DATE3

Date 19

End date of 3rd program that has ended

ACAD_PROGRAM_ENDED_STATUS3

Varchar2 (3)

Status of 3rd program that has ended.

WITHDREW_DATE

Date 19

Date student withdrew from university

BENCHMARK1_BACKGROUND_TERM

Varchar2(7)

Benchmark I: Background Check Term

BENCHMARK1_RUBRIC_TERM

Varchar2(7)

Benchmark I: Portfolio Assessment Rubric Term

BENCHMARK1_COMPLETE_TERM

Varchar2(7)

Benchmark I: All Complete Term

BENCHMARK2_STU_TEACH_TERM

Varchar2(7)

Request for Student Teaching Placement Term

BENCHMARK2_BACKGROUND_TERM

Varchar2(7)

Benchmark II: Updated Background Check Term

BENCHMARK2_TB_TEST_DATE

Date 19

Benchmark II: Satisfactory Tuberculosis (TB) Test Date – valid for a year

BENCHMARK2_RUBRIC_TERM

Varchar2(7)

Benchmark II: Portfolio Assessment Rubric Term

BENCHMARK2_COMPLETE_TERM

Varchar2(7)

Benchmark II: All Complete Term

BENCHMARK3_COMPLETE_TERM

Varchar2(7)

Benchmark III: Completion Term

PROGRAM_COMPLETER_CODE

Varchar2(3)

Program Completer Code – codes for the different majors of Teacher Ed – e.g. 285 Mktd Ed

LAST_UPDATE_DATE

Date 19

Date Time transaction loaded. Format : YYYYMMDD HH24:MI:SS