Reporting View Target: COURSE_OFFERING

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Student Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: COURSE_OFFERING_FEES

Description Contains detail data about a section (schedule offering) of a course (subject and course number) when it has associated section-based or course-based specific fees for a specific academic period. Details include whether the fee is a flat fee or an amount per credit for the course.
Key & Frequency One record per academic term per detail code per fee assessment type per level code.
Recommended Search Columns ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER
ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER, DETAIL_CODE, FEE_LEVEL
DETAIL_CODE, ACADEMIC_PERIOD

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ACADEMIC_PERIOD Academic Period This field defines the term for which you are creating the course section fee. VARCHAR2(63)
SSRFEES

SSRFEES_TERM_CODE

ACADEMIC_PERIOD_ADMITTED Academic Period Admitted Specifies the fee is to be assessed for students admitted in this academic period. VARCHAR2(63)
SSRFEES

SSRFEES_TERM_CODE_ADMIT

ACADEMIC_PERIOD_ADMITTED_DESC Academic Period Admitted Description Student admit academic period description. VARCHAR2(255)
STVTERM

STVTERM_DESC

ACADEMIC_PERIOD_DESC Academic Period Description This field defines the description of the term for which you are creating the course section fee. VARCHAR2(255)
STVTERM

STVTERM_DESC

ACTIVITY_DATE Activity Date This field contains the most current date the record was added or changed. DATE
SSRFEES

SSRFEES_ACTIVITY_DATE

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

CAMPUS Campus Specifies the fee is to be assessed when the persons' curriculum has this campus. VARCHAR2(63)
SSRFEES

SSRFEES_CAMP_CODE

CAMPUS_DESC Campus Description Campus description. VARCHAR2(255)
STVCAMP

STVCAMP_DESC

CATEGORY Category The category code associated with the detail code for this section fee. VARCHAR2(63)
TBBDETC

TBBDETC_DCAT_CODE

CATEGORY_DESC Category Description The description of the category code associated with the detail code for this section fee. VARCHAR2(255)
TTVDCAT

TTVDCAT_DESC

COLLEGE College Specifies the fee is to be assessed when the persons' curriculum has this college. VARCHAR2(63)
SSRFEES

SSRFEES_COLL_CODE

COLLEGE_DESC College Description College description. VARCHAR2(255)
STVCOLL

STVCOLL_DESC

COURSE_FEE_SEQUENCE_NUMBER Course Fee Sequence Number Sequence number assigned by the system as this course offering fee assessment rule was begun. NUMBER
SSRFEES

SSRFEES_SEQ_NO

COURSE_IDENTIFICATION Course ID Combined subject code and course number that identifies the instructional content of this course. VARCHAR2(255)
CALCULATION

SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB

COURSE_OFFERING_FEE_USER Course Offering Fee User User who inserted or last updated this course offering fee assessment rule. VARCHAR2(63)
SSRFEES

SSRFEES_USER_ID

COURSE_REFERENCE_NUMBER Course Reference Number This field defines the course reference number for which you are creating the course section fee. VARCHAR2(5)
SSRFEES

SSRFEES_CRN

CURRICULUM_STUDENT_POPULATION Curriculum Student Population Specifies the fee is to be assessed when student has this student population. VARCHAR2(63)
SSRFEES

SSRFEES_STYP_CODE_CURRIC

CURRICULUM_STUDENT_POP_DESC Curriculum Student Pop Description Student population description. VARCHAR2(255)
STVSTYP

STVSTYP_DESC

CURRICULUM_STUDENT_RATE 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

CURRICULUM_STUDENT_RATE_DESC Curriculum Student Rate Description Curriculum student rate description. VARCHAR2(255)
STVRATE

STVRATE_DESC

CURRICULUM_TYPE 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

CURRICULUM_TYPE_DESC Curriculum Type Description 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')

DEGREE Degree Specifies the fee is to be assessed when the persons' curriculum has this degree or outcome value. VARCHAR2(63)
SSRFEES

SSRFEES_DEGC_CODE

DEGREE_DESC Degree Description Degree description. VARCHAR2(255)
STVDEGC

STVDEGC_DESC

DEPARTMENT Department Specifies the fee is to be assessed when the persons' curriculum has this department. VARCHAR2(63)
SSRFEES

SSRFEES_DEPT_CODE

DEPARTMENT_DESC Department Description Department description. VARCHAR2(255)
STVDEPT

