- DATA VIEW NAME
- UW.STDNT_DEGREE_PLAN_COURSE
- OVERVIEW
- This view contains information for courses that students have included in their Course Search & Enroll app Degree Plans. Information in this view is most useful for forecasting course demand in future terms. After enrolling, courses are removed from the STDNT_DEGREE_PLAN_COURSES view.
- LOAD FREQUENCY
- Updated nightly
- DATA CUSTODIAN
- Registrar’s Office
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 InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - None
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 10/2022 – New view created.
- DATA FORMAT
- 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 |
| ROADMAP_ID | NUMBER (19) | Can use this to join to the field of the same name on UW.CG_ROADMAP to identify information about the student defined degree plan |
| ROADMAP_NAME | VARCHAR2 (100) | Student defined plan name |
| ROADMAP_IS_PRIMARY | NUMBER (1) | Indicates primary student intent
Values: 0 = Not primary intent 1 = Is primary intent |
| PVI | VARCHAR2 (100) | The Publicly Visible Identifier (or PVI) is a unique number assigned to each person in the University of Wisconsin System’s Identification, Authentication and Authorization (IAA) system. The PVI is in the form in the form of UW000A000 and is issued to identify a person and tie together the multiple roles that person may have in various source systems (HR, Student, etc.) |
| EMPLID | VARCHAR2 (20) | A unique number assigned to individuals entered in the Student Information System (SIS). This ID will never be changed throughout the individual’s relationship with the University. Ten characters are in use. |
| TERM_CODE | VARCHAR2 (4) | A four-digit Student Information System (SIS) numeric representation for the academic term.
CYYT DERIVED as follows: Fall 1998-99 = 0992 Summer 1999-00 = 1006
|
| COURSE_ID | VARCHAR2 (20) | A 6-digit unique ID assigned to a specific course. All course members of a crosslisted course will have the same Course ID. |
| SUBJECT_CODE | VARCHAR2 (4) | 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. |
| CATALOG_NUMBER | VARCHAR2 (10) | The course number that goes with the title of the course. UW MSN uses up to 3 characters to define the actual course number.
|
| COURSE_TITLE | VARCHAR2 (100) | The official name of the course. |
| TOPIC_ID | NUMBER (10) | Sequential code that corresponds to a submitted Topic Title in the Course Catalog.
|
| COURSE_CREDITS | NUMBER (10) | Number of credits a student earns for successful completion of the course. |
| CREDIT_MIN | NUMBER (10) | Minimum credits for an entire course. If Minimum and Maximum credits are equal, then the course has been approved to be offered for a fixed, single credit only. If Minimum and Maximum credits differ, then a credit range had been approved for the course. Null when the section Associated Class = 99 or 9999 and the min/max credits vary across the other Class Associations for the course. |
| CREDIT_MAX | NUMBER (10) | Maximum credits for a course. If the minimum and maximum credits are equal, then the course has been approved to be offered for a fixed, single credit only. If minimum and maximum credits differ, then a credit range has been approved for the course. Not populated when the section Associated Class = 99 or 9999 and the min/max credits vary across the other Class Associations for the course. |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted.
Format : YYYYMMDD HH24:MI:SS |