Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic period or time frame associated with this course record.	VARCHAR2(63)	SFRSTCA	SFRSTCA_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
COLLEGE	College, faculty or school to which the course instructional responsibility is associated.	VARCHAR2(63)	SCBCRSE SSBOVRR	SCBCRSE_COLL_CODE SSBOVRR_COLL_CODE
COLLEGE_DESC	College, faculty or school name.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC
COURSE_BILLING_CREDITS	Billing units associated with this section or schedule offering.	NUMBER	SFRSTCA	SFRSTCA_BILL_HR
COURSE_CAMPUS	Campus the student attended this schedule offering or section.	VARCHAR2(63)	SFRSTCA	SFRSTCA_CAMP_CODE
COURSE_CAMPUS_DESC	Institution campus description.	VARCHAR2(255)	STVCAMP	STVCAMP_DESC
COURSE_CREDITS	Credits associated with this course.	NUMBER	SFRSTCA	SFRSTCA_CREDIT_HR
COURSE_IDENTIFICATION	Combined subject code and course number that identifies the instructional content of this course.	VARCHAR2(255)	SSBSECT	SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB
COURSE_LEVEL	Level of academic study satisfied by this course. For example, undergraduate, graduate, credit, etc.	VARCHAR2(63)	SFRSTCA	SFRSTCA_LEVL_CODE
COURSE_LEVEL_DESC	Course level description.	VARCHAR2(255)	STVLEVL	STVLEVL_DESC
COURSE_NUMBER	Course number associated with the subject for the course.	VARCHAR2(63)	SSBSECT	SSBSECT_CRSE_NUMB
COURSE_REFERENCE_NUMBER	Computer assigned internal unique number for the schedule offering.	VARCHAR2(63)	SFRSTCA	SFRSTCA_CRN
COURSE_SECTION_NUMBER	Sequence number used to associated the information about the unique course for the student.	VARCHAR2(63)	SSBSECT	SSBSECT_SEQ_NUMB
COURSE_VERSION_NUMBER	Course version number.	VARCHAR2(255)	NA	NA
DEPARTMENT	Department responsible for the instructional delivery of this offering.	VARCHAR2(63)	SCBCRSE SSBOVRR	SCBCRSE_DEPT_CODE SSBOVRR_DEPT_CODE
DEPARTMENT_DESC	Department name.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC
DIVISION	Division responsible for the instructional delivery of this course or section.	VARCHAR2(63)	SCBCRSE SSBOVRR	SCBCRSE_DIVS_CODE SSBOVRR_DIVS_CODE
DIVISION_DESC	Name of the division.	VARCHAR2(255)	STVDIVS	STVDIVS_DESC
GRADE_COMMENT	Value for the grade comment or result code added for this course.	VARCHAR2(63)	SFRSTCA	SFRSTCA_GCMT_CODE
GRADE_COMMENT_DESC	Grade comment descriptive text.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
GRADE_TYPE	Grade mode associated with this section or offering of the course.	VARCHAR2(63)	SFRSTCA	SFRSTCA_GMOD_CODE
GRADE_TYPE_DESC	Grading mode (e.g., pass/fail, audit, normal grading mode) associated with the grading mode code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ID	Person's identification number used to access the records associated with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
LAST_DATE_CHANGE	Date this record was last added or changed.	DATE	SFRSTCA	SFRSTCA_ACTIVITY_DATE
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Combination of the person's last, first, and middle initial into one value.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SFRSTCA	SFRSTCA_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
REGISTRATION_ERROR_FLAG	Indicates an error is associated with this section registration.	VARCHAR2(1)	SFRSTCA	SFRSTCA_ERROR_FLAG
REGISTRATION_ERROR_MESSAGE	Text of the message associated with an error for this section registration.	VARCHAR2(255)	SFRSTCA	SFRSTCA_MESSAGE
REGISTRATION_SOURCE	Identifies the source of the audit record as either temporary or base from the registration input form.	VARCHAR2(63)	SFRSTCA	SFRSTCA_SOURCE_CDE
REGISTRATION_STATUS	Course registration status associated with this section.	VARCHAR2(63)	SFRSTCA	SFRSTCA_RSTS_CODE
REGISTRATION_STATUS_DATE	Date associated with the course registration status of this section.	DATE	SFRSTCA	SFRSTCA_RSTS_DATE
REGISTRATION_STATUS_DESC	Course registration status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
REGISTRATION_USER_ID	Person user identification number who processed the registration request for this section.	VARCHAR2(63)	SFRSTCA	SFRSTCA_USER
SECTION_ADD_DATE	Date the student registered in this section.	DATE	SFRSTCA	SFRSTCA_ADD_DATE
SEQUENCE_NUMBER	Sequence number for the records for the course reference number for this student in this academic period.	NUMBER	SFRSTCA	SFRSTCA_SEQ_NUMBER
SUBJECT	Main instructional subject area for this course.	VARCHAR2(63)	SSBSECT	SSBSECT_SUBJ_CODE
SUBJECT_DESC	Subject code description.	VARCHAR2(255)	STVSUBJ	STVSUBJ_DESC
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.	VARCHAR2(255)	NA	NA

Ver: 8.1