Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Student Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: REGISTRATION_PLAN - Registration Plan

Description Contains high-level overview information about a registration plan created by the student for the academic period.
Key & Frequency One row per person per academic period per plan key
Recommended Search Columns PERSON_UID, ACADEMIC_PERIOD, PLAN_SEQUENCE_NUMBER
PERSON_UID, ACADEMIC_PERIOD, PLAN_KEY, PLAN_SEQUENCE_NUMBER

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



Ver: 9.0