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

Banner Operational Data Store
Reporting View Target: PLAN_TEMPLATE_COURSE

Description Contains detail information about the registration plan templates that may have been used to create a list of academic periods and courses to be taken in each in sequence of academic periods for the student level and program or degree.
Key & Frequency One row per academic period per plan sequence number key per plan course key
Recommended Search Columns TEMPLATE_SEQUENCE_NUMBER,TEMPLATE_COURSE_KEY

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

COURSE_ATTRIBUTE Degree course attribute required to be satisfied by successful completion of this course to meet the Audit requirement. VARCHAR2(63)

SEP_TMPL_CLASS

COURSE_ATTRIBUTE

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_TMPL_CLASS

CAMPUS

COURSE_CAMPUS_DESC Description for the campus. VARCHAR2(255)

STVCAMP

STVCAMP_DESC

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

CALCULATION

COURSE_DISCIPLINE||COURSE_NUMBER

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

SEP_TMPL_CLASS

COURSE_NUMBER

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

SEP_TMPL_CLASS

DELIVERY

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

STVSCHD

STVSCHD_DESC

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

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

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

NA

NA

SCRIBE_POINTER Value that represents the audit requirement written in Scribe that this group within the plan will fulfill. VARCHAR2(63)

SEP_TMPL_GROUP

SCRIBE_POINTER

TEMPLATE_COMMENT_EXISTS_IND Indicator whether comments or notes exist for the plan or plan course. VARCHAR2(1)

FUNCTION

DOKODSF.F_GET_PLAN_CMNT_EXST_IND

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

SEP_TMPL_MST

IS_ACTIVE

TEMPLATE_COURSE_ACTIVITY_DATE Date record was inserted or last updated. DATE

SEP_TMPL_CLASS

MODIFY_DATE

TEMPLATE_COURSE_CREATE_DATE Date plan was created. DATE

SEP_TMPL_CLASS

CREATE_DATE

TEMPLATE_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_TMPL_MST

MGKFUNC.F_GET_PERSON_INFO

CREATE_WHO

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

FUNCTION

MGKFUNC.F_FORMAT_NAME

TEMPLATE_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

RAD_PRIMARY_MST

RAD_USER_DEF1

TEMPLATE_COURSE_CREDITS Credits associated with this course or course section. NUMBER

SEP_TMPL_CLASS

CREDITS

TEMPLATE_COURSE_CRITICAL_IND Indicates this course is critical and must be taken to complete the requirements in the curriculum or program. VARCHAR2(1)

SEP_TMPL_CLASS

IS_CRITICAL

TEMPLATE_COURSE_DATA_ORIGIN Source system or process that last updated this registration plan course. VARCHAR2(63)

SEP_TMPL_CLASS

MODIFY_WHAT

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

SEP_TMPL_CLASS

CLASS_ID

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

SEP_TMPL_CLASS

COURSE_DISCIPLINE

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

STVSUBJ

STVSUBJ_DESC

TEMPLATE_COURSE_USER_ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

SEP_TMPL_MST

MODIFY_WHO

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

FUNCTION

MGKFUNC.F_FORMAT_NAME

TEMPLATE_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

RAD_PRIMARY_MST

RAD_USER_DEF1

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

SEP_TMPL_CLASS

SEQUENCE

TEMPLATE_DESC Free-format description of plan from third party plan. VARCHAR2(255)

SEP_TMPL_MST

DESCRIPTION

TEMPLATE_GROUP_KEY Unique key to identify the group for the third party product registration plan for this academic period. VARCHAR2(63)

SEP_TMPL_TERM

GROUP_ID

TEMPLATE_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)

SEP_TMPL_GROUP

GROUP_TYPE

TEMPLATE_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

CASE WHEN GROUP_TYPE

TEMPLATE_ID Identifier for template used for the person, academic period and plan. VARCHAR2(63)

SEP_TMPL_MST

TEMPLATE_ID

TEMPLATE_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_TMPL_MST

TMPL_MST_ID

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

SEP_TMPL_CLASS

MINIMUM_GRADE

TEMPLATE_SEQUENCE_NUMBER Generated one up number that points to the person plan information header record. NUMBER

SEP_TMPL_GROUP

SEQUENCE

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

SEP_TMPL_CLASS

CREATE_WHAT



Ver: 9.1