RETURN TO COMPOSITE VIEW REPORTS LIST
Advancement Composite View Reports

SGHE Operational Data Store
Composite View Target: AA_YEAR_TYPE_DEFINITION

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Identifies the valid term codes within the Year selected. VARCHAR2(0)    
ACADEMIC_PERIOD_DESC Describes the term code and identifies what it represents. Not used in academic year. VARCHAR2(0)    
AID_PERIOD The Aid Period to which the applicant is currently assigned. Not used in academic year. VARCHAR2(0)    
AID_PERIOD_DESC This describes the aid period code and identifies what it represents. VARCHAR2(0)    
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(0)    
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 the Year Start Date = 01-JUL-1990, then Year Start Year = 1990. NUMBER    
SUB_ACADEMIC_PERIOD This field identifies the session or part of the academic period associated with the information in the record. Not used in academic year. VARCHAR2(0)    
SUB_ACADEMIC_PERIOD_DESC This field specifies the session or part of the academic period associated with the session code. Not used in academic year. VARCHAR2(0)    
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(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)    


Ver: 3.1