Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Finance Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: ENDOWMENT_SUMMARIZED_UNITS

Description Contains summarized purchased endowment units and book value for each endowment fund within a pool that had purchased units during the unitization period. An aggregation of the purchased endowment units and book value is represented from the first unitzation period to the reportable unitization period along with its current market value and market purchase unit price.
Key & Frequency One row per chart of accounts per endowment pool per endowment fund per unitization period end date.
Recommended Search Columns CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, ENDOWMENT_POOL
CHART_OF_ACCOUNTS, ENDOWMENT_POOL, FUND

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
AGGREGATE_BOOK_AMOUNT Aggregation of all the transaction amounts up to and including this unitization period end date associated with this particular chart of accounts and fund.    

FUNCTION

MFKFUNC.F_GET_BOOK_AMOUNT

 
AGGREGATE_UNITS_PURCHASED Aggregation of all the number of units that the gift purchased in the pool up to and including this unitzation period end date based on the unit value for the period of the gift date for this specific chart of accounts and fund.    

FUNCTION

MFKFUNC.F_GET_UNITS_PURCHASED

 
BOOK_AMOUNT Summarized amount of the transactions associated with this particular chart of accounts and fund.    

FUNCTION

MFKFUNC.F_SUM_BOOK_AMOUNT

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

FNVENDW

FNVENDW_COAS_CODE

 
CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title.    

FUNCTION

F_GET_FINANCE_DESC

 
CHART_OF_ACCOUNTS_STATUS Status of the chart of accounts.    

FTVCOAS

FTVCOAS_STATUS_IND

 
ENDOWMENT_FUND_LD Detailed endowment title of the fund.    

FNVENDW

FNVENDW_LONG_FUND_TITLE

 
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

 
FUND Unique fiscal entity code.    

FNBUNTH

FNBUNTH_FUND_CODE

 
FUND_DESC Description or title of the associated fund.    

FUNCTION

F_GET_FINANCE_DESC

 
FUND_STATUS Current status of the associated fund.    

FTVFUND

FTVFUND_STATUS_IND

 
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_VALUATION_DATE Date this market unit price is valid.    

FNRUCTR

FNRUCTR_VALUATION_DATE

 
MARKET_VALUE Number of units that the gift purchased in the pool based on the unit value for the period of the gift date.    

CALCULATION

MFKFUNC.F_GET_UNITS_PURCHASED * MARKET_PURCHASE_UNIT_PRICE

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

NA

NA

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

NA

NA

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

NA

NA

 
UNITIZATION_PERIOD_END_DATE End date of the unitization period for which the gift purchased units.    

FNBUNTH

FNBUNTH_UNTZ_END_DATE

 
UNITS_PURCHASED Summarized number of units that the gift purchased in the pool based on the unit value for the period of the gift date for this specific chart of accounts and fund.    

FUNCTION

MFKFUNC.F_SUM_UNITS_PURCHASED

 


Ver: 8.3