Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
BUILDING	Building code for the room assignment.	VARCHAR2(63)	MEETING_TIME	BUILDING	NO	NO	MEETING TIME
BUILDING_LD	Long name for the building.	VARCHAR2(255)	MEETING_TIME	BUILDING_DESC	NO	NO	MEETING TIME
BUILDING_SD	Short name for the building.	VARCHAR2(255)	MEETING_TIME	BUILDING_DESC	NO	NO	MEETING TIME
BUILDING_SITE	Site associated with the building code for this room assignment.	VARCHAR2(63)	MEETING_TIME	BUILDING_SITE	NO	NO	MEETING TIME
BUILDING_SITE_LD	Long name for the building site.	VARCHAR2(255)	MEETING_TIME	BUILDING_SITE_DESC	NO	NO	MEETING TIME
BUILDING_SITE_SD	Short name for the building site.	VARCHAR2(255)	MEETING_TIME	BUILDING_SITE_DESC	NO	NO	MEETING TIME
MEETING_LOCATION_KEY	Key for the meeting location dimension.	NUMBER	ETL_GENERATED	MEETING_LOCATION_KEY	NO	NO	MEETING TIME
ROOM	Classroom meeting location where this course section is scheduled. It is not required when scheduling course section meeting times.	VARCHAR2(63)	MEETING_TIME	ROOM	NO	NO	MEETING TIME
ROOM_LD	Long Description for the room.	VARCHAR2(255)	EDW CLEANSING PROCESS	NA	NO	NO	MEETING TIME
ROOM_SD	Short Description for the room.	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

Ver: 9.0