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 SFBPLAN_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
APPROVAL_METHOD	Identifies the third party product approval method which may be one of the following three options; N = No approval method used, L = Locked indicator or W = Banner Workflow used.	VARCHAR2(63)	CONSTANT FUNCTION	'NA' DOKODSF.F_GET_SHP_SETTINGS_TEXT
APPROVAL_METHOD_DESC	Description for the approval method selected within the third party product.	VARCHAR2(255)	CALCULATION CONSTANT	CASE WHEN APPROVAL_METHOD 'NOT APPLICABLE'
APPROVAL_STATUS	Identifies the type of approval was recorded for this registration plan when the approval method is set to use Banner Workflow otherwise set to 'NA' or not applicable.	VARCHAR2(63)	CONSTANT SEP_PLAN	'NA' APPROVAL_STATUS
APPROVAL_STATUS_DESC	Description for the plan approval status from the third party product when the approval method is set to use Banner Workflow.	VARCHAR2(255)	CALCULATION CONSTANT	CASE WHEN APPROVAL_STATUS 'NOT APPLICABLE'
APPROVED_IND	Indicates the plan is approved by the Advisor or Registrar. Valid values are 'Y' or 'N'.	VARCHAR2(2)	CONSTANT SFBPLAN	'NA' SFBPLAN_APPROVE_IND
CREATE_DATE	Date plan was created.	DATE	SEP_PLAN SFBPLAN	CREATE_DATE SFBPLAN_ACTIVITY_DATE
DEGREE	Award, degree, diploma, certification upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate.	VARCHAR2(63)	SEP_PLAN SORLCUR	DEGREE SORLCUR_DEGC_CODE
DEGREE_DESC	Degree description.	VARCHAR2(255)	STVDEGC	STVDEGC_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
LOCKED_IND	Indicates the registration plan is locked and may not be changed. Valid values are 'Y' or N' but will be 'NA' when not used by the source system.	VARCHAR2(2)	SEP_PLAN SFBPLAN	IS_LOCKED SFBPLAN_LOCK_IND
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA SFBPLAN	NA SFBPLAN_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
OFFICIAL_TRACKING_STATUS	Official 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	'NOTAPPLICABLE' OFFICIAL_TRACKING_STATUS
OFFICIAL_TRACKING_STATUS_DESC	Description for the official tracking status for the plan in the academic period.	VARCHAR2(255)	CALCULATION	CASE WHEN OFFICIAL_TRACKING_STATUS
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RAD_PRIMARY_MST SFBPLAN	RAD_USER_DEF1 SFBPLAN_PIDM
PLAN_ACTIVITY_DATE	Date record was inserted or updated.	DATE	SEP_PLAN SFBPLAN	MODIFY_DATE SFBPLAN_ACTIVITY_DATE
PLAN_COMMENT	Comments attached to the base registration plan record.	VARCHAR2(4000)	CONSTANT SFBPLAN	'NA' SFBPLAN_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_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	MGKFUNC.F_GET_PERSON_INFO CREATE_WHO
PLAN_CREATOR_NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PLAN_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	RAD_PRIMARY_MST SFBPLAN	RAD_USER_DEF1 SFBPLAN_SRC_PIDM
PLAN_DATA_ORIGIN	Source system that created or updated data.	VARCHAR2(63)	SEP_PLAN SFBPLAN	MODIFY_WHAT SFBPLAN_DATA_ORIGIN
PLAN_DESC	Free-format description of the registration plan.	VARCHAR2(255)	SEP_PLAN 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_TERM	'NA' GROUP_ID
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 SFBPLAN	SEQUENCE SFBPLAN_SEQ_NO
PLAN_SOURCE	Source system that created or updated data. Source System will be 'B; for Banner, 'C' for Colleague or 'D' for Degree Works.	VARCHAR2(63)	CONSTANT SFBPLAN	'D' SFBPLAN_SRC_CDE
PLAN_SOURCE_DESC	Description for the source code identified in this record.	VARCHAR2(255)	CALCULATION	CASE WHEN PLAN_SOURCE
PLAN_TRACK_STATUS	Official 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	'NOTAPPLICABLE' OFFICIAL_TRACKING_STATUS
PLAN_TRACK_STATUS_CURRENT_IND	Indicates whether any changes have been made to this plan for the academic period since tracking status was last calculated. Valid values are Y, N or NA.	VARCHAR2(2)	CONSTANT SEP_PLAN	'NA' IS_TRACKING_STATUS_CURRENT
PLAN_TRACK_STATUS_DESC	Description for the official tracking status for the plan in the academic period.	VARCHAR2(255)	CALCULATION	CASE WHEN OFFICIAL_TRACKING_STATUS
PLAN_UNOFFICIAL_TRACK_STATUS	Unofficial 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	'NA' UNOFFICIAL_TRACKING_STATUS
PLAN_UNOFF_TRACK_STATUS_DESC	Description for the unofficial tracking status for the plan in the academic period.	VARCHAR2(255)	CALCULATION	CASE WHEN UNOFFICIAL_TRACKING_STATUS
PLAN_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 SFBPLAN	MGKFUNC.F_GET_PERSON_INFO MODIFY_WHO SFBPLAN_USER_ID
PLAN_USER_NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PLAN_USER_UID	System generated internal ID for the person who created or last updated the plan. This may be the student or one of the student's advisors.	NUMBER	RAD_PRIMARY_MST SFBPLAN	RAD_USER_DEF1 SFBPLAN_USER_ID
PLAN_VERSION_NUMBER	Incremented number used for optimistic locking.	NUMBER	CONSTANT SFBPLAN	1 SFBPLAN_VERSION
PREFERRED_IND	Indicates the registration plan is an active plan. Valid values are 'Y' or 'N'.	VARCHAR2(2)	SEP_PLAN SFBPLAN	IS_ACTIVE SFBPLAN_PREFERRED_IND
PROCESS_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
STUDENT_LEVEL	Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc.	VARCHAR2(63)	SEP_PLAN SORLCUR	SCHOOL SORLCUR_LEVL_CODE
STUDENT_LEVEL_DESC	Student level description.	VARCHAR2(255)	STVLEVL	STVLEVL_DESC
STUDENT_PLAN_COUNT	Number of student registration plans defined in Banner for the student and academic period.	NUMBER	FUNCTION	MSKFUNC.F_GET_REG_PLAN_CNT
STUDY_PATH_SEQUENCE	Sequence number of the study path for which the registration plan is created.	NUMBER	CONSTANT SFBPLAN	0 SFBPLAN_STSP_KEY_SEQUENCE
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_PLAN	'NA' TEMPLATE_ID
TEMPLATE_KEY	Unique key to identify the template from the third party product used to create this plan.	VARCHAR2(63)	CONSTANT SEP_TMPL_MST	'NA' DESCRIPTION
THIRD_PARTY_PLAN_COUNT	Number of student registration plans defined in Degree Works for the student and academic period.	NUMBER	FUNCTION	MDKFUNC.F_GET_THIRD_PARY_PLAN_IND
TRACKING_STATUS_CURRENT_IND	Indicates whether any changes have been made to this plan for the academic period since tracking status was last calculated. Valid values are Y, N or NA.	VARCHAR2(2)	CONSTANT SEP_PLAN_TERM	'NA' IS_TRACKING_STATUS_CURRENT
UNOFFICIAL_TRACKING_STATUS	Unofficial 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	'NOTAPPLICABLE' UNOFFICIAL_TRACKING_STATUS
UNOFFICIAL_TRACK_STATUS_DESC	Description for the unofficial tracking status for the plan in the academic period.	VARCHAR2(255)	CALCULATION	CASE WHEN UNOFFICIAL_TRACKING_STATUS

Ver: 9.1