- DATA VIEW NAME
- RETENTION_STDNT_GROUP_HIST
- OVERVIEW
- This data view contains student groups in which a student is listed or participated for every term since the summer term of the 1984-85 academic year. (Term 0856). The only student groups eliminated from this view are priority registration groups (AMCB, AFR, ASO, AJR, and ASR).
- LOAD FREQUENCY
- Information for the prior three terms replaced the 3rd of each month.
- DATA CUSTODIAN
- Office of the Registrar
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 the InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - Programs may list students as participating in certain groups, but fail to remove the student when they are no longer active in the group. The information in this view should not always be interpreted as indicating a student’s “active” status in that group in the given term.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 12/2001 – New view created.
11/2002 – Load Frequency changed.
04/2009 – Data extract modified to eliminate priority registration groups AMCB, AFR, ASO, AJR, and ASR.
02/2012 – c4j Custodian Change . - 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 |
|---|---|---|
| *TERM | varchar2 (4) | The code for the academic year and semester. |
| TERM_DESCR | varchar2 (30) | Description of the ISIS code for the academic year and semester. |
| *ID | varchar2 (11) | ISIS personal Identifier. 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. |
| CAMPUS_ID | varchar2 (16) | A unique student identifier (10 digits). Campus_ID may change at the student’s request. |
| *STUDENT_GROUP | varchar2 (4) | The code for the student group. |
| STUDENT_GROUP_DESCR | varchar2 (30) | The description of the student group. |
| EXTRACT_DATE_TIME | date | The date and time these data were extracted. |