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 Appendix A: 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 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 cashCASH_activity ACTIVITY table stores the translated values. See Chapter 3: Working With Eagle Performance for details.
WRITERS NOTE: Eddie to update Cash section
...
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 |