Reporting View Target: COURSE_OFFERING

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 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.

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.1

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.

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