PPST_PSYCH_STOUT

Includes information of the School Psychology file on Datatel (XST.PPST.PSYCH)

Data is refreshed weekly

Debbie Hass, School of Teacher Ed

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

None

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

03/2006 – New view 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)

Varchar2(7)

* Person ID – Key to file

Varchar2(10)

* Code of School Psychology score – Key to file

Number(2,0)

Score of General Knowledge A1

Number(2,0)

Score of General Knowledge A2

Number(2,0)

Score of General Knowledge A3

Number(2,0)

Score of General Knowledge A4

Number(2,0)

Score of General Knowledge A5

Number(2,0)

Score of General Knowledge A6

Number(2,0)

Score of General Knowledge A7

Number(2,0)

Score for Personal Characteristics B1

Number(2,0)

Score for Personal Characteristics B2

Number(2,0)

Score for Personal Characteristics B3

Number(2,0)

Score for Personal Characteristics B4

Number(2,0)

Score for Personal Characteristics B5

Number(2,0)

Score for Personal Characteristics B6

Number(2,0)

Score for Personal Characteristics B7

Number(2,0)

Score for Personal Characteristics B8

Number(2,0)

Score for Personal Characteristics B9

Number(2,0)

Score for Personal Characteristics B10

Number(2,0)

Score for Personal Characteristics B11

Number(2,0)

Score for Personal Characteristics B12

Number(2,0)

Score for Interpersonal Relationships C1

Number(2,0)

Score for Interpersonal Relationships C2

Number(2,0)

Score for Interpersonal Relationships C3

Number(2,0)

Score for Interpersonal Relationships C4

Number(2,0)

Score for Interpersonal Relationships C5

Number(2,0)

Score for Interpersonal Relationships C6

Number(2,0)

Score for Interpersonal Relationships C7

Number(2,0)

Score for Interpersonal Relationships C8

Number(2,0)

Score for Interpersonal Relationships C9

Number(2,0)

Score for Interpersonal Relationships C10

Number(2,0)

Score for Interpersonal Relationships C11

Number(2,0)

Score for Interpersonal Relationships C12

Number(2,0)

Score for Interpersonal Relationships C13

Number(2,0)

Score for Interpersonal Relationships C14

Number(2,0)

Score for Interpersonal Relationships C15

Number(2,0)

Score for Interpersonal Relationships C16

Number(2,0)

Score for Interpersonal Relationships C17

Number(2,0)

Score for Supervisory Relationships D1

Number(2,0)

Score for Supervisory Relationships D2

Number(2,0)

Score for Supervisory Relationships D3

Number(2,0)

Score for Supervisory Relationships D4

Number(2,0)

Score for Assessment Skills E1

Number(2,0)

Score for Assessment Skills E2

Number(2,0)

Score for Assessment Skills E3

Number(2,0)

Score for Assessment Skills E4

Number(2,0)

Score for Assessment Skills E5

Number(2,0)

Score for Assessment Skills E6

Number(2,0)

Score for Assessment Skills E7

Number(2,0)

Score for Assessment Skills E8

Number(2,0)

Score for Assessment Skills E9

Number(2,0)

Score for Assessment Skills E10

Number(2,0)

Score for Assessment Skills E11

Number(2,0)

Score for Assessment Skills E12

Number(2,0)

Score for Professional Growth F1

Number(2,0)

Score for Professional Growth F2

Number(2,0)

Score for Professional Growth F3

Number(2,0)

Score for Professional Growth F4

Number(2,0)

Score for Professional Growth F5

Number(2,0)

Score for Professional Growth F6

Number(2,0)

Score for Direct Service G1

Number(2,0)

Score for Direct Service G2

Number(2,0)

Score for Direct Service G3

Number(2,0)

Score for Pupil Services Standards H1

Number(2,0)

Score for Pupil Services Standards H2

Number(2,0)

Score for Pupil Services Standards H3

Number(2,0)

Score for Pupil Services Standards H4

Number(2,0)

Score for Pupil Services Standards H5

Number(2,0)

Score for Pupil Services Standards H6

Number(2,0)

Score for Pupil Services Standards H7

Varchar2(7)

Term of score

Varchar2(12)

Name of the course that scores refer to

Varchar2(7)

Person ID of instructor for course

Date 19

Date Time transaction loaded