| 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(0)
|
NA
|
NA
|
|
ACADEMIC_PERIOD_DESC
|
Describes the term code and identifies what it represents. Not used in academic year.
|
VARCHAR2(0)
|
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(0)
|
NA
|
NA
|
|
AID_PERIOD_DESC
|
This describes the aid period code and identifies what it represents.
|
VARCHAR2(0)
|
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)
|
|
|
|
YEAR_TYPE_DESC
|
This field specifies the type of year, e.g. fiscal, academic, calendar, award.
|
VARCHAR2(30)
|
|
|
|
ZONE_VALUE
|
Zone column for future use, not currently populated.
|
VARCHAR2(6)
|
NA
|
NA
|