- DATA VIEW NAME
- LUMEN_PROGRAM_PROPOSALS
- OVERVIEW
- This view contains all completed and in-progress program proposals created in the Lumen Program Proposal System.
- The view may be connected to LUMEN_PROG_LEARNING_OUTCOMES using the CIM_PROG_KEY and PROPOSAL_NUMBER to retrieve additional data about a program.
- The max PROPOSAL_NUMBER represents the most recent proposal for the course.
- LOAD FREQUENCY
- Data updated nightly.
- DATA STEWARD
- Academic Planning and Institutional Research Contact: Michelle Young
- AUTHORIZATION
- You must receive approval to access data from the data steward.
- SPECIAL
CONSIDERATIONS - None.
- QUESTIONS
- Contact: Division of Information Technology Help Desk Phone: 264-HELP (4357)
- LAST UPDATED
- 05/2020 – 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 |
|---|---|---|
| CIM_PROG_KEY | NUMBER | A unique ID assigned by Lumen Programs that identifies a program. Plans or subplans in SIS (SIS_CODE) will have a CIM_PROG_KEY. |
| SIS_CODE | VARCHAR2 (10) | The SIS plan or subplan code for the program. |
| SIS_CODE_BABS | VARCHAR2 (10) | If program is an L&S BA/BS program, the BA code is entered as the SIS_CODE, the BS code is entered here. |
| SIS_DESCRIPTION | VARCHAR2 (30) | The SIS plan/subplan descr field. |
| SIS_DESCRIPTION_BABS | VARCHAR2 (30) | If program is an L&S BA/BS program, the BA code is entered as the SIS_DESCRIPTION, the BS code is entered here. |
| SIS_TRANSCRIPT_DESCR | VARCHAR2 (100) | The official description of the academic program as it appears on the student’s transcript. |
| PROPOSAL_NUMBER | NUMBER | For each CIM_PROG_KEY a proposal number starting with one (1) will be assigned to each successive proposal submitted for a course. The highest proposal number represents the most recent proposal. |
| PROPOSAL_TYPE | VARCHAR2 (11) | The type of proposal. Values: Discontinue Change New |
| PROPOSAL_STATUS | VARCHAR2 | Where the proposal is in the approval process. Values: Completed Not in Workflow Workflow Role Name |
| PROPOSAL_CREATED_DATE | DATE | The date the proposal was first initiated. |
| PROPOSAL_COMPLETED_DATE | DATE | The date the final step of workflow was completed. |
| TERM_AVAILABLE | VARCHAR2 (4) | For program change proposals, the term the changes will be effective. |
| PROGRAM_STATE | VARCHAR2 | The status of the program in terms of its availability for student enrollment. Values: A = Active D = Discontinued RA = Reactivate S = Suspend Admissions SD = Suspend, will be discontinued |
| SIS_PROGRAM_TYPE | VARCHAR2 | The type of program, the SIS plan or subplan type. Values: CAP = Capstone Certificate (Special only) CRT = Certificate HON = Honors Program (Undergraduate only) MAJ = Degree/Major MIN = Minor (PhD and BSE only) NON = Non-Degree Program (Special only) OPT = Named Option TCH = Educator Certification TRK = Non-Degree Track (Special only) |
| SIS_PARENT_CODE | VARCHAR2 | Populated for named option proposals, |
| PARENT_AUDIENCE | VARCHAR2 | Populated for named option proposals, inherited value from parent plan AUDIENCE field. |
| AUDIENCE | VARCHAR2 | The type of student eligible to enroll in the program. Values: GP = Graduate or Professional SPCL = Special UGRD = Undergraduate |
| PARENT_SIS_ACAD_OWNER | VARCHAR2 | Populated for named option proposals, inherited value from parent plan SIS_ACAD_OWNER field. |
| SIS_ACAD_OWNER | VARCHAR2 | The department that is responsible for the program. |
| PARENT_CAF_SCHOOL_COLLEGE | VARCHAR2 | Populated for named option proposals, inherited value from parent plan CAF_ SCHOOL_COLLEGE field. |
| CAF_SCHOOL_COLLEGE | VARCHAR2 | The division that is responsible for the department (SIS_ACAD_OWNER) this field auto-fills in the form based on the academic structure. |
| PARENT_CAF_GRADUATE_SCHOOL | VARCHAR2 | Populated for named option proposals, inherited value from parent plan CAF_GRADUATE_SCHOOL field. |
| CAF_GRADUATE_SCHOOL | VARCHAR2 (3) | Indicates that the program is part of the Graduate School. Values: Yes = program is in the Graduate School |
| AWARD | VARCHAR2 | The type of degree awarded for a program, populated for degree granting plans only. Values: AUD = Doctor of Audiology BA = Bachelor of Arts BA & BS = Bachelor of Arts and Bachelor of Science BBA = Bachelor of Business Admin BFA = Bachelor of Fine Arts BLA = Bachelor of Land Arch BM = Bachelor of Music BNS = Bachelor of Naval Science BS = Bachelor of Science BSE = Bachelor of Science=Education BSN = Bachelor of Science=Nursing BSW = Bachelor of Social Work DMA = Doctor of Musical Arts DNP = Doctor of Nursing Practice DPT = Doctor of Physical Therapy DVM = Doctor of Veterinary Medicine EDS = Education Specialist JD = Doctor of Law (Juris Doctor) LLM = Master of Laws LLMI = LLMI Legal Institutions MA = Master of Arts MACC = Master of Accountancy MBA = Master of Business Admin MD = Doctor of Medicine ME = Master of Engineering MFA = Master of Fine Arts MGCS = Master of Genetic Counselor St MIPA = Master of Int’l Public Affairs MM = Master of Music MPA = Master of Public Affairs MPH = Master of Public Health MS = Master of Science MSPA = Master of Physician Asst St MSW = Master of Social Work OTD = Doctor of Occupational Therapy PHARD = Doctor of Pharmacy PHD = Doctor of Philosophy PMFS = Master of Prof French Studies SJD = Doctor of Juridical Science |
| NEW_AWARD_NAME | VARCHAR2 | If the award does not exist, it is entered here until formal approval by the Board of Regents the code is then added to the AWARD list. |
| NAMED_OPTIONS | VARCHAR2 | If the proposal is a parent plan, the subplan code and transcript description of the subplans are listed here. |
| PARENT_ADDL_MAJOR | VARCHAR2 (3) | Populated for named option proposals, inherited value from parent plan ADDL_MAJOR field |
| ADDL_MAJOR | VARCHAR2 (3) | Indicator of whether the program may be offered as an additional major. For masters and PhD, this is known as a joint degree. For undergraduates earn an additional major by completing major-specific requirements. Values: Yes = program allows additional majors |
| CAF_PHD_MINOR_REQUIRED | VARCHAR2 (3) | Populated for doctoral degrees only, indicates whether a minor is a required part of the requirements for the degree. Values: Yes = this program requires a minor |
| CAF_NON_ADMIT_MASTERS | VARCHAR2 (3) | Populated for masters (MS/MA) degrees only, indicates program does not directly admit students to the program; awarded in relation to a partner PhD program. Values: Yes = this is a non-admitting masters |
| INTERESTED_DEPTS | VARCHAR2 | Departments or school/colleges in a related field of study or contributes courses to the program. |
| PROGRAM_REVIEW_UTD | VARCHAR2 (3) | Indicator of whether the department offering the program is up to date on program review. Values: Yes = department is up to date on program review |
| ASSESMENT_PLAN_UTD | VARCHAR2 (3) | Indicator of whether the department offering the program is up to date on assessment plans. Values: Yes = department is up to date with assessment plans |
| ASSESSMENT_REPORT_UTD | VARCHAR2 (3) | Indicator of whether the department offering the program is up to date on assessment reports. Values: Yes = department is up to date with assessment reports |
| DELIVERY_MODE | VARCHAR2 | UW System defined mode of delivery. Values: F2F = Face-to-Face (majority face-to-face courses) ONLINE = Distance Education (>50% – 99%) ONLINE100 = Distance Education (100% online) See OPT = Set at the named option level (parent plans only) |
| CONSORT_COLLABORATION | VARCHAR2 (3) | Indicator of whether the program is part of a consortial or collaborative arrangement with an outside college or university. Values: Yes = program is part of a consortial or collaborative arrangement |
| ADDL_LOCATION | VARCHAR2 (3) | Indicator of whether instruction will take place at a location geographically separate from UW-Madison. Values: Yes = instruction takes place at a location geographically separate from UW-Madison |
| PARENT_ACCREDITATION | VARCHAR2 (3) | Populated for named option proposals, inherited value from parent plan ACCREDITATION field. |
| ACCREDITATION | VARCHAR2 (3) | Indicator of whether the program has special accreditation. Values: Yes = program has special accreditation |
| PARENT_LICENSURE_CERTIFICATIO N |
VARCHAR2 (3) | Populated for named option proposals, inherited value from parent plan LICENSURE_CERTIFICATION field. |
| LICENSURE_CERTIFICATION | VARCHAR2 | Indicator of whether the program results in certification or licensure. Values: Yes = program has licensure or certification |
| SIS_FIRST_TERM | VARCHAR2 | For new program proposals, the first term students will enroll. |
| FIRST_TERM_APPL | VARCHAR2 | For new program proposals the first term the application will be available. Populated for graduate, professional or special programs. |
| PROG_START_TERM | VARCHAR2 | Terms that the program will admit students. Populated for graduate, professional or special programs. Values: Fall Spring Summer |
| PROG_START_TERM_MMDD | VARCHAR2 | The deadline for application submissions for each term that admissions applications are accepted. Populated for graduate, professional or special programs. |
| GFEC_CHECKIN | VARCHAR2 | For new graduate programs the date of the 3-year review. |
| PROG_REVIEW_YEAR | VARCHAR2 | For new programs the date of the 5-year review. |
| PERCENTAGE_CHANGE | VARCHAR2 | If the curricular requirements are changing, how much of the program will change. Values: NONE = No change 30 = Less than 30% of the curriculum will change 30-50 = 30% – 50% of the curriculum will change 50 = More than 50% of the curriculum will change |
| TOTAL_CREDITS_REQUIRED | VARCHAR2 | The minimum number of credits required to complete the program. |
| SUSP_DIS_RESOLVE_DATE | VARCHAR2 | For a suspended program, the deadline for determining whether it will be reactivated or discontinued. |
| SIS_LAST_ADMIT | VARCHAR2 | For a suspended or discontinued program, the final term in which a student can declare or be admitted to the program. |
| SIS_DIS_STUDENT_COMPLETE_TERM | VARCHAR2 | For a program that is to be discontinued the last term a student may be enrolled in or complete the program. |
| APPROVAL_DEPT | VARCHAR2 | Notes about the approval of the proposal by departmental governance. |
| APPROVAL_DEPT_ENTERED_BY | VARCHAR2 | Name of person who recorded approval. |
| APPROVAL_DEPT_DATE | VARCHAR2 | Date of approval. |
| APPROVAL_SCHL_COLL | VARCHAR2 | Notes about the approval of the proposal by school/college governance. |
| APPROVAL_SCHL_COLL_ENTER_BY | VARCHAR2 | Name of person who recorded approval. |
| APPROVAL_SCHL_COLL_DATE | VARCHAR2 | Date of approval. |
| APPROVAL_GFEC | VARCHAR2 | Notes about the approval of the proposal by GFEC governance. Only populated on programs in the Graduate School. |
| APPROVAL_GFEC_ENTERED_BY | VARCHAR2 | Name of person who recorded approval. |
| APPROVAL_GFEC_DATE | VARCHAR2 | Date of approval. |
| APPROVAL_UAPC | VARCHAR2 | Notes about the approval of the proposal by UAPC governance. |
| APPROVAL_UAPC_ENTERED_BY | VARCHAR2 | Name of person who recorded approval. |
| APPROVAL_UAPC_DATE | VARCHAR2 | Date of approval. |
| ADMIN_NOTE | VARCHAR2 | Administrative use only, information about the program that is relevant to the program or its history and is not recorded elsewhere |
| GUIDE_URL | VARCHAR2 | The relative URL for the program in Guide. https://guide.wisc.edu/ + GUIDE_URL is the full URL. |
| SIS_EFF_DATE | VARCHAR2 | The term in which the new program or changes to the program will go into effect, the first day of the term is displayed. Format: MM/DD/YYYY |
| EFF_CAT | VARCHAR2 | The edition of the Guide the proposal was published in. A new edition of the Guide is published each academic year on June 1. |
| SIS_CAREER_CODE | VARCHAR2 (4) | A broad grouping of students related to their degree objectives and admitting office. Used for tuition charges, awarding financial aid, grading scales and other operational functions. Values: GRAD = Graduate LAW = Law MEDS = Medicine and Public Health PHAR = Pharmacy UGRD = Undergraduate USPC = University Special Students VMED = Veterinary Medicine |
| SIS_PROGRAM_CODE | VARCHAR2 (4) | One or more academic plans that share characteristics within a school/college/division. Academic program code controls administrative functions such as min credits, max credits, tuition rates, academic standing, grading schemes, full-time/part-time standing, financial aid primacy number. All plans other than graduate minors have an academic program code. |
| SIS_PROGRAM_CODE_BABS | VARCHAR2 (10) | If program is an L&S BA/BS program, the BA code is entered as the SIS_PROGRAM_CODE, the BS code is entered here. |
| SIS_SHORT_DESCR | VARCHAR2 (10) | A 10-character description of the program name. |
| SIS_PLAN_CODE_AMAJ | VARCHAR2 (10) | The SIS plan code if the program is offered as an additional major |
| SIS_PLAN_CODE_INTENDED | VARCHAR2 (10) | The SIS plan code if the program has an intended major. |
| SIS_SUBPLAN_CODE_HONORS | VARCHAR2 (10) | The SIS subplan code if the program is offered with honors in the major. |
| SIS_SUBPLAN_CODE_HONORS_BABS | VARCHAR2 (10) | If program is an L&S BA/BS program, the BA code is entered as the SIS_SUBPLAN_CODE_HONORS, the BS code is entered here. |
| SIS_SUBPLAN_HONORS_AMAJ | VARCHAR2 (10) | The SIS subplan code if the program is offered as an additional major and there is honors in the major. |
| SIS_PLAN_CODE_SCRT | VARCHAR2 (10) | The SIS plan code if an undergraduate certificate can be completed by special students. |
| SIS_PLAN_CODE_OTHER | VARCHAR2 | In some situations, a program will have multiple plan or subplan codes due to the program spanning multiple careers or programs. Concatenated field. |
| SIS_PLAN_DESCR_OTHER | VARCHAR2 | The plan or subplan description. Concatenated field. |
| SIS_DEGREE_DIPLOMA_TEXT | VARCHAR2 | The name of the program as it appears on the diploma. |
| SIS_DEGREE_DIPLOMA_TEXT2 | VARCHAR2 | The name of the program as it appears on the diploma if second line is needed. |
| SIS_DEGREE_CODE | VARCHAR2 (3) | The code entered in the SIS degree table that corresponds to the program’s award. |
| SIS_DEGREE_CODE_BABS | VARCHAR2 (3) | If program is an L&S BA/BS program, the BA code is entered as the SIS_DEGREE_CODE, the BS code is entered here. |
| SIS_FIELD_OF_STUDY | VARCHAR2 | The UW-Madison broad disciplinary division to which each plan with a type of MAJ, MIN, CAP, CERT 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 plan. Values: BIO = Biological Sciences HUM = Arts and Humanities PHY = Physical Sciences SOC = Social Sciences |
| SIS_PROGRAM_LENGTH | VARCHAR2 (1) | The number of years the program is designed to take to complete. |
| SIS_NSC_CLAF | VARCHAR2 | The National Student Clearinghouse classification. Only populated for plan codes when plan type = CAP, CERT and for plans of type MAJ if the plan leads to a degree. Values: B = Bachelors C = Certificate D = Doctoral G = Unspecified L = Professional M = Masters N = Unspecified T = Post Baccalaureate certificate |
| CAF_PLAN_GROUP | VARCHAR2 (3) | Characters 5,6, and 7 of the plan. Useful for analytic purposes and grouping plans together. |
| SIS_EDUCATION_LEVEL | VARCHAR2 | For plans of type MAJ that award degrees, a code indicating the degree level based on federal IPEDS categorization. Values: B = Bachelors degrees D = Research Doctoral degrees M = Masters degrees P = Clinical Doctorate degrees |
| CAF_AWARD_CATEGORY | VARCHAR2 | An easily sortable numeric indicator of the level and type of award granted to a student who completes a given plan code. Values: 10 = Bachelors 30 = Masters 40 = Research Doctorate 50 = Clinical Doctorate 60 = Other Doctorate 70 = Undergraduate Certificate 80 = Capstone Certificate 90 = Graduate/professional certificate |
| CAF_ENROLLMENT_CATEGORY | VARCHAR2 | An easily sortable numeric indicator of the level, career, and program of enrollment for students enrolled in the plan code useful for analytic and reporting purposes. Values: 100 = Undergraduate 300 = Master’s 310 = Master’s of Public Health 320 = Master’s of Physician Assistant Studies 400 = Research Doctorate 510 = Law 520 = Medicine 530 = Pharmacy 540 = Veterinary Medicine 550 = Other Clinical Doctorate 600 = Undergraduate certificate 700 = Certificate for Non-Degree-seeking students 710 = Other Special Student (Non-certificate) 800 = Capstone Certificate 900 = Graduate Certificate |
| SIS_CIP_CODE | VARCHAR2 | 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. Codes are in the XX.YYZZ format where XX denotes the broadest disciplinary area (i.e. Biological Sciences), YY indicates a disciplinary area within the XX (i.e. Botany) and ZZ indicates a specialty within the XX.YY area (i.e. Plant Pathology). |
| CAF_STEMOPT | VARCHAR2 | Plan codes of type MAJ that meet the US Department of Homeland Security criteria of STEM for the purposes of the Optional Practical Training Program. Values: Yes = meet DHS STEM Optional Practical Training criteria |
| CAF_UWSTEM | VARCHAR2 | Plan codes with a value of Y in this field are institutionally defined as STEM (Science, Technology, Engineering, Math) for analytic purposes. Plan codes that are not considered STEM have a null value in this field. The STEM assignment is made when the curriculum is focused on math, statistics, physical science, biological science, natural science, technology, and/or engineering principles. In almost all cases, the CIP code associated with plans that have a value of 1 will be in the following areas: 01, 03, 11, 14, 15, 26, 27, and 40. Assigned by APIR. |
| CAF_HEALTH | VARCHAR2 | Indicates whether the plan is institutionally defined as a Health program for analytic purposes in that its focus is on preparing students for work or research in health-related fields. In almost all cases, the CIP code associated with these plans will be in CIP Area 51. Values: Y = plan is considered a health program |
| CAF_INNOV_PROG | VARCHAR2 | An indicator assigned between 2011 and 2017, of whether the plan or any of its subplans is considered to meet the goals of Educational Innovation initiative. Values: P = entire plan is considered part of the Educational Innovation initiative O = one or more of the subplans associated with this plan is considered part of the Educational Innovation initiative |
| CAF_DIST_ED_PROG | VARCHAR2 | An indicator of whether the plan or any of its subplans is approved for distance delivery as defined by the Higher Learning Commission where 50% or more of the required courses may be taken as distance-delivered courses where the vast majority of instruction and interaction occurs via electronic communication where instructors and students are physically separated from each other. Values: P = entire plan is a distance education plan O = one or more of the subplans associated with this plan are approved for distance delivery |
| CAF_NON_TRADITIONAL | VARCHAR2 | An indicator of whether the plan or any of its subplans meets the institutional criteria for consideration as a non-traditional program, including having an applied, practice-oriented curriculum that is self-contained with a clear pathway with few electives or options; being offered in a modality that allows non-traditional audiences to attend (evening, weekend, distance, intensive, or some combination thereof); having a market demand and learning goals that are oriented to market considerations. Values: P = entire plan is considered a non-traditional plan O = one or more of the subplans associated with this plan meet the criteria for consideration as non-traditional |
| CAF_SPECIAL_PLAN_TYPE | VARCHAR2 | For administrative use to track specific types of plans and options for budget/fiscal considerations. Values: NPP = Non-pooled, entire plan NPO = Plan has one or more options that are non-pooled tuition |
| CAF_CDR_CERT | VARCHAR2 | The level of the certificate as reported to UW System Administration through the CDR. Values: 1 = certificates < 1 year or 30 semester credit hours 6 = post bachelors certificate 8 = post master’s certificate |
| ADDED_TO_CROSSWALK | VARCHAR2 | Indicates that the plan code has been added to the SIS crosswalk table with UW System major codes. Values: YES = added to SIS UW System crosswalk table. |
| ETL_UPDATE_DATE | DATE | ETL_UPDATE_DATE |