Penn Computing

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

CM_SECTOR_HISTORY Table

Explanation

Contains detail information about proposals for changes to Sectors assigned to courses, 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 Sector/course proposal over multiple versions.
  • Find proposals that were planned to be reviewed in a specific Committee Term.
Primary Key Indexed Data Elements Related Tables
SECTOR_HISTORY_ID SECTOR_HISTORY_ID CM_SECTOR_CURRENT_PROPOSAL
CM_PROPOSAL_HISTORY
 
 

Cautions

  • Can contain multiple rows per proposal: the most recently approved proposal for the Sector/course 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