Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Formulas for the computation of income receivable values are summarized in About Deriving Position Income Receivables. For detailed field mapping information, see the STAR to PACE Direct Data Maps Quick Reference Guide.

Holdings/Positions

ESTAR Data Category

STAR Database

STAR Tables/Object

PACE Database

PACE Tables

Positions

ESTAR

ESTAR_COST_POSITION

(level 120 of cost object)

HOLDING

POSITION

POSITION_DETAIL

POSITION_COST_DETAIL

Income

(only values for performance calculations are transferred)

ESTAR

ESTAR_INCOME_POSITION

ESTAR_INCOME_ACTIVITY

ESTAR_CXL_INCOME_ ACTIVITY

HOLDING

POSITION

POSITION_DETAIL

POSITION_COST_DETAIL

LOT_LEVEL_POSITIONS

POSITION_COST_LOT

Open Lots

ESTAR

ESTAR_COST_POSITION

(level 150 of cost object)

HOLDING

POSITION

LOT_LEVEL_POSITIONS

POSITION_COST_LOT

Settled Foreign Cash - Open Lots

ESTAR

ESTAR_COST_POSITION

(level 150 level of cost cash object)

(cancel lots – level 250 of cost cash object)

HOLDING

POSITION

SETTLED_CASH_OPEN_LOTS

Cash

ESTAR

ESTAR_COST_POSITION

ESTAR_TRADED_CASH_ ACTIVITY

ESTAR_SETTLED_CASH_ ACTIVITY

HOLDING

POSITION

POSITION_DETAIL

LOT_LEVEL_POSITIONS

Trades

ESTAR Data Category

STAR Database

STAR Tables/Object

PACE Database

PACE Tables

Close Lots/Disposal Lots

ESTAR

ESTAR_COST_POSITION

(level 180, 280, and 400 of cost object)

TRADES

TRADE
TRADE_DETAIL
DISPOSAL_LOTS

Trades

ESTAR

ESTAR_COST_POSITION

(level 150 & 180 of cost object)

(cancel lots – level 250 & level 400 of cost object)

TRADES

TRADE
TRADE_DETAIL

Open Adjustments

ESTAR

ESTAR_COST_POSITION

(level 350 of cost object)

(cancel open adjustments – level 450 of cost object)

TRADES

TRADE
TRADE_DETAIL

Close Adjustments

ESTAR

ESTAR_COST_POSITION

(level 380 of cost object)

(cancel open adjustments – level 480 of cost object)

TRADES

TRADE
TRADE_DETAIL
DISPOSAL_LOTS

Settled Cash Disposal Lots

ESTAR

ESTAR_COST_POSITION

(level 150 & level 180 of cost cash object)

(cancel lots – level 250 & level 280 of cost cash object)

TRADES

SETTLED_CASH_DISPOSAL_LOTS

Cash

Accounting data from Eagle STAR must be normalized or translated before Eagle's performance measurement solution can use that data to calculate performance. Eagle Accounting contains code values that determine how event types and transactions impact cash flows for performance purposes. The Performance Flow Description field in the CASH_ACTIVITY table stores the translated values. For details, see Use Eagle Performance with STAR to PACE Direct

Info

Traded cash activity, settled cash activity, and income are high volume and currently stored in relational tables in the ESTAR database. Eagle has made the decision not to replicate these tables in Eagle PACE. There are several approaches you can take to send this activity to downstream systems. Eagle recommends that you contact Eagle for a solution that meets your business needs.

ESTAR Data Category

STAR Database

STAR Tables/Object

PACE Database

PACE Tables

Traded Cash Activity

(non-income cash)

ESTAR

ESTAR_CASH_POSITION 

ESTAR_TRADED_CASH_ACTIVITY

CASH

CASH_ACTIVITY

(performance data only)

Settled Cash Activity

(actual settlement of income cash)

ESTAR

ESTAR_CASH_POSITION

ESTAR_SETTLED_CASH_ACTIVITY

CASH

CASH_ACTIVITY

(performance data only)

Traded Cash Activity

ESTAR

ESTAR_CASH_POSITION

ESTAR_TRADED_CASH_ACTIVITY

HOLDING

POSITION

POSITION_DETAIL

LOT_LEVEL_POSITIONS

Settled Cash Activity

ESTAR

ESTAR_CASH_POSITION 

ESTAR_SETTLED_CASH_ACTIVITY

HOLDING

POSITION

POSITION_DETAIL

LOT_LEVEL_POSITIONS

Settled Cash Activity

(foreign cash activity only)

ESTAR

ESTAR_CASH_POSITION

ESTAR_SETTLED_CASH_ACTIVITY

TRADES

SETTLED_CASH_ACTIVITY

Ledger

ESTAR Data Category

STAR Database

STAR Tables/Object

PACE Database

PACE Tables

Ledger Balances

ESTAR

ESTAR_LEDGER_ACCOUNT

ESTAR_LEDGER_LOG

ESTAR_LEDGER_BALANCES

LEDGER

GL_DETAIL_POSTING