- DATA VIEW NAME
- Desc
- OVERVIEW
- This view contains standardized test scores including ACT, SAT, GRE, placement tests and others as recorded in ISIS. Information is available for students enrolled since the summer term of the 1984-85 academic year.
- LOAD FREQUENCY
- Entire view is refreshed the 3rd of each month.
- 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 the InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - Standardized tests are periodically redesigned. For trend analyses spanning several years visit an appropriate website, (e.g., www.ets.org for the SAT) to obtain information on how and when scoring systems have changed.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 05/2002 – New view created.
11/2002 – Changed Load Frequency.
06/2003 – Change in Data Custodian. - 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 |
|---|---|---|
| *ID | Varchar2 (11) | ISIS personal Identifier. The ID 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) | The “surname,” or overall name of the test. Values are: ACT AP C LEP GMAT GRE IB LSAT MCAT MELAB SAT SATI SATII TOEFL UWMAP UWS WIENG See TEST_ID_DESCR for descriptions. |
| Test_ID_Descr | Varchar2 (30) | Description of the Test ID. |
| *Test_Component_ID | Varchar2 (5) | The component of the overall test to which the score refers. |
| Test_Component_Descr | Varchar2 (30) | Description of the Test Component. |
| *Test_Date | Date | The date the test was taken. |
| *Test_Data_Source | Varchar2 (3) | The source of the reported scores. |
| Test_Data_Source_Descr | Varchar2 (30) | Description of the data source. |
| Test_Score | Number (4,2) | The numerical score on the test (if applicable). |
| Test_Letter_Score | Varchar2 (4) | The letter grade on the test (if applicable). |
| Test_Academic_Level | Varchar2 (4) | The academic level of the student at the time of taking the test. |
| Test_Academic_Level_Descr | Varchar2 (30) | Description of the student’s academic level at the time of taking the test. |
| Test_Percentile | Number (3) | The percentile rank of the score. |
| Test_Administered_IND | Varchar22 (1) | Indicates if the test has “Standard Test Administration” Values: Y = Standard Test Administration; otherwise N. |
| Extract_Date_Time | Date | The date and time these data were extracted from the source system. |