Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACADEMIC_PERIOD	Identifies the academic period in which the student plans to register for the course or course section in the plan.	VARCHAR2(63)	SFRBSEL	SFRBSEL_TERM_CODE	NO	NO
ACADEMIC_PERIOD_DESC	Description for the academic period.	VARCHAR2(255)	STVTERM	STVTERM_DESC	NO	NO
ACADEMIC_YEAR	Identifies the academic period for which the course or course section is planned for registration.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE	NO	NO
ACADEMIC_YEAR_DESC	Description for the academic period.	VARCHAR2(255)	STVACYR	STVACYR_DESC	NO	NO
ADMINISTRATIVE_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
BLOCK_COURSE_RESTRICTION	Identifies what type of course registration restrictions apply to this course in this block registration group. Valid values include : NR - Add/Drop Courses with No Restriction; NB - Add/Drop only Non-Block Courses; NA - Add/Drop Courses Not Available.	VARCHAR2(63)	SFRBRDB	SFRBRDB_COURSE_RESTRICTION	NO	NO
BLOCK_COURSE_RESTRICTION_DESC	Description for the type of registration restriction defined for this course.	VARCHAR2(255)	CALCULATION	CASE WHEN SFRBRDB_COURSE_RESTRICTION	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)	SFRBSEL	SFRBSEL_BLCK_CODE	NO	NO
BLOCK_REGISTRATION_DESC	Description for the block registration code.	VARCHAR2(255)	STVBLCK	STVBLCK_DESC	NO	NO
BLOCK_REGISTRATION_OVERRIDE	Identifies the override rule code to use to change the block registration code.	VARCHAR2(63)	SFRBLPA	SFRBLPA_ROVR_CODE	NO	NO
BLOCK_REGISTRATION_USER_ID	User ID of the person who inserted or last updated this record.	VARCHAR2(63)	SFRBSEL	SFRBSEL_USER_ID	NO	NO
BLOCK_REGISTRATION_USER_NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_FORMAT_NAME	NO	NO
BLOCK_REGISTRATION_USER_UID	System generated internal ID for the person who created the plan. This may be the student or one of the student's advisors.	NUMBER	SPRIDEN	SPRIDEN_PIDM	NO	NO
BLOCK_REG_ACTIVITY_DATE	Date this record was inserted or last updated.	DATE	SFRBSEL	SFRBSEL_ACTIVITY_DATE	NO	NO
BLOCK_REG_COURSE_KEY	Sequence number that uniquely identifies the rule for block assignment.	NUMBER	SFRBKOP	SFRBKOP_SURROGATE_ID	NO	NO
BLOCK_REG_DATA_ORIGIN	Source system or process that created or last updated this record.	VARCHAR2(63)	SFRBSEL	SFRBSEL_DATA_ORIGIN	NO	NO
BLOCK_REG_OVERRIDE_DESC	Description for the block registration restriction override.	VARCHAR2(255)	STVROVR	STVROVR_DESC	NO	NO
BLOCK_REG_SEQUENCE_NUMBER	Sequence number that uniquely identifies the rule for block assignment.	NUMBER	SFRBSEL	SFRBSEL_BRDH_SEQ_NUM	NO	NO
BLOCK_REG_VERSION_NUMBER	Incremented number used for optimistic locking.	NUMBER	SFRBSEL	SFRBSEL_VERSION	NO	NO
COURSE_IDENTIFICATION	Course subject and course number combined.	VARCHAR2(255)	CALCULATION	SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB	NO	NO
COURSE_NUMBER	Course number associated with the subject for the course.	VARCHAR2(63)	SSBSECT	SSBSECT_CRSE_NUMB	NO	NO
COURSE_REFERENCE_NUMBER	Sequence number that uniquely identifies the course section in this block registration assignment.	VARCHAR2(63)	SSRBLCK	SSRBLCK_CRN	NO	NO
CRSE_REFERENCE_NUMBER_OPT_IND	Indicates whether this course reference number is optional during registration.	VARCHAR2(1)	SFRBKOP	SFRBKOP_OPTIONAL_CDE	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
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	SFRBSEL	SFRBSEL_BPDI_CODE	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
PERMIT_BLOCK_REG_OVERRIDE_IND	Indicates if the student may change the selected block registration code.	VARCHAR2(1)	SFRPABC	SFRPABC_BLOCK_RESTRICTION_IND	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SFRBSEL	SFRBSEL_PIDM	NO	NO
PROCESS_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
STUDY_PATH_SEQUENCE	Key sequence of the study path in the Block Web Registration.	NUMBER	SFRBSEL	SFRBSEL_KEY_SEQNO	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)	SSBSECT	SSBSECT_PTRM_CODE	NO	NO
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.	VARCHAR2(255)	STVPTRM	STVPTRM_DESC	NO	NO

Ver: 9.2