Penn Computing

University of Pennsylvania
Penn Computing << go backback
CM_PROGRAM_HISTORY Table - Data Element Index . Curriculum Management Tables and Data Elements . Data Warehouse Home

CM_PROGRAM_HISTORY Table

dwcat_cm.cm_proposal_history

Explanation

Contains detail information about proposals for changes to academic program elements (Majors, Major Concentrations, Minors), for proposals that are "at rest", that is, no longer actively working their way through the CIM workflow.

Common Uses

  • Track the changes to details about a Program proposal over multiple versions.
  • Find proposals that were planned to be reviewed in a specific Committee Term.
Primary Key Indexed Data Elements Related Tables
PROGRAM_HISTORY_ID PROGRAM_HISTORY_ID CM_PROGRAM_CURRENT_PROPOSAL
CM_PROPOSAL_HISTORY
 
 

Cautions

  • Can contain multiple rows per proposal: the most recently approved proposal for the Program will have the MOST_RECENTLY_APPROVED_YN flag set to 'Y'.
  • The most recently approved row can be a duplicate of an archived row.


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