- DATA VIEW NAME
- ACADEMIC_SUBPLAN
- OVERVIEW
- This view contains governance-approved named options, honor in the major and non-degree tracks associated with majors and non-degree offerings.
The view is term-based meaning there is a row for each subplan code (active and inactive) that existed at the start of the term selected.
This data view should be joined to UW.ACADEMIC_PLAN via the plan code in order to get the most complete information. Not all plans have subplans.
- 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
08/2021 – SUBPLAN_NONADMIT_INDICATOR added - 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 Char) | 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) |
| PLAN | VARCHAR2 (10 Char) | For all full definition of academic plan, see the plan table. In this context, active plans of type MAJ may have subplans and the plan listed here is the parent plan of the related subplan. |
| SUBPLAN | VARCHAR2 (10 Char) | A code representing an approved curricular path option within an academic plan. |
| SUBPLAN_STATUS | VARCHAR2 (1 Char) | The status of the subplan as of the effective date. An active value means the subplan is available for students to be assigned to, as of the effective date. A = Active I = Inactive If the parent plan status is changed to I=inactive, then all subplans are also become inactive as of or before the same effective date. |
| TERM_DESCR | VARCHAR2 (30 Char) | Description of the Term (i.e. Fall 2018-2019) |
| TERM_BEGIN_DATE | DATE | Date the term started (non-medical calendar dates). |
| SUBPLAN_EFFDT | DATE | For new academic subplans, the date when the subplan 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. Effective dates for academic subplans may differ from the effective dates its parent plan. |
| SUBPLAN_TYPE | VARCHAR2 (3 Char) | A code indicating the type of subplan, related to the degree or credential awarded to students who complete it. OPT = named option HON = Honors TRK = Track |
| SUBPLAN_DESCR | VARCHAR2 (30 Char) | The official description of the academic subplan. |
| SUBPLAN_SHORT_DESCR | VARCHAR2 (10 Char) | The official short description of the academic subplan. |
| SUBPLAN_TRANSCRIPT_DESCR | VARCHAR2 (100 Char) | The officially approved description of the academic subplan as it appears on the student’s transcript. |
| SUBPLAN_LAST_ADMIT_TERM | VARCHAR2 (4 Char) | For subplans that have had a governance action to suspend or discontinue, this is the last term a student may be newly declared in the subplan. |
| SUBPLAN_STATE | VARCHAR2 (1 Char) | The status of active plans that are not open to new declarations. S = Suspended. For plans that have a UAPC-approved formal action to suspend admission. No new students are allowed to declare but currently enrolled students are allowed to continue in the plan. A subsequent proposal will required to be submitted to the UAPC for the plan to be discontinued (a D action) or for the S state to be removed so that new students will be allowed to enroll. SD = Suspended and Discontinued. For plans that have formal UAPC-approved action suspending admission and also discontinuing the program at a future date. D = Plans that have a formal action approved to be discontinued at a future date; a plan may carry both future or current dated S row and a future dated D row. When the effective date of the D entry is reached, the plan will be checked to confirm no students remain enrolled, and the plan status will be changed from A (active) to I (inactive), and the plan state will be cleared of any values. |
| SUBPLAN_DISTANCE_PROGRAM | VARCHAR2 (1 Char) | For subplans where the mode of delivery is online/distance education. UW-Madison uses definitions for online/distance-delivered programs that are set by the Higher Learning Commission. As of March 2015, the definition of online/distance-delivered programs is: • Distance-delivered programs are those certificate or degree programs in which 50% or more of the required courses may be taken as distance-delivered courses. • Distance-delivered courses are those in which all or the vast majority (typically 75% or more) of the instruction and interaction occurs via electronic communication, correspondence or equivalent mechanisms, with the faculty and students physically separated from each other. (NOTE: Programs that are predominately student-directed are considered “correspondence programs” and UW-Madison is not approved to offer such programs.) Valid value: O = Option is a distance education program |
| SUBPLAN_SPECIAL_OPT_TYPE | VARCHAR2 (5 Char) | For administrative use to track specific types of plans and options for budget/fiscal considerations. Valid Value: NPO= Option is a non-pooled option |
| SUBPLAN_EI_PROGRAM | VARCHAR2 (1 Char) | Starting in Fall 2011, UW-Madison launched the Educational Innovation initiative and under that initiative approved a series of academic programs that meet the following criteria: • The program brings in new and additional students and does not compete with existing programs for enrollment; overall enrollment in all other school/college programs remains steady. • The program is specifically designed to meet the needs of non-traditional audiences; has an applied, practice-oriented curriculum that is self-contained with a clear pathway with few electives or options; is offered in a modality that allows non-traditional audiences to attend (evening, weekend, distance, intensive, or some combination thereof); has a market demand and learning goals that are oriented to market considerations. • The program is distinctly identifiable in the student record system, either as a degree/major or as an option of a degree/major, or as a Capstone certificate. Valid Value: O = Option is an Educational Innovations program |
| SUBPLAN_NONTRAD_PROGRAM | VARCHAR2 (1 Char) | Program designed to meet the needs of non-traditional student audiences; has an applied, practice-oriented curriculum that is self-contained with a clear pathway with few electives or options; is offered in a modality that allows non-traditional audiences to attend (evening, weekend, distance, intensive, or some combination thereof); has a market demand and learning goals that are oriented to market considerations. Most are offered as master’s level programs, named options in master’s level programs, or as Capstone certificate programs. (Frequently but not always are also distance-delivered, EI, or non-pooled tuition programs.) Valid Value: O = Option is a non-traditional option |
| SUBPLAN_FIRST_TERM_VALID | VARCHAR2 (4 Char) | The first term the subplan code can be assigned to applicants or matriculated students. |
| SUBPLAN_NONADMIT_INDICATOR | VARCHAR2 (1 Char) | An indicator that a subplan (named option) under a master’s degree plan (MA or MS only) does not directly admit students and is used for awarding of masters degrees to students admitted to research doctorate plans who complete significant requirements but will not complete the intended doctorate requirements. Y = Non admitting masters level subplan Null = Master’s degree subplan that does admit directly OR the field is not relevant to the subplan type and level |
| ETL_UPDATE_DT | DATE | The date the record in the warehouse was last updated. |