RETURN TO BANNER EDW META DATA REPORTS LIST
Meeting Time Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_MEETING_TIME

Description Meeting Time Dimension table provides the data that identifies the time and dates that the student course met. .

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
BEGIN_TIME Schedule offering meeting begin time. VARCHAR2(63)

MEETING_TIME

BEGIN_TIME

NO

NO MEETING TIME
BEGIN_TIME_RANGE Range of time that fits the schedule offering meeting begin time. VARCHAR2(63)

MEETING_TIME

BEGIN_TIME

NO

NO MEETING TIME
BEGIN_TIME_RANGE_LD Long description for the begin meeting time range. VARCHAR2(63)

EDW CLEANSING PROCESS

NA

NO

NO MEETING TIME
BEGIN_TIME_RANGE_SD Short description for the begin meeting time range. VARCHAR2(63)

EDW CLEANSING PROCESS

NA

NO

NO MEETING TIME
END_TIME Schedule offering meeting end time. VARCHAR2(63)

MEETING_TIME

END_TIME

NO

NO MEETING TIME
FRIDAY_IND Identifies the schedule offering meets on Friday. NUMBER

MEETING_TIME

FRIDAY_IND

NO

NO MEETING TIME
FRIDAY_IND_LD Long description that identifies a Friday meeting. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO MEETING TIME
FRIDAY_IND_SD Short description that identifies a Friday meeting. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO MEETING TIME
MEETING_TIME_CATEGORY Meeting time/instructional session associated with this section. VARCHAR2(63)

MEETING_TIME

CATEGORY

NO

NO MEETING TIME
MEETING_TIME_CATEGORY_LD Long description for the meeting time category. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO MEETING TIME
MEETING_TIME_CATEGORY_SD Short description for the meeting time category. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

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

ETL_GENERATED

NA

NO

NO MEETING TIME
MONDAY_IND Identifies the schedule offering meets on Monday. NUMBER

MEETING_TIME

MONDAY_IND

NO

NO MEETING TIME
MONDAY_IND_LD Long description that identifies a Monday meeting. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO MEETING TIME
MONDAY_IND_SD Short description that identifies a Monday meeting. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO MEETING TIME
SATURDAY_IND Identifies the schedule offering meets on Saturday. NUMBER

MEETING_TIME

SATURDAY_IND

NO

NO MEETING TIME
SATURDAY_IND_LD Long description that identifies a Saturday meeting. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO MEETING TIME
SATURDAY_IND_SD Short description that identifies a Saturday meeting. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO MEETING TIME
SUNDAY_IND Identifies the schedule offering meets on Sunday. NUMBER

MEETING_TIME

SUNDAY_IND

NO

NO MEETING TIME
SUNDAY_IND_LD Long description that identifies a Sunday meeting. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO MEETING TIME
SUNDAY_IND_SD Short description that identifies a Sunday meeting. VARCHAR2(255)

EDW CLEANSING PROCESS

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
THURSDAY_IND Identifies the schedule offering meets on Thursday. NUMBER

MEETING_TIME

THURSDAY_IND

NO

NO MEETING TIME
THURSDAY_IND_LD Long description that identifies a Thursday meeting. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO MEETING TIME
THURSDAY_IND_SD Short description that identifies a Thursday meeting. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO MEETING TIME
TUESDAY_IND Identifies the schedule offering meets on Tuesday. NUMBER

MEETING_TIME

TUESDAY_IND

NO

NO MEETING TIME
TUESDAY_IND_LD Long description that identifies a Tuesday meeting. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO MEETING TIME
TUESDAY_IND_SD Short description that identifies a Tuesday meeting. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO MEETING TIME
WEDNESDAY_IND Identifies the schedule offering meets on Wednesday. NUMBER

MEETING_TIME

WEDNESDAY_IND

NO

NO MEETING TIME
WEDNESDAY_IND_LD Long description that identifies a Wednesday meeting. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO MEETING TIME
WEDNESDAY_IND_SD Short description that identifies a Wednesday meeting. VARCHAR2(255)

EDW CLEANSING PROCESS

NA

NO

NO MEETING TIME


Ver: 9.0