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: 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 |
STARTables/Object |
PACEDatabase |
PACETables |
---|---|---|---|---|
Positions |
ESTAR |
Estar_cost_position |
Holding |
Position |
Income |
ESTAR |
Estar_income_position |
Holding |
Position |
Open Lots |
ESTAR |
Estar_cost_position |
Holding |
Position |
Settled Foreign Cash - Open Lots |
ESTAR |
Estar_cost_position |
Holding |
Position |
Cash |
ESTAR |
Estar_cost_position |
Holding |
Position |
Trades
ESTAR Data Category |
STAR Database |
STARTables/Object |
PACEDatabase |
PACETables |
---|---|---|---|---|
Close Lots/Disposal Lots |
ESTAR |
Estar_cost_position |
Trades |
Trade |
Trades |
ESTAR |
Estar_cost_position |
Trades |
Trade |
Open Adjustments |
ESTAR |
Estar_cost_position |
Trades |
Trade |
Close Adjustments |
ESTAR |
Estar_cost_position |
Trades |
Trade |
Settled Cash Disposal Lots |
ESTAR |
Estar_cost_position |
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. See Chapter 3: Working With Eagle Performance for details.
WRITERS NOTE: Eddie to update Cash section
Note: |
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 |
STARTables/Object |
PACEDatabase |
PACETables |
---|---|---|---|---|
Traded Cash Activity (non-income cash) |
ESTAR |
Estar_cash_position |
Cash |
Cash_activity (performance data only) |
Settled Cash Activity (actual settlement of income cash) |
ESTAR |
Estar_cash_position |
Cash |
Cash_activity (performance data only) |
Traded Cash Activity |
ESTAR |
Estar_cash_position |
Holding |
Position |
Settled Cash Activity |
ESTAR |
Estar_cash_position |
Holding |
Position |
Settled Cash Activity |
ESTAR |
Estar_cash_position |
Trades |
Settled_cash_activity |
Ledger
ESTAR Data Category |
STAR Database |
STARTables/Object |
PACEDatabase |
PACETables |
---|---|---|---|---|
Ledger Balances |
ESTAR |
Estar_ledger_account |
Ledger |
Gl_detail_posting |
Add Comment