Search Position Data for All Portfolios

Owned by Copy Page Tree (Unlicensed)
Last updated: Jul 27, 2023 by Nancy Cohn (Deactivated)
3 min read

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:

  1. In Accounting Center, in the left navigation pane, click Reports > Position Viewer.
    You see the Position Viewer workspace.  

  2. In the Search type list, click All Portfolios.
    In the Search Details pane, you see the search criteria for the selected search type.

  3. Complete the search criteria.

  4. 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

Option

Description

Default Search Options

 

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:

  • Posting date (Default)

  • Trade date

  • Accounting date

  • Contractual settlement date

  • Month end date

Display Zero Cash Balances

Indicates whether to include zero cash balances. A zero cash balance is a valid balance. Options include:

  • Yes. Default. The results include zero cash balance records for the specified cash position and asset currency.

  • No. The results exclude zero cash balances.

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:

  • No. Do not include these holdings in the query result.

  • Yes. Include these holdings in the query result.

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.

Â