- DATA VIEW NAME
- STDNT_GRAD_TEST_SCORES_PROG
- OVERVIEW
- Test scores for applicants to Graduate School. See Special Considerations below.
- LOAD FREQUENCY
- The data is refreshed nightly.
- DATA CUSTODIAN
- Graduate School
Contact: Katie Bourassa - 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 - 1. Limit by ACAD_PROG when selecting records. If you select for multiple programs you get multiple occurring records for the same student for students who applied for more than one program. If you do not limit by ACAD_PROG, you get all the records for all the applicants, which can be more than 150,000 record!
2. Dates include a meaningless timestamp. If using Paradox, reformat the table you get and change the @ (timestamp) type to D (date). You will not lose information. - QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 12/1998 New data view.
03/2002 Created view using varchar2.
09/2004 Data Custodian change.
07/2006 Include GMAT test scores.
12/2012 Changed to include IELTS and MELAB test scores.
11/2014 Preferred name policy s8w. - 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 |
|---|---|---|
| EMPLID | VARCHAR2 11 | The ISIS system’s unique and unchanging identifier. (This is not the student ID) |
| CAMPUS_ID | VARCHAR2 16 | This is the student ID that goes on the student’s ID card. |
| LAST_NAME | VARCHAR2 30 | Applicant’s preferred last name. |
| FIRST_NAME | VARCHAR2 30 | Applicant’s preferred first name. |
| MIDDLE_NAME | VARCHAR2 30 | Applicant’s preferred middle name. |
| TEST_ID | VARCHAR2 5 | GRE, TOEFL, GMAT, IELTS, and MELAB. |
| TEST_COMPONENT | VARCHAR2 5 | Verbal, Quantitative and the like. |
| TEST_DATE | DATE | |
| SCORE | NUMBER 4.0 | |
| PERCENTILE | NUMBER 3.0 | Percent of people who got lower scores. |
| ACAD_PROG | VARCHAR2 5 | Program (major) code. You can find these codes in GWIS |
| LOADDATE | DATE | The date and time these data were extracted. Format: YYYYMMDD HH24:MI:SS |