The Position Table Query allows you to research positions processed by STAR to PACE Direct based on data stored in the POSITION, POSITION_DETAIL, and POSITION_COST_DETAIL tables in the HOLDING database in the Eagle PACEdata warehouse.
To view positions in the Eagle PACEdata warehouse:
In Accounting Center, in the left navigation pane, click Reports > System Queries > STAR to PACE Direct > Position Table Query.
You see the Position Table Query panel.Complete the options on the Position 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.
Position Table Query Panel Options
The following table lists the fields and field descriptions for the Position Table Query panel.
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. |
Custody Bank Acct Num | Specifies the custodian bank primary account number. |
Entity Type | Displays the entity type. |
Issue Name | Specifies the issue name. |
Issue Symbol | Specifies the issue symbol. |
Primary Asset ID | Specifies the primary asset identifier. |
Long/Short Indicator | Allows you to display only long or short positions in your query results. |
Search Criteria | |
Source Name | Specifies the source to use for qualifying the query. |
Syncsend Engine Router | (Hidden) Indicates whether the system uses the Accounting engine or a report service to process the report results. Options include:
|
Event Type | Displays the event type value POSITION_QUERY. |
Date | Specifies the date to use for qualifying the query. The default is the current date. |