Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Identifies the academic period in which the student plans to register for the course or course section in the plan.	VARCHAR2(63)	SEP_PLAN_TERM SFBPLAN	TERM SFRPLAN_TERM_CODE
ACADEMIC_PERIOD_DESC	Description for the academic period.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_PERIOD_KEY	Unique key to the third party product plan academic period.	VARCHAR2(63)	CONSTANT SEP_PLAN_TERM	'NA' TERM_ID
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	Description for the academic period.	VARCHAR2(255)	STVACYR	STVACYR_DESC
ADMINISTRATIVE_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
COURSE_ACTIVE_IND	Indicates the course is active for this person, plan and academic period. Valid values are 'Y', 'N' or 'NA'.	VARCHAR2(2)	CONSTANT SFRPLAN	'NA' SFRPLAN_ACTIVE_IND
COURSE_ATTRIBUTE	Degree course attribute when one is required to successfully complete this course. This column does not need to be populated in either product's registration plan.	VARCHAR2(63)	SEP_PLAN_CLASS SFRPLAN	COURSE_ATTRIBUTE SFRPLAN_ATTR_CODE
COURSE_ATTRIBUTE_COUNT	Number of course attributes associated with this course.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_COURSE_ATTRIBUTES
COURSE_ATTRIBUTE_DESC	Description for the course attribute.	VARCHAR2(255)	STVATTR	STVATTR_DESC
COURSE_CAMPUS	Campus on which the course or course section is or must be scheduled.	VARCHAR2(63)	SEP_PLAN_CLASS SFRPLAN	CAMPUS SFRPLAN_CAMP_CODE
COURSE_CAMPUS_DESC	Description for the campus.	VARCHAR2(255)	STVCAMP	STVCAMP_DESC
COURSE_COLLEGE	College, School or Faculty responsible for the instruction of this course or section.	VARCHAR2(63)	CONSTANT SFRPLAN	'NA' SFRPLAN_COLL_CODE
COURSE_COLLEGE_DESC	Description of the College, School or Faculty responsible for the instruction in the offering.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC
COURSE_CREDITS	Credits associated with this course or course section.	NUMBER	SEP_PLAN_CLASS SFRPLAN	CREDITS SFRPLAN_CREDITS
COURSE_CRITICAL_IND	Indicates this course is critical and has been flagged as must complete within this person, plan and academic period.	VARCHAR2(2)	SEP_PLAN_CLASS SFRPLAN	IS_CRITICAL SFRPLAN_CRITICAL_IND
COURSE_DEPARTMENT	Department within the college, school or faculty responsible for the instruction of this course or section.	VARCHAR2(63)	CONSTANT SFRPLAN	'NA' SFRPLAN_DEPT_CODE
COURSE_DEPARTMENT_DESC	Description of the department responsible for the instruction in the offering.	VARCHAR2(255)	CONSTANT STVDEPT	'NOT APPLICABLE' STVDEPT_DESC
COURSE_END_DATE	Date the section instruction ends for this section sub academic period.	DATE	CONSTANT SFRPLAN	'NA' SFRPLAN_COMPLETION_DATE
COURSE_GRADE_TYPE	Grade mode associated with the course of this section.	VARCHAR2(63)	CONSTANT SFRPLAN	'NA' SFRPLAN_GMOD_CODE
COURSE_GRADE_TYPE_COUNT	Number of grade types associated with this course or course offering.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_GRADE_TYPE
COURSE_GRADE_TYPE_DESC	Description for the grade mode or type.	VARCHAR2(255)	STVGMOD	STVGMOD_DESC
COURSE_IDENTIFICATION	Course subject and course number combined.	VARCHAR2(255)	CALCULATION	SCBCRSE_SUBJ_CODE||SCBCRSE_CRSE_NUMB
COURSE_LEVEL	Level of academic study satisfied by this course. For example, undergraduate, graduate, credit, etc.	VARCHAR2(63)	SEP_PLAN SFRPLAN	SCHOOL SFRPLAN_LEVL_CODE
COURSE_LEVEL_DESC	Description for the course level.	VARCHAR2(255)	STVLEVL	STVLEVL_DESC
COURSE_LOCKED_IND	Indicates this course has been locked in this person, plan and academic period. Valid values are 'Y' or 'N'.	VARCHAR2(2)	CONSTANT SFRPLAN	'NA' SFRPLAN_LOCK_IND
COURSE_NUMBER	Course number associated with the subject for the course.	VARCHAR2(63)	SEP_PLAN_CLASS SFRPLAN	COURSE_NUMBER SFRPLAN_CRSE_NUMB
COURSE_REFERENCE_NUMBER	Computer assigned internal unique number for the section when it is used in a Banner registration plan. Column will always be NA for Degree Works data but may optionally have a Banner value.	VARCHAR2(63)	CONSTANT SFRPLAN	'NA' SFRPLAN_CRN
COURSE_START_DATE	Date the section instruction begins for this section sub academic period.	DATE	CONSTANT SFRPLAN	'NA' SFRPLAN_START_DATE
COURSE_SUBJECT	Main instructional subject or displace area for this course.	VARCHAR2(63)	SEP_PLAN_CLASS SFRPLAN	COURSE_DISCIPLINE SFRPLAN_SUBJ_CDE
COURSE_SUBJECT_DESC	Description of the subject area for this course	VARCHAR2(255)	STVSUBJ	STVSUBJ_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
MINIMUM_GRADE	Minimum grade that every course in this group must meet in order to fulfill the requirement.	VARCHAR2(63)	CONSTANT SEP_PLAN_CLASS	'NA' MINIMUM_GRADE
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	CONSTANT SFRPLAN	'NA' SFRPLAN_VPDI_CODE
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RAD_PRIMARY_MST SFRPLAN	RAD_USER_DEF1 SFRPLAN_PIDM
PLAN_COMMENT	Comments attached to the base registration plan record.	VARCHAR2(4000)	CONSTANT SFRPLAN	'NA' SFRPLAN_COMMENT
PLAN_COMMENT_EXISTS_IND	Indicator whether comments or notes exist for the plan or plan course.	VARCHAR2(2)	CALCULATION FUNCTION	DECODE(SFRPLAN_COMMENT) DOKODSF.F_GET_PLAN_CMNT_EXST_IND
PLAN_COURSE_ACTIVITY_DATE	Date record was inserted or last updated.	DATE	SEP_PLAN_CLASS SFRPLAN	MODIFY_DATE SFRPLAN_ACTIVITY_DATE
PLAN_COURSE_CREATE_DATA_ORIGIN	Source system or process that created or updated data.	VARCHAR2(63)	SEP_PLAN_CLASS SFRPLAN	CREATE_WHAT SFRPLAN_DATA_ORIGIN
PLAN_COURSE_CREATE_DATE	Date plan was created.	DATE	SEP_PLAN_CLASS SFRPLAN	CREATE_DATE SFRPLAN_ACTIVITY_DATE
PLAN_COURSE_CREATOR_ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION SEP_PLAN_CLASS	MGKFUNC.F_GET_PERSON_INFO CREATE_WHO
PLAN_COURSE_CREATOR_NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PLAN_COURSE_CREATOR_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	FUNCTION RAD_PRIMARY_MST	SOKODSF.F_GET_BANNER_PIDM RAD_USER_DEF1
PLAN_COURSE_DATA_ORIGIN	Source system or process that created or updated data.	VARCHAR2(63)	SEP_PLAN_CLASS SFRPLAN	MODIFY_WHAT SFRPLAN_DATA_ORIGIN
PLAN_COURSE_HONORS_IND	Indicates whether or not the courses in this group must be taken for honors.	VARCHAR2(2)	CONSTANT SEP_PLAN_CLASS	'NA' IS_HONORS
PLAN_COURSE_KEY	Internally system-generated unique identification number which represents the unique key for the student course database record for this plan.	VARCHAR2(63)	SEP_PLAN_CLASS SFRPLAN	CLASS_ID SFRPLAN_SURROGATE_ID
PLAN_COURSE_SEQUENCE_NUMBER	Identifies the number of courses or course sections and the sequence in which they were added to the base plan.	NUMBER	SEP_PLAN_CLASS SFRPLAN	SEQUENCE SFRPLAN_SEQ_NO
PLAN_COURSE_SOURCE	Source system that created or updated data. Source System will be 'B' = Banner or 'D' = Degree Works.	VARCHAR2(63)	CONSTANT SFRPLAN	'D' SFRPLAN_SRC_CDE
PLAN_COURSE_SOURCE_DESC	Description for the source system for this registration plan course record.	VARCHAR2(255)	CALCULATION	DECODE(SFRPLAN_SRC_CDE)
PLAN_COURSE_USER_ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION SEP_PLAN_CLASS	MGKFUNC.F_GET_PERSON_INFO MODIFY_WHO
PLAN_COURSE_USER_NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PLAN_COURSE_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	CONSTANT RAD_PRIMARY_MST	'NA' RAD_USER_DEF1
PLAN_COURSE_VERSION_NUMBER	Incremented number used for optimistic locking.	NUMBER	CONSTANT SFRPLAN	1 SFRPLAN_VERSION
PLAN_DESC	Free-format description of the registration plan.	VARCHAR2(255)	SEP_PLAN_CLASS SFBPLAN	DESCRIPTION SFBPLAN_DESCRIPTION
PLAN_GROUP_KEY	Unique key to identify the group for the third party product registration plan for this academic period.	VARCHAR2(63)	CONSTANT SEP_PLAN_GROUP	'NA' GROUP_ID
PLAN_GROUP_TYPE	Identifies when the group is a union and when it is a choice of one or more courses defined. Values will be UN = Union, CH = Choice or NA = Not Applicable in the product.	VARCHAR2(63)	CONSTANT SEP_PLAN_GROUP	'NA' GROUP_TYPE
PLAN_GROUP_TYPE_DESC	Description for the type of group defined for this record. The group type may be either a union or choice within the group or not applicable.	VARCHAR2(255)	CALCULATION CONSTANT	DECODE(GROUP_TYPE) 'NOT APPLICABLE'
PLAN_KEY	Internally system-generated unique identification number which represents the unique key of the database record for the person, academic period and registration plan.	VARCHAR2(63)	SEP_PLAN SFBPLAN	PLAN_ID SFBPLAN_SURROGATE_ID
PLAN_SEQUENCE_NUMBER	Generated one up number that points to the person plan information header record.	NUMBER	SEP_PLAN_GROUP SFRPLAN	SEQUENCE SFRPLAN_SFBPLAN_SEQ_NO
PROCESS_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROJECTED_SEAT_NEEDED	Used to calculate the number of seats being requested for a course and or section within an academic period.	NUMBER	CALCULATION	COUNT (*) OVER (PARTITION BY B.PERSON_UID)
SCHEDULE_COUNT	Number of course schedule or delivery methods associated with this course or course offering.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_COURSE_SCHEDULE
SCHEDULE_TYPE	Schedule or instructional type description for the course or for a section.	VARCHAR2(63)	SEP_PLAN_CLASS SFRPLAN	DELIVERY SFRPLAN_SCHD_CODE
SCHEDULE_TYPE_DESC	Description for a schedule type or instructional type for a course or section.	VARCHAR2(255)	STVSCHD	STVSCHD_DESC
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.	VARCHAR2(63)	CONSTANT SSBSECT	'NA' SSBSECT_PTRM_CODE
SUB_ACADEMIC_PERIOD_DESC	Description for the part of academic period.	VARCHAR2(255)	CONSTANT STVPTRM	'NOT APPLICABLE' STVPTRM_DESC
TEMPLATE_DESC	Free-format description of plan from third party plan.	VARCHAR2(255)	SEP_TMPL_MST	DESCRIPTION
TEMPLATE_ID	Identifier for template used for the person, academic period and plan.	VARCHAR2(63)	CONSTANT SEP_TMPL_MST	'NA' TEMPLATE_ID
TRACKING_STATUS	Tracking status that identifies if the overall plan has been evaluated for the academic period and if it is on track or not. When source product supplies this data, the values will be NOTEVALUATED, ONTRACK or OFFTRACK. When the source does not this will be NOT APPLICABLE.	VARCHAR2(63)	CONSTANT SEP_PLAN_TERM	'NA' TRACKING_STATUS
TRACKING_STATUS_DESC	Description for the tracking status for the plan in the academic period.	VARCHAR2(255)	CALCULATION	CASE WHEN TRACKING_STATUS

Ver: 9.1