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(63)	ROBINST RORTPRD STVTERM	ROBINST_CURRENT_TERM_CODE RORTPRD_TERM_CODE STVTERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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(63)	RORTPRD	RORTPRD_APRD_CODE
AID_PERIOD_DESC	Financial Aid period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
END_DATE	Official end date for the year based on the year type.	DATE	STVTERM	STVTERM_END_DATE
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	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
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 associated with this year type definition.	VARCHAR2(63)	SOBTERM	SOBTERM_READMIT_REQ
READMIT_ACADEMIC_PERIOD_DESC	Readmit academic period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
START_DATE	Official start date for the year based on the year type.	DATE	STVTERM	STVTERM_START_DATE
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 value to be associated this record. This may be from any of the year validations in the system.	VARCHAR2(63)	ROBINST RORTPRD STVTERM STVTERM	ROBINST_AIDY_CODE RORTPRD_AIDY_CODE STVTERM_ACYR_CODE STVTERM_FA_PROC_YR
YEAR_CODE_DESC	Year value and type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
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. 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.1