About Cash Balance Fields in the POSITION Table

The Cash Balance records stored in PACE provide different views of the Eagle STAR accounting data. The following table lists the description and derivation of the cash balance related fields stored in the POSITION table in PACE.

POSITION Field	Description	Derivation

POSITION Field	Description	Derivation
star_market_value_local star_quantity	STAR Traded Cash Balance Local - Accounting View	The value represents all cash activity related to principal and income transactions in issue currency terms. All activity in STAR that generates a cash activity record is reflected in this balance amount. The open receivables and payables are added to the settled cash balance for the effective date requested.
star_market_value	STAR Traded Cash Balance Base - Accounting View	This value represents the entity base currency equivalent of the above traded cash balance local. The settled base amount is derived. The Marked-to-Market amount of the open receivables and payables is then added. The actual base cost of the cash balance is captured in the settlement amount. The base equivalent of the open principal receivables and payables are derived by dividing the local amount by the most recent FX rate. Open Receivables and Payables / Mkt_exchange_rate
share_par_value local_gaap_cost_value book_value_local local_market_value	STAR Traded Cash Balance Local - PACE Performance View	This value does not include open INCOME receivables and payables. The open income amounts must be reflected on the individual position detail records for PACE Performance purposes. The settled cash balance (which includes principal and income values) for the effective date requested is the starting value. The open PRINCIPAL receivables and payables are then added to it to arrive at the final amount. Income purchased pending settlement is included in this cash payables.
gaap_cost_value book_value market_value	STAR Traded Cash Balance Base - PACE Performance View	This value does not include open INCOME receivables and payables. The open income amounts must be reflected on the individual position detail records for PACE Performance purposes. The settled cash balance (which includes principal and income values) for the effective date requested is the starting value. The open PRINCIPAL receivables and payables are then added to it to arrive at the final amount. The actual base cost of the cash balance is captured in the settlement amount. The base equivalent of the open principal receivables and payables are derived by dividing the local amount by the most recent FX rate.
settlement_date_position_local	STAR Settled Cash Balance Local - Accounting View	The S2P Direct Process will populate this field with the actual settled cash balance local for a given cash position.
settlement_date_position_cost	STAR Settled Cash Balance Base Cost - Accounting View	The S2P Direct Process will populate this field with the base cost of the local settled cash balance for a given cash position.
settlement_date_position	STAR Settled Cash Balance Base - Accounting View	The S2P Direct Process will populate this field with the actual settled cash balance (base market value) for a given cash position accounting date. Settlement_date_position_local (Tag 10044) / Mkt_exchange_rate (Tag 96)
settle_quantity	Settled Quantity	This field is populated with the total number of shares that CONTRACTUAL settle for a given position and date. For cash positions this field will be populated with the ACTUAL settled cash amount.
settled_local_gaap_cost_value	Settled Current Local Cost	The value represents the current local cost associated with the settled quantity.
settled_gaap_cost_value	Settled Current Base Cost	The value represents the current base cost associated with the settled quantity.
settled_local_market_value	Settled Market Value Local	The value represents the local market value associated with the settled quantity. Settled_quantity X price X security_master.price_multiplier X security_master.trading_unit
settled_market_value	Settled Market Value Base	The value represents the base market value associated with the settled quantity. Settled_local_market_value / Mkt_exchange_rate
notional_market_value_local	Notional Market Value Local	The value represents the currency local market value less the notional cost local of all futures positions for the given currency. This value is required for notional valuation of futures in PACE for reporting. Local_market_value - sum of (notional_cost_local for all futures cost positions with the given currency as issue currency).
notional_market_value	Notional Market Value Base	The value represents the currency market value less the notional cost of all futures positions. This value is required for notional valuation of futures in PACE for reporting. Market_value - sum of (notional_cost for all futures cost positions with the given currency as issue currency).
notional_cost_local	Notional Cost Local	The value represents the currency local GAAP cost value less the notional cost local of all futures positions. This value is required for notional valuation of futures in PACE for reporting. Local_gaap_cost_value - sum of (notional_cost_local for all futures cost positions with the given currency as issue currency).
notional_cost	Notional Cost Base	The value represents the currency gaap cost value less the notional cost of all futures positions This value is required for notional valuation of futures in PACE for reporting. Gaap_cost_value - sum of (notional_cost for all future positions with the given currency as issue currency).