| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
ACADEMIC_PERIOD
|
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
|
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Description for the academic period.
|
VARCHAR2(255)
|
|
STVTERM
|
STVTERM_DESC
|
|
ACADEMIC_PERIOD_KEY
|
Academic Period Key
|
Unique key to the third party product plan academic period.
|
VARCHAR2(63)
|
|
CONSTANT SEP_PLAN_TERM
|
'NA' TERM_ID
|
|
ACADEMIC_YEAR
|
Academic Year
|
Identifies the academic period for which the course or course section is planned for registration.
|
VARCHAR2(63)
|
|
STVTERM
|
STVTERM_ACYR_CODE
|
|
ACADEMIC_YEAR_DESC
|
Academic Year Description
|
Description for the academic period.
|
VARCHAR2(255)
|
|
STVACYR
|
STVACYR_DESC
|
|
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_ACTIVE_IND
|
Course Active Indicator
|
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
|
|
COURSE_ATTRIBUTE
|
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
|
|
COURSE_ATTRIBUTE_COUNT
|
Course Attribute Count
|
Number of course attributes associated with this course.
|
NUMBER
|
|
FUNCTION
|
MSKFUNC.F_COUNT_COURSE_ATTRIBUTES
|
|
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_PLAN_CLASS SFRPLAN
|
CAMPUS SFRPLAN_CAMP_CODE
|
|
COURSE_CAMPUS_DESC
|
Course Campus Description
|
Description for the campus.
|
VARCHAR2(255)
|
|
STVCAMP
|
STVCAMP_DESC
|
|
COURSE_COLLEGE
|
Course College
|
College, School or Faculty responsible for the instruction of this course or section.
|
VARCHAR2(63)
|
|
CONSTANT SFRPLAN
|
'NA' SFRPLAN_COLL_CODE
|
|
COURSE_COLLEGE_DESC
|
Course College Description
|
Description of the College, School or Faculty responsible for the instruction in the offering.
|
VARCHAR2(255)
|
|
STVCOLL
|
STVCOLL_DESC
|
|
COURSE_CREDITS
|
Course Credits
|
Credits associated with this course or course section.
|
NUMBER
|
|
SEP_PLAN_CLASS SFRPLAN
|
CREDITS SFRPLAN_CREDITS
|
|
COURSE_CRITICAL_IND
|
Course Critical Indicator
|
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
|
|
COURSE_DEPARTMENT
|
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
|
|
COURSE_DEPARTMENT_DESC
|
Course Department Description
|
Description of the department responsible for the instruction in the offering.
|
VARCHAR2(255)
|
|
CONSTANT STVDEPT
|
'NOT APPLICABLE' STVDEPT_DESC
|
|
COURSE_END_DATE
|
Course End Date
|
Date the section instruction ends for this section sub academic period.
|
DATE
|
|
CONSTANT SFRPLAN
|
'NA' SFRPLAN_COMPLETION_DATE
|
|
COURSE_GRADE_TYPE
|
Course Grade Type
|
Grade mode associated with the course of this section.
|
VARCHAR2(63)
|
|
CONSTANT SFRPLAN
|
'NA' SFRPLAN_GMOD_CODE
|
|
COURSE_GRADE_TYPE_COUNT
|
Course Grade Type Count
|
Number of grade types associated with this course or course offering.
|
NUMBER
|
|
FUNCTION
|
MSKFUNC.F_COUNT_GRADE_TYPE
|
|
COURSE_GRADE_TYPE_DESC
|
Course Grade Type Description
|
Description for the grade mode or type.
|
VARCHAR2(255)
|
|
STVGMOD
|
STVGMOD_DESC
|
|
COURSE_IDENTIFICATION
|
Course Identification
|
Course subject and course number combined.
|
VARCHAR2(255)
|
|
CALCULATION
|
SCBCRSE_SUBJ_CODE||SCBCRSE_CRSE_NUMB
|
|
COURSE_LEVEL
|
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
|
|
COURSE_LEVEL_DESC
|
Course Level Description
|
Description for the course level.
|
VARCHAR2(255)
|
|
STVLEVL
|
STVLEVL_DESC
|
|
COURSE_LOCKED_IND
|
Course Locked Indicator
|
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
|
|
COURSE_NUMBER
|
Course Number
|
Course number associated with the subject for the course.
|
VARCHAR2(63)
|
|
SEP_PLAN_CLASS SFRPLAN
|
COURSE_NUMBER SFRPLAN_CRSE_NUMB
|
|
COURSE_REFERENCE_NUMBER
|
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
|
|
COURSE_START_DATE
|
Course Start Date
|
Date the section instruction begins for this section sub academic period.
|
DATE
|
|
CONSTANT SFRPLAN
|
'NA' SFRPLAN_START_DATE
|
|
COURSE_SUBJECT
|
Course Subject
|
Main instructional subject or displace area for this course.
|
VARCHAR2(63)
|
|
SEP_PLAN_CLASS SFRPLAN
|
COURSE_DISCIPLINE SFRPLAN_SUBJ_CDE
|
|
COURSE_SUBJECT_DESC
|
Course Subject Description
|
Description of the subject area for this course
|
VARCHAR2(255)
|
|
STVSUBJ
|
STVSUBJ_DESC
|
|
ID
|
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
|
|
MINIMUM_GRADE
|
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
|
|
MULTI_SOURCE
|
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
|
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
NAME
|
Name
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
|
RAD_PRIMARY_MST SFRPLAN
|
RAD_USER_DEF1 SFRPLAN_PIDM
|
|
PLAN_COMMENT
|
Plan Comment
|
Comments attached to the base registration plan record.
|
VARCHAR2(4000)
|
|
CONSTANT SFRPLAN
|
'NA' SFRPLAN_COMMENT
|
|
PLAN_COMMENT_EXISTS_IND
|
Plan Comment Exists Indicator
|
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
|
|
PLAN_COURSE_ACTIVITY_DATE
|
Plan Course Activity Date
|
Date record was inserted or last updated.
|
DATE
|
|
SEP_PLAN_CLASS SFRPLAN
|
MODIFY_DATE SFRPLAN_ACTIVITY_DATE
|
|
PLAN_COURSE_CREATE_DATA_ORIGIN
|
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
|
|
PLAN_COURSE_CREATE_DATE
|
Plan Course Create Date
|
Date plan was created.
|
DATE
|
|
SEP_PLAN_CLASS SFRPLAN
|
CREATE_DATE SFRPLAN_ACTIVITY_DATE
|
|
PLAN_COURSE_CREATOR_ID
|
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
|
|
PLAN_COURSE_CREATOR_NAME
|
Plan Course Creator Name
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
PLAN_COURSE_CREATOR_UID
|
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
|
|
PLAN_COURSE_DATA_ORIGIN
|
Plan Course Data Origin
|
Source system or process that created or updated data.
|
VARCHAR2(63)
|
|
SEP_PLAN_CLASS SFRPLAN
|
MODIFY_WHAT SFRPLAN_DATA_ORIGIN
|
|
PLAN_COURSE_HONORS_IND
|
Plan Course Honors Indicator
|
Indicates whether or not the courses in this group must be taken for honors.
|
VARCHAR2(2)
|
|
CONSTANT SEP_PLAN_CLASS
|
'NA' IS_HONORS
|
|
PLAN_COURSE_KEY
|
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
|
|
PLAN_COURSE_SEQUENCE_NUMBER
|
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
|
|
PLAN_COURSE_SOURCE
|
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
|
|
PLAN_COURSE_SOURCE_DESC
|
Plan Course Source Description
|
Description for the source system for this registration plan course record.
|
VARCHAR2(255)
|
|
CALCULATION
|
DECODE(SFRPLAN_SRC_CDE)
|
|
PLAN_COURSE_USER_ID
|
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
|
|
PLAN_COURSE_USER_NAME
|
Plan Course User Name
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
PLAN_COURSE_USER_UID
|
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
|
|
PLAN_COURSE_VERSION_NUMBER
|
Plan Course Version Number
|
Incremented number used for optimistic locking.
|
NUMBER
|
|
CONSTANT SFRPLAN
|
1 SFRPLAN_VERSION
|
|
PLAN_DESC
|
Plan Description
|
Free-format description of the registration plan.
|
VARCHAR2(255)
|
|
SEP_PLAN_CLASS SFBPLAN
|
DESCRIPTION SFBPLAN_DESCRIPTION
|
|
PLAN_GROUP_KEY
|
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
|
|
PLAN_GROUP_TYPE
|
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
|
|
PLAN_GROUP_TYPE_DESC
|
Plan 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 CONSTANT
|
DECODE(GROUP_TYPE) 'NOT APPLICABLE'
|
|
PLAN_KEY
|
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
|
|
PLAN_SEQUENCE_NUMBER
|
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
|
|
PROCESS_GROUP
|
Process Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
PROJECTED_SEAT_NEEDED
|
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)
|
|
SCHEDULE_COUNT
|
Schedule Count
|
Number of course schedule or delivery methods associated with this course or course offering.
|
NUMBER
|
|
FUNCTION
|
MSKFUNC.F_COUNT_COURSE_SCHEDULE
|
|
SCHEDULE_TYPE
|
Schedule Type
|
Schedule or instructional type description for the course or for a section.
|
VARCHAR2(63)
|
|
SEP_PLAN_CLASS SFRPLAN
|
DELIVERY SFRPLAN_SCHD_CODE
|
|
SCHEDULE_TYPE_DESC
|
Schedule Type Description
|
Description for a schedule type or instructional type for a course or section.
|
VARCHAR2(255)
|
|
STVSCHD
|
STVSCHD_DESC
|
|
SUB_ACADEMIC_PERIOD
|
Sub Academic Period
|
A session, portion or part of the academic period.
|
VARCHAR2(63)
|
|
CONSTANT SSBSECT
|
'NA' SSBSECT_PTRM_CODE
|
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub Academic Period Description
|
Description for the part of academic period.
|
VARCHAR2(255)
|
|
CONSTANT STVPTRM
|
'NOT APPLICABLE' STVPTRM_DESC
|
|
TEMPLATE_DESC
|
Template Description
|
Free-format description of plan from third party plan.
|
VARCHAR2(255)
|
|
SEP_TMPL_MST
|
DESCRIPTION
|
|
TEMPLATE_ID
|
Template ID
|
Identifier for template used for the person, academic period and plan.
|
VARCHAR2(63)
|
|
CONSTANT SEP_TMPL_MST
|
'NA' TEMPLATE_ID
|
|
TRACKING_STATUS
|
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
|
|
TRACKING_STATUS_DESC
|
Tracking Status Description
|
Description for the tracking status for the plan in the academic period.
|
VARCHAR2(255)
|
|
CALCULATION
|
CASE WHEN TRACKING_STATUS
|