To query In the Position Viewer workspace, you can select a Search type of All Portfolios to review Cost, Cash, and Income position data across all entities for a certain Primary Asset ID or Issue Name. Use this option when you want to see a security across funds.
To search position data for all portfolios:
...
In Accounting Center, in the left navigation pane, click Reports > Position Viewer.
You see the Position Viewer workspace.In the Search type list, click All Portfolios.
In the Search Details pane, you see the search criteria for the selected search type.Complete the search criteria.
Click the Search button.
You see the selected search criteria in the header area. You see the search results in the grid.
All Portfolios - Search Options
The following are the options in the Search Details pane of for a Search type of All Portfolios in Position Viewer's Portfolio Viewer workspace.
Option | Description | |||||
|---|---|---|---|---|---|---|
Default Search Options
|
...
The following are the options for a query based on all portfolios in Position Viewer:
...
Src name | Specifies the name of the interface source. . |
DB Partition | Specifies the database partition to query. |
...
The default is 1 (ESTAR). You can add additional values if your environment uses partitioning. |
As of Start Date |
...
Specifies the As Of start date. | |
Bypass Cost Recalculation |
...
Indicates whether to bypass cost recalculation. Available options include Yes and No. | |
Issue |
...
Name |
...
...
Specifies the name of the security. |
...
| |
Asset ID | Specifies the unique Eagle security identifier assigned by the system |
...
. |
Cash Balance Date Type |
...
Indicates the date type of cash balance record you want to view. Options include: |
...
|
...
|
...
|
...
|
...
|
Display Zero Cash Balances |
...
Indicates whether to include zero cash balances. A zero cash balance is a valid balance. Options include: |
...
|
...
|
...
|
...
|
Rejection/Corporate Actions Begin Date |
...
Specifies the begin date for which you want to view rejection and corporate action activity. If you specify a range, you exclude activity that occurred outside this date range from the Rejections and Corporate Action detail tabs in the Cost object. | |
Rejection/Corporate Actions End Date |
...
Specifies the end date for which you want to view rejection and corporate action activity. | |
Trade Activity Start Date |
...
Specifies the begin date for which you want to view trade activity. If you specify a range, you exclude trade activity that occurred outside this date range from the Trade Activity detail tab in the Cost object. | |
Trade Activity End Date |
...
Specifies the end date for which you want to view trade activity. | |
Include Zero Holdings |
...
Determines whether zero holdings appear in the query result. Available options include: |
...
|
...
|
...
|
...
|
...
Income Report Start Date | Specifies the begin date to view income activity. |
...
If you specify a range, you exclude income activity that occurred outside this date range from the Income object. |
Income Report |
...
End Date | Specifies the end date to view income activity. |
...
|
Max Items Composite |
...
Specifies the maximum number of records in rows of data to return |
...
for your search criteria. Your Center Role determines the default value that appears. If your Center Role allows it, you can change the default value to a lower number of rows, but you cannot exceed the default value. | |
Additional Search Options | |
Xref Type | Specifies the cross reference security type, such as SEDOL, CUSIP, and so on. |
Xref ID | Specifies the cross reference security identifier. |
Primary Asset ID | Specifies the primary industry standard identifier, such as CUSIP and ISIN. |