| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACADEMIC_PERIOD
|
Academic period or time frame this section or schedule offering was taught.
|
VARCHAR2(6)
|
SSRTEXT
|
SSRTEXT_TERM_CODE
|
|
COURSE_REFERENCE_NUMBER
|
Computer assigned internal unique number for the schedule offering.
|
VARCHAR2(5)
|
SSRTEXT
|
SSRTEXT_CRN
|
|
LOAD_DATE
|
Date information was last updated in ODS
|
DATE
|
NA
|
SYSDATE
|
|
OFFERING_NUMBER
|
Offering number of a course. An offering number can only be used once to identify a subject/course number combination in a term; however, multiple offerings of a course can share a zero offering number.
|
NUMBER(23, 20)
|
SSRTEXT
|
SSRTEXT_SEQNO
|
|
SECTION_CONTRACT_CODE
|
Section Contract Code
|
VARCHAR2(2)
|
SSRSCCD
|
SSRSCCD_SCCD_CODE
|
|
SECTION_CONTRACT_DESC
|
Section Contract Description
|
VARCHAR2(30)
|
STVSCCD
|
STVSCCD_DESC
|
|
SECTION_TEXT
|
Section Text
|
VARCHAR2(60)
|
SSRTEXT
|
SSRTEXT_TEXT
|