InfoAccess

  

DATA VIEW NAME

PPST_DEVPSYCH_STOUT

OVERVIEW 

Includes information of the School Psychology Developmental Performance Appraisal file on Datatel (XST.PPST.DEVPSYCH)

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 DeskPhone:  264-HELP (4357)

LAST UPDATED

06/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

  

DEVPSYCH_CODE

Varchar2(10)

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

  

DEVPSYCH_KNOW_A1

Number(2,0)

Data Based Decision Making – Knowledge – A1

  

DEVPSYCH_PERFORM_A2

Number(2,0)

Data Based Decision Making – Performance – A2

  

DEVPSYCH_KNOW_B1

Number(2,0)

Consultation and Collaboration – Knowledge – B1

  

DEVPSYCH_PERFORM_B2

Number(2,0)

Consultation and Collaboration – Performance – B2

  

DEVPSYCH_KNOW_C1

Number(2,0)

Instruction & Development of Skills – Knowledge – C1

  

DEVPSYCH_PERFORM_C2

Number(2,0)

Instruction & Development of Skills – Performance – C2

  

DEVPSYCH_KNOW_D1

Number(2,0)

Social & Develop of Life Skills – Knowledge – D1

  

DEVPSYCH_PERFORM_D2

Number(2,0)

Social & Develop of Life Skills – Performance – D2

  

DEVPSYCH_KNOW_E1

Number(2,0)

Student Diversity in Dev & Learn – Knowledge – E1

  

DEVPSYCH_PERFORM_E2

Number(2,0)

Student Diversity in Dev & Learn – Performance – E2

  

DEVPSYCH_KNOW_F1

Number(2,0)

Schools & Sys Org, Policy Dev – Knowledge – F1

  

DEVPSYCH_PERFORM_F2

Number(2,0)

Schools & Sys Org, Policy Dev – Performance – F2

  

DEVPSYCH_KNOW_G1

Number(2,0)

Prevention, Crisis, Mental Health – Knowledge – G1

  

DEVPSYCH_PERFORM_G2

Number(2,0)

Prevention, Crisis, Mental Health – Prevention – G2

  

DEVPSYCH_KNOW_H1

Number(2,0)

Home/School/Community Collaboration – Knowledge – H1

  

DEVPSYCH_PERFORM_H2

Number(2,0)

Home/School/Community Collaboration – Performance– H2

  

DEVPSYCH_KNOW_I1

Number(2,0)

Research & Program Evaluation – Knowledge – I1

  

DEVPSYCH_PERFORM_I2

Number(2,0)

Research & Program Evaluation – Performance – I2

  

DEVPSYCH_KNOW_J1

Number(2,0)

School Psych Practice & Dev – Knowledge – J1

  

DEVPSYCH_PERFORM_J2

Number(2,0)

School Psych Practice & Dev – Performance – J2

  

DEVPSYCH_KNOW_K1

Number(2,0)

Information Technology – Knowledge – K1

  

DEVPSYCH_PERFORM_K2

Number(2,0)

Information Technology – Performance – K2

  

DEVPSYCH_SCORE_TERM

Varchar2(7)

Dev Psych Term of Score

  

COURSE_NAME

Varchar2(12)

Dev Psych Course

  

DEVPSYCH_COURSE_ INSTRUCTOR

Varchar2(7)

Dev Psych Instructor

  

LAST_DATE_UPDATED

Date 19

Date Time transaction loaded