Understand Useful Queries, Logs, and Overrides

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

1 View Tables in Eagle PACE
2 Maintain S2P Delta Trigger Logs and Prices/FX Rates Exceptions
3 Maintain Entity Price Overrides

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:

In Accounting Center, in the left navigation pane, click Reports > System Queries.
In the left navigation, click STAR to PACE Direct. Or, for archive queries, click Archive.
You see the options for the available panels.
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

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

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.