The List Delta Log – Summary Level panel allows you to retrieve and report data from the SPD_DELTA_TRIGGER_LOG table, including the account 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.
You see the results that met your criteria in the Show All tab. The grid report shows each account and corresponding transaction count.
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