| 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)
|
SEP_PLAN_TERM SFBPLAN
|
TERM SFBPLAN_TERM_CODE
|
NO NO
|
NO
|
|
ACADEMIC_PERIOD_DESC
|
Description for the academic period.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
|
ACADEMIC_PERIOD_KEY
|
Unique key to the third party product plan academic period.
|
VARCHAR2(63)
|
CONSTANT SEP_PLAN_TERM
|
'NA' TERM_ID
|
NO 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
|
|
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
|
NO NO
|
NO
|
|
APPROVAL_METHOD_DESC
|
Description for the approval method selected within the third party product.
|
VARCHAR2(255)
|
CALCULATION CONSTANT
|
CASE WHEN APPROVAL_METHOD 'NOT APPLICABLE'
|
NO NO
|
NO
|
|
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
|
NO NO
|
NO
|
|
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'
|
NO NO
|
NO
|
|
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
|
NO NO
|
NO
|
|
CREATE_DATE
|
Date plan was created.
|
DATE
|
SEP_PLAN SFBPLAN
|
CREATE_DATE SFBPLAN_ACTIVITY_DATE
|
NO NO
|
NO
|
|
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
|
NO NO
|
NO
|
|
DEGREE_DESC
|
Degree description.
|
VARCHAR2(255)
|
STVDEGC
|
STVDEGC_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
|
|
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
|
NO NO
|
NO
|
|
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
|
NO 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
|
|
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
|
NO NO
|
NO
|
|
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
|
NO
|
NO
|
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
RAD_PRIMARY_MST SFBPLAN
|
RAD_USER_DEF1 SFBPLAN_PIDM
|
NO NO
|
NO
|
|
PLAN_ACTIVITY_DATE
|
Date record was inserted or updated.
|
DATE
|
SEP_PLAN SFBPLAN
|
MODIFY_DATE SFBPLAN_ACTIVITY_DATE
|
NO NO
|
NO
|
|
PLAN_COMMENT
|
Comments attached to the base registration plan record.
|
VARCHAR2(4000)
|
CONSTANT SFBPLAN
|
'NA' SFBPLAN_COMMENT
|
NO NO
|
NO
|
|
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
|
NO NO
|
NO
|
|
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
|
NO NO
|
NO
|
|
PLAN_CREATOR_NAME
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
|
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
|
NO NO
|
NO
|
|
PLAN_DATA_ORIGIN
|
Source system that created or updated data.
|
VARCHAR2(63)
|
SEP_PLAN SFBPLAN
|
MODIFY_WHAT SFBPLAN_DATA_ORIGIN
|
NO NO
|
NO
|
|
PLAN_DESC
|
Free-format description of the registration plan.
|
VARCHAR2(255)
|
SEP_PLAN SFBPLAN
|
DESCRIPTION SFBPLAN_DESCRIPTION
|
NO NO
|
NO
|
|
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
|
NO NO
|
NO
|
|
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
|
NO NO
|
NO
|
|
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
|
NO NO
|
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
|
NO NO
|
NO
|
|
PLAN_SOURCE_DESC
|
Description for the source code identified in this record.
|
VARCHAR2(255)
|
CALCULATION
|
CASE WHEN PLAN_SOURCE
|
NO
|
NO
|
|
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
|
NO NO
|
NO
|
|
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
|
NO NO
|
NO
|
|
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
|
NO
|
NO
|
|
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
|
NO NO
|
NO
|
|
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
|
NO
|
NO
|
|
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
|
NO NO NO
|
NO
|
|
PLAN_USER_NAME
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
|
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
|
NO NO
|
NO
|
|
PLAN_VERSION_NUMBER
|
Incremented number used for optimistic locking.
|
NUMBER
|
CONSTANT SFBPLAN
|
1 SFBPLAN_VERSION
|
NO NO
|
NO
|
|
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
|
NO 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
|
|
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
|
NO NO
|
NO
|
|
STUDENT_LEVEL_DESC
|
Student level description.
|
VARCHAR2(255)
|
STVLEVL
|
STVLEVL_DESC
|
NO
|
NO
|
|
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
|
NO
|
NO
|
|
STUDY_PATH_SEQUENCE
|
Sequence number of the study path for which the registration plan is created.
|
NUMBER
|
CONSTANT SFBPLAN
|
0 SFBPLAN_STSP_KEY_SEQUENCE
|
NO NO
|
NO
|
|
TEMPLATE_DESC
|
Free-format description of plan from third party plan.
|
VARCHAR2(255)
|
SEP_TMPL_MST
|
DESCRIPTION
|
NO
|
NO
|
|
TEMPLATE_ID
|
Identifier for template used for the person, academic period and plan.
|
VARCHAR2(63)
|
CONSTANT SEP_PLAN
|
'NA' TEMPLATE_ID
|
NO NO
|
NO
|
|
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
|
NO NO
|
NO
|
|
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
|
NO
|
NO
|
|
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
|
NO NO
|
NO
|
|
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
|
NO NO
|
NO
|
|
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
|
NO
|
NO
|