- DATA VIEW NAME
- STDNT_GROUP_MULTITERM
- OVERVIEW
- This view contains Student Group information, for those students who have an active student group on file, for the two prior terms, the current term and up to two future terms. It is possible for a student to be part of more than one group and therefore have multiple records. The only student groups eliminated from this view are priority registration groups (AMCB, AFR, ASO, AJR, and ASR).
- LOAD FREQUENCY
- Data is refreshed nightly (Monday through Saturday).
- DATA CUSTODIAN
- Registrar’s Office
Contact: Phil Hull - 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 InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - To join this information with other data views use the ID field. Many students will not have a record on this data view. It is therefore very important to ensure you are creating an appropriate join for your needs. You will need to decide if you need to create a simple join or an outer join. A simple join (or equal join) will only give you rows that have a match on both tables being joined.
An outer join would give you all the rows returned by the simple join as well as those rows from one table that do not match any row from the other table. For example, if you select all applicants from the UW.ADMISSIONS_UGRAD data view and their student groups from the UW.STUDENT_GROUP data view, there may be applicants who do not have a student group on file. An outer join would return these applicants along with all the others.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 09/2001 – New view created.
04/2009 – Data extract modified to eliminate priority registration groups AMCB, AFR, ASO, AJR, and ASR.
02/2012 – Custodian Change . - DATA FORMAT
- 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 |
|---|---|---|
| *Term | Varchar2(4) | The ISIS code for the academic year and semester. |
| *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. |
| *Student_Group | Varchar2 (4) | The code for the student group in which the student participated in the given term. |
| Group_Descr | Varchar2 (30) | The description of the student group. |
| Extract_Date_Time | Date | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |