Data, Academic Planning & Institutional Research

STDNT TEST

DATA VIEW NAME
STDNT_TEST
OVERVIEW
This data view contains all of the test and placement scores for prospects and applicants.
Valid tests include:
Advanced Placement (College Board)
ACT
CLEP (College Level Examination Program)
GMAT
GRE
IB (International Baccalaureate)
Law School Admission Test
MCAT (Medical School Admission Test)
Michigan English Language Assessment B
SAT
TOEFL (Test of English as a Foreign Language)
UW System Placement
UW Madison Advanced Placement
Wisconsin English
LOAD FREQUENCY
The data in this view is refreshed daily.
DATA CUSTODIAN
Undergraduate Admissions Office
Contact: David Leszczynski
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
If using this with the Ugrd_Prospect data view join using the prospect_key. If using with other data just use the ID.
QUESTIONS
Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357)
LAST UPDATED
Desc
DATA FORMAT
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
*TEST_KEY NUMBER(15)
A unique identifier that is system generated. A surrogate key. It is based on ID, Test_ID and Test_Component_ID, Test_Date and Data_Source.
PROSPECT_KEY NUMBER(15) Surrogate key of prospect table. Match this key on this table to same key on Ugrd_Prospect view.
ID VARCHAR2(11) ISIS personal Identifier. It will never be changed throughout the individual’s relationship with the University. This is not the same as Campus_ID. Only 10 characters are in use.
TEST_ID VARCHAR2(5) Type of test, examples: ACT, SATI, AP
TEST_ID_DESCR VARCHAR2(30) Full description of test ID
TEST_COMPONENT_ID VARCHAR2(5) Type of test components. Example of valid values: MATH, VERB, CLCAB, WR, etc.
TEST_COMPONENT_DESCR VARCHAR2(30) Description of the test component. Example of valid values: Math, Verbal, Calculus AB, Writing, etc.
TEST_DATE DATE Date the exam was taken.
DATA_SOURCE VARCHAR2(3) Details how the test score was reported. Most often the test score will be reported by the appropriate testing agency. For the ACT or SATI the test score may show that it was reported by the high school.
DATA_SOURCE_DESCR VARCHAR2(30) Description of how the test score was reported.
SCORE NUMBER(6,2) Test score value.
LETTER_SCORE VARCHAR2(4) A letter score is not used in every exam.
ACADEMIC_LEVEL VARCHAR2(4) The value indicates the academic level of the student when they took the exam.
Valid values:

0 Unknown
17 Pre-K and Kindergarten
16 1st Grade
15 2nd Grade
14 3rd Grade
13 4th Grade
12 5th Grade
11 6th Grade
10 7th Grade
01 Pre-Eighth Grade
1 8th Grade
2 9th Grade
3 10th Grade
4 11th Grade
5 12th Grade
6 Postsecondary Freshman
7 Postsecondary Sophomore
8 Postsecondary Junior
9 Postsecondary Senior
90 Post-Secondary
91 Postsecondary Professional
92 Postsecondary Master
93 Postsecondary Doctoral
94 Postdoctoral
DATE_LOADED DATE Date the test score was loaded into ISIS.
TEST_PERCENTILE NUMBER(3,0) Student’s percentile as it compares to national test score takers. This value is not present for all exams.
TEST_ADMINISTERED_IND VARCHAR2(1) Standard test administration indicator.
Valid values:

Y Yes
N No
Null Unknown
SAT_MOST_RECENT_IND VARCHAR2(1) This field identifies the individual SAT Math, Verbal, and Writing components that make up the most recent SAT exam. Note: the Writing component will only be present on exams taken March 2005 to present.
Valid values:

Y Yes
Null No
SAT_HIGHEST_COMBINED_IND VARCHAR2(1) This field identifies the individual SAT Math, Verbal, and Writing components that make up the highest SAT combined score. Note: the Writing component will only be present on exams taken March 2005 to present.
Valid values:

Y Yes
Null No
ACT_MOST_RECENT_IND VARCHAR2(1) This field flags all the individual ACT components taken on the student’s most recent ACT exam date.
Valid values:

Y Yes
Null No
ACT_HIGHEST_COMPOSITE_IND VARCHAR2(1) The composite score, as reported by ACT, is the average of the four test scores (Engilish, Mathematics, Reading, and Science) earned during a single test administration, rounded to the nearest whole number. The score range for each of the four tests is 1 – 36. This indicator flags the all components of the test date with the highest combined score.
Valid values:

Y Yes
Null No
EXTRACT_DATE_TIME DATE The date and time these data were extracted.
Format : YYYYMMDD HH24:MI:SS