The List Delta Log – Summary Level panel enables 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 figure shows the grid report.
Figure 42: Sample List Delta Log – Summary Level Grid Report
WRITERS NOTE: need data to recreate screenshots of grid reports throughout this chapter
The following table describes each field on the grid report.
Field |
Description |
Status Switch |
The status of the transactions, as counted. Options include:
|
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. |
Add Comment