- DATA VIEW NAME
- ACADEMIC_SUBJECT
- OVERVIEW
- This view contains subject codes and information related to curricular subjects; all for-credit courses offered by the university are organized into curricular subjects. The view is term-based meaning there is a row for each subject (active and inactive) that existed at the start of the term selected.
Subject codes are added to SIS as soon as they are approved by the University Academic Planning Council. This may be before courses are associated with them and before they are used in the Schedule of Classes.
Subject codes used only for transfer courses (subject field has a text code instead of a numeric code and subject owner is T), the subject for the Farm and Industry Short course prior to 2017 (codes begin with SC_ and subject owner is F) and the administrative placeholder subject codes (subject owner is S) are included. To only get a list of subjects used for credit-based courses offered through UW-Madison, exclude Subject Owners T, F and S.
- LOAD FREQUENCY
- Updated nightly.
- DATA CUSTODIAN
- Academic Planning and Institutional Research
Contact: Michelle Young - 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
- 06/2019 – 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) | A four-digit Student Information System (SIS) numeric representation for the academic term. It is derived as follows: Character 1 = Century (0 = 1900 and 1 = 2000) Character 2 & 3 = Academic Year (i.e. 2018-19 would be ’19’) Character 4 = Term ( 2=Fall, 4=Spring and 6=Summer) |
| SUBJECT | VARCHAR2(8) | For subjects used by courses offered for UW-Madison for-credit courses (not used for transfer equivalencies or placeholders for study abroad), a unique three digit code identifying each subject listing, used to organize groups of courses in related subject areas or topics. |
| SUBJECT_SHORT_DESCR | VARCHAR2(10) | The officially approved short description of the subject. This field is the one most frequently used in publications and for DARS. |
| SUBJECT_STATUS | VARCHAR2(1) | Indicates the status of the subject code. Valid values: A = Active I = Inactive |
| SUBJECT_DESCR | VARCHAR2(30) | The officially approved description of the subject. |
| TERM_DESCR | VARCHAR2(30) | Description of the Term (i.e. Fall 2018-2019) |
| TERM_BEGIN_DATE | DATE | Date the term started (non-medical calendar dates). |
| SUBJECT_EFFDT | DATE | For new subjects, the date when the subject first became active. For subsequent actions, the effective date is when changes from the previous version became effective. Dates of 01/01/1900 indicate migration from the legacy system to PeopleSoft. Dates of 05/14/2017 indicate changes made during the academic structure review process. Effective dates are limited to first day of the relevant fall, spring, or summer term. |
| SUBJECT_FORMAL_DESCR | VARCHAR2(50) | This is generally the same as the description, unless character limits on the description necessitate abbreviating. |
| SUBJECT_CIP_CODE | VARCHAR2(13) | A six-digit code assigned to plans using the federal Classification of Instructional Programs (CIP) taxonomy. The code assignment is coordinated during the governance process by APIR. Codes are in the XX.YYZZ format where XX denotes the broadest disciplinary area (i.e. Biological Sciences), YY indicates a diciplinary area within the XX (i.e. Botany) and ZZ indicates a specialty within the XX.YY area (i.e. Plant Pathology). CIP codes are intended for academic plans, not for subjects. However, several data systems use CIP Codes for subjects. |
| SUBJECT_FIELDOFSTUDY | VARCHAR2(10) | The UW-Madison broad disciplinary division to which each subject has been assigned for analytic purposes by APIR. Assignments are based on divisional assignment of the majority of faculty in the department (academic organization) that serves as the academic owner of the subject. Values are: BIO = Biological Sciences HUM = Arts and Humanities PHY = Physical Sciences SOC = Social Sciences |
| SUBJECT_SCHOOLCOLLEGE | VARCHAR2(5) | A three character code for the school/college with governance responsibility for the subject. Uses the same codes as the ACAD_GROUP_TBL |
| SUBJECT_SCHOOLCOLLEGE_DESCR | VARCHAR2(30) | Description of the school/college with governance responsibilities for the subject. |
| SUBJECT_SCHOOLCOL_SHORT_DESCR | VARCHAR2(10) | Short description of the school/college with governance responsibilities for the subject. |
| SUBJECT_OWNER | VARCHAR2(10) | The SIS code of the department that owns the subject code. |
| SUBJECT_OWNER_UDDS | VARCHAR2(10) | The budgetary code (UDD or UD) representing the academic owner of the subject. |
| SUBJECT_OWNER_DESCR | VARCHAR2(30) | The officially approved description of the owner of the subject. |
| SUBJECT_OWNER_FORMAL_DESCR | VARCHAR2(50) | An abbreviated name for the owner of the subject used in data systems where space is limited. |
| ETL_UPDATE_DT | DATE | The date the record in the warehouse was last updated. |