| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACADEMIC_PERIOD
|
Identifies the valid term codes within the Year selected.
|
VARCHAR2(1)
|
NA
|
NA
|
|
ACADEMIC_PERIOD_DESC
|
Describes the term code and identifies what it represents. Not used in academic year.
|
VARCHAR2(1)
|
NA
|
NA
|
|
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
|
The current date.
|
DATE
|
NA
|
SYSDATE
|
|
DML_DATE
|
This is the date the DML activity occurred.
|
DATE
|
NA
|
NA
|
|
DML_TYPE
|
This is the type of DML.
|
VARCHAR2(0)
|
NA
|
NA
|
|
DOMAIN_VALUE
|
Domain column for future use, not currently populated.
|
VARCHAR2(6)
|
NA
|
NA
|
|
END_DATE
|
This is the official end date of the year.
|
DATE
|
ATVDCYR ATVFISC
|
ATVDCYR_END_DATE ATVFISC_END_DATE
|
|
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
|
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
|
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
|
This is the official start date of the year.
|
DATE
|
ATVDCYR ATVFISC
|
ATVDCYR_START_DATE ATVFISC_START_DATE
|
|
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
|
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
|
The description of the valid year.
|
VARCHAR2(30)
|
ATVDCYR ATVFISC
|
ATVDCYR_DESC ATVFISC_DESC
|
|
YEAR_TYPE
|
This field indentifies the type of year.
|
VARCHAR2(30)
|
CONSTANT CONSTANT
|
ADV_FISC ADV_GIFT_SOC
|
|
YEAR_TYPE_DESC
|
This field specifies the type of year, e.g. fiscal, academic, calendar, award.
|
VARCHAR2(30)
|
CONSTANT CONSTANT
|
ADVANCEMENT FISCAL YEAR ADVANCEMENT GIFT SOCIETY YEAR
|
|
ZONE_VALUE
|
Zone column for future use, not currently populated.
|
VARCHAR2(6)
|
NA
|
NA
|