Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
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
|
NO NO
|
NO
|
ACADEMIC_PERIOD_DESC
|
Description for the academic period.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
ACADEMIC_PERIOD_KEY
|
Unique key to the third party product plan academic period.
|
VARCHAR2(63)
|
CONSTANT SEP_PLAN_TERM
|
'NA' TERM_ID
|
NO NO
|
NO
|
ACADEMIC_YEAR
|
Identifies the academic period for which the course or course section is planned for registration.
|
VARCHAR2(63)
|
STVTERM
|
STVTERM_ACYR_CODE
|
NO
|
NO
|
ACADEMIC_YEAR_DESC
|
Description for the academic period.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
NO
|
NO
|
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_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
|
NO NO
|
NO
|
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
|
NO NO
|
NO
|
COURSE_ATTRIBUTE_COUNT
|
Number of course attributes associated with this course.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_COURSE_ATTRIBUTES
|
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_PLAN_CLASS SFRPLAN
|
CAMPUS SFRPLAN_CAMP_CODE
|
NO NO
|
NO
|
COURSE_CAMPUS_DESC
|
Description for the campus.
|
VARCHAR2(255)
|
STVCAMP
|
STVCAMP_DESC
|
NO
|
NO
|
COURSE_COLLEGE
|
College, School or Faculty responsible for the instruction of this course or section.
|
VARCHAR2(63)
|
CONSTANT SFRPLAN
|
'NA' SFRPLAN_COLL_CODE
|
NO NO
|
NO
|
COURSE_COLLEGE_DESC
|
Description of the College, School or Faculty responsible for the instruction in the offering.
|
VARCHAR2(255)
|
STVCOLL
|
STVCOLL_DESC
|
NO
|
NO
|
COURSE_CREDITS
|
Credits associated with this course or course section.
|
NUMBER
|
SEP_PLAN_CLASS SFRPLAN
|
CREDITS SFRPLAN_CREDITS
|
NO NO
|
NO
|
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
|
NO NO
|
NO
|
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
|
NO NO
|
NO
|
COURSE_DEPARTMENT_DESC
|
Description of the department responsible for the instruction in the offering.
|
VARCHAR2(255)
|
CONSTANT STVDEPT
|
'NOT APPLICABLE' STVDEPT_DESC
|
NO NO
|
NO
|
COURSE_END_DATE
|
Date the section instruction ends for this section sub academic period.
|
DATE
|
CONSTANT SFRPLAN
|
'NA' SFRPLAN_COMPLETION_DATE
|
NO NO
|
NO
|
COURSE_GRADE_TYPE
|
Grade mode associated with the course of this section.
|
VARCHAR2(63)
|
CONSTANT SFRPLAN
|
'NA' SFRPLAN_GMOD_CODE
|
NO NO
|
NO
|
COURSE_GRADE_TYPE_COUNT
|
Number of grade types associated with this course or course offering.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_GRADE_TYPE
|
NO
|
NO
|
COURSE_GRADE_TYPE_DESC
|
Description for the grade mode or type.
|
VARCHAR2(255)
|
STVGMOD
|
STVGMOD_DESC
|
NO
|
NO
|
COURSE_IDENTIFICATION
|
Course subject and course number combined.
|
VARCHAR2(255)
|
CALCULATION
|
SCBCRSE_SUBJ_CODE||SCBCRSE_CRSE_NUMB
|
NO
|
NO
|
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
|
NO NO
|
NO
|
COURSE_LEVEL_DESC
|
Description for the course level.
|
VARCHAR2(255)
|
STVLEVL
|
STVLEVL_DESC
|
NO
|
NO
|
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
|
NO NO
|
NO
|
COURSE_NUMBER
|
Course number associated with the subject for the course.
|
VARCHAR2(63)
|
SEP_PLAN_CLASS SFRPLAN
|
COURSE_NUMBER SFRPLAN_CRSE_NUMB
|
NO NO
|
NO
|
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
|
NO NO
|
NO
|
COURSE_START_DATE
|
Date the section instruction begins for this section sub academic period.
|
DATE
|
CONSTANT SFRPLAN
|
'NA' SFRPLAN_START_DATE
|
NO NO
|
NO
|
COURSE_SUBJECT
|
Main instructional subject or displace area for this course.
|
VARCHAR2(63)
|
SEP_PLAN_CLASS SFRPLAN
|
COURSE_DISCIPLINE SFRPLAN_SUBJ_CDE
|
NO NO
|
NO
|
COURSE_SUBJECT_DESC
|
Description of the subject area for this course
|
VARCHAR2(255)
|
STVSUBJ
|
STVSUBJ_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO NO
|
NO
|
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
|
NO NO
|
NO
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
NAME
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
RAD_PRIMARY_MST SFRPLAN
|
RAD_USER_DEF1 SFRPLAN_PIDM
|
NO NO
|
NO
|
PLAN_COMMENT
|
Comments attached to the base registration plan record.
|
VARCHAR2(4000)
|
CONSTANT SFRPLAN
|
'NA' SFRPLAN_COMMENT
|
NO NO
|
NO
|
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
|
NO NO
|
NO
|
PLAN_COURSE_ACTIVITY_DATE
|
Date record was inserted or last updated.
|
DATE
|
SEP_PLAN_CLASS SFRPLAN
|
MODIFY_DATE SFRPLAN_ACTIVITY_DATE
|
NO NO
|
NO
|
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
|
NO NO
|
NO
|
PLAN_COURSE_CREATE_DATE
|
Date plan was created.
|
DATE
|
SEP_PLAN_CLASS SFRPLAN
|
CREATE_DATE SFRPLAN_ACTIVITY_DATE
|
NO NO
|
NO
|
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
|
NO NO
|
NO
|
PLAN_COURSE_CREATOR_NAME
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
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
|
NO NO
|
NO
|
PLAN_COURSE_DATA_ORIGIN
|
Source system or process that created or updated data.
|
VARCHAR2(63)
|
SEP_PLAN_CLASS SFRPLAN
|
MODIFY_WHAT SFRPLAN_DATA_ORIGIN
|
NO NO
|
NO
|
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
|
NO NO
|
NO
|
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
|
NO NO
|
NO
|
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
|
NO NO
|
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
|
NO NO
|
NO
|
PLAN_COURSE_SOURCE_DESC
|
Description for the source system for this registration plan course record.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(SFRPLAN_SRC_CDE)
|
NO
|
NO
|
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
|
NO NO
|
NO
|
PLAN_COURSE_USER_NAME
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
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
|
NO NO
|
NO
|
PLAN_COURSE_VERSION_NUMBER
|
Incremented number used for optimistic locking.
|
NUMBER
|
CONSTANT SFRPLAN
|
1 SFRPLAN_VERSION
|
NO NO
|
NO
|
PLAN_DESC
|
Free-format description of the registration plan.
|
VARCHAR2(255)
|
SEP_PLAN_CLASS SFBPLAN
|
DESCRIPTION SFBPLAN_DESCRIPTION
|
NO NO
|
NO
|
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
|
NO NO
|
NO
|
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
|
NO NO
|
NO
|
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'
|
NO NO
|
NO
|
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
|
NO NO
|
NO
|
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
|
NO 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
|
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)
|
NO
|
NO
|
SCHEDULE_COUNT
|
Number of course schedule or delivery methods associated with this course or course offering.
|
NUMBER
|
FUNCTION
|
MSKFUNC.F_COUNT_COURSE_SCHEDULE
|
NO
|
NO
|
SCHEDULE_TYPE
|
Schedule or instructional type description for the course or for a section.
|
VARCHAR2(63)
|
SEP_PLAN_CLASS SFRPLAN
|
DELIVERY SFRPLAN_SCHD_CODE
|
NO NO
|
NO
|
SCHEDULE_TYPE_DESC
|
Description for a schedule type or instructional type for a course or section.
|
VARCHAR2(255)
|
STVSCHD
|
STVSCHD_DESC
|
NO
|
NO
|
SUB_ACADEMIC_PERIOD
|
A session, portion or part of the academic period.
|
VARCHAR2(63)
|
CONSTANT SSBSECT
|
'NA' SSBSECT_PTRM_CODE
|
NO NO
|
NO
|
SUB_ACADEMIC_PERIOD_DESC
|
Description for the part of academic period.
|
VARCHAR2(255)
|
CONSTANT STVPTRM
|
'NOT APPLICABLE' STVPTRM_DESC
|
NO NO
|
NO
|
TEMPLATE_DESC
|
Free-format description of plan from third party plan.
|
VARCHAR2(255)
|
SEP_TMPL_MST
|
DESCRIPTION
|
NO
|
NO
|
TEMPLATE_ID
|
Identifier for template used for the person, academic period and plan.
|
VARCHAR2(63)
|
CONSTANT SEP_TMPL_MST
|
'NA' TEMPLATE_ID
|
NO NO
|
NO
|
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
|
NO NO
|
NO
|
TRACKING_STATUS_DESC
|
Description for the tracking status for the plan in the academic period.
|
VARCHAR2(255)
|
CALCULATION
|
CASE WHEN TRACKING_STATUS
|
NO
|
NO
|