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
|