PPST_ACT_STOUT

Includes the ACT test scores (2 sets) to be used in the Teacher Education Benchmark tracking

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 from Datatel – Key to file

Number(2)

Composite score 1

Number(2)

Composite score 2

Number(2)

English score 1

Number(2)

English score 2

Number(2)

Math score 1

Number(2)

Math score 2

Number(2)

Reading score 1

Number(2)

Reading score 2

Number(2)

Science score 1

Number(2)

Science score 2

Number(2)

Writing score 1

Number(2)

Writing score 2

Date 19

Writing date 1

Date 19

Writing date 2

Date 19

Composite date 1 (includes the English, Math, Reading, and Science tests)

Date 19

Composite date 2 (includes the English, Math, Reading, and Science tests)

Date 19

Date Time transaction loaded