STVDEPT_DESC

DETAIL_CODE 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

DETAIL_CODE_DESC Detail Code Description 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

FEE_AMOUNT Fee Amount This field defines the amount of the fee you are creating for the course section. NUMBER
SSRFEES

SSRFEES_AMOUNT

FEE_LEVEL Fee Level Identifies the level code of the course when this fee is to be assessed. VARCHAR2(63)
SSRFEES

SSRFEES_LEVL_CODE

FEE_LEVEL_DESC Fee Level Description Fee course level description. VARCHAR2(255)
STVLEVL

STVLEVL_DESC

FEE_METHOD Fee Method This column is obsolete and no longer populated in Banner Student. VARCHAR2(1)
SSRFEES

SSRFEES_FEE_IND

FEE_METHOD_CONVERTER Fee Method Converter This column is obsolete and no longer populated in Banner Student. NUMBER
SSRFEES

SSRFEES_FEE_IND_IND

FEE_METHOD_DESC Fee Method Description This column is obsolete and no longer populated in Banner Student. VARCHAR2(255)
CALCULATION

DECODE(SSRFEES_FEE_IND)

FEE_TYPE Fee Type This field is used to identify the type of fee to fee assessment. VARCHAR2(63)
SSRFEES

SSRFEES_FTYP_CODE

FEE_TYPE_DESC Fee Type Description Fee assessment type description. VARCHAR2(255)
STVFTYP

STVFTYP_DESC

MAJOR Major Specifies the fee is to be assessed when the persons' curriculum has this major. VARCHAR2(63)
SSRFEES

SSRFEES_MAJR_CODE

MAJOR_DESC Major Description Major description. VARCHAR2(255)
STVMAJR

STVMAJR_DESC

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)
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 Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

PROGRAM Program Specifies the fee is to be assessed when the persons' curriculum has this program. VARCHAR2(63)
SSRFEES

SSRFEES_PROGRAM

PROGRAM_DESC Program Description Program description. VARCHAR2(255)
SMRPRLE

SMRPRLE_PROGRAM_DESC

RESIDENCY Residency Specifies the fee is to be assessed when the person has this residency code. VARCHAR2(63)
SSRFEES

SSRFEES_RESD_CODE

RESIDENCY_DESC Residency Description Residency code description. VARCHAR2(255)
STVRESD

STVRESD_DESC

STUDENT_ATTRIBUTE Student Attribute Specifies the fee is to be assessed when student has this student attribute. VARCHAR2(63)
SSRFEES

SSRFEES_ATTS_CODE

STUDENT_ATTRIBUTE_DESC Student Attribute Description Student attribute description. VARCHAR2(255)
STVATTS

STVATTS_DESC

STUDENT_CLASSIFICATION Student Classification Specifies the fee is to be assessed when the person has this student classification code. VARCHAR2(63)
SSRFEES

SSRFEES_CLAS_CODE

STUDENT_CLASSIFICATION_DESC Student Classification Description Student Classification code description. VARCHAR2(255)
STVCLAS

STVCLAS_DESC

STUDENT_COHORT Student Cohort Specifies the fee is to be assessed when student has this student cohort. VARCHAR2(63)
SSRFEES

SSRFEES_CHRT_CODE

STUDENT_COHORT_DESC Student Cohort Description Student cohort description. VARCHAR2(255)
STVCHRT

STVCHRT_DESC

STUDENT_LEVEL Student Level Specifies the fee is to be assessed when the persons' curriculum has this student level. VARCHAR2(63)
SSRFEES

SSRFEES_LEVL_CODE_STDN

STUDENT_LEVEL_DESC Student Level Description Student level description VARCHAR2(255)
STVLEVL

STVLEVL_DESC

STUDENT_POPULATION Student Population Specifies the fee is to be assessed when student has this student population. VARCHAR2(63)
SSRFEES

SSRFEES_STYP_CODE

STUDENT_POPULATION_DESC Student Population Description Student population description. VARCHAR2(255)
STVSTYP

STVSTYP_DESC

STUDENT_RATE 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

STUDENT_RATE_DESC Student Rate Description Student rate description. VARCHAR2(255)
STVRATE

STVRATE_DESC

VISA Visa Specifies the fee is to be assessed when students' current visa is this visa type. VARCHAR2(63)
SSRFEES

SSRFEES_VTYP_CODE

VISA_DESC Visa Description Visa code description. VARCHAR2(255)
STVVTYP

