Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACADEMIC_PERIOD	Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.	VARCHAR2(63)	SSRFEES	SSRFEES_TERM_CODE	NO	NO
ACADEMIC_PERIOD_ADMITTED	Specifies the fee is to be assessed for students admitted in this academic period.	VARCHAR2(63)	SSRFEES	SSRFEES_TERM_CODE_ADMIT	NO	NO
ACADEMIC_PERIOD_ADMITTED_DESC	Student admit academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC	NO	NO
ACADEMIC_PERIOD_DESC	This field defines the description of the term for which you are creating the course section fee.	VARCHAR2(255)	STVTERM	STVTERM_DESC	NO	NO
ACTIVITY_DATE	This field contains the most current date the record was added or changed.	DATE	SSRFEES	SSRFEES_ACTIVITY_DATE	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
CAMPUS	Specifies the fee is to be assessed when the persons' curriculum has this campus.	VARCHAR2(63)	SSRFEES	SSRFEES_CAMP_CODE	NO	NO
CAMPUS_DESC	Campus description.	VARCHAR2(255)	STVCAMP	STVCAMP_DESC	NO	NO
CATEGORY	The category code associated with the detail code for this section fee.	VARCHAR2(63)	TBBDETC	TBBDETC_DCAT_CODE	NO	NO
CATEGORY_DESC	The description of the category code associated with the detail code for this section fee.	VARCHAR2(255)	TTVDCAT	TTVDCAT_DESC	NO	NO
COLLEGE	Specifies the fee is to be assessed when the persons' curriculum has this college.	VARCHAR2(63)	SSRFEES	SSRFEES_COLL_CODE	NO	NO
COLLEGE_DESC	College description.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC	NO	NO
COURSE_FEE_SEQUENCE_NUMBER	Sequence number assigned by the system as this course offering fee assessment rule was begun.	NUMBER	SSRFEES	SSRFEES_SEQ_NO	NO	NO
COURSE_IDENTIFICATION	Course subject and course number combined.	VARCHAR2(255)	CALCULATION	SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB	NO	NO
COURSE_OFFERING_FEE_USER	User who inserted or last updated this course offering fee assessment rule.	VARCHAR2(63)	SSRFEES	SSRFEES_USER_ID	NO	NO
COURSE_REFERENCE_NUMBER	This field defines the course reference number for which you are creating the course section fee.	VARCHAR2(5)	SSRFEES	SSRFEES_CRN	NO	NO
CURRICULUM_STUDENT_POPULATION	Specifies the fee is to be assessed when student has this student population.	VARCHAR2(63)	SSRFEES	SSRFEES_STYP_CODE_CURRIC	NO	NO
CURRICULUM_STUDENT_POP_DESC	Student population description.	VARCHAR2(255)	STVSTYP	STVSTYP_DESC	NO	NO
CURRICULUM_STUDENT_RATE	Specifies the fee is to be assessed when student has this student rate on their academic study record.	VARCHAR2(63)	SSRFEES	SSRFEES_RATE_CODE_CURRIC	NO	NO
CURRICULUM_STUDENT_RATE_DESC	Curriculum student rate description.	VARCHAR2(255)	STVRATE	STVRATE_DESC	NO	NO
CURRICULUM_TYPE	Identifies whether this fee rule should look for curriculum values specified only in the primary curriculum. Or if the secondary or any curriculum values for the person should be used to determine when to assess this fee.	VARCHAR2(63)	SSRFEES	SSRFEES_PRIM_SEC_CDE	NO	NO
CURRICULUM_TYPE_DESC	Curriculum type to use description.	VARCHAR2(255)	DECODE OR FUNCTION	DECODE (SSRFEES_PRIM_SEC_CDE) 'P','PRIMARY CURRICULUM ONLY', 'S', 'SECONDARY CURRICULUM ONLY', 'A', 'ANY CURRICULUM')	NO	NO
DEGREE	Specifies the fee is to be assessed when the persons' curriculum has this degree or outcome value.	VARCHAR2(63)	SSRFEES	SSRFEES_DEGC_CODE	NO	NO
DEGREE_DESC	Degree description.	VARCHAR2(255)	STVDEGC	STVDEGC_DESC	NO	NO
DEPARTMENT	Specifies the fee is to be assessed when the persons' curriculum has this department.	VARCHAR2(63)	SSRFEES	SSRFEES_DEPT_CODE	NO	NO
DEPARTMENT_DESC	Department description.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC	NO	NO
DETAIL_CODE	This field defines the detail code of the specific fee(s) you are creating for the course section.	VARCHAR2(63)	SSRFEES	SSRFEES_DETL_CODE	NO	NO
DETAIL_CODE_DESC	This field defines the description of the detail code of the specific fee(s) you are creating for the course section.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC	NO	NO
FEE_AMOUNT	This field defines the amount of the fee you are creating for the course section.	NUMBER	SSRFEES	SSRFEES_AMOUNT	NO	NO
FEE_LEVEL	Identifies the level code of the course when this fee is to be assessed.	VARCHAR2(63)	SSRFEES	SSRFEES_LEVL_CODE	NO	NO
FEE_LEVEL_DESC	Fee course level description.	VARCHAR2(255)	STVLEVL	STVLEVL_DESC	NO	NO
FEE_METHOD	This column is obsolete and no longer populated in Banner Student.	VARCHAR2(1)	SSRFEES	SSRFEES_FEE_IND	NO	NO
FEE_METHOD_CONVERTER	This column is obsolete and no longer populated in Banner Student.	NUMBER	SSRFEES	SSRFEES_FEE_IND_IND	NO	NO
FEE_METHOD_DESC	This column is obsolete and no longer populated in Banner Student.	VARCHAR2(255)	CALCULATION	DECODE(SSRFEES_FEE_IND)	NO	NO
FEE_TYPE	This field is used to identify the type of fee to fee assessment.	VARCHAR2(63)	SSRFEES	SSRFEES_FTYP_CODE	NO	NO
FEE_TYPE_DESC	Fee assessment type description.	VARCHAR2(255)	STVFTYP	STVFTYP_DESC	NO	NO
MAJOR	Specifies the fee is to be assessed when the persons' curriculum has this major.	VARCHAR2(63)	SSRFEES	SSRFEES_MAJR_CODE	NO	NO
MAJOR_DESC	Major description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	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	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
PROGRAM	Specifies the fee is to be assessed when the persons' curriculum has this program.	VARCHAR2(63)	SSRFEES	SSRFEES_PROGRAM	NO	NO
PROGRAM_DESC	Program description.	VARCHAR2(255)	SMRPRLE	SMRPRLE_PROGRAM_DESC	NO	NO
RESIDENCY	Specifies the fee is to be assessed when the person has this residency code.	VARCHAR2(63)	SSRFEES	SSRFEES_RESD_CODE	NO	NO
RESIDENCY_DESC	Residency code description.	VARCHAR2(255)	STVRESD	STVRESD_DESC	NO	NO
STUDENT_ATTRIBUTE	Specifies the fee is to be assessed when student has this student attribute.	VARCHAR2(63)	SSRFEES	SSRFEES_ATTS_CODE	NO	NO
STUDENT_ATTRIBUTE_DESC	Student attribute description.	VARCHAR2(255)	STVATTS	STVATTS_DESC	NO	NO
STUDENT_CLASSIFICATION	Specifies the fee is to be assessed when the person has this student classification code.	VARCHAR2(63)	SSRFEES	SSRFEES_CLAS_CODE	NO	NO
STUDENT_CLASSIFICATION_DESC	Student Classification code description.	VARCHAR2(255)	STVCLAS	STVCLAS_DESC	NO	NO
STUDENT_COHORT	Specifies the fee is to be assessed when student has this student cohort.	VARCHAR2(63)	SSRFEES	SSRFEES_CHRT_CODE	NO	NO
STUDENT_COHORT_DESC	Student cohort description.	VARCHAR2(255)	STVCHRT	STVCHRT_DESC	NO	NO
STUDENT_LEVEL	Specifies the fee is to be assessed when the persons' curriculum has this student level.	VARCHAR2(63)	SSRFEES	SSRFEES_LEVL_CODE_STDN	NO	NO
STUDENT_LEVEL_DESC	Student level description	VARCHAR2(255)	STVLEVL	STVLEVL_DESC	NO	NO
STUDENT_POPULATION	Specifies the fee is to be assessed when student has this student population.	VARCHAR2(63)	SSRFEES	SSRFEES_STYP_CODE	NO	NO
STUDENT_POPULATION_DESC	Student population description.	VARCHAR2(255)	STVSTYP	STVSTYP_DESC	NO	NO
STUDENT_RATE	Specifies the fee is to be assessed when student has this student rate on their student record.	VARCHAR2(63)	SSRFEES	SSRFEES_RATE_CODE	NO	NO
STUDENT_RATE_DESC	Student rate description.	VARCHAR2(255)	STVRATE	STVRATE_DESC	NO	NO
VISA	Specifies the fee is to be assessed when students' current visa is this visa type.	VARCHAR2(63)	SSRFEES	SSRFEES_VTYP_CODE	NO	NO
VISA_DESC	Visa code description.	VARCHAR2(255)	STVVTYP	STVVTYP_DESC	NO	NO

Ver: 9.2