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