Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD	Academic Period	Identifies the valid term codes within the Year selected.	VARCHAR2(0)		NA	NA
ACADEMIC_PERIOD_DESC	Academic Period Description	Describes the term code and identifies what it represents. Not used in academic year.	VARCHAR2(0)		NA	NA
AID_PERIOD	Aid Period	The Aid Period to which the applicant is currently assigned. Not used in academic year.	VARCHAR2(0)		NA	NA
AID_PERIOD_DESC	Aid Year Description	This describes the aid period code and identifies what it represents.	VARCHAR2(0)		NA	NA
CURRENT_DATE	Current Date	The current date.	DATE		NA	SYSDATE
DML_DATE	DML Date	This is the date the DML activity occurred.	DATE		NA	NA
DML_TYPE	DML Type	This is the type of DML.	VARCHAR2(0)		NA	NA
DOMAIN_VALUE	Domain Value	Domain column for future use, not currently populated.	VARCHAR2(6)		NA	NA
END_DATE	End Date	This is the official end date of the year.	DATE		ATVDCYR ATVFISC	ATVDCYR_END_DATE ATVFISC_END_DATE
END_YEAR	End Year	The year and century of the Year End date. Example: If the Year End Date = 30-JUN-1991, then Year End Year = 1991.	NUMBER		NA	NA
MIF_DESC	MIF Description	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(30)		NA	NA
MIF_VALUE	MIF Value	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(6)		NA	NA
START_DATE	Start Date	This is the official start date of the year.	DATE		ATVDCYR ATVFISC	ATVDCYR_START_DATE ATVFISC_START_DATE
START_YEAR	Start Year	The year and century of the Year Start date. Example: If the Year Start Date = 01-JUL-1990, then Year Start Year = 1990.	NUMBER		NA	NA
YEAR_CODE	Year Code	The year to be associated with information in this record. This may be from any of the year validations in the system.	VARCHAR2(4)		ATVDCYR ATVFISC	ATVDCYR_CODE ATVFISC_CODE
YEAR_CODE_DESC	Year Description	The description of the valid year.	VARCHAR2(30)		ATVDCYR ATVFISC	ATVDCYR_DESC ATVFISC_DESC
YEAR_TYPE	Year Type	This field indentifies the type of year.	VARCHAR2(30)
YEAR_TYPE_DESC	Year Type Description	This field specifies the type of year, e.g. fiscal, academic, calendar, award.	VARCHAR2(30)
ZONE_VALUE	Zone Value	Zone column for future use, not currently populated.	VARCHAR2(6)		NA	NA

Ver: