View Delta Trigger Log Information – Detail Level

The List Delta Log - Detail Level panel retrieves and reports on data from the SPD_DELTA_TRIGGER_LOG and the SPD_DELTA_TRIGGER_LOG_HIST tables. Information includes the instance, account, accounting and post dates, status switch, asset currency, event and batch identifiers, target event id, link event id, MT query type, event type, cash category, cash event type, update date, and update source.

To view Delta Trigger Log information at the detail level:

  1. In Accounting Center, in the left navigation pane, click Setup > Admin > STAR to PACE Maintenance > List Delta Log – Detail Level.
    You see the List Delta Log – Detail Level panel.

  2. Complete the options on the List Delta Log – Detail Level panel.

  3. Under Result Options, in the Format area, click Grid or Advanced Report for the report view you want.

  4. Click Submit.
    You see the results that met your criteria in the Show All tab. 

List Delta Log – Detail Level Panel Options

The following table lists the fields and field descriptions for the List Delta Log – Detail Level panel.

Option

Description

Option

Description

List S2P Direct Log – Detail 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_DETAIL.

Asset ID Type

Specifies the primary asset identifier type for the security. For example, CUSIP, ISIN, or SEDOL.

Issue Name

Specifies the issue name.

Asset ID

Specifies the primary asset identifier.

Long/Short Indicator

Specifies whether the position is long or short.

Max Rows

Specifies the maximum number of rows. Default value is 5,000.

Partition

Specifies the database partition for the position. This value is automatically established by a lookup based on the specific entity.