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 and if any curriculum values were used in the rule to assess this fee.
Key & Frequency One record per academic term per course offering per detail code per sequence number.
Recommended Search Columns DETAIL_CODE, ACADEMIC_PERIOD
ACADEMIC_PERIOD, COURSE_REFERENCE_NUMBER, DETAIL_CODE, FEE_LEVEL

Target Column Business Definition Database Data Type Source Name Source Column
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

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 Student admit academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

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

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

SSRFEES

SSRFEES_ACTIVITY_DATE

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

NA

NA

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. VARCHAR2(255)

STVCAMP

STVCAMP_DESC

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

TBBDETC

TBBDETC_DCAT_CODE

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

TTVDCAT

TTVDCAT_DESC

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. VARCHAR2(255)

STVCOLL

STVCOLL_DESC

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 subject and course number combined. VARCHAR2(255)

CALCULATION

SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB

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 This field defines the course reference number for which you are creating the course section fee. VARCHAR2(5)

SSRFEES

SSRFEES_CRN

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 Student population description. VARCHAR2(255)

STVSTYP

STVSTYP_DESC

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. VARCHAR2(255)

STVRATE

STVRATE_DESC

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 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 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. VARCHAR2(255)

STVDEGC

STVDEGC_DESC

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. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

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 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 This field defines the amount of the fee you are creating for the course section. NUMBER

SSRFEES

SSRFEES_AMOUNT

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 course level description. VARCHAR2(255)

STVLEVL

STVLEVL_DESC

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

SSRFEES

SSRFEES_FEE_IND

FEE_METHOD_CONVERTER This column is obsolete and no longer populated in Banner Student. NUMBER

SSRFEES

SSRFEES_FEE_IND_IND

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

CALCULATION

DECODE(SSRFEES_FEE_IND)

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 assessment type description. VARCHAR2(255)

STVFTYP

STVFTYP_DESC

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. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

SSRFEES

SSRFEES_PROGRAM

PROGRAM_DESC Program description. VARCHAR2(255)

SMRPRLE

SMRPRLE_PROGRAM_DESC

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

SSRFEES

SSRFEES_RESD_CODE

RESIDENCY_DESC Residency code description. VARCHAR2(255)

STVRESD

STVRESD_DESC

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. VARCHAR2(255)

STVATTS

STVATTS_DESC

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 code description. VARCHAR2(255)

STVCLAS

STVCLAS_DESC

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. VARCHAR2(255)

STVCHRT

STVCHRT_DESC

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 VARCHAR2(255)

STVLEVL

STVLEVL_DESC

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. VARCHAR2(255)

STVSTYP

STVSTYP_DESC

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. VARCHAR2(255)

STVRATE

STVRATE_DESC

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 code description. VARCHAR2(255)

STVVTYP

STVVTYP_DESC



Ver: 8.5