Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACADEMIC_PERIOD
|
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(63)
|
SSRFEES
|
SSRFEES_TERM_CODE
|
ACADEMIC_PERIOD_ADMITTED
|
Academic Period Admitted
|
Specifies the fee is to be assessed for students admitted in this academic period.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_TERM_CODE_ADMIT
|
ACADEMIC_PERIOD_ADMITTED_DESC
|
Academic Period Admitted Description
|
Student admit academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
This field defines the description of the term for which you are creating the course section fee.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
ACTIVITY_DATE
|
Activity Date
|
This field contains the most current date the record was added or changed.
|
DATE
|
SSRFEES
|
SSRFEES_ACTIVITY_DATE
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
CAMPUS
|
Campus
|
Specifies the fee is to be assessed when the persons' curriculum has this campus.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_CAMP_CODE
|
CAMPUS_DESC
|
Campus Description
|
Campus description.
|
VARCHAR2(255)
|
STVCAMP
|
STVCAMP_DESC
|
CATEGORY
|
Category
|
The category code associated with the detail code for this section fee.
|
VARCHAR2(63)
|
TBBDETC
|
TBBDETC_DCAT_CODE
|
CATEGORY_DESC
|
Category Description
|
The description of the category code associated with the detail code for this section fee.
|
VARCHAR2(255)
|
TTVDCAT
|
TTVDCAT_DESC
|
COLLEGE
|
College
|
Specifies the fee is to be assessed when the persons' curriculum has this college.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_COLL_CODE
|
COLLEGE_DESC
|
College Description
|
College description.
|
VARCHAR2(255)
|
STVCOLL
|
STVCOLL_DESC
|
COURSE_FEE_SEQUENCE_NUMBER
|
Course Fee Sequence Number
|
Sequence number assigned by the system as this course offering fee assessment rule was begun.
|
NUMBER
|
SSRFEES
|
SSRFEES_SEQ_NO
|
COURSE_IDENTIFICATION
|
Course ID
|
Course subject and course number combined.
|
VARCHAR2(255)
|
CALCULATION
|
SSBSECT_SUBJ_CODE||SSBSECT_CRSE_NUMB
|
COURSE_OFFERING_FEE_USER
|
Course Offering Fee User
|
User who inserted or last updated this course offering fee assessment rule.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_USER_ID
|
COURSE_REFERENCE_NUMBER
|
Course Reference Number
|
This field defines the course reference number for which you are creating the course section fee.
|
VARCHAR2(5)
|
SSRFEES
|
SSRFEES_CRN
|
CURRICULUM_STUDENT_POPULATION
|
Curriculum Student Population
|
Specifies the fee is to be assessed when student has this student population.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_STYP_CODE_CURRIC
|
CURRICULUM_STUDENT_POP_DESC
|
Curriculum Student Pop Description
|
Student population description.
|
VARCHAR2(255)
|
STVSTYP
|
STVSTYP_DESC
|
CURRICULUM_STUDENT_RATE
|
Curriculum Student Rate
|
Specifies the fee is to be assessed when student has this student rate on their academic study record.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_RATE_CODE_CURRIC
|
CURRICULUM_STUDENT_RATE_DESC
|
Curriculum Student Rate Description
|
Curriculum student rate description.
|
VARCHAR2(255)
|
STVRATE
|
STVRATE_DESC
|
CURRICULUM_TYPE
|
Curriculum Type
|
Identifies whether this fee rule should look for curriculum values specified only in the primary curriculum. Or if the secondary or any curriculum values for the person should be used to determine when to assess this fee.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_PRIM_SEC_CDE
|
CURRICULUM_TYPE_DESC
|
Curriculum Type Description
|
Curriculum type to use description.
|
VARCHAR2(255)
|
DECODE OR FUNCTION
|
DECODE (SSRFEES_PRIM_SEC_CDE) 'P','PRIMARY CURRICULUM ONLY', 'S', 'SECONDARY CURRICULUM ONLY', 'A', 'ANY CURRICULUM')
|
DEGREE
|
Degree
|
Specifies the fee is to be assessed when the persons' curriculum has this degree or outcome value.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_DEGC_CODE
|
DEGREE_DESC
|
Degree Description
|
Degree description.
|
VARCHAR2(255)
|
STVDEGC
|
STVDEGC_DESC
|
DEPARTMENT
|
Department
|
Specifies the fee is to be assessed when the persons' curriculum has this department.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_DEPT_CODE
|
DEPARTMENT_DESC
|
Department Description
|
Department description.
|
VARCHAR2(255)
|
STVDEPT
|
STVDEPT_DESC
|
DETAIL_CODE
|
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
|
Detail Code Description
|
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
|
Fee Amount
|
This field defines the amount of the fee you are creating for the course section.
|
NUMBER
|
SSRFEES
|
SSRFEES_AMOUNT
|
FEE_LEVEL
|
Fee Level
|
Identifies the level code of the course when this fee is to be assessed.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_LEVL_CODE
|
FEE_LEVEL_DESC
|
Fee Level Description
|
Fee course level description.
|
VARCHAR2(255)
|
STVLEVL
|
STVLEVL_DESC
|
FEE_METHOD
|
Fee Method
|
This column is obsolete and no longer populated in Banner Student.
|
VARCHAR2(1)
|
SSRFEES
|
SSRFEES_FEE_IND
|
FEE_METHOD_CONVERTER
|
Fee Method Converter
|
This column is obsolete and no longer populated in Banner Student.
|
NUMBER
|
SSRFEES
|
SSRFEES_FEE_IND_IND
|
FEE_METHOD_DESC
|
Fee Method Description
|
This column is obsolete and no longer populated in Banner Student.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(SSRFEES_FEE_IND)
|
FEE_TYPE
|
Fee Type
|
This field is used to identify the type of fee to fee assessment.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_FTYP_CODE
|
FEE_TYPE_DESC
|
Fee Type Description
|
Fee assessment type description.
|
VARCHAR2(255)
|
STVFTYP
|
STVFTYP_DESC
|
MAJOR
|
Major
|
Specifies the fee is to be assessed when the persons' curriculum has this major.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_MAJR_CODE
|
MAJOR_DESC
|
Major Description
|
Major description.
|
VARCHAR2(255)
|
STVMAJR
|
STVMAJR_DESC
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
PROGRAM
|
Program
|
Specifies the fee is to be assessed when the persons' curriculum has this program.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_PROGRAM
|
PROGRAM_DESC
|
Program Description
|
Program description.
|
VARCHAR2(255)
|
SMRPRLE
|
SMRPRLE_PROGRAM_DESC
|
RESIDENCY
|
Residency
|
Specifies the fee is to be assessed when the person has this residency code.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_RESD_CODE
|
RESIDENCY_DESC
|
Residency Description
|
Residency code description.
|
VARCHAR2(255)
|
STVRESD
|
STVRESD_DESC
|
STUDENT_ATTRIBUTE
|
Student Attribute
|
Specifies the fee is to be assessed when student has this student attribute.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_ATTS_CODE
|
STUDENT_ATTRIBUTE_DESC
|
Student Attribute Description
|
Student attribute description.
|
VARCHAR2(255)
|
STVATTS
|
STVATTS_DESC
|
STUDENT_CLASSIFICATION
|
Student Classification
|
Specifies the fee is to be assessed when the person has this student classification code.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_CLAS_CODE
|
STUDENT_CLASSIFICATION_DESC
|
Student Classification Description
|
Student Classification code description.
|
VARCHAR2(255)
|
STVCLAS
|
STVCLAS_DESC
|
STUDENT_COHORT
|
Student Cohort
|
Specifies the fee is to be assessed when student has this student cohort.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_CHRT_CODE
|
STUDENT_COHORT_DESC
|
Student Cohort Description
|
Student cohort description.
|
VARCHAR2(255)
|
STVCHRT
|
STVCHRT_DESC
|
STUDENT_LEVEL
|
Student Level
|
Specifies the fee is to be assessed when the persons' curriculum has this student level.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_LEVL_CODE_STDN
|
STUDENT_LEVEL_DESC
|
Student Level Description
|
Student level description
|
VARCHAR2(255)
|
STVLEVL
|
STVLEVL_DESC
|
STUDENT_POPULATION
|
Student Population
|
Specifies the fee is to be assessed when student has this student population.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_STYP_CODE
|
STUDENT_POPULATION_DESC
|
Student Population Description
|
Student population description.
|
VARCHAR2(255)
|
STVSTYP
|
STVSTYP_DESC
|
STUDENT_RATE
|
Student Rate
|
Specifies the fee is to be assessed when student has this student rate on their student record.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_RATE_CODE
|
STUDENT_RATE_DESC
|
Student Rate Description
|
Student rate description.
|
VARCHAR2(255)
|
STVRATE
|
STVRATE_DESC
|
VISA
|
Visa
|
Specifies the fee is to be assessed when students' current visa is this visa type.
|
VARCHAR2(63)
|
SSRFEES
|
SSRFEES_VTYP_CODE
|
VISA_DESC
|
Visa Description
|
Visa code description.
|
VARCHAR2(255)
|
STVVTYP
|
STVVTYP_DESC
|