Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD	Academic Period	Academic period or time frame associated with this course record.	VARCHAR2(63)		SFRSTCA	SFRSTCA_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic Period description	Academic period description.	VARCHAR2(255)		STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic Year.	Academic year associated with the academic period on this record.	VARCHAR2(63)		STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic Year Description	Academic year description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
BLOCK_REGISTRATION	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	Block Registration Description	Description for the block registration code.	VARCHAR2(255)		STVBLCK	STVBLCK_DESC
BLOCK_REG_SEQUENCE_NUMBER	Block Registration Sequence Number	Sequence number that uniquely identifies the rule for block assignment.	NUMBER		SFRSTCA	SFRSTCA_BRDH_SEQ_NUM
COLLEGE	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 description	College, faculty or school name.	VARCHAR2(255)		STVCOLL	STVCOLL_DESC
COURSE_BILLING_CREDITS	Course Billing Credits	Billing units associated with this section or schedule offering.	NUMBER		SFRSTCA	SFRSTCA_BILL_HR
COURSE_CAMPUS	Course Campus	Campus the student attended this schedule offering or section.	VARCHAR2(63)		SFRSTCA	SFRSTCA_CAMP_CODE
COURSE_CAMPUS_DESC	Course Campus description	Institution campus description.	VARCHAR2(255)		STVCAMP	STVCAMP_DESC
COURSE_CREDITS	Course Credits	Credits associated with this course.	NUMBER		SFRSTCA	SFRSTCA_CREDIT_HR
COURSE_IDENTIFICATION	Course Identification	Course subject and course number combined.	VARCHAR2(255)		CALCULATION	SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB
COURSE_LEVEL	Course Level Code	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	Course level description.	VARCHAR2(255)		STVLEVL	STVLEVL_DESC
COURSE_NUMBER	Course Number	Course number associated with the subject for the course.	VARCHAR2(63)		SSBSECT	SSBSECT_CRSE_NUMB
COURSE_REFERENCE_NUMBER	Course Reference Number	Computer assigned internal unique number for the schedule offering.	VARCHAR2(63)		SFRSTCA	SFRSTCA_CRN
COURSE_SECTION_NUMBER	Course Section	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	Course version number.	VARCHAR2(255)		NA	NA
DEPARTMENT	Department Code	Department responsible for the instructional delivery of this offering.	VARCHAR2(63)		SCBCRSE SSBOVRR	SCBCRSE_DEPT_CODE SSBOVRR_DEPT_CODE
DEPARTMENT_DESC	Department description	Department name.	VARCHAR2(255)		STVDEPT	STVDEPT_DESC
DIVISION	Division	Division responsible for the instructional delivery of this course or section.	VARCHAR2(63)		SCBCRSE SSBOVRR	SCBCRSE_DIVS_CODE SSBOVRR_DIVS_CODE
DIVISION_DESC	Division description	Name of the division.	VARCHAR2(255)		STVDIVS	STVDIVS_DESC
GRADE_COMMENT	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 description	Grade comment descriptive text.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
GRADE_TYPE	Grade Type	Grade mode associated with this section or offering of the course.	VARCHAR2(63)		SFRSTCA	SFRSTCA_GMOD_CODE
GRADE_TYPE_DESC	Grade Type description	Grading mode (e.g., pass/fail, audit, normal grading mode) associated with the grading mode code.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
ID	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	Last Change Date	Date this record was last added or changed.	DATE		SFRSTCA	SFRSTCA_ACTIVITY_DATE
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)		NA	NA
MULTI_SOURCE_DESC	Multi Source description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)		NA	NA
NAME	Name	Combination of the person's last, first, and middle initial into one value.	VARCHAR2(255)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_UID	Person_Uid	System generated, unique, internal identification number assigned to this person.	NUMBER		SFRSTCA	SFRSTCA_PIDM
PROCESS_GROUP	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	Registration Error Flag	Indicates an error is associated with this section registration.	VARCHAR2(1)		SFRSTCA	SFRSTCA_ERROR_FLAG
REGISTRATION_ERROR_MESSAGE	Registration Error Message	Text of the message associated with an error for this section registration.	VARCHAR2(255)		SFRSTCA	SFRSTCA_MESSAGE
REGISTRATION_SOURCE	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	Registration Status	Course registration status associated with this section.	VARCHAR2(63)		SFRSTCA	SFRSTCA_RSTS_CODE
REGISTRATION_STATUS_DATE	Registration Status Date	Date associated with the course registration status of this section.	DATE		SFRSTCA	SFRSTCA_RSTS_DATE
REGISTRATION_STATUS_DESC	Registration Status description	Course registration status description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
REGISTRATION_USER_ID	Registration User ID	Person user identification number who processed the registration request for this section.	VARCHAR2(63)		SFRSTCA	SFRSTCA_USER
SECTION_ADD_DATE	Section Add Date	Date the student registered in this section.	DATE		SFRSTCA	SFRSTCA_ADD_DATE
SEQUENCE_NUMBER	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	Subject	Main instructional subject area for this course.	VARCHAR2(63)		SSBSECT	SSBSECT_SUBJ_CODE
SUBJECT_DESC	Subject description	Subject code description.	VARCHAR2(255)		STVSUBJ	STVSUBJ_DESC
SUB_ACADEMIC_PERIOD	Sub Academic Period	A session, portion or part of the academic period.	VARCHAR2(63)		NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub Academic Period description	Sub academic period description.	VARCHAR2(255)		NA	NA

Ver: 9.0