Reporting View Target: ENDOWMENT_SUMMARIZED

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, ENDOWMENT_POOL, FUND
CHART_OF_ACCOUNTS, FUND

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

AGGREGATE_BOOK_AMOUNT 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. NUMBER
FUNCTION

MFKFUNC.F_GET_BOOK_AMOUNT

AGGREGATE_UNITS_PURCHASED 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. NUMBER
FUNCTION

MFKFUNC.F_GET_UNITS_PURCHASED

BOOK_AMOUNT Book Amount Summarized amount of the transactions associated with this particular chart of accounts and fund. NUMBER
FUNCTION

MFKFUNC.F_SUM_BOOK_AMOUNT

CHART_OF_ACCOUNTS Chart Of Accounts Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)
FNVENDW

FNVENDW_COAS_CODE

CHART_OF_ACCOUNTS_DESC Chart Of Accounts Description Chart of accounts code description or title. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_STATUS Chart Of Accounts Status Status of the chart of accounts. VARCHAR2(63)
FTVCOAS

FTVCOAS_STATUS_IND

ENDOWMENT_FUND_LD Endowment Fund Long Description Detailed endowment title of the fund. VARCHAR2(255)
FNVENDW

FNVENDW_LONG_FUND_TITLE

ENDOWMENT_POOL Endowment Pool User assigned code for a unitized pool of funds. VARCHAR2(63)
FNRUCTR

FNRUCTR_POOL_CODE

ENDOWMENT_POOL_DESC Endowment Pool Description Endowment pool description. VARCHAR2(255)
FNVPOOL

FNVPOOL_POOL_TITLE

FUND Fund Unique fiscal entity code. VARCHAR2(63)
FNBUNTH

FNBUNTH_FUND_CODE

FUND_DESC Fund Description Description or title of the associated fund. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

FUND_STATUS Fund Status Current status of the associated fund. VARCHAR2(63)
FTVFUND

FTVFUND_STATUS_IND

MARKET_PURCHASE_UNIT_PRICE 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_VALUATION_DATE Market Valuation Date Date this market unit price is valid. DATE
FNRUCTR

FNRUCTR_VALUATION_DATE

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

MFKFUNC.F_GET_UNITS_PURCHASED * MARKET_PURCHASE_UNIT_PRICE

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

UNITIZATION_PERIOD_END_DATE Unitization Period End Date End date of the unitization period for which the gift purchased units. DATE
FNBUNTH

FNBUNTH_UNTZ_END_DATE

UNITS_PURCHASED 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. NUMBER
FUNCTION

MFKFUNC.F_SUM_UNITS_PURCHASED

Ver: 9.0

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, ENDOWMENT_POOL, FUND CHART_OF_ACCOUNTS, FUND

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AGGREGATE_BOOK_AMOUNT	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.	NUMBER	FUNCTION	MFKFUNC.F_GET_BOOK_AMOUNT
AGGREGATE_UNITS_PURCHASED	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.	NUMBER	FUNCTION	MFKFUNC.F_GET_UNITS_PURCHASED
BOOK_AMOUNT	Book Amount	Summarized amount of the transactions associated with this particular chart of accounts and fund.	NUMBER	FUNCTION	MFKFUNC.F_SUM_BOOK_AMOUNT
CHART_OF_ACCOUNTS	Chart Of Accounts	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FNVENDW	FNVENDW_COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart Of Accounts Description	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_STATUS	Chart Of Accounts Status	Status of the chart of accounts.	VARCHAR2(63)	FTVCOAS	FTVCOAS_STATUS_IND
ENDOWMENT_FUND_LD	Endowment Fund Long Description	Detailed endowment title of the fund.	VARCHAR2(255)	FNVENDW	FNVENDW_LONG_FUND_TITLE
ENDOWMENT_POOL	Endowment Pool	User assigned code for a unitized pool of funds.	VARCHAR2(63)	FNRUCTR	FNRUCTR_POOL_CODE
ENDOWMENT_POOL_DESC	Endowment Pool Description	Endowment pool description.	VARCHAR2(255)	FNVPOOL	FNVPOOL_POOL_TITLE
FUND	Fund	Unique fiscal entity code.	VARCHAR2(63)	FNBUNTH	FNBUNTH_FUND_CODE
FUND_DESC	Fund Description	Description or title of the associated fund.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
FUND_STATUS	Fund Status	Current status of the associated fund.	VARCHAR2(63)	FTVFUND	FTVFUND_STATUS_IND
MARKET_PURCHASE_UNIT_PRICE	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_VALUATION_DATE	Market Valuation Date	Date this market unit price is valid.	DATE	FNRUCTR	FNRUCTR_VALUATION_DATE
MARKET_VALUE	Market Value	Number of units that the gift purchased in the pool based on the unit value for the period of the gift date.	NUMBER	CALCULATION	MFKFUNC.F_GET_UNITS_PURCHASED * MARKET_PURCHASE_UNIT_PRICE
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
UNITIZATION_PERIOD_END_DATE	Unitization Period End Date	End date of the unitization period for which the gift purchased units.	DATE	FNBUNTH	FNBUNTH_UNTZ_END_DATE
UNITS_PURCHASED	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.	NUMBER	FUNCTION	MFKFUNC.F_SUM_UNITS_PURCHASED