InfoAccess

  

DATA VIEW NAME

PPST_COURSE_STOUT

OVERVIEW 

Includes information on the COURSES required for the certification process for Teacher Education majors

LOAD FREQUENCY

Data is refreshed weekly

DATA CUSTODIAN

Debbie Hass, School of Teacher 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

02/2004 – New view 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

COURSE_NAME

Varchar2(9)

* Course name – e.g. ENGL-101 – key to file

COURSE_GRADE

Varchar2(2)

Grade of the course

LAST_UPDATE_DATE

Date 19

Date Time transaction loaded