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

SGHE 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 Name Business Definition Database Data Type Domain Value Source Name Source Column
ADMINISTRATIVE_GROUP Administrative Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

COURSE_ATTRIBUTE 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 Course Attribute Description Description for the course attribute. VARCHAR2(255)  

STVATTR

STVATTR_DESC

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

SEP_TMPL_CLASS

CAMPUS

COURSE_CAMPUS_DESC Course Campus Description Description for the campus. VARCHAR2(255)  

STVCAMP

STVCAMP_DESC

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

CALCULATION

COURSE_DISCIPLINE||COURSE_NUMBER

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

SEP_TMPL_CLASS

COURSE_NUMBER

COURSE_SCHEDULE_TYPE 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 Course Schedule Type Description Description for a schedule type or instructional type for a course or section. VARCHAR2(255)  

STVSCHD

STVSCHD_DESC

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

NA

NA

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

NA

NA

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

NA

NA

SCRIBE_POINTER 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 Template Comment Exists Indicator 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 Template Course Active Indicator 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 Template Course Activity Date Date record was inserted or last updated. DATE  

SEP_TMPL_CLASS

MODIFY_DATE

TEMPLATE_COURSE_CREATE_DATE Template Course Create Date Date plan was created. DATE  

SEP_TMPL_CLASS

CREATE_DATE

TEMPLATE_COURSE_CREATOR_ID 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 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 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 Template Course Credits Credits associated with this course or course section. NUMBER  

SEP_TMPL_CLASS

CREDITS

TEMPLATE_COURSE_CRITICAL_IND Template Course Critical Indicator 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 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 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 Template Course Subject Main instructional subject or displace area for this course. VARCHAR2(63)  

SEP_TMPL_CLASS

COURSE_DISCIPLINE

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

STVSUBJ

STVSUBJ_DESC

TEMPLATE_COURSE_USER_ID 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 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 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 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 Template Description Free-format description of plan from third party plan. VARCHAR2(255)  

SEP_TMPL_MST

DESCRIPTION

TEMPLATE_GROUP_KEY 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 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 Template Group Type Description 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 Template ID Identifier for template used for the person, academic period and plan. VARCHAR2(63)  

SEP_TMPL_MST

TEMPLATE_ID

TEMPLATE_KEY 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 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 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 Tmpl Crse Create Data Origin Source system or process that created or updated data. VARCHAR2(63)  

SEP_TMPL_CLASS

CREATE_WHAT



Ver: 9.0