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)
|
SHRTRCR
|
SHRTRCR_TERM_CODE
|
NO
|
NO
|
ACADEMIC_PERIOD_DESC
|
Description of the academic period.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
ACADEMIC_YEAR
|
Academic year associated with the academic period.
|
VARCHAR2(30)
|
STVTERM
|
STVTERM_ACYR_CODE
|
NO
|
NO
|
ACADEMIC_YEAR_DESC
|
Description for this academic year.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
COURSE_ATTRIBUTE
|
Identifies the type of degree course attribute will be satisfied by successful completion of this course.
|
VARCHAR2(4)
|
SHRTATT
|
SHRTATT_ATTR_CODE
|
NO
|
NO
|
COURSE_ATTRIBUTE_DESC
|
Description for the degree course attribute.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
COURSE_IDENTIFICATION
|
Course subject and course number combined.
|
VARCHAR2(9)
|
|
|
|
NO
|
COURSE_NUMBER
|
Course number associated with the subject for the course.
|
VARCHAR2(5)
|
SHRTRCE
|
SHRTRCE_CRSE_NUMB
|
NO
|
NO
|
COURSE_REFERENCE_NUMBER
|
Computer assigned internal unique number for the schedule offering.
|
VARCHAR2(51)
|
CALCULATION
|
SHRTATT_TRIT_SEQ_NO||TO_CHAR(SHRTATT_TRAM_SEQ_NO,'FM09')||TO_CHAR(NVL(SHRTATT_TRCR_SEQ_NO,0),'FM009')||TO_CHAR(SHRTATT_TRCE_SEQ_NO,'FM009')
|
NO
|
NO
|
COURSE_SEQUENCE_NUMBER
|
Sequence number used to associated the information about the unique course for the student.
|
NUMBER
|
SHRTATT SHRTATT
|
SHRTATT_TRCE_SEQ_NO SHRTATT_TRIT_SEQ_NO||SHRTATT_TRAM_SEQ_NO||SHRTATT_TRCR_SEQ_NO||SHRTATT_TRCE_SEQ_NO
|
NO NO
|
NO
|
CURRENT_DATE
|
CURRENT_DATE: The current date.
|
DATE
|
NA
|
SYSDATE
|
NO
|
NO
|
DOMAIN_VALUE
|
The institution value of the organization-oriented identifier for the record used to determine access authorization to this record.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
INSTITUTION_COURSE_IND
|
This field stores a Y or N to indicate if the course was taken at the institution or not.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(SHRTATT_PIDM, NULL, 'Y', 'N')
|
NO
|
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)
|
NA
|
NA
|
NO
|
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)
|
NA
|
NA
|
NO
|
NO
|
PERSON_UID
|
System generated unique internal identification number assigned to this person.
|
NUMBER
|
SHRTATT
|
SHRTATT_PIDM
|
NO
|
NO
|
SUBJECT
|
Identifies the main instructional subject area for this course.
|
VARCHAR2(4)
|
SHRTRCE
|
SHRTRCE_SUBJ_CODE
|
NO
|
NO
|
SUBJECT_DESC
|
Description for the subject code.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD
|
Identifies a session, portion or part of the academic period.
|
VARCHAR2(3)
|
NA
|
NA
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD_DESC
|
Description of the sub academic period.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
TRANSFER_COURSE_IND
|
This field stores a Y or N to indicate if the course is a transfer course or not.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(SHRTATT_PIDM, NULL, 'N', 'Y')
|
NO
|
NO
|
ZONE_VALUE
|
The institution value of the process-oriented identifier for the record used to determine access authorization to this record.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|