STVVTYP_DESC

Ver: 9.0

Description	Contains detail data about a section (schedule offering) of a course (subject and course number) when it has associated section-based or course-based specific fees for a specific academic period. Details include whether the fee is a flat fee or an amount per credit for the course.
Key & Frequency	One record per academic term per detail code per fee assessment type per level code.
Recommended Search Columns	ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER, DETAIL_CODE, FEE_LEVEL DETAIL_CODE, ACADEMIC_PERIOD

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic Period	This field defines the term for which you are creating the course section fee.	VARCHAR2(63)	SSRFEES	SSRFEES_TERM_CODE
ACADEMIC_PERIOD_ADMITTED	Academic Period Admitted	Specifies the fee is to be assessed for students admitted in this academic period.	VARCHAR2(63)	SSRFEES	SSRFEES_TERM_CODE_ADMIT
ACADEMIC_PERIOD_ADMITTED_DESC	Academic Period Admitted Description	Student admit academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_PERIOD_DESC	Academic Period Description	This field defines the description of the term for which you are creating the course section fee.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACTIVITY_DATE	Activity Date	This field contains the most current date the record was added or changed.	DATE	SSRFEES	SSRFEES_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CAMPUS	Campus	Specifies the fee is to be assessed when the persons' curriculum has this campus.	VARCHAR2(63)	SSRFEES	SSRFEES_CAMP_CODE
CAMPUS_DESC	Campus Description	Campus description.	VARCHAR2(255)	STVCAMP	STVCAMP_DESC
CATEGORY	Category	The category code associated with the detail code for this section fee.	VARCHAR2(63)	TBBDETC	TBBDETC_DCAT_CODE
CATEGORY_DESC	Category Description	The description of the category code associated with the detail code for this section fee.	VARCHAR2(255)	TTVDCAT	TTVDCAT_DESC
COLLEGE	College	Specifies the fee is to be assessed when the persons' curriculum has this college.	VARCHAR2(63)	SSRFEES	SSRFEES_COLL_CODE
COLLEGE_DESC	College Description	College description.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC
COURSE_FEE_SEQUENCE_NUMBER	Course Fee Sequence Number	Sequence number assigned by the system as this course offering fee assessment rule was begun.	NUMBER	SSRFEES	SSRFEES_SEQ_NO
COURSE_IDENTIFICATION	Course ID	Combined subject code and course number that identifies the instructional content of this course.	VARCHAR2(255)	CALCULATION	SSBSECT_SUBJ_CODE\|\|SSBSECT_CRSE_NUMB
COURSE_OFFERING_FEE_USER	Course Offering Fee User	User who inserted or last updated this course offering fee assessment rule.	VARCHAR2(63)	SSRFEES	SSRFEES_USER_ID
COURSE_REFERENCE_NUMBER	Course Reference Number	This field defines the course reference number for which you are creating the course section fee.	VARCHAR2(5)	SSRFEES	SSRFEES_CRN
CURRICULUM_STUDENT_POPULATION	Curriculum Student Population	Specifies the fee is to be assessed when student has this student population.	VARCHAR2(63)	SSRFEES	SSRFEES_STYP_CODE_CURRIC
CURRICULUM_STUDENT_POP_DESC	Curriculum Student Pop Description	Student population description.	VARCHAR2(255)	STVSTYP	STVSTYP_DESC
CURRICULUM_STUDENT_RATE	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
CURRICULUM_STUDENT_RATE_DESC	Curriculum Student Rate Description	Curriculum student rate description.	VARCHAR2(255)	STVRATE	STVRATE_DESC
CURRICULUM_TYPE	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
CURRICULUM_TYPE_DESC	Curriculum Type Description	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')
DEGREE	Degree	Specifies the fee is to be assessed when the persons' curriculum has this degree or outcome value.	VARCHAR2(63)	SSRFEES	SSRFEES_DEGC_CODE
DEGREE_DESC	Degree Description	Degree description.	VARCHAR2(255)	STVDEGC	STVDEGC_DESC
DEPARTMENT	Department	Specifies the fee is to be assessed when the persons' curriculum has this department.	VARCHAR2(63)	SSRFEES	SSRFEES_DEPT_CODE
DEPARTMENT_DESC	Department Description	Department description.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC
DETAIL_CODE	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
DETAIL_CODE_DESC	Detail Code Description	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
FEE_AMOUNT	Fee Amount	This field defines the amount of the fee you are creating for the course section.	NUMBER	SSRFEES	SSRFEES_AMOUNT
FEE_LEVEL	Fee Level	Identifies the level code of the course when this fee is to be assessed.	VARCHAR2(63)	SSRFEES	SSRFEES_LEVL_CODE
FEE_LEVEL_DESC	Fee Level Description	Fee course level description.	VARCHAR2(255)	STVLEVL	STVLEVL_DESC
FEE_METHOD	Fee Method	This column is obsolete and no longer populated in Banner Student.	VARCHAR2(1)	SSRFEES	SSRFEES_FEE_IND
FEE_METHOD_CONVERTER	Fee Method Converter	This column is obsolete and no longer populated in Banner Student.	NUMBER	SSRFEES	SSRFEES_FEE_IND_IND
FEE_METHOD_DESC	Fee Method Description	This column is obsolete and no longer populated in Banner Student.	VARCHAR2(255)	CALCULATION	DECODE(SSRFEES_FEE_IND)
FEE_TYPE	Fee Type	This field is used to identify the type of fee to fee assessment.	VARCHAR2(63)	SSRFEES	SSRFEES_FTYP_CODE
FEE_TYPE_DESC	Fee Type Description	Fee assessment type description.	VARCHAR2(255)	STVFTYP	STVFTYP_DESC
MAJOR	Major	Specifies the fee is to be assessed when the persons' curriculum has this major.	VARCHAR2(63)	SSRFEES	SSRFEES_MAJR_CODE
MAJOR_DESC	Major Description	Major description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	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	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROGRAM	Program	Specifies the fee is to be assessed when the persons' curriculum has this program.	VARCHAR2(63)	SSRFEES	SSRFEES_PROGRAM
PROGRAM_DESC	Program Description	Program description.	VARCHAR2(255)	SMRPRLE	SMRPRLE_PROGRAM_DESC
RESIDENCY	Residency	Specifies the fee is to be assessed when the person has this residency code.	VARCHAR2(63)	SSRFEES	SSRFEES_RESD_CODE
RESIDENCY_DESC	Residency Description	Residency code description.	VARCHAR2(255)	STVRESD	STVRESD_DESC
STUDENT_ATTRIBUTE	Student Attribute	Specifies the fee is to be assessed when student has this student attribute.	VARCHAR2(63)	SSRFEES	SSRFEES_ATTS_CODE
STUDENT_ATTRIBUTE_DESC	Student Attribute Description	Student attribute description.	VARCHAR2(255)	STVATTS	STVATTS_DESC
STUDENT_CLASSIFICATION	Student Classification	Specifies the fee is to be assessed when the person has this student classification code.	VARCHAR2(63)	SSRFEES	SSRFEES_CLAS_CODE
STUDENT_CLASSIFICATION_DESC	Student Classification Description	Student Classification code description.	VARCHAR2(255)	STVCLAS	STVCLAS_DESC
STUDENT_COHORT	Student Cohort	Specifies the fee is to be assessed when student has this student cohort.	VARCHAR2(63)	SSRFEES	SSRFEES_CHRT_CODE
STUDENT_COHORT_DESC	Student Cohort Description	Student cohort description.	VARCHAR2(255)	STVCHRT	STVCHRT_DESC
STUDENT_LEVEL	Student Level	Specifies the fee is to be assessed when the persons' curriculum has this student level.	VARCHAR2(63)	SSRFEES	SSRFEES_LEVL_CODE_STDN
STUDENT_LEVEL_DESC	Student Level Description	Student level description	VARCHAR2(255)	STVLEVL	STVLEVL_DESC
STUDENT_POPULATION	Student Population	Specifies the fee is to be assessed when student has this student population.	VARCHAR2(63)	SSRFEES	SSRFEES_STYP_CODE
STUDENT_POPULATION_DESC	Student Population Description	Student population description.	VARCHAR2(255)	STVSTYP	STVSTYP_DESC
STUDENT_RATE	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
STUDENT_RATE_DESC	Student Rate Description	Student rate description.	VARCHAR2(255)	STVRATE	STVRATE_DESC
VISA	Visa	Specifies the fee is to be assessed when students' current visa is this visa type.	VARCHAR2(63)	SSRFEES	SSRFEES_VTYP_CODE
VISA_DESC	Visa Description	Visa code description.	VARCHAR2(255)	STVVTYP	STVVTYP_DESC