- DATA VIEW NAME
- UGRD_PROSPECT_ACAD_INTEREST
- OVERVIEW
- This view details the academic interests for undergraduate prospects including those who have applied for undergraduate admissions. Current means of gathering academic interest information is from the ACT and SAT exams and from undergraduate admissions interest cards.
- 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 the InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - None.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 04/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.
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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| *INTEREST_KEY | NUMBER(15) | A unique identifier that is system generated. A surrogate key. It is based on ID and Subject Area Code. | ||||||||
| 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. | ||||||||
| SUBJECT_AREA_CODE | VARCHAR2(4) | ISIS code specifying the academic subject area. | ||||||||
| SUBJECT_AREA_DESCR | VARCHAR2(30) | ISIS description for the academic area. | ||||||||
| DATA_SOURCE | VARCHAR2(3) | Source of the self reported information. Valid values:
|
||||||||
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |