Understand Storing Accounting Data
- Nancy Cohn (Deactivated)
The tables that follow provide a high-level overview of the data mappings in the STAR to PACE Direct data transfer from Eagle STAR to Eagle PACE. Eagle STAR is Eagle's accounting solution and Eagle PACE is the Eagle data warehouse.
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 |
Trades | ESTAR | ESTAR_COST_POSITION (level 150 & 180 of cost object) (cancel lots – level 250 & level 400 of cost object) | TRADES | TRADE |
Open Adjustments | ESTAR | ESTAR_COST_POSITION (level 350 of cost object) (cancel open adjustments – level 450 of cost object) | TRADES | TRADE |
Close Adjustments | ESTAR | ESTAR_COST_POSITION (level 380 of cost object) (cancel open adjustments – level 480 of cost object) | TRADES | TRADE |
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.Â
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 |
Â