Go To View:  RETURN TO REPORTING VIEW 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 course based or section 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.

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD This field defines the term for which you are creating the course section fee. VARCHAR2(63)

SSRFEES

SSRFEES_TERM_CODE

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 Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

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

CALCULATION

SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB

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

SSRFEES

SSRFEES_CRN

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 This field identifies the level code that the fee is defined for VARCHAR2(63)

SSRFEES

SSRFEES_LEVL_CODE

FEE_LEVEL_DESC This field identifies the description of the level code that the fee is defined for VARCHAR2(255)

STVLEVL

STVLEVL_DESC

FEE_METHOD This field is used to specify whether the course fee will be assessed on a per-credit hour basis (C) or on a flat basis (F). "C" and "F" are the only valid values. VARCHAR2(1)

SSRFEES

SSRFEES_FEE_IND

FEE_METHOD_CONVERTER This field does not display on this form. This field is used to convert the fee indicator of F - flat or C - per credit to a 1 or 0. "F" is converted to a "1" and "C" is converted to a "0". NUMBER

SSRFEES

SSRFEES_FEE_IND_IND

FEE_METHOD_DESC Description of the fee method. VARCHAR2(21)

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 This field is used to identify the description of the type of fee to fee assessment. VARCHAR2(255)

STVFTYP

STVFTYP_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



Ver: 8.0