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

SGHE Banner Operational Data Store
Composite View Target: AS_YEAR_TYPE_DEFINITION_GS

Description Contains the year types and codes as well as what aid and academic periods are associated with each.

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Identifies the valid term codes within the Year selected. VARCHAR2(6)    
ACADEMIC_PERIOD_DESC Describes the term code and identifies what it represents. Not used in academic year. VARCHAR2(30)    
AID_PERIOD The Aid Period to which the applicant is currently assigned. Not used in academic year. VARCHAR2(1)    
AID_PERIOD_DESC This describes the aid period code and identifies what it represents. VARCHAR2(1)    
CURRENT_DATE CURRENT DATE: The current date. DATE    
DML_DATE This is the date the DML activity occurred. DATE    
DML_TYPE This is the type of DML. VARCHAR2(1)    
DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)    
END_DATE This is the official end date of the year. 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    
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)    
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)    
START_DATE This is the official start date of the year. DATE    
START_YEAR The year and century of the Year Start date. Example: If theYear Start Date = 01-JUL-1990, then Year Start Year = 1990. NUMBER    
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)    
YEAR_CODE_DESC The description of the valid year. VARCHAR2(30)    
YEAR_TYPE This field indentifies the type of year. VARCHAR2(11)    
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)    


Ver: 8.0