PPST_REFLEC_STOUT

Includes information of the Reflection file on Datatel (XST.PPST.REFLEC).

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

Varchar2(10)

* Code of Reflection score – Key to file

Number(2,0)

Score for intended learning

Number(2,0)

Score for Unanticipated & New Learning

Number(2,0)

Score for Connection to Domains, Components & Wisconsin Teacher Standards

Varchar2(2)

Letter Grade for Artifact

Varchar2(7)

Term of score

Varchar2(12)

Name of the course that scores refer to

Varchar2(7)

Person ID of instructor for course

Date 19

Date Time transaction loaded