Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

STAR to PACE Direct provides several useful panels for viewing/maintaining tables, logs, price exceptions, and price overrides. You can:

  • View tables in Eagle PACE
  • Maintain Delta Trigger Logs and Prices/FX Rates Exceptions
  • Maintain Entity Price Overrides

On this page

View Tables in Eagle PACE

The Eagle data warehouse queries provide views of tables data, including views of positions based on transaction dates, such as the accounting date, trade date, settlement date, post date, and month end date. You can query general ledger balances and settled cash activity. For detailed information about each query, see View Accounting Data in the Eagle Data Warehouse.

Use these queries when you are investigating an issue with STAR to PACE Direct. They return only the stored data. No calculations are performed. If the queries described in this section do not display results data the way you prefer, you can create a custom profile that customizes the view of results.

To access the Eagle PACE queries:

  1. In Accounting Center, in the left navigation pane, click Reports > System Queries.
  2. In the left navigation, click STAR to PACE Direct. Or, for archive queries, click Archive.
    You see the options for the available panels.
  3. Select the option for the panel you want to use.

The following table lists the query name, query description, and the database tables populated by S2P for each available query.

Query

Description

Database

Database Table

Performance Returns Table Query

Displays performance returns.

PERFORM

PERF_SEC_RETURNS

PACE Dictionaries Table Query

Displays the list of PACE dictionaries.

RULES

DICTIONARIES
DICTIONARY_FORMAT 
DICTIONARY_DETAIL

Position Table Query

Displays position level data.

HOLDING

POSITION
POSITION_ DETAIL
POSITION_COST_DETAIL

Lot Level Position Table Query

Displays lot level holdings data. This includes the individual open lots created by Eagle Accounting for each position.

HOLDING

LOT_LEVEL_POSITION
POSITION_COST_LOT

Trade Table Query

Displays trade details from the Trades tables.

TRADES

TRADE
TRADE_DETAIL

Disposal Lot Table Query

Displays the individual close lots created by Eagle Accounting, including the individual gain/ loss for each close lot.

TRADES

DISPOSAL_LOTS

Cash Activity Table Query

Displays individual cash activity data from the Cash Activity table.

CASH

CASH_ACTIVITY

Settled Cash Open Lot Table Query

Displays the individual settled cost cash open lots from the settled cash open lots table.

HOLDING

SETTLED_CASH_OPEN_ LOTS

Settled Cash Activity Table Query

Displays the individual settled cash activity records from the Settled Cash Activity table.

TRADES

SETTLED_CASH_ACTIVITY

Settled Cash Disposal Lot Table Query

Displays the individual settled cash activity disposal lots from the Settled Cash Disposal Lot table.

TRADES

SETTLED_CASH_DISP LOTS

General Ledger Balances Report

Displays the daily or monthly general ledger account balances from the General Ledger Detail Posting table and provides security details from the Security Master table.

LEDGER

GL_DETAIL_POSTING

Interest Income Table query

No longer supported.


Do not use

Maintain S2P Delta Trigger Logs and Prices/FX Rates Exceptions

You can query the Delta Trigger logs for information on the status and the number of transactions involved in the S2P Delta process. You can also rebuild the logs and maintain prices and FX rate exceptions.

To maintain the S2P Delta Trigger logs or Price and FX Rates Exceptions:

In Accounting Center, in the left navigation pane, click Setup > Admin > STAR to PACE Maintenance.
You see the list of panels available.

Select the panel you want to use. 

For detailed instructions about the options available for querying/rebuilding the Delta Trigger logs and maintaining the prices and FX rates exception information, see Perform Data Maintenance.

The following table lists the query name and query description for each available list type query.

Query

Description

List Delta Log – Summary Level

Displays delta log information at the summary level

List Delta Log – Detail Level

Displays delta log information at the detail level

List Price or FX Rate Exceptions

Displays prices or FX rate exceptions

Maintain Entity Price Overrides

You can maintain entity price overrides, including adding, changing, and deleting price overrides at the entity level. The price in the Eagle data warehouse is an enterprise wide value for a given source. Under certain conditions, for a given entity, you may want to deviate from this price. 

For detailed information about the Entity Price Override options available for maintaining entity price overrides, see Add Entity Price Overrides, Delete an Entity Price Override, and Edit Entity Price Overrides.

  • No labels