InfoAccess

  

DATA VIEW NAME

PPST_BENCHMARK_STOUT

OVERVIEW 

Includes benchmark 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

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

* BNCHMRK_LEVEL

Varchar2(1)

* The benchmark level (I, II, or III) related to the student’s interview.

* BNCHMRK_YEAR_TERM

Varchar2(7)

* The benchmark year and term (2008FA, etc) then the student’s interview took place.

* BNCHMRK_ATTEMPT

Varchar2 (1)

* The interview attempt (first, second, or third) at the same benchmark level.

BNCHMRK_AREA_OF_STUDY

Varchar2(15)

The student’s area of study (Coaching, etc)

BNCHMRK_REVIEWER_1

Varchar2 (20)

A person who interviewed the student.

BNCHMRK_REVIEWER_2

Varchar2(20)

A person who interviewed the student.

BNCHMRK_RANK_01

Varchar2(1)

The rank a student receives for this metric.

BNCHMRK_RANK_02

Varchar2(1)

The rank a student receives for this metric.

BNCHMRK_RANK_03

Varchar2(1)

The rank a student receives for this metric.

BNCHMRK_RANK_04

Varchar2(1)

The rank a student receives for this metric.

BNCHMRK_RANK_05

Varchar2(1)

The rank a student receives for this metric.

BNCHMRK_RANK_06

Varchar2(1)

The rank a student receives for this metric.

BNCHMRK_RANK_07

Varchar2(1)

The rank a student receives for this metric.

BNCHMRK_RANK_08

Varchar2(1)

The rank a student receives for this metric.

BNCHMRK_RANK_09

Varchar2(1)

The rank a student receives for this metric.

BNCHMRK_RANK_10

Varchar2(1)

The rank a student receives for this metric.

BNCHMRK_RANK_11

Varchar2(1)

The rank a student receives for this metric.

BNCHMRK_RANK_12

Varchar2(1)

The rank a student receives for this metric.

BNCHMRK_RANK_13

Varchar2(1)

The rank a student receives for this metric.

BNCHMRK_RANK_14

Varchar2(1)

The rank a student receives for this metric.

BNCHMRK_RANK_15

Varchar2(1)

The rank a student receives for this metric.

LAST_UPDATE_DATE_TIME

Date(19)

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