Penn Computing

University of Pennsylvania
Penn Computing << go backback
CM_PROGRAM_CURRENT_PROPOSAL data element index . Curriculum Management Tables and Data Elements . Data Warehouse Home

CM_PROGRAM_CURRENT_PROPOSAL Table

dwcat_cm.cm_program_current_proposal

Explanation

Contains detail information about proposals for changes to academic program components (Majors, Major Concentrations, and Minors), for proposals that are currently in the CIM workflow.

Common Uses

  • Find the status and next queue for current Program proposals
  • Find proposals queued up for review in a specific Committee Term.
Primary Key Indexed Data Elements Related Tables
PROGRAM_CURRENT_PROP_ID PROGRAM_CURRENT_PROP_ID CM_PROGRAM_HISTORY
CM_PROPOSAL
 
 

Cautions

  • Contains only one row per proposal: the most recently introduced proposal for the program.
  • The most recently approved record is also found in the CM_PROGRAM_HISTORY table, with the MOST_RECENTLY_APPROVED_YN flag set to 'Y'. In other words, when a proposal is complete, a record is written to history and until and unless a new proposal for the same foundational approach/course is introduced, that 'complete' record can be found in both CM_PROGRAM_CURRENT_PROPOSAL and CM_PROGRAM_HISTORY.


Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania