Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_TIME_KEY	Key for the academic time dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	COURSE SECTION
CENSUS_ENROLLMENT_DATE1	First date used for official enrollment reporting in a time frame. All student registration through this date is counted in the census one enrollment count.	DATE	SCHEDULE_OFFERING	CENSUS_ENROLLMENT_DATE1	NO	NO	COURSE SECTION
CENSUS_ENROLLMENT_DATE2	Second date used for official enrollment reporting in a time frame. All student registration through this date is counted in the census two enrollment count.	DATE	SCHEDULE_OFFERING	CENSUS_ENROLLMENT_DATE2	NO	NO	COURSE SECTION
COURSE_KEY	Key for the course dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	COURSE SECTION
COURSE_REFERENCE_NUMBER_KEY	Key for the course reference number dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	COURSE SECTION
COURSE_SECTION_KEY	Key for the course section dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	COURSE SECTION
END_DATE	Date the course offering instruction ends for this sub academic period.	DATE	SCHEDULE_OFFERING	END_DATE	NO	NO	COURSE SECTION
MEETING_DAYS	Group of meeting days for this course offering. For example, M,T,W,R.	VARCHAR2(255)	FUNCTION	BANNER GOKDATE.SQLL	NO	NO
MEETING_TIME_GROUP_KEY	Key for the meeting time group attribute.	NUMBER	ETL_GENERATED	NA	NO	NO	COURSE SECTION
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	COURSE SECTION
START_DATE	Date the course offering instruction began for this sub academic period.	DATE	SCHEDULE_OFFERING	START_DATE	NO	NO	COURSE SECTION
SUB_ACADEMIC_PERIOD_KEY	Key for the sub academic period dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	COURSE SECTION
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
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL_GENERATED	NA	NO	NO	COURSE SECTION

Ver: 9.0