- DATA VIEW NAME
- STDNT_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 efore they are used in the schedule of classes.
- LOAD FREQUENCY
- Data will be refreshed each weekend.
- DATA CUSTODIAN
- Registrar’s Office
Contact: Phil Hull
Please 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.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 05/2003 – New view created
06/2008 – Data Custodian change.C4j.
01/2010 – Data Custodian Change C4j
09/2012 – Data Custodian Contact changed from Karen Hanson to Kim Alling
12/2012 – Extract changed to include subject codes as soon as they are approved by the University Academic Planning Council. Additional information for governance approved subject codes is also available. The new fields are:
CIP_CODE
UDDS_DPP
UDDS_ACAD_OWNER
CDR_CAC
PRIMARY_DISC_DIV - 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 |
|---|---|---|
| *SUBJECT CODE | VARCHAR2(8) | The code used in the Schedule of Classes to identify a course listing department. For example, Mathematics is 600. |
| SUBJECT DESCR SHORT | 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 DESCR FORMAL | 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 suject 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 |