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