Target Column	Business Definition	Database Data Type	Source Name	Source Column
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(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	Administrative-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	First level of the institution organization structure that owns the student or the academic instruction for a student course.	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 major subject area of a student course or associated with the major within the student academic study.	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	Identification number assigned to a person that is used externally for all communication and correspondence 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: 9.1