Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD		Academic period associated with this year type definition.	VARCHAR2(6)		STVTERM	STVTERM_CODE
ACADEMIC_PERIOD_DESC		Academic period description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
AID_PERIOD		The Aid Period to which the applicant is currently assigned. Not used in academic year.	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	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	Readmit Academic Period		VARCHAR2(6)
READMIT_ACADEMIC_PERIOD_DESC	Readmit Academic Period Description		VARCHAR2(30)
START_DATE	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: