The List Delta Log – Summary Level panel enables allows you to retrieve and report data from the SPD_DELTA_TRIGGER_LOG table, including the status and number of transactions.
To view Delta Trigger Log information at the summary level:
- In Accounting Center, in the left navigation pane, click Setup > Admin > STAR to PACE Maintenance > List Delta Log – Summary Level.
You see the List Delta Log – Summary Level panel. - Complete the options on the List Delta Log – Summary Level panel.
- Under Result Options, in the Format area, click Grid or Advanced Report for the report view you want.
Click Submit.
The following
...
table describes each field on the grid report.
...
Column Name
Description
Status Switch
The status of the transactions, as counted. Options include:
- 1 ─ Pending. The transaction (cash transaction) is waiting to be sent to Eagle PACE.
- 2 ─ Pending or Failed. The transaction is pending or has failed. There are three possible reasons for this value. First, the Delta process may be running and the data is in transit. Secondly, the entity accounting basis may have prevented the data from being sent to Eagle PACE. Check the entity accounting basis to see if the entity elections are correct. Thirdly, the Delta process has failed. Check the Global Process workspace for errors.
- 3 ─ Completed. The transaction has been sent to Eagle PACE successfully.
Count
The count of pending, pending or failed, and completed transactions.
...
List Delta Log – Summary Level Panel Options
The following table lists the fields and field descriptions for the List Delta Log – Summary Level panel.
Option | Description |
|---|---|
List S2P Direct Log – Summary Level |
Post Date | Specifies the post date for your report result. For example, enter today's date. |
Accounting Date | Specifies the accounting date for your report result. |
Entity ID | Specifies the entity identifier for a portfolio, sector portfolio, composite portfolio, or Master Fund. |
Entity Name | Specifies the entity by the name of the entity. |
Accounting Basis | Specifies the accounting basis for the entity. For example, USTAX, GAAP, or IFRS. |
Event Type | Displays the event type value QRY_DELTA_LOG_SUMMARY. |
Asset ID Type | Specifies the primary asset identifier type for the security, such as CUSIP, ISIN, and SEDOL. |
Issue Name | Specifies the issue name of the security. |
Asset ID | Specifies the primary asset identifier of the security. |
Long/Short Indicator | Allows you to display only long or short positions in your query results. |
Partition | Specifies the database partition for the position. This value is automatically established by a lookup based on the specific entity. |