Go To View:  RETURN TO BANNER COMP META DATA 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.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACADEMIC_PERIOD This field defines the term for which you are creating the course section fee.    

SSRFEES

SSRFEES_TERM_CODE

 
ACADEMIC_PERIOD_DESC This field defines the description of the term for which you are creating the course section fee.    

STVTERM

STVTERM_DESC

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

SSRFEES

SSRFEES_ACTIVITY_DATE

 
CATEGORY The category code associated with the detail code for this section fee.    

TBBDETC

TBBDETC_DCAT_CODE

 
CATEGORY_DESC The description of the category code associated with the detail code for this section fee.    

TTVDCAT

TTVDCAT_DESC

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

SSRFEES

SSRFEES_CRN

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

NA

SYSDATE

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

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.    

TBBDETC

TBBDETC_DESC

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

NA

NA

 
FEE_AMOUNT This field defines the amount of the fee you are creating for the course section.    

SSRFEES

SSRFEES_AMOUNT

 
FEE_ASSESSMENT_TYPE This field is used to identify the type of fee to fee assessment.    

SSRFEES

SSRFEES_FTYP_CODE

 
FEE_ASSESSMENT_TYPE_DESC This field is used to identify the description of the type of fee to fee assessment.    

STVFTYP

STVFTYP_DESC

 
FEE_LEVEL This field identifies the level code that the fee is defined for    

SSRFEES

SSRFEES_LEVL_CODE

 
FEE_LEVEL_DESC This field identifies the description of the level code that the fee is defined for    

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

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.    

SSRFEES

SSRFEES_FEE_IND

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

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

NA

NA

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

NA

NA

 


Ver: 8.3