| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
COURSE_SECTION
|
Course section number used with the academic period, subject and course number to uniquely identify a schedule offering. An offering number can only be used once to identify a subject/course number combination in an academic period; however, multiple offerings of a course can share a zero course section number.
|
VARCHAR2(63)
|
SCHEDULE_OFFERING
|
OFFERING_NUMBER
|
NO
|
NO
|
COURSE SECTION, STUDENT COURSE
|
|
COURSE_SECTION_KEY
|
Key for the course section dimension.
|
NUMBER
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
COURSE SECTION, STUDENT COURSE
|
|
COURSE_SECTION_LD
|
Long description for the course section .
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
STUDENT COURSE
|
|
COURSE_SECTION_SD
|
Short description for the course section .
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
STUDENT COURSE
|
|
GRADABLE_IND
|
Indicates whether the course section can be graded.
|
NUMBER
|
SCHEDULE_OFFERING
|
GRADABLE_IND
|
NO
|
NO
|
COURSE SECTION, STUDENT COURSE
|
|
GRADABLE_IND_LD
|
Long description for the gradable indicator.
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
STUDENT COURSE
|
|
GRADABLE_IND_SD
|
Short description for the gradable indicator .
|
VARCHAR2(255)
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
STUDENT COURSE
|
|
INSTRUCTION_DELIVERY_MODE
|
Instructional method code used to relate schedule type and instructional method.
|
VARCHAR2(63)
|
COURSE_SCHEDULE
|
INSTRUCTIONAL_METHOD
|
NO
|
NO
|
COURSE SECTION, STUDENT COURSE
|
|
INSTRUCTION_DELIVERY_MODE_LD
|
Long description for the instructional delivery mode .
|
VARCHAR2(255)
|
COURSE_SCHEDULE
|
INSTRUCTIONAL_METHOD_DESC
|
NO
|
NO
|
COURSE SECTION, STUDENT COURSE
|
|
INSTRUCTION_DELIVERY_MODE_SD
|
Short description for the instructional delivery mode.
|
VARCHAR2(255)
|
COURSE_SCHEDULE
|
INSTRUCTIONAL_METHOD_DESC
|
NO
|
NO
|
COURSE SECTION, STUDENT COURSE
|
|
SECTION_CROSS_LIST
|
Identifies a course section as cross listed or meeting the same days and times with the same instructor as another course section in the academic period.
|
VARCHAR2(63)
|
SCHEDULE_OFFERING
|
SECTION_CROSS_LIST
|
NO
|
NO
|
COURSE SECTION, STUDENT COURSE
|
|
SECTION_CROSS_LIST_LD
|
Long description for the section cross list code .
|
VARCHAR2(255)
|
SCHEDULE_OFFERING
|
SECTION_CROSS_LIST_DESC
|
NO
|
NO
|
COURSE SECTION, STUDENT COURSE
|
|
SECTION_CROSS_LIST_SD
|
Short description for the section cross list code .
|
VARCHAR2(255)
|
SCHEDULE_OFFERING
|
SECTION_CROSS_LIST_DESC
|
NO
|
NO
|
COURSE SECTION, STUDENT COURSE
|
|
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, STUDENT COURSE
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL_GENERATED
|
NA
|
NO
|
NO
|
COURSE SECTION, STUDENT COURSE
|