| 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
|
Academic period description.
|
VARCHAR2(30)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
|
ACADEMIC_YEAR
|
Academic year associated with the academic period on this record.
|
VARCHAR2(4)
|
STVTERM
|
STVTERM_ACYR_CODE
|
NO
|
NO
|
|
ACADEMIC_YEAR_DESC
|
Academic year description.
|
VARCHAR2(30)
|
STVACYR
|
STVACYR_DESC
|
NO
|
NO
|
|
COURSE_BILLING_CREDITS
|
Billing units associated with this section or schedule offering.
|
NUMBER
|
|
|
|
NO
|
|
COURSE_CAMPUS
|
Campus the student attended this schedule offering or section.
|
VARCHAR2(3)
|
|
|
|
NO
|
|
COURSE_CAMPUS_DESC
|
Institution campus description.
|
VARCHAR2(30)
|
STVCAMP
|
STVCAMP_DESC
|
NO
|
NO
|
|
COURSE_CREDITS
|
Credits associated with this course.
|
NUMBER
|
|
|
|
NO
|
|
COURSE_IDENTIFICATION
|
Course subject and course number combined.
|
VARCHAR2(9)
|
NA
|
NA
|
NO
|
NO
|
|
COURSE_LEVEL
|
Level of academic study satisfied by this course. For example, undergraduate, graduate, credit, etc.
|
VARCHAR2(2)
|
|
|
|
NO
|
|
COURSE_LEVEL_DESC
|
Course level description.
|
VARCHAR2(30)
|
STVLEVL
|
STVLEVL_DESC
|
NO
|
NO
|
|
COURSE_NUMBER
|
Course number associated with the subject for the course.
|
VARCHAR2(5)
|
NA
|
NA
|
NO
|
NO
|
|
COURSE_REFERENCE_NUMBER
|
Computer assigned internal unique number for the schedule offering.
|
VARCHAR2(5)
|
|
|
|
NO
|
|
COURSE_SECTION_NUMBER
|
Sequence number used to associated the information about the unique course for the student.
|
VARCHAR2(3)
|
NA
|
NA
|
NO
|
NO
|
|
COURSE_VERSION_NUMBER
|
This field identifies the course version number.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
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
|
|
GRADE_COMMENT
|
Value for the grade comment or result code added for this course.
|
VARCHAR2(7)
|
|
|
|
NO
|
|
GRADE_COMMENT_DESC
|
Grade comment descriptive text.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
|
GRADE_TYPE
|
Grade mode associated with this section or offering of the course.
|
VARCHAR2(1)
|
|
|
|
NO
|
|
GRADE_TYPE_DESC
|
Grading mode (e.g., pass/fail, audit, normal grading mode) associated with the grading mode code.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
|
LAST_DATE_CHANGE
|
Date this record was last added or changed.
|
DATE
|
|
|
|
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
|
|
|
|
NO
|
|
REGISTRATION_ERROR_FLAG
|
Indicates an error is associated with this section registration.
|
VARCHAR2(1)
|
|
|
|
NO
|
|
REGISTRATION_ERROR_MESSAGE
|
Text of the message associated with an error for this section registration.
|
VARCHAR2(200)
|
|
|
|
NO
|
|
REGISTRATION_SOURCE
|
This field shows the source of the audit record.
|
VARCHAR2(4)
|
|
|
|
NO
|
|
REGISTRATION_STATUS
|
Course registration status associated with this section.
|
VARCHAR2(2)
|
|
|
|
NO
|
|
REGISTRATION_STATUS_DATE
|
Date associated with the course registration status of this section.
|
DATE
|
|
|
|
NO
|
|
REGISTRATION_STATUS_DESC
|
Course registration status description.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
|
REGISTRATION_USER_ID
|
Person user identification number who processed the registration request for this section.
|
VARCHAR2(30)
|
|
|
|
NO
|
|
SECTION_ADD_DATE
|
Date the student registered in this section.
|
DATE
|
|
|
|
NO
|
|
SEQUENCE_NUMBER
|
Sequence number for the records for the course reference number for this student in this academic period.
|
NUMBER
|
|
|
|
NO
|
|
SUBJECT
|
Main instructional subject area for this course.
|
VARCHAR2(4)
|
NA
|
NA
|
NO
|
NO
|
|
SUBJECT_DESC
|
Subject code description.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
|
SUB_ACADEMIC_PERIOD
|
A session, portion or part of the academic period.
|
VARCHAR2(3)
|
NA
|
NA
|
NO
|
NO
|
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub academic period description.
|
VARCHAR2(30)
|
NA
|
NA
|
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
|