InfoAccess

  

DATA VIEW NAME

PPST_DISP_NEW_STOUT

OVERVIEW 

Includes Disposition interview data on students who have an active education program.

LOAD FREQUENCY

Data is refreshed weekly on Mondays at 10:00 a.m.

DATA CUSTODIAN

Deb Hass, School of Education

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

06/2008 – New table 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

DISP_CODE

Varchar2(10)

The Disposition Code and level (DISPI-A, DISPII-A, etc.) related to the student’s interview.

DISP_MISC1

Integer(2)

The score a student receives for this metric.

DISP_MISC2

Integer(2)

The score a student receives for this metric.

DISP_MISC3

Integer(2)

The score a student receives for this metric.

DISP_MISC4

Integer(2)

The score a student receives for this metric.

DISP_MISC5

Integer(2)

The score a student receives for this metric.

DISP_MISC6

Integer(2)

The score a student receives for this metric.

DISP_MISC7

Integer(2)

The score a student receives for this metric.

DISP_MISC8

Integer(2)

The score a student receives for this metric.

DISP_MISC9

Integer(2)

The score a student receives for this metric.

DISP_MISC10

Integer(2)

The score a student receives for this metric.

DISP_MISC11

Integer(2)

The score a student receives for this metric.

DISP_MISC12

Integer(2)

The score a student receives for this metric.

DISP_MISC13

Integer(2)

The score a student receives for this metric.

DISP_MISC14

Integer(2)

The score a student receives for this metric.

DISP_MISC15

Integer(2)

The score a student receives for this metric.

DISP_SCORE_TERM

Varchar2(7)

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

COURSE_NAME

Varchar2(12)

The student’s area of study (SPED 430, etc)

DISP_COURSE_INSTRUCTOR

Varchar2 (7)

A Course Instructor for the student.

LAST_DATE_UPDATED

Date(19)

The timestamp for when this batch of data was inserted to the table.