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 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: 8.5