Penn Computing

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

CM_SECTOR_CURRENT_PROPOSAL Table

Explanation

Contains detail information about proposals for changes to Sectors that are assigned to courses, for proposals that are currently in the CIM workflow.

Common Uses

  • Find the status and next queue for current Sector proposals
  • Find proposals queued up for review in a specific Committee Term.
Primary Key Indexed Data Elements Related Tables
SECTOR_CURRENT_PROP_ID SECTOR_CURRENT_PROP_ID CM_SECTOR_HISTORY
CM_PROPOSAL
CM_SECTOR_CURRENT_QUESTION
 
 

Cautions

  • Contains only one row per proposal: the most recently introduced proposal for the sector/course.
  • The most recently approved record is also found in the CM_SECTOR_HISTORY table, with the MOST_RECENTLY_APPROVED_YN flag set to 'Y'. In other words, when a proposal is complete, until and unless a new proposal for the same foundational approach/course is introduced, that 'complete' record can be found in both CM_SECTOR_CURRENT_PROPOSAL and CM_SECTOR_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