| Target Column |
Business Definition |
Database Data Type |
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 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
|
|
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
|