InfoAccess

  

DATA VIEW NAME

PPST_PRESTU_STOUT

OVERVIEW 

Includes information of the Pre-student Teaching Evaluation file on Datatel (XST.PPST.PRESTU)

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

04/2006 – 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

PRESTU_CODE

Varchar2(10)

* Code of Sch Psych Dev Performance score – Key to file

PRESTU_PLANNING_A1

Number(2,0)

Planning & Preparation – A1

PRESTU_PLANNING_A2

Number(2,0)

Planning & Preparation – A2

PRESTU_PLANNING_A3

Number(2,0)

Planning & Preparation – A3

PRESTU_PLANNING_A4

Number(2,0)

Planning & Preparation – A4

PRESTU_CLASSROOM_B1

Number(2,0)

Classroom Environment – B1

PRESTU_CLASSROOM_B2

Number(2,0)

Classroom Environment – B2

PRESTU_CLASSROOM_B3

Number(2,0)

Classroom Environment – B3

PRESTU_CLASSROOM_B4

Number(2,0)

Classroom Environment – B4

PRESTU_CLASSROOM_B5

Number(2,0)

Classroom Environment – B5

PRESTU_INSTRUCTION_C1

Number(2,0)

Instruction – C1

PRESTU_INSTRUCTION_C2

Number(2,0)

Instruction – C2

PRESTU_INSTRUCTION_C3

Number(2,0)

Instruction – C3

PRESTU_INSTRUCTION_C4

Number(2,0)

Instruction – C4

PRESTU_INSTRUCTION_C5

Number(2,0)

Instruction – C5

PRESTU_INSTRUCTION_C6

Number(2,0)

Instruction – C6

PRESTU_INSTRUCTION_C7

Number(2,0)

Instruction – C7

PRESTU_INSTRUCTION_C8

Number(2,0)

Instruction – C8

PRESTU_RESPONS_D1

Number(2,0)

Prof Responsibilty/Pers Characteristics – D1

PRESTU_RESPONS_D2

Number(2,0)

Prof Responsibilty/Pers Characteristics – D2

PRESTU_RESPONS_D3

Number(2,0)

Prof Responsibilty/Pers Characteristics – D3

PRESTU_RESPONS_D4

Number(2,0)

Prof Responsibilty/Pers Characteristics – D4

PRESTU_RESPONS_D5

Number(2,0)

Prof Responsibilty/Pers Characteristics – D5

PRESTU_RESPONS_D6

Number(2,0)

Prof Responsibilty/Pers Characteristics – D6

PRESTU_RESPONS_D7

Number(2,0)

Prof Responsibilty/Pers Characteristics – D7

PRESTU_RESPONS_D8

Number(2,0)

Prof Responsibilty/Pers Characteristics – D8

PRESTU_STANDARD_E1

Number(2,0)

Wisconsin Teacher Standards – E1

PRESTU_STANDARD_E2

Number(2,0)

Wisconsin Teacher Standards – E2

PRESTU_STANDARD_E3

Number(2,0)

Wisconsin Teacher Standards – E3

PRESTU_STANDARD_E4

Number(2,0)

Wisconsin Teacher Standards – E4

PRESTU_STANDARD_E5

Number(2,0)

Wisconsin Teacher Standards – E5

PRESTU_STANDARD_E6

Number(2,0)

Wisconsin Teacher Standards – E6

PRESTU_SCORE_TERM

Varchar2(7)

Pre-Student Teaching Term of Score

COURSE_NAME

Varchar2(12)

Pre-Student Teaching Course

PRESTU_COURSE_INSTRUCTOR

Varchar2(7)

Pre-Student Teaching Instructor

LAST_DATE_UPDATED

Date 19

Date Time transaction loaded