- DATA VIEW NAME
- STDNT_ACADEMIC_GROUP_CODES
- OVERVIEW
- This view contains information for the college or school within the University. It includes the codes and code descriptions. This view can be used in conjunction with other views by joining on ACAD_GROUP_CODE.
- LOAD FREQUENCY
- The data is refreshed each weekend.
- DATA CUSTODIAN
- Registrar’s Office – Phil Hull
- 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 InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - None.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 10/01 View Create to use VarChar2 data type and conformed data element names. c4j
2/2012 Custodian Change c4j - 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 |
|---|---|---|
| *ACAD_GROUP_CODE | VARCHAR2 (5) | The code represents the college or school in which the student is enrolled, except for CAVE and MSN used administratively. Valid values are: AH School of Allied Health Prof (Dissolved) ALS Agricultural and Life Sciences AMN Air, Military & Naval Science BUS School of Business CAVE Continuing and Vocational Educ CIC Committee on Inst Cooperation DCS Division of Continuing Studies EDU School of Education EGR College of Engineering HEC School of Human Ecology IES Institute for Environmental St L&S College of Letters & Science LAW School of Law MED School of Medicine MSN Univ of Wisconsin – Madison NUR School of Nursing PHM School of Pharmacy VET School of Veterinary Medicine |
| ACAD_GROUP_LONG_DESCR | VARCHAR2 (30) | This is the long description of the ACAD_GROUP_CODE. |
| ACAD_GROUP_SHORT_DESCR | VARCHAR2 (10) | his is the short description of the ACAD_GROUP_CODE. |
| EXTRACT_DATE_TIME | DATE | The System generated date when the data was last refreshed. Format: mm/dd/ccyy. |