Reporting View Target: PLAN_TEMPLATE

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

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