RETURN TO BANNER EDW META DATA REPORTS LIST
Meeting Time Star  

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_MEETING_TIME

Description Meeting Time Fact table provides measures that identify the meeting, meeting time, meeting location for a student course.

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 MEETING TIME
COURSE_KEY Key for the course dimension. NUMBER

ETL_GENERATED

NA

NO

NO MEETING TIME
COURSE_REFERENCE_NUMBER_KEY Key for the course reference number dimension. NUMBER

ETL_GENERATED

NA

NO

NO MEETING TIME
END_DATE Date the course offering instruction ends for this section. DATE

MEETING_TIME

END_DATE

NO

NO MEETING TIME
MEETING_KEY Key for the meeting dimension. NUMBER

ETL_GENERATED

NA

NO

NO MEETING TIME
MEETING_LOCATION_KEY Key for the meeting location dimension. NUMBER

ETL_GENERATED

NA

NO

NO MEETING TIME
MEETING_TIME_COUNT_KEY Key for the meeting time count attribute. NUMBER

ETL_GENERATED

NA

NO

NO MEETING TIME
MEETING_TIME_GROUP_KEY Key for the meeting time group attribute. NUMBER

ETL_GENERATED

NA

NO

NO MEETING TIME
MEETING_TIME_KEY Key for the meeting time dimension. NUMBER

ETL_GENERATED

NA

NO

NO MEETING TIME
MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER

ETL_GENERATED

NA

NO

NO MEETING TIME
START_DATE Date the course offering instruction began for this section. DATE

MEETING_TIME

START_DATE

NO

NO MEETING TIME
SUB_ACADEMIC_PERIOD_KEY Key for the sub academic period dimension. NUMBER

ETL_GENERATED

NA

NO

NO MEETING TIME
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL_GENERATED

NA

NO

NO MEETING TIME
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

ETL_GENERATED

NA

NO

NO MEETING TIME


Ver: 9.0