InfoAccess

  

DATA VIEW NAME

PPST_REFLEC_NEW_STOUT

OVERVIEW 

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

REFLEC_CODE

Varchar2(10)

The Reflection Code and level (REFLI-A, REFLII-A, etc.) related to the student’s interview.

REFLEC_MISC1

Integer(2)

The score a student receives for this metric.

REFLEC_MISC2

Integer(2)

The score a student receives for this metric.

REFLEC_MISC3

Integer(2)

The score a student receives for this metric.

REFLEC_MISC4

Integer(2)

The score a student receives for this metric.

REFLEC_MISC5

Integer(2)

The score a student receives for this metric.

REFLEC_MISC6

Integer(2)

The score a student receives for this metric.

REFLEC_MISC7

Integer(2)

The score a student receives for this metric.

REFLEC_MISC8

Integer(2)

The score a student receives for this metric.

REFLEC_SCORE_TERM

Varchar2(7)

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

COURSE_NAME

Varchar2(12)

The course (SPED 430, etc)

REFLEC_COURSE_INSTRUCTOR

Varchar2 (7)

A Course Instructor for the student.

LAST_DATE_UPDATED

Date(7)

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