CM_SECTOR Table . Curriculum Management Tables and Data Elements . Data Warehouse Home

Last_Refresh_Date Retired Sector_Code Sector_Desc

Data element	Definition
Last_Refresh_Date Indexed - no Format - Date May be Null? Y	The latest date the record was refreshed in the Data Warehouse.
Retired Indexed - no Format - Varchar2(800) May be Null? Y	Flag indicating the sector code is no longer actively being assigned to courses. Sectors that are retired will have a 'Y' in this column.
Sector_Code Indexed - yes Format - Varchar2(800) May be Null? N	Code identifying each sector. A sector is an academic area that can be assigned to a course, indicating successful completion of the course can be used towards fulfillment of the requirements in that academic area.
Sector_Desc Indexed - no Format - Varchar2(800) May be Null? Y	Text description of the code in Sector_Code,

CM_SECTOR Table . Curriculum Management Tables and Data Elements . Data Warehouse Home