RETURN TO COMPOSITE VIEW REPORTS LIST
Finance Composite View Reports

SGHE 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 Definition Database Data Type 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: 3.1