Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Advancement Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AA_YEAR_TYPE_DEFINITION

Description Contains the year types and codes.

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

ADV_FISC

ADV_GIFT_SOC

YEAR_TYPE_DESC This field specifies the type of year, e.g. fiscal, academic, calendar, award. VARCHAR2(30)

CONSTANT

ADVANCEMENT FISCAL YEAR

ADVANCEMENT GIFT SOCIETY YEAR

ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)

NA

NA



Ver: 8.0