- DATA VIEW NAME
- STDNT_SOAR_ATTENDEES
- OVERVIEW
- This data view is based on information collected by the SOAR Reservation System. The SOAR Reservation System enables new undergraduate degree-seeking students (freshmen or transfer) to sign up for the SOAR program. The data view contains one record for each student per admit term in which they registered for SOAR. A few students will have multiple SOAR reservations if they have been admitted and registered for SOAR multiple times. This data view has historical SOAR data starting from admit term 1046. For questions about how the SOAR Reservation System works contact the data custodian.
STDNT_SOAR_Attendees was designed to be used in conjunction with STDNT administration data views, including STDNT_Ugrd_Applicant.
- 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
- None.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 06/2002 New view created with RTRIM to be used to join with other STDNT views.
03/2013 View has been revised with seven additional and some revised fields.
05/2020 Data from the new SOAR reservation system has been merged with the existing data.
DATA FORMATS
Key fields are identified with an asterisk(*)
The codes following the field names in this document define the field. The different types are:Char:Character dataNumber:Numeric fields will be null if no data is available.Date:This data type allows the date to be represented in various formats and date related functions to be used against the field. The formats (i.e. 19980203, 10-jun-98) and functions available vary based on your query tool.
| 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. |
| CAMPUS_ID | VARCHAR2 (16) | This is simply a unique student identifier (10 digits). It may change occasionally at the student’s request. |
| LAST_NAME | VARCHAR2 (30) | The student’s last name. |
| FIRST_NAME | VARCHAR2 (30) | The student’s first name. |
| *ADMIT_TERM | VARCHAR2 (4) | The term for which the applicant has applied for admission. This field uses the term codes from ISIS: First digit is century (0 for 20th, 1 for twenty-first) Second and third digits are last two digits of the fiscal year (13 for fall, 2012: spring 2013, and summer 2013). Fourth digit is the term (2 = fall, 4 = spring, 6 = summer) Example: Fall, 2012 = 1132 Spring, 2013 = 1134 Summer, 2013 = 1136 |
| *SESSION_NUMBER | VARCHAR2 (4) | A four digit identifier corresponding to the month and day of the SOAR session. Values are not unique and can be repeated from year to year. |
| SESSION_BEGIN_DATE | DATE | A SOAR session may comprise one or more days. The session begin date identifies the first day of a SOAR session. |
| SESSION_END_DATE | DATE | A SOAR session may comprise one or more days. The session end date identifies the day a SOAR session ends. |
| GUEST_NUMBER | NUMBER (1) | SOAR attendees may invite guests (usually a limit of 2). Guest Number is the number of guests that will accompany the student.
Guest Number is used primarily for planning, including facilities and staffing needs and catering. |
| ADV_GRP_RESERVED | VARCHAR2 (5) | Designation of the advising unit they intend to advise with during SOAR. |
| ADV_GRP_ATTENDED | VARCHAR2 (10) | Designation of the advising unit they actually advised with at SOAR. |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |