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.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
CHART_OF_ACCOUNTS   Identifies the chart from other charts in a multi-chart environment. VARCHAR2(1)  

FNRUCTR

FNRUCTR_COAS_CODE

CHART_OF_ACCOUNTS_DESC   Chart of accounts code description or title. VARCHAR2(35)  

FUNCTION

F_GET_FINANCE_DESC

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

NA

SYSDATE

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

NA

NA

ENDOWMENT_POOL   User assigned code for a unitized pool of funds. VARCHAR2(2)  

FNRUCTR

FNRUCTR_POOL_CODE

ENDOWMENT_POOL_DESC   Endowment pool description. VARCHAR2(30)  

FNVPOOL

FNVPOOL_POOL_TITLE

MARKET_PERIOD_END_DATE   Ending period for the market valuation. DATE  

FNRUCTR

FNRUCTR_PERIOD_END_DATE

MARKET_PERIOD_START_DATE   Beginning period for the market valuation. DATE  

FNRUCTR

FNRUCTR_PERIOD_START_DATE

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

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. DATE  

FNRUCTR

FNRUCTR_UNTZD_DATE

MARKET_VALUATION_DATE   Date this market unit price is valid. DATE  

FNRUCTR

FNRUCTR_VALUATION_DATE

MIF_DESC   Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)  

NA

NA

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

NA

NA

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

FNRUCTR

FNRUCTR_NUM_UNITS_PERIOD

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

NA

NA



Ver: