Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Student Composite View Reports

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. This may also include curriculum values if they were used in defining the rule to assess this course offering fee.

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

SSRFEES

SSRFEES_TERM_CODE

NO

NO
ACADEMIC_PERIOD_ADMITTED   VARCHAR2(6)       NO
ACADEMIC_PERIOD_ADMITTED_DESC   VARCHAR2(30)       NO
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

NO

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

SSRFEES

SSRFEES_ACTIVITY_DATE

NO

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

TBBDETC

TBBDETC_DCAT_CODE

NO

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

TTVDCAT

TTVDCAT_DESC

NO

NO
COLLEGE   VARCHAR2(2)       NO
COLLEGE_DESC   VARCHAR2(30)       NO
COURSE_FEE_SEQUENCE_NUMBER   NUMBER       NO
COURSE_OFFERING_FEE_USER   VARCHAR2(30)       NO
COURSE_REFERENCE_NUMBER This field defines the course reference number for which you are creating the course section fee. VARCHAR2(5)

SSRFEES

SSRFEES_CRN

NO

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

NA

SYSDATE

NO

NO
CURRICULUM_STUDENT_POPULATION   VARCHAR2(1)       NO
CURRICULUM_STUDENT_POP_DESC   VARCHAR2(30)       NO
CURRICULUM_STUDENT_RATE   VARCHAR2(5)       NO
CURRICULUM_STUDENT_RATE_DESC   VARCHAR2(30)       NO
CURRICULUM_TYPE   VARCHAR2(1)       NO
CURRICULUM_TYPE_DESC   VARCHAR2(25)       NO
DEGREE   VARCHAR2(6)       NO
DEGREE_DESC   VARCHAR2(30)       NO
DEPARTMENT   VARCHAR2(4)       NO
DEPARTMENT_DESC   VARCHAR2(30)       NO
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

NO

NO
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

NO

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

NA

NA

NO

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

SSRFEES

SSRFEES_AMOUNT

NO

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

SSRFEES

SSRFEES_FTYP_CODE

NO

NO
FEE_ASSESSMENT_TYPE_DESC Fee assessment type description. VARCHAR2(30)

STVFTYP

STVFTYP_DESC

NO

NO
FEE_LEVEL Identifies the level code of the course when this fee is to be assessed. VARCHAR2(2)

SSRFEES

SSRFEES_LEVL_CODE

NO

NO
FEE_LEVEL_DESC Fee course level description. VARCHAR2(30)

STVLEVL

STVLEVL_DESC

NO

NO
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

SSRFEES

SSRFEES_FEE_IND_IND

NO

NO
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

NO

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

NA

NA

NO

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

NA

NA

NO

NO
PROGRAM   VARCHAR2(12)       NO
PROGRAM_DESC   VARCHAR2(30)       NO
RESIDENCY   VARCHAR2(1)       NO
RESIDENCY_DESC   VARCHAR2(30)       NO
STUDENT_ATTRIBUTE   VARCHAR2(4)       NO
STUDENT_ATTRIBUTE_DESC   VARCHAR2(30)       NO
STUDENT_CLASSIFICATION   VARCHAR2(2)       NO
STUDENT_CLASSIFICATION_DESC   VARCHAR2(30)       NO
STUDENT_COHORT   VARCHAR2(10)       NO
STUDENT_COHORT_DESC   VARCHAR2(30)       NO
STUDENT_LEVEL   VARCHAR2(2)       NO
STUDENT_LEVEL_DESC   VARCHAR2(30)       NO
STUDENT_POPULATION   VARCHAR2(1)       NO
STUDENT_POPULATION_DESC   VARCHAR2(30)       NO
STUDENT_RATE   VARCHAR2(5)       NO
STUDENT_RATE_DESC   VARCHAR2(30)       NO
VISA   VARCHAR2(2)       NO
VISA_DESC   VARCHAR2(30)       NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO


Ver: