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

Found_Approach_Code Found_Approach_Desc Last_Refresh_Date Retired

Data element	Definition
Found_Approach_Code Indexed - yes Format - Varchar2(800) May be Null? N	Code used in the source Curriculum Management system to identify Foundational Approaches that can be assigned to courses.
Found_Approach_Desc Indexed - no Format - Varchar2(800) May be Null? Y	Text description of the Found_Approach_Code.
Last_Refresh_Date Indexed - no Format - Date May be Null? Y	The date this record was last refreshed from the source.
Retired Indexed - no Format - Varchar2(800) May be Null? Y	Flag indicating whether or not the code is still actively being used. Retired codes will have a 'Y' in this column.

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