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

Banner Operational Data Store
Reporting View Target: REGISTRATION_PLAN_COURSE - Registration Plan Course

Description Contains detail information about the student's registration plan for the person that lists the student courses and or sections to be taken in the academic period.
Key & Frequency One row per person per academic period per plan sequence number key per plan course key
Recommended Search Columns PERSON_UID,ACADEMIC_PERIOD,PLAN_SEQUENCE_NUMBER,PLAN_COURSE_SEQUENCE_NUMBER
PLAN_COURSE_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

SFRPLAN_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

COURSE_ACTIVE_IND Indicates the course is active for this person, plan and academic period. Valid values are 'Y', 'N' or 'NA'. VARCHAR2(2)

CONSTANT

SFRPLAN

'NA'

SFRPLAN_ACTIVE_IND

COURSE_ATTRIBUTE Degree course attribute when one is required to successfully complete this course. This column does not need to be populated in either product's registration plan. VARCHAR2(63)

SEP_PLAN_CLASS

SFRPLAN

COURSE_ATTRIBUTE

SFRPLAN_ATTR_CODE

COURSE_ATTRIBUTE_COUNT Number of course attributes associated with this course. NUMBER

FUNCTION

MSKFUNC.F_COUNT_COURSE_ATTRIBUTES

COURSE_ATTRIBUTE_DESC Description for the course attribute. VARCHAR2(255)

STVATTR

STVATTR_DESC

COURSE_CAMPUS Campus on which the course or course section is or must be scheduled. VARCHAR2(63)

SEP_PLAN_CLASS

SFRPLAN

CAMPUS

SFRPLAN_CAMP_CODE

COURSE_CAMPUS_DESC Description for the campus. VARCHAR2(255)

STVCAMP

STVCAMP_DESC

COURSE_COLLEGE College, School or Faculty responsible for the instruction of this course or section. VARCHAR2(63)

CONSTANT

SFRPLAN

'NA'

SFRPLAN_COLL_CODE

COURSE_COLLEGE_DESC Description of the College, School or Faculty responsible for the instruction in the offering. VARCHAR2(255)

STVCOLL

STVCOLL_DESC

COURSE_CREDITS Credits associated with this course or course section. NUMBER

SEP_PLAN_CLASS

SFRPLAN

CREDITS

SFRPLAN_CREDITS

COURSE_CRITICAL_IND Indicates this course is critical and has been flagged as must complete within this person, plan and academic period. VARCHAR2(2)

SEP_PLAN_CLASS

SFRPLAN

IS_CRITICAL

SFRPLAN_CRITICAL_IND

COURSE_DEPARTMENT Department within the college, school or faculty responsible for the instruction of this course or section. VARCHAR2(63)

CONSTANT

SFRPLAN

'NA'

SFRPLAN_DEPT_CODE

COURSE_DEPARTMENT_DESC Description of the department responsible for the instruction in the offering. VARCHAR2(255)

CONSTANT

STVDEPT

'NOT APPLICABLE'

STVDEPT_DESC

COURSE_END_DATE Date the section instruction ends for this section sub academic period. DATE

CONSTANT

SFRPLAN

'NA'

SFRPLAN_COMPLETION_DATE

COURSE_GRADE_TYPE Grade mode associated with the course of this section. VARCHAR2(63)

CONSTANT

SFRPLAN

'NA'

SFRPLAN_GMOD_CODE

COURSE_GRADE_TYPE_COUNT Number of grade types associated with this course or course offering. NUMBER

FUNCTION

MSKFUNC.F_COUNT_GRADE_TYPE

COURSE_GRADE_TYPE_DESC Description for the grade mode or type. VARCHAR2(255)

STVGMOD

STVGMOD_DESC

COURSE_IDENTIFICATION Course subject and course number combined. VARCHAR2(255)

CALCULATION

SCBCRSE_SUBJ_CODE||SCBCRSE_CRSE_NUMB

COURSE_LEVEL Level of academic study satisfied by this course. For example, undergraduate, graduate, credit, etc. VARCHAR2(63)

SEP_PLAN

SFRPLAN

SCHOOL

SFRPLAN_LEVL_CODE

COURSE_LEVEL_DESC Description for the course level. VARCHAR2(255)

STVLEVL

STVLEVL_DESC

COURSE_LOCKED_IND Indicates this course has been locked in this person, plan and academic period. Valid values are 'Y' or 'N'. VARCHAR2(2)

CONSTANT

SFRPLAN

'NA'

SFRPLAN_LOCK_IND

COURSE_NUMBER Course number associated with the subject for the course. VARCHAR2(63)

SEP_PLAN_CLASS

SFRPLAN

COURSE_NUMBER

SFRPLAN_CRSE_NUMB

COURSE_REFERENCE_NUMBER Computer assigned internal unique number for the section when it is used in a Banner registration plan. Column will always be NA for Degree Works data but may optionally have a Banner value. VARCHAR2(63)

CONSTANT

SFRPLAN

'NA'

SFRPLAN_CRN

COURSE_START_DATE Date the section instruction begins for this section sub academic period. DATE

CONSTANT

SFRPLAN

'NA'

SFRPLAN_START_DATE

COURSE_SUBJECT Main instructional subject or displace area for this course. VARCHAR2(63)

SEP_PLAN_CLASS

SFRPLAN

COURSE_DISCIPLINE

SFRPLAN_SUBJ_CDE

COURSE_SUBJECT_DESC Description of the subject area for this course VARCHAR2(255)

STVSUBJ

STVSUBJ_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

MINIMUM_GRADE Minimum grade that every course in this group must meet in order to fulfill the requirement. VARCHAR2(63)

CONSTANT

SEP_PLAN_CLASS

'NA'

MINIMUM_GRADE

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

CONSTANT

SFRPLAN

'NA'

SFRPLAN_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

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

RAD_PRIMARY_MST

SFRPLAN

RAD_USER_DEF1

SFRPLAN_PIDM

PLAN_COMMENT Comments attached to the base registration plan record. VARCHAR2(4000)

CONSTANT

SFRPLAN

'NA'

SFRPLAN_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_COURSE_ACTIVITY_DATE Date record was inserted or last updated. DATE

SEP_PLAN_CLASS

SFRPLAN

MODIFY_DATE

SFRPLAN_ACTIVITY_DATE

PLAN_COURSE_CREATE_DATA_ORIGIN Source system or process that created or updated data. VARCHAR2(63)

SEP_PLAN_CLASS

SFRPLAN

CREATE_WHAT

SFRPLAN_DATA_ORIGIN

PLAN_COURSE_CREATE_DATE Date plan was created. DATE

SEP_PLAN_CLASS

SFRPLAN

CREATE_DATE

SFRPLAN_ACTIVITY_DATE

PLAN_COURSE_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_CLASS

MGKFUNC.F_GET_PERSON_INFO

CREATE_WHO

PLAN_COURSE_CREATOR_NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PLAN_COURSE_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

FUNCTION

RAD_PRIMARY_MST

SOKODSF.F_GET_BANNER_PIDM

RAD_USER_DEF1

PLAN_COURSE_DATA_ORIGIN Source system or process that created or updated data. VARCHAR2(63)

SEP_PLAN_CLASS

SFRPLAN

MODIFY_WHAT

SFRPLAN_DATA_ORIGIN

PLAN_COURSE_HONORS_IND Indicates whether or not the courses in this group must be taken for honors. VARCHAR2(2)

CONSTANT

SEP_PLAN_CLASS

'NA'

IS_HONORS

PLAN_COURSE_KEY Internally system-generated unique identification number which represents the unique key for the student course database record for this plan. VARCHAR2(63)

SEP_PLAN_CLASS

SFRPLAN

CLASS_ID

SFRPLAN_SURROGATE_ID

PLAN_COURSE_SEQUENCE_NUMBER Identifies the number of courses or course sections and the sequence in which they were added to the base plan. NUMBER

SEP_PLAN_CLASS

SFRPLAN

SEQUENCE

SFRPLAN_SEQ_NO

PLAN_COURSE_SOURCE Source system that created or updated data. Source System will be 'B' = Banner or 'D' = Degree Works. VARCHAR2(63)

CONSTANT

SFRPLAN

'D'

SFRPLAN_SRC_CDE

PLAN_COURSE_SOURCE_DESC Description for the source system for this registration plan course record. VARCHAR2(255)

CALCULATION

DECODE(SFRPLAN_SRC_CDE)

PLAN_COURSE_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_CLASS

MGKFUNC.F_GET_PERSON_INFO

MODIFY_WHO

PLAN_COURSE_USER_NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PLAN_COURSE_USER_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

CONSTANT

RAD_PRIMARY_MST

'NA'

RAD_USER_DEF1

PLAN_COURSE_VERSION_NUMBER Incremented number used for optimistic locking. NUMBER

CONSTANT

SFRPLAN

1

SFRPLAN_VERSION

PLAN_DESC Free-format description of the registration plan. VARCHAR2(255)

SEP_PLAN_CLASS

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_GROUP

'NA'

GROUP_ID

PLAN_GROUP_TYPE Identifies when the group is a union and when it is a choice of one or more courses defined. Values will be UN = Union, CH = Choice or NA = Not Applicable in the product. VARCHAR2(63)

CONSTANT

SEP_PLAN_GROUP

'NA'

GROUP_TYPE

PLAN_GROUP_TYPE_DESC Description for the type of group defined for this record. The group type may be either a union or choice within the group or not applicable. VARCHAR2(255)

CALCULATION

CONSTANT

DECODE(GROUP_TYPE)

'NOT APPLICABLE'

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

SFRPLAN

SEQUENCE

SFRPLAN_SFBPLAN_SEQ_NO

PROCESS_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

PROJECTED_SEAT_NEEDED Used to calculate the number of seats being requested for a course and or section within an academic period. NUMBER

CALCULATION

COUNT (*) OVER (PARTITION BY B.PERSON_UID)

SCHEDULE_COUNT Number of course schedule or delivery methods associated with this course or course offering. NUMBER

FUNCTION

MSKFUNC.F_COUNT_COURSE_SCHEDULE

SCHEDULE_TYPE Schedule or instructional type description for the course or for a section. VARCHAR2(63)

SEP_PLAN_CLASS

SFRPLAN

DELIVERY

SFRPLAN_SCHD_CODE

SCHEDULE_TYPE_DESC Description for a schedule type or instructional type for a course or section. VARCHAR2(255)

STVSCHD

STVSCHD_DESC

SUB_ACADEMIC_PERIOD A session, portion or part of the academic period. VARCHAR2(63)

CONSTANT

SSBSECT

'NA'

SSBSECT_PTRM_CODE

SUB_ACADEMIC_PERIOD_DESC Description for the part of academic period. VARCHAR2(255)

CONSTANT

STVPTRM

'NOT APPLICABLE'

STVPTRM_DESC

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_TMPL_MST

'NA'

TEMPLATE_ID

TRACKING_STATUS 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

'NA'

TRACKING_STATUS

TRACKING_STATUS_DESC Description for the tracking status for the plan in the academic period. VARCHAR2(255)

CALCULATION

CASE WHEN TRACKING_STATUS



Ver: 9.1