Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	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
ACADEMIC_PERIOD_DESC	Academic Period Description	Description for the academic period.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic Year	Identifies the academic period for which the course or course section is planned for registration.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic Year Description	Description for the academic period.	VARCHAR2(255)	STVACYR	STVACYR_DESC
ADMINISTRATIVE_GROUP	Administrative Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
BLOCK_COURSE_RESTRICTION	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
BLOCK_COURSE_RESTRICTION_DESC	Block Course Restriction Description	Description for the type of registration restriction defined for this course.	VARCHAR2(255)	CALCULATION	CASE WHEN SFRBRDB_COURSE_RESTRICTION
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)	SFRBSEL	SFRBSEL_BLCK_CODE
BLOCK_REGISTRATION_DESC	Block Registration Description	Description for the block registration code.	VARCHAR2(255)	STVBLCK	STVBLCK_DESC
BLOCK_REGISTRATION_OVERRIDE	Block Registration Override	Identifies the override rule code to use to change the block registration code.	VARCHAR2(63)	SFRBLPA	SFRBLPA_ROVR_CODE
BLOCK_REGISTRATION_USER_ID	Block Registration User ID	User ID of the person who inserted or last updated this record.	VARCHAR2(63)	SFRBSEL	SFRBSEL_USER_ID
BLOCK_REGISTRATION_USER_NAME	Block Registration User Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_FORMAT_NAME
BLOCK_REGISTRATION_USER_UID	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
BLOCK_REG_ACTIVITY_DATE	Block Registration Activity Date	Date this record was inserted or last updated.	DATE	SFRBSEL	SFRBSEL_ACTIVITY_DATE
BLOCK_REG_COURSE_KEY	Block Registration Course KEY	Sequence number that uniquely identifies the rule for block assignment.	NUMBER	SFRBKOP	SFRBKOP_SURROGATE_ID
BLOCK_REG_DATA_ORIGIN	Block Registration Data Origin	Source system or process that created or last updated this record.	VARCHAR2(63)	SFRBSEL	SFRBSEL_DATA_ORIGIN
BLOCK_REG_OVERRIDE_DESC	Block Registration Override Description	Description for the block registration restriction override.	VARCHAR2(255)	STVROVR	STVROVR_DESC
BLOCK_REG_SEQUENCE_NUMBER	Block Registration Sequence Number	Sequence number that uniquely identifies the rule for block assignment.	NUMBER	SFRBSEL	SFRBSEL_BRDH_SEQ_NUM
BLOCK_REG_VERSION_NUMBER	Block Registration Version Number	Incremented number used for optimistic locking.	NUMBER	SFRBSEL	SFRBSEL_VERSION
COURSE_IDENTIFICATION	Course Identification	Course subject and course number combined.	VARCHAR2(255)	CALCULATION	SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB
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	Sequence number that uniquely identifies the course section in this block registration assignment.	VARCHAR2(63)	SSRBLCK	SSRBLCK_CRN
CRSE_REFERENCE_NUMBER_OPT_IND	Crse Reference Number Option Indicator	Indicates whether this course reference number is optional during registration.	VARCHAR2(1)	SFRBKOP	SFRBKOP_OPTIONAL_CDE
ID	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
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	SFRBSEL	SFRBSEL_BPDI_CODE
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERMIT_BLOCK_REG_OVERRIDE_IND	Permit Block Registration Override Indicator	Indicates if the student may change the selected block registration code.	VARCHAR2(1)	SFRPABC	SFRPABC_BLOCK_RESTRICTION_IND
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SFRBSEL	SFRBSEL_PIDM
PROCESS_GROUP	Process Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
STUDY_PATH_SEQUENCE	Study Path Sequence	Key sequence of the study path in the Block Web Registration.	NUMBER	SFRBSEL	SFRBSEL_KEY_SEQNO
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)	SSBSECT	SSBSECT_PTRM_CODE
SUB_ACADEMIC_PERIOD_DESC	Sub Academic Period Description	Sub academic period description.	VARCHAR2(255)	STVPTRM	STVPTRM_DESC

Ver: 9.2