Includes information of the Disposition file on Datatel (XST.PPST.MISC). Only the first eight DISP scores are being recorded presently

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)

05/2005 – 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 Disposition score – Key to file

Number (2)

Score for attendance

Number (2)

Score for preparedness

Number (2)

Score for learning

Number (2)

Score for climate

Number (2)

Score for reflective

Number (2)

Score for listener

Number (2)

Score for cooperative

Number (2)

Score for respective

Number (2)

Not used yet

Number (2)

Not used yet

Number (2)

Not used yet

Number (2)

Not used yet

Number (2)

Not used yet

Number (2)

Not used yet

Number (2)

Not used yet

Varchar2 (7)

The Disposition year and term (2008FA, etc) when the student’s interview took place.

Varchar2 (12)

Name of the course that scores refer to

Date 19

Date Time transaction loaded