Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
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	NO	NO
COURSE_ATTRIBUTE_DESC	Description for the course attribute.	VARCHAR2(255)	STVATTR	STVATTR_DESC	NO	NO
COURSE_CAMPUS	Campus on which the course or course section is or must be scheduled.	VARCHAR2(63)	SEP_TMPL_CLASS	CAMPUS	NO	NO
COURSE_CAMPUS_DESC	Description for the campus.	VARCHAR2(255)	STVCAMP	STVCAMP_DESC	NO	NO
COURSE_IDENTIFICATION	Course subject and course number combined.	VARCHAR2(255)	CALCULATION	COURSE_DISCIPLINE||COURSE_NUMBER	NO	NO
COURSE_NUMBER	Course number associated with the subject for the course.	VARCHAR2(63)	SEP_TMPL_CLASS	COURSE_NUMBER	NO	NO
COURSE_SCHEDULE_TYPE	Schedule or instructional type description for the course or for a section.	VARCHAR2(63)	SEP_TMPL_CLASS	DELIVERY	NO	NO
COURSE_SCHEDULE_TYPE_DESC	Description for a schedule type or instructional type for a course or section.	VARCHAR2(255)	STVSCHD	STVSCHD_DESC	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
PROCESS_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
TEMPLATE_COURSE_ACTIVITY_DATE	Date record was inserted or last updated.	DATE	SEP_TMPL_CLASS	MODIFY_DATE	NO	NO
TEMPLATE_COURSE_CREATE_DATE	Date plan was created.	DATE	SEP_TMPL_CLASS	CREATE_DATE	NO	NO
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	NO NO	NO
TEMPLATE_COURSE_CREATOR_NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_FORMAT_NAME	NO	NO
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	NO	NO
TEMPLATE_COURSE_CREDITS	Credits associated with this course or course section.	NUMBER	SEP_TMPL_CLASS	CREDITS	NO	NO
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	NO	NO
TEMPLATE_COURSE_DATA_ORIGIN	Source system or process that last updated this registration plan course.	VARCHAR2(63)	SEP_TMPL_CLASS	MODIFY_WHAT	NO	NO
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	NO	NO
TEMPLATE_COURSE_SUBJECT	Main instructional subject or displace area for this course.	VARCHAR2(63)	SEP_TMPL_CLASS	COURSE_DISCIPLINE	NO	NO
TEMPLATE_COURSE_SUBJECT_DESC	Description of the subject area for this course	VARCHAR2(255)	STVSUBJ	STVSUBJ_DESC	NO	NO
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	NO	NO
TEMPLATE_COURSE_USER_NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_FORMAT_NAME	NO	NO
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	NO	NO
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	NO	NO
TEMPLATE_DESC	Free-format description of plan from third party plan.	VARCHAR2(255)	SEP_TMPL_MST	DESCRIPTION	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
TEMPLATE_ID	Identifier for template used for the person, academic period and plan.	VARCHAR2(63)	SEP_TMPL_MST	TEMPLATE_ID	NO	NO
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	NO	NO
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	NO	NO
TEMPLATE_SEQUENCE_NUMBER	Generated one up number that points to the person plan information header record.	NUMBER	SEP_TMPL_GROUP	SEQUENCE	NO	NO
TMPL_CRSE_CREATE_DATA_ORIGIN	Source system or process that created or updated data.	VARCHAR2(63)	SEP_TMPL_CLASS	CREATE_WHAT	NO	NO

Ver: 9.2