- DATA VIEW NAME
- STDNT_SOAR_INTEREST
- OVERVIEW
- This data view is based on information collected by the SOAR Reservation System. This data view contains the area of study interests a student specified on their SOAR reservation. A student is not required to enter this information. Students may specify multiple areas of interest resulting in multiple rows per student. Students who do not list an area of study interest are not included in the data view.
STDNT_SOAR_Interest was designed to be used in conjunction with STDNT_SOAR_Attendees by joining on ID.
- LOAD FREQUENCY
- Data is refreshed nightly.
- DATA CUSTODIAN
- Center for First-Year Experience
Contact: Lucas Dushack - AUTHORIZATION
- No approval signature is required by the Data Custodian to receive
authorization to access this data view.
For information about how to get authorized for InfoAccess data views, connect to the InfoAccess Home Page - SPECIAL CONSIDERATIONS
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 04/2013 – New view created.
05/2020 Data from the new SOAR reservation system has been merged with the existing data. - 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) | The ID (also known as SIS ID and EMPLID) is generated by the SIS system. It is a unique identifier for a student and will never be changed throughout the individual’s relationship with the University. This is not the same as Campus_ID. |
| INTEREST_ABBR_DESCR | VARCHAR2(20) | The abbreviated description of the area of study interest. These values do NOT map directly to values used for programs/plans in SIS. |
| INTEREST_FULL_DESCR | VARCHAR2(200) | The full description of the area of study interest. These values do NOT map directly to values used for programs/plans in SIS. |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |