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: