Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Human Resources Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AN_FISCAL_YEAR

Description Source composite view contains all fiscal years that have current data.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACTIVE_IND Indicates if the defined fiscal year is active.    

NBBFISC

NBBFISC_ACTIVE_IND

 
CHART_OF_ACCOUNTS Identifies the chart from other charts in a multi-chart environment.    

NBBFISC

NBBFISC_COAS_CODE

 
CURRENT_DATE System current date (sysdate) or date the data was extracted.    

NA

SYSDATE

 
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined.    

NA

NA

 
FISCAL_END End date of the defined fiscal year.    

NBBFISC

NBBFISC_END_DATE

 
FISCAL_START Begin date of the defined fiscal year.    

NBBFISC

NBBFISC_BEGIN_DATE

 
FISCAL_YEAR Unique identifier or code for the fiscal year.    

NBBFISC

NBBFISC_CODE

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
QUARTER1_START Start month of quarter 1.    

CALCULATION

ADD_MONTHS

 
QUARTER2_START Start month of quarter 2.    

CALCULATION

ADD_MONTHS

 
QUARTER3_START Start month of quarter 3.    

CALCULATION

ADD_MONTHS

 
QUARTER4_START Start month of quarter 4.    

CALCULATION

ADD_MONTHS

 
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 


Ver: 8.3