View Settled Cash Activity

The Settle Cash Activity Table Query allows you to research settled cash activity processed by STAR to PACE Direct based on data stored in the SETTLED_CASH_ACTIVITY table in the TRADES database in the Eagle data warehouse.

To view settled cash activity in the Eagle data warehouse:

In Accounting Center, in the left navigation pane, click Reports > System Queries > STAR to PACE Direct > Settle Cash Activity Table Query.
You see the Settle Cash Activity Table Query panel.
Complete the options on the Settle Cash Activity Table Query panel.
Under Result Options, in the Format area, click Grid or Advanced Report for the report view you want.
In the Location area, click Show results after submit. Or, you can click Send results to Scheduler for optimum performance when submitting ad hoc reports that involve a significant amount of data.
Click Submit.
The report appears on your desktop for the view selected.

Settle Cash Activity Table Query Panel Options

The following table lists the fields and field descriptions for the panel.

Option	Description

Option	Description
Optional Parameters
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.
Acctg Basis	Specifies the accounting basis for the entity. For example, USTAX, GAAP, or IFRS. This field appears if you set the Reporting Source field to Specific Accounting Basis.
Search Criteria
Reporting Source	Specifies the accounting basis as the reporting source to use for qualifying the query. Options include: Across All Accounting Basis. Every accounting basis of the selected entities is used as the reporting source. Primary Accounting Basis Only (Default). Only the primary accounting basis for the entity is used as the reporting source. Specific Accounting Basis. Allows you to choose a specific accounting basis to use as the reporting source. The Acctg Basis field unhides for data entry in the Optional Parameters section.
Source Name	Displays the source name. For example, STARDIRECT. The field appears if you set the Reporting Source field to Primary Accounting Basis.
Date Type	Specifies the type of date to use for qualifying the query. Options include: Post Date Trade Date Accounting Date Settlement Date Month End Date
Query Based On	Allows you to qualify your query result. Options include: Date Range. Entity ID. Default. Primary Asset ID. The Issue Name, Issue Symbol, and Primary Asset ID fields unhide for data entry in the Optional Parameters section. Primary Asset ID and Entity ID. The Issue Name, Issue Symbol, and Primary Asset ID fields unhide for data entry in the Optional Parameters section.
Event Type	Displays the event type value Q_SCA.
Start Date	Specifies the start date for your query results. The default is today's date.
End Date	Specifies the end date for your query results. The default is today's date.