- DATA VIEW NAME
- UW.FROZEN_SUBJECT_CODES
- OVERVIEW
- This view contains one record for each subject code and the information related to each subject code that is current at the time of the extract. Subject codes are added as soon as they are approved by the University Academic Planning Council. This may be before courses are associated with them and/or before they are used in the schedule of classes.
- LOAD FREQUENCY
- Data will be updated twice/year on January 1 and September 1.
- DATA CUSTODIAN
- Office of the Registrar
Contact: Phil HullPlease contact:
Academic Planning and Institutional Research
Contact: Clare Huhn
For questions regarding the following fields:
CIP_CODE
UDDS_DPP
UDDS_ACAD_OWNER
CDR_CAC
PRIMARY_DISC_DIV - 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 - There are no special considerations listed for this view.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 10/2015 – New view created.
- 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 ISIS code for the academic year and semester. |
| REPORT_YEAR | VARCHAR2(6) | The academic year of snapshot. i.e. 201415 = Fall 2014-15 and Spring 201415 |
| *SUBJECT_CODE | VARCHAR2(10) | The Timetable department number of the course. For example, 600 is Mathematics. |
| SUBJECT_DESCRSHORT | VARCHAR2(10) | The 10 character short department name corresponding to the subject code. |
| SUBJECT_DESCR | VARCHAR2(30) | The 30 character department name corresponding to the subject code. |
| SUBJECT_DESCRFORMAL | VARCHAR2(50) | The 50 character formal department name corresponding to the subject code. |
| *STATUS | VARCHAR2(1) | Indicates the status of the subject code. Valid values: A = Active I = Inactive |
| CIP_CODE | VARCHAR2(13) | A code assigned by Academic Planning and Institutional Research based on the Department of Education’s Classification of Instructional Programs taxonomy. Because these codes are standardized nationally, they can be used for peer comparisons. These only pertain to governance approved subject codes that are used for curricular listings (not for subject codes used solely for administrative purposes). |
| UDDS_DPPS | VARCHAR2(11) | The UDDS associated with the academic owner of the subject code that is used for the Department Planning Profiles produced by Academic Planning and Institutional Research. These are occasionally different from the UDDS_ACAD_OWNER in cases when the academic owner is not a budgetary unit. These only pertain to governance approved subject codes that are used for curricular listings (not for subject codes used solely for administrative purposes). |
| UDDS_ACAD_OWNER | VARCHAR2(11) | The UDDS associated with the academic owner of the subject code. The academic home of a subject code is determined at the time the subject code is approved by the University Academic Planning Council. These only pertain to governance approved subject codes that are used for curricular listings (not for subject codes used solely for administrative purposes). |
| CDR_CAC | VARCHAR2(10) | This code is a crosswalk to the UW System Administration’s Central Data Request database. This code is assigned by UW System Administration for governance approved subject codes. |
| PRIMARY_DISC_DIV | VARCHAR2(1) | An assignment of each subject to one of UW-Madison’s four disciplinary divisions. These assignments are made by Academic Planning and Institutional Research and are primarily based on the divisional committee that approves the courses listed under the subject. BIO = Biological Sciences PHY = Physical Sciences HUM = Arts & Humanities SOC = Social Studies |
| EFFECTIVE_DATE | DATE | The effective date associated with the subject code. This is the date that the subjects are added into ISIS and not the date the University Academic Planning Council approved the subject code. If the subject code has not been entered into ISIS the value will be NULL |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted.
Format : YYYYMMDD HH24:MI:SS |