Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD	Academic Period	Academic period associated with this year type definition.	VARCHAR2(63)		ROBINST RORTPRD STVTERM	ROBINST_CURRENT_TERM_CODE RORTPRD_TERM_CODE STVTERM_CODE
ACADEMIC_PERIOD_DESC	Academic Period Description	Academic period description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
AID_PERIOD	Aid Period	Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc.	VARCHAR2(63)		RORTPRD	RORTPRD_APRD_CODE
AID_PERIOD_DESC	Aid Period Description	Financial Aid period description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
END_DATE	End Date	Official end date for the year based on the year type.	DATE		STVTERM	STVTERM_END_DATE
END_YEAR	End Year	Year and century of the End date. Example: If the End Date = 30-JUN-1991, then Year End Year = 1991.	NUMBER		ROBINST	ROBINST_AIDY_END_YEAR
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)		NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)		NA	NA
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
READMIT_ACADEMIC_PERIOD	Readmit Academic Period	Readmit academic period associated with this year type definition.	VARCHAR2(63)		SOBTERM	SOBTERM_READMIT_REQ
READMIT_ACADEMIC_PERIOD_DESC	Readmit Academic Period Description	Readmit academic period description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
START_DATE	Start Date	Official start date for the year based on the year type.	DATE		STVTERM	STVTERM_START_DATE
START_YEAR	Start Year	Year and century of the Start date. Example: If the Start Date = 01-JUL-1990, then Start Year = 1990.	NUMBER		ROBINST	ROBINST_AIDY_START_YEAR
YEAR_CODE	Year Code	Year value to be associated this record. This may be from any of the year validations in the system.	VARCHAR2(63)		STVTERM	STVTERM_ACYR_CODE
YEAR_CODE_DESC	Year Code Description	Year value and type description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
YEAR_TYPE	Year Type	Type of year being defined. This may be an academic, financial aid, fiscal or calendar year type.	VARCHAR2(63)		CONSTANT CONSTANT CONSTANT CONSTANT	'ACYR' 'AIDY' 'FA_PROC_YR' 'INST_AIDY'
YEAR_TYPE_DESC	Year Type Description	Year type description. For example, fiscal, academic, calendar, financial aid year.	VARCHAR2(255)		CONSTANT CONSTANT CONSTANT CONSTANT	'ACADEMIC YEAR' 'AID YEAR' 'FINANCIAL AID PROCESSING YEAR FOR AN ACADEMIC PERIOD' 'INSTITUTION AID YEAR AND CURRENT ACADEMIC PERIOD'

Ver: 9.0