Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
CONTINUING_EDUCATION_IND	Indicates whether the course earns continuing education units instead of credits.	NUMBER	COURSE_CATALOG	CONTINUING_EDUCATION_IND	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
CONTINUING_EDUCATION_IND_LD	Long description for the continuing education indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE ATTRIBUTE
CONTINUING_EDUCATION_IND_SD	Short description for the continuing education indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE ATTRIBUTE
COOPERATIVE_EDUCATION_IND	Indicates this is a cooperative education course.	NUMBER	COURSE_CATALOG	COOPERATIVE_EDUCATION_IND	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
COOPERATIVE_EDUCATION_IND_LD	Long description cooperative education indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE ATTRIBUTE
COOPERATIVE_EDUCATION_IND_SD	Short description cooperative education indicator.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE ATTRIBUTE
COURSE_CAMPUS	Campus scheduling the offering.	VARCHAR2(63)	STUDENT_COURSE	CAMPUS	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
COURSE_CAMPUS_LD	Long description of the campus.	VARCHAR2(255)	STUDENT_COURSE	CAMPUS_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
COURSE_CAMPUS_SD	Short description of the campus.	VARCHAR2(255)	STUDENT_COURSE	CAMPUS_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
COURSE_COLLEGE	College, School or Faculty responsible for the instruction in the offering.	VARCHAR2(63)	STUDENT_COURSE	COLLEGE	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
COURSE_COLLEGE_LD	Long name of the first layer of the institution's organization.	VARCHAR2(255)	STUDENT_COURSE	COLLEGE_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
COURSE_COLLEGE_SD	Short name of the first layer of the institution's organization.	VARCHAR2(255)	STUDENT_COURSE	COLLEGE_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
COURSE_DEPARTMENT	Department responsible for the instruction in the offering.	VARCHAR2(63)	STUDENT_COURSE	DEPARTMENT	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
COURSE_DEPARTMENT_LD	Long name of the third layer of the institution's organization.	VARCHAR2(255)	STUDENT_COURSE	DEPARTMENT_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
COURSE_DEPARTMENT_SD	Short name of the third layer of the institution's organization.	VARCHAR2(255)	STUDENT_COURSE	DEPARTMENT_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
COURSE_DIVISION	Optional Division of the institution responsible for the instruction in the offering.	VARCHAR2(63)	STUDENT_COURSE	DIVISION	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
COURSE_DIVISION_LD	Long name of the second layer of the institution's organization.	VARCHAR2(255)	STUDENT_COURSE	DIVISION_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
COURSE_DIVISION_SD	Short name of the second layer of the institution's organization.	VARCHAR2(255)	STUDENT_COURSE	DIVISION_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
COURSE_IDENTIFICATION	Course subject and course number combined.	VARCHAR2(255)	STUDENT_COURSE	COURSE_IDENTIFICATION	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
COURSE_KEY	Key for the course dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
COURSE_LEVEL	Level of study for the student's program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc.	VARCHAR2(63)	STUDENT_COURSE	COURSE_LEVEL	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
COURSE_LEVEL_LD	Long description for level of study.	VARCHAR2(255)	STUDENT_COURSE	COURSE_LEVEL_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
COURSE_LEVEL_SD	Short description for level of study.	VARCHAR2(255)	STUDENT_COURSE	COURSE_LEVEL_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
COURSE_NUMBER	Course number assigned to the course to identify the course content. This might be logical groupings like 100s or 1000s to identify first year courses, etc.	VARCHAR2(63)	STUDENT_COURSE	COURSE_NUMBER	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
COURSE_TITLE_LONG	Long Course Title.	VARCHAR2(255)	STUDENT_COURSE	COURSE_TITLE_LONG	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
COURSE_TITLE_SHORT	Short Course Title.	VARCHAR2(255)	STUDENT_COURSE	COURSE_TITLE_SHORT	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
PROGRAM_CLASSIFICATION	Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.	VARCHAR2(63)	COURSE_CATALOG	PROGRAM_CLASSIFICATION	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
PROGRAM_CLASSIFICATION_LD	Long text describing the area of study. For example description associated with the CIP codes used in Integrated Postsecondary Education Data System (IPEDS) reporting in the US.	VARCHAR2(255)	COURSE_CATALOG	PROGRAM_CLASSIFICATION_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
PROGRAM_CLASSIFICATION_SD	Short text describing the area of study. For example description associated with the CIP codes used in Integrated Postsecondary Education Data System (IPEDS) reporting in the US.	VARCHAR2(255)	COURSE_CATALOG	PROGRAM_CLASSIFICATION_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
SCHEDULE	Teaching method for the instruction in this scheduled offering. Examples may include lecture, lab, internet, etc.	VARCHAR2(63)	STUDENT_COURSE	SCHEDULE_TYPE	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
SCHEDULE_LD	Long description of the schedule or instruction type.	VARCHAR2(255)	STUDENT_COURSE	SCHEDULE_TYPE_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
SCHEDULE_SD	Short description of the schedule or instruction type.	VARCHAR2(255)	STUDENT_COURSE	SCHEDULE_TYPE_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
SESSION_TYPE	Meeting time/instructional session associated with this section.	VARCHAR2(63)	SCHEDULE_OFFERING	STUDENT_MEETING_TIME	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
SESSION_TYPE_LD	Long description of session.	VARCHAR2(255)	SCHEDULE_OFFERING	STUDENT_MEETING_TIME_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
SESSION_TYPE_SD	Short description of session.	VARCHAR2(255)	SCHEDULE_OFFERING	STUDENT_MEETING_TIME_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
SUBJECT	Subject code and area of study for the course.	VARCHAR2(63)	STUDENT_COURSE	SUBJECT	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
SUBJECT_LD	Long description of the subject area.	VARCHAR2(255)	STUDENT_COURSE	SUBJECT_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
SUBJECT_SD	Short description of the subject area.	VARCHAR2(255)	STUDENT_COURSE	SUBJECT_DESC	NO	NO	ACADEMIC PROGRAM COURSE, COURSE REGISTRATION, COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL_GENERATED	NA	NO	NO	COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL_GENERATED	NA	NO	NO	COURSE SECTION, MEETING TIME, STUDENT COURSE, STUDENT COURSE ATTRIBUTE

Ver: 9.0