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(63)	SFRSTCA	SFRSTCA_TERM_CODE	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC	NO	NO
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE	NO	NO
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
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	NO	NO
BLOCK_REGISTRATION_DESC	Description for the block registration code.	VARCHAR2(255)	STVBLCK	STVBLCK_DESC	NO	NO
BLOCK_REG_SEQUENCE_NUMBER	Sequence number that uniquely identifies the rule for block assignment.	NUMBER	SFRSTCA	SFRSTCA_BRDH_SEQ_NUM	NO	NO
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	NO NO	NO
COLLEGE_DESC	College, faculty or school name.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC	NO	NO
COURSE_BILLING_CREDITS	Billing units associated with this section or schedule offering.	NUMBER	SFRSTCA	SFRSTCA_BILL_HR	NO	NO
COURSE_CAMPUS	Campus the student attended this schedule offering or section.	VARCHAR2(63)	SFRSTCA	SFRSTCA_CAMP_CODE	NO	NO
COURSE_CAMPUS_DESC	Institution campus description.	VARCHAR2(255)	STVCAMP	STVCAMP_DESC	NO	NO
COURSE_CREDITS	Credits associated with this course.	NUMBER	SFRSTCA	SFRSTCA_CREDIT_HR	NO	NO
COURSE_IDENTIFICATION	Course subject and course number combined.	VARCHAR2(255)	CALCULATION	SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB	NO	NO
COURSE_LEVEL	Level of academic study satisfied by this course. For example, undergraduate, graduate, credit, etc.	VARCHAR2(63)	SFRSTCA	SFRSTCA_LEVL_CODE	NO	NO
COURSE_LEVEL_DESC	Course level description.	VARCHAR2(255)	STVLEVL	STVLEVL_DESC	NO	NO
COURSE_NUMBER	Course number associated with the subject for the course.	VARCHAR2(63)	SSBSECT	SSBSECT_CRSE_NUMB	NO	NO
COURSE_REFERENCE_NUMBER	Computer assigned internal unique number for the schedule offering.	VARCHAR2(63)	SFRSTCA	SFRSTCA_CRN	NO	NO
COURSE_SECTION_NUMBER	Sequence number used to associated the information about the unique course for the student.	VARCHAR2(63)	SSBSECT	SSBSECT_SEQ_NUMB	NO	NO
COURSE_VERSION_NUMBER	Course version number.	VARCHAR2(255)	NA	NA	NO	NO
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	NO NO	NO
DEPARTMENT_DESC	Department name.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC	NO	NO
DIVISION	Division responsible for the instructional delivery of this course or section.	VARCHAR2(63)	SCBCRSE SSBOVRR	SCBCRSE_DIVS_CODE SSBOVRR_DIVS_CODE	NO NO	NO
DIVISION_DESC	Name of the division.	VARCHAR2(255)	STVDIVS	STVDIVS_DESC	NO	NO
GRADE_COMMENT	Value for the grade comment or result code added for this course.	VARCHAR2(63)	SFRSTCA	SFRSTCA_GCMT_CODE	NO	NO
GRADE_COMMENT_DESC	Grade comment descriptive text.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
GRADE_TYPE	Grade mode associated with this section or offering of the course.	VARCHAR2(63)	SFRSTCA	SFRSTCA_GMOD_CODE	NO	NO
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	NO	NO
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	NO	NO
LAST_DATE_CHANGE	Date this record was last added or changed.	DATE	SFRSTCA	SFRSTCA_ACTIVITY_DATE	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Combination of the person's last, first, and middle initial into one value.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SFRSTCA	SFRSTCA_PIDM	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
REGISTRATION_ERROR_FLAG	Indicates an error is associated with this section registration.	VARCHAR2(1)	SFRSTCA	SFRSTCA_ERROR_FLAG	NO	NO
REGISTRATION_ERROR_MESSAGE	Text of the message associated with an error for this section registration.	VARCHAR2(255)	SFRSTCA	SFRSTCA_MESSAGE	NO	NO
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	NO	NO
REGISTRATION_STATUS	Course registration status associated with this section.	VARCHAR2(63)	SFRSTCA	SFRSTCA_RSTS_CODE	NO	NO
REGISTRATION_STATUS_DATE	Date associated with the course registration status of this section.	DATE	SFRSTCA	SFRSTCA_RSTS_DATE	NO	NO
REGISTRATION_STATUS_DESC	Course registration status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
REGISTRATION_USER_ID	Person user identification number who processed the registration request for this section.	VARCHAR2(63)	SFRSTCA	SFRSTCA_USER	NO	NO
SECTION_ADD_DATE	Date the student registered in this section.	DATE	SFRSTCA	SFRSTCA_ADD_DATE	NO	NO
SEQUENCE_NUMBER	Sequence number for the records for the course reference number for this student in this academic period.	NUMBER	SFRSTCA	SFRSTCA_SEQ_NUMBER	NO	NO
SUBJECT	Main instructional subject area for this course.	VARCHAR2(63)	SSBSECT	SSBSECT_SUBJ_CODE	NO	NO
SUBJECT_DESC	Subject code description.	VARCHAR2(255)	STVSUBJ	STVSUBJ_DESC	NO	NO
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA	NO	NO
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.	VARCHAR2(255)	NA	NA	NO	NO

Ver: 9.2