Go To View:  RETURN TO BANNER COMP META DATA 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 Name Business Definition Database Data Type Domain Value Source Name Source Column
ACADEMIC_PERIOD Academic Period Identifies the valid term codes within the Year selected. VARCHAR2(0)  

NA

NA

ACADEMIC_PERIOD_DESC Academic Period Description Describes the term code and identifies what it represents. Not used in academic year. VARCHAR2(0)  

NA

NA

AID_PERIOD Aid Period The Aid Period to which the applicant is currently assigned. Not used in academic year. VARCHAR2(0)  

NA

NA

AID_PERIOD_DESC Aid Year Description This describes the aid period code and identifies what it represents. VARCHAR2(0)  

NA

NA

CURRENT_DATE Current Date The current date. DATE  

NA

SYSDATE

DML_DATE DML Date This is the date the DML activity occurred. DATE  

NA

NA

DML_TYPE DML Type This is the type of DML. VARCHAR2(0)  

NA

NA

DOMAIN_VALUE Domain Value Domain column for future use, not currently populated. VARCHAR2(6)  

NA

NA

END_DATE End Date This is the official end date of the year. DATE  

ATVDCYR

ATVFISC

ATVDCYR_END_DATE

ATVFISC_END_DATE

END_YEAR 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 MIF Description 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 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 Start Date This is the official start date of the year. DATE  

ATVDCYR

ATVFISC

ATVDCYR_START_DATE

ATVFISC_START_DATE

START_YEAR 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 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 Year Description The description of the valid year. VARCHAR2(30)  

ATVDCYR

ATVFISC

ATVDCYR_DESC

ATVFISC_DESC

YEAR_TYPE Year Type This field indentifies the type of year. VARCHAR2(30)      
YEAR_TYPE_DESC Year Type Description This field specifies the type of year, e.g. fiscal, academic, calendar, award. VARCHAR2(30)      
ZONE_VALUE Zone Value Zone column for future use, not currently populated. VARCHAR2(6)  

NA

NA



Ver: