Target Column	Business Definition	Database Data Type	Source Name	Source Column
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)	STVTERM	STVTERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
AID_PERIOD	Represents a financial aid period or portion of an aid year associated. Aid periods can be a single academic period or set of them as appropriate for tracking the aid awarded, accepted, paid, etc.	VARCHAR2(1)	NA	NA
AID_PERIOD_DESC	This describes the aid period code and identifies what it represents.	VARCHAR2(1)	NA	NA
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DML_DATE	Date the DML activity occurred.	DATE	NA	NA
DML_TYPE	This is the type of DML.	VARCHAR2(1)	NA	NA
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
END_DATE	End date for the year based on the year type.	DATE	STVTERM	STVTERM_END_DATE
END_YEAR	Year and century of the year end date. For Example, if the year end date is 30-JUN-1991, then year end year = 1991.	NUMBER	NA	NA
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
READMIT_ACADEMIC_PERIOD		VARCHAR2(6)
READMIT_ACADEMIC_PERIOD_DESC		VARCHAR2(30)
START_DATE	Official start date of the year.	DATE	STVTERM	STVTERM_START_DATE
START_YEAR	Year and century of the year start date. E.g., if the year start date is 01-JUL-1990, then the year start year is 1990.	NUMBER	NA	NA
YEAR_CODE	Year value to be associated this record. This may be from any of the year validations in the system. Year value to be associated this record. This may be from any of the year validations in the system.	VARCHAR2(4)	STVTERM STVTERM	STVTERM_ACYR_CODE STVTERM_FA_PROC_YR
YEAR_CODE_DESC	Academic year description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
YEAR_TYPE	This field indentifies the type of year.	VARCHAR2(11)	CONSTANT CONSTANT	'FA_PROC_YR' 'N'
YEAR_TYPE_DESC	This field specifies the type of year, e.g. fiscal, academic, calendar, award.	VARCHAR2(60)	CONSTANT CONSTANT	'ACADEMIC YEAR' 'FINANCIAL AID PROCESSING YEAR FOR AN ACADEMIC PERIOD'
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: