|
InfoAccess |
|
|
DATA VIEW NAME |
PPST_CONTENT_STOUT |
|
OVERVIEW |
This table contains the PRAXIS test scores and dates taken for the Education major students |
|
LOAD FREQUENCY |
Data is refreshed weekly. |
|
DATA CUSTODIAN |
Debbie Hass, School of Teacher Ed |
|
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 |
|
LAST UPDATED |
05/2005 – 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. |
|
Numeric Data |
NUMBER (N) (N) = length. Field contains only numbers. |
|
Date |
DATE - Date can be in various formats. Date functions available with
your query tool can be used to format the date. |
Column Name |
Format |
Description |
|
PERSON_ID |
Varchar2(7) |
* Person ID – Key to file |
|
CONTENT_CODE |
Varchar2(10) |
* Code of PRAXIS test – Key to file |
|
CONTENT_DESC |
Varchar2(50) |
Description of the Content Code |
|
CONTENT_COUNTER |
Number(2) |
How many times this test was taken |
|
CONTENT_LAST_TERM_TAKEN |
Varchar2(7) |
The last term the test was taken |
|
CONTENT_PASSED |
Varchar2(1) |
Whether the test was passed (yes or no) |
|
CONTENT_SCORE1 |
Number(3) |
Score of 1st test |
|
CONTENT_DATE1 |
Date 19 |
Date of 1st test |
|
CONTENT_PREV_TERM1 |
Varchar2(7) |
Previous term of test1 |
|
CONTENT_SCORE2 |
Number(3) |
Score of 2nd test |
|
CONTENT_DATE2 |
Date 19 |
Date of 2nd test |
|
CONTENT_PREV_TERM2 |
Varchar2(7) |
Previous term of test2 |
|
CONTENT_SCORE3 |
Number(3) |
Score of 3rd test |
|
CONTENT_DATE3 |
Date 19 |
Date of 3rd test |
|
CONTENT_PREV_TERM3 |
Varchar2(7) |
Previous term of test3 |
|
CONTENT_SCORE4 |
Number(3) |
Score of 4th test |
|
CONTENT_DATE4 |
Date 19 |
Date of 4th test |
|
CONTENT_PREV_TERM4 |
Varchar2(7) |
Previous term of test4 |
|
CONTENT_SCORE5 |
Number(3) |
Score of 5thest |
|
CONTENT_DATE5 |
Date 19 |
Date of 5th test |
|
CONTENT_PREV_TERM5 |
Varchar2(7) |
Previous term of test5 |
|
CONTENT_SCORE6 |
Number(3) |
Score of 6th test |
|
CONTENT_DATE6 |
Date 19 |
Date of 6th test |
|
CONTENT_PREV_TERM6 |
Varchar2(7) |
Previous term of test6 |
|
CONTENT_SCORE7 |
Number(3) |
Score of 7th test |
|
CONTENT_DATE7 |
Date 19 |
Date of 7th test |
|
CONTENT_PREV_TERM7 |
Varchar2(7) |
Previous term of test7 |
|
CONTENT_SCORE8 |
Number(3) |
Score of 8th test |
|
CONTENT_DATE8 |
Date 19 |
Date of 8th test |
|
CONTENT_PREV_TERM8 |
Varchar2(7) |
Previous term of test8 |
|
CONTENT_SCORE9 |
Number(3) |
Score of 9th test |
|
CONTENT_DATE9 |
Date 19 |
Date of 9th test |
|
CONTENT_PREV_TERM9 |
Varchar2(7) |
Previous term of test9 |
|
CONTENT_SCORE10 |
Number(3) |
Score of 10th test |
|
CONTENT_DATE10 |
Date 19 |
Date of 10th test |
|
CONTENT_PREV_TERM10 |
Varchar2(7) |
Previous term of test10 |
|
CONTENT_SCORE11 |
Number(3) |
Score of 11th test |
|
CONTENT_DATE11 |
Date 19 |
Date of 11th test |
|
CONTENT_PREV_TERM11 |
Varchar2(7) |
Previous term of test11 |
|
CONTENT_SCORE12 |
Number(3) |
Score of 12th test |
|
CONTENT_DATE12 |
Date 19 |
Date of 12th test |
|
CONTENT_PREV_TERM12 |
Varchar2(7) |
Previous term of test12 |
|
LAST_UPDATE_DATE |
Date 19 |
Last date that the table was updated |