| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
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)
|
|
SEP_PLAN_TERM SFBPLAN
|
TERM SFBPLAN_TERM_CODE
|
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Description for the academic period.
|
VARCHAR2(255)
|
|
STVTERM
|
STVTERM_DESC
|
|
ACADEMIC_PERIOD_KEY
|
Academic Period Key
|
Unique key to the third party product plan academic period.
|
VARCHAR2(63)
|
|
CONSTANT SEP_PLAN_TERM
|
'NA' TERM_ID
|
|
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
|
|
APPROVAL_METHOD
|
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
|
Approval Method Description
|
Description for the approval method selected within the third party product.
|
VARCHAR2(255)
|
|
CALCULATION CONSTANT
|
CASE WHEN APPROVAL_METHOD 'NOT APPLICABLE'
|
|
APPROVAL_STATUS
|
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
|
Approval Status Description
|
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
|
Approved Indicator
|
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
|
Create Date
|
Date plan was created.
|
DATE
|
|
SEP_PLAN SFBPLAN
|
CREATE_DATE SFBPLAN_ACTIVITY_DATE
|
|
DEGREE
|
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
|
Degree description.
|
VARCHAR2(255)
|
|
STVDEGC
|
STVDEGC_DESC
|
|
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
|
|
LOCKED_IND
|
Locked Indicator
|
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
|
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
|
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
|
|
OFFICIAL_TRACKING_STATUS
|
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
|
Official Tracking Status Description
|
Description for the official tracking status for the plan in the academic period.
|
VARCHAR2(255)
|
|
CALCULATION
|
CASE WHEN OFFICIAL_TRACKING_STATUS
|
|
PERSON_UID
|
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
|
Plan Activity Date
|
Date record was inserted or updated.
|
DATE
|
|
SEP_PLAN SFBPLAN
|
MODIFY_DATE SFBPLAN_ACTIVITY_DATE
|
|
PLAN_COMMENT
|
Plan Comment
|
Comments attached to the base registration plan record.
|
VARCHAR2(4000)
|
|
CONSTANT SFBPLAN
|
'NA' SFBPLAN_COMMENT
|
|
PLAN_COMMENT_EXISTS_IND
|
Plan Comment Exists Indicator
|
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
|
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
|
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
|
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
|
Plan Data Origin
|
Source system that created or updated data.
|
VARCHAR2(63)
|
|
SEP_PLAN SFBPLAN
|
MODIFY_WHAT SFBPLAN_DATA_ORIGIN
|
|
PLAN_DESC
|
Plan Description
|
Free-format description of the registration plan.
|
VARCHAR2(255)
|
|
SEP_PLAN SFBPLAN
|
DESCRIPTION SFBPLAN_DESCRIPTION
|
|
PLAN_GROUP_KEY
|
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
|
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
|
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
|
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
|
Plan Source Description
|
Description for the source code identified in this record.
|
VARCHAR2(255)
|
|
CALCULATION
|
CASE WHEN PLAN_SOURCE
|
|
PLAN_TRACK_STATUS
|
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
|
Plan Track Status Current Indicator
|
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
|
Plan Track Status Description
|
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
|
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
|
Plan Unoff Track Status Description
|
Description for the unofficial tracking status for the plan in the academic period.
|
VARCHAR2(255)
|
|
CALCULATION
|
CASE WHEN UNOFFICIAL_TRACKING_STATUS
|
|
PLAN_USER_ID
|
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
|
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
|
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
|
Plan Version Number
|
Incremented number used for optimistic locking.
|
NUMBER
|
|
CONSTANT SFBPLAN
|
1 SFBPLAN_VERSION
|
|
PREFERRED_IND
|
Preferred Indicator
|
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
|
Process Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
STUDENT_LEVEL
|
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
|
Student level description.
|
VARCHAR2(255)
|
|
STVLEVL
|
STVLEVL_DESC
|
|
STUDENT_PLAN_COUNT
|
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
|
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
|
Template Description
|
Free-format description of plan from third party plan.
|
VARCHAR2(255)
|
|
SEP_TMPL_MST
|
DESCRIPTION
|
|
TEMPLATE_ID
|
Template ID
|
Identifier for template used for the person, academic period and plan.
|
VARCHAR2(63)
|
|
CONSTANT SEP_PLAN
|
'NA' TEMPLATE_ID
|
|
TEMPLATE_KEY
|
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
|
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
|
Tracking Status Current Indicator
|
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
|
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
|
Unofficial Track Status Description
|
Description for the unofficial tracking status for the plan in the academic period.
|
VARCHAR2(255)
|
|
CALCULATION
|
CASE WHEN UNOFFICIAL_TRACKING_STATUS
|