CM_TERM_OFFERED Table - Data Element Index . Curriculum Management Tables and Data Elements . Data Warehouse Home

Last_Refresh_Date Retired Term_Offered_Code Term_Offered_Desc

Data element	Definition
Last_Refresh_Date Indexed - no Format - Date May be Null? Y	The lastest date the record was refreshed in the Data Warehouse.
Retired Indexed - no Format - Varchar2(800) May be Null? Y	Flag indicating the code is not longer used/not active. Retired codes will have a 'Y' in this column.
Term_Offered_Code Indexed - yes Format - Varchar2(800) May be Null? N	Code for the term the course is generally offered. Note: this is not a "term code" but an internal code used to provide an attibute of the course. Used with the Term_Offered_Desc, to describe when the course is typically offered. Example: A -- course usually offered in the Fall term.
Term_Offered_Desc Indexed - no Format - Varchar2(800) May be Null? Y	Descriptive text explaining the code found in Term_Offered_Code.

CM_TERM_OFFERED Table - Data Element Index . Curriculum Management Tables and Data Elements . Data Warehouse Home