Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Student Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AS_COURSE_OFFERING_FEES

Description Source composite view contains all of the fees that will be charged when a student registers for this section. This may include a flat fee for the section or an amount charge per each credit registered for this 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(6)

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(30)

STVTERM

STVTERM_DESC

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

SSRFEES

SSRFEES_ACTIVITY_DATE

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

TBBDETC

TBBDETC_DCAT_CODE

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

TTVDCAT

TTVDCAT_DESC

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

SSRFEES

SSRFEES_CRN

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DETAIL_CODE This field defines the detail code of the specific fee(s) you are creating for the course section. VARCHAR2(4)

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(30)

TBBDETC

TBBDETC_DESC

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

FEE_AMOUNT This field defines the amount of the fee you are creating for the course section. NUMBER(12,2)

SSRFEES

SSRFEES_AMOUNT

FEE_ASSESSMENT_TYPE This field is used to identify the type of fee to fee assessment. VARCHAR2(4)

SSRFEES

SSRFEES_FTYP_CODE

FEE_ASSESSMENT_TYPE_DESC This field is used to identify the description of the type of fee to fee assessment. VARCHAR2(30)

STVFTYP

STVFTYP_DESC

FEE_LEVEL This field identifies the level code that the fee is defined for VARCHAR2(2)

SSRFEES

SSRFEES_LEVL_CODE

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

STVLEVL

STVLEVL_DESC

FEE_METHOD_CONVERSION_IND 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(1)

SSRFEES

SSRFEES_FEE_IND_IND

FEE_METHOD_IND 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

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

NA

NA

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

NA

NA

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

NA

NA



Ver: 8.0