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
BLOCK_REGISTRATION	Identifies the block registration code that was assigned to the student that had the student register for this student course.	VARCHAR2(63)	SFRSTCA	SFRSTCA_BLCK_CODE
BLOCK_REGISTRATION_DESC	Description for the block registration code.	VARCHAR2(255)	STVBLCK	STVBLCK_DESC
BLOCK_REG_SEQUENCE_NUMBER	Sequence number that uniquely identifies the rule for block assignment.	NUMBER	SFRSTCA	SFRSTCA_BRDH_SEQ_NUM
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	Course subject and course number combined.	VARCHAR2(255)	CALCULATION	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.5