| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
|
ACADEMIC_PERIOD
|
Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.
|
VARCHAR2(6)
|
|
|
|
NO
|
|
ACADEMIC_PERIOD_DESC
|
This field specifies the description of the academic period or term associated with the academic period code.
|
VARCHAR2(30)
|
|
|
|
NO
|
|
COURSE_REFERENCE_NUMBER
|
Computer assigned internal unique number for the schedule offering.
|
VARCHAR2(5)
|
|
|
|
NO
|
|
CURRENT_DATE
|
This is a the system current date (sysdate).
|
DATE
|
|
|
|
NO
|
|
DOMAIN_VALUE
|
Domain column for future use, not currently populated.
|
VARCHAR2(6)
|
|
|
|
NO
|
|
MIF_DESC
|
The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(30)
|
|
|
|
NO
|
|
MIF_VALUE
|
The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(6)
|
|
|
|
NO
|
|
SCHEDULE_ATTRIBUTE
|
This field defines the attribute code of the section.
|
VARCHAR2(4)
|
|
|
|
NO
|
|
SCHEDULE_ATTRIBUTE_DESC
|
This field defines the attribute code description of the section.
|
VARCHAR2(30)
|
|
|
|
NO
|
|
ZONE_VALUE
|
Zone column for future use, not currently populated.
|
VARCHAR2(6)
|
|
|
|
NO
|