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

SGHE Banner Operational Data Store
Composite View Target: AF_ENDOWMENT_MARKET_VALUES

Description Source composite view contains information on the purchase price for endowment pools by period and actual valuation and unitization dates.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
CHART_OF_ACCOUNTS Identifies the chart from other charts in a multi-chart environment.    

FNRUCTR

FNRUCTR_COAS_CODE

 
CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title.    

FUNCTION

F_GET_FINANCE_DESC

 
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

 
ENDOWMENT_POOL User assigned code for a unitized pool of funds.    

FNRUCTR

FNRUCTR_POOL_CODE

 
ENDOWMENT_POOL_DESC Endowment pool description.    

FNVPOOL

FNVPOOL_POOL_TITLE

 
MARKET_PERIOD_END_DATE Ending period for the market valuation.    

FNRUCTR

FNRUCTR_PERIOD_END_DATE

 
MARKET_PERIOD_START_DATE Beginning period for the market valuation.    

FNRUCTR

FNRUCTR_PERIOD_START_DATE

 
MARKET_PURCHASE_UNIT_PRICE Market price per unit at which the units of this pool is to be purchased.    

FNRUCTR

FNRUCTR_PUR_PRICE_VAL_UNIT

 
MARKET_UNITIZATION_DATE Date when unitization was performed for this period. The field is blank if unitization has not yet been run.    

FNRUCTR

FNRUCTR_UNTZD_DATE

 
MARKET_VALUATION_DATE Date this market unit price is valid.    

FNRUCTR

FNRUCTR_VALUATION_DATE

 
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

 
PERIOD_TOTAL_UNITS Number of units that has been added to this period.    

FNRUCTR

FNRUCTR_NUM_UNITS_PERIOD

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

NA

NA

 


Ver: 8.3