Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

DO NOT TURN THIS TOPIC INTO A TABLE!!! I am actively working on it. nkc
In the Position workspace, you can select a Search type of One Portfolio One Sec to review position data based on a single entity and security. Use this option when you want to see a single position for a fund..

To search position data for one portfolio and one security:

  1. From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
  2. Enter Position Viewer in the Start Search text box.
  3. Click the Position Viewer (Accounting Center) link to access the Position Viewer.
    You see the Position workspace.
  4. In the the Search type list, click One Portfolio One Sec.
  5. Click the Search arrow and select New SearchLast Search, or any saved search. Or, click the double arrow to the right of the workspace to expand the Search Details pane. 
    You see the Search Details pane.
  6. Complete the search criteria or click Add Search Criteria to manage the search criteria that appear.
  7. Click the Search button in the Search Details pane.
    You see the selected search criteria in the header area. You see the search results in the grid. 
  8. From the Query Based On field, select One Portfolio - One Security.
  9. Complete the options on the Query Positions window. See the Query Positions Window Options - Query Based on One Portfolio and One Security section.
  10. Click Search.

Query Positions Window Options - Query Based on One Portfolio and One Security

The following are the options for a query based on one portfolio and one security in Position Viewer:

  • Query Based On. Determines the scope of position data to return. Select One Portfolio - One Security to view a single position for a fund.
  • Entity Name. Specifies the unique account description for the entity to query.
  • Entity ID. Specifies the unique account identifier for the entity to query. This is the primary key to the Entity table.
  • Src name. Specifies the name of the interface source. You can accept the default based on the Entity Name and Entity ID field values.
  • Cash Balance. Specifies the cash balance as of date. Options include:
    –  Settlement Date. Returns cash balances as of the settlement date.
    –  Trade Date. Returns cash balances as of the trade date.
  • Position Type. Allows you to view position information for the current day or as of a point in time. Available options include:
    –  Current. Allows you to view all positions as of the current day.
    –  As Of. Allows you to view positions for a specified date. When using this option, select a date and choose As Of Summary.
  • Account Basis. Specifies the accounting basis used by the entity. If there are multiple bases, select a basis from the drop down list.
  • Base Currency. Displays the currency that the entity uses for accounting purposes.
  • Issue: Query Based On. Determines the type of security identifier you use in the query. Available options include:
    –  Issue Name. Descriptive name of the security.
    –  Primary Asset ID. Primary industry standard identifier such as CUSIP and ISIN.
    –  Xref ID. Security cross reference.
  • Issue Name. Specifies the name of the security. This field appears if the query is based on issue name.
  • Primary Asset ID. Specifies the primary industry standard identifier, such as CUSIP and ISIN. This field appears if the query is based on primary asset ID.
  • Xref Type. Specifies the cross reference security type, such as SEDOL, CUSIP, and so on. This field appears if the query is based on security cross reference.
  • Xref ID. Specifies the cross reference security identifier. This field appears if the query is based on security cross reference.
  • 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 Balance. 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.
  • Select Date Range for Income History Query. Indicates whether you want to enter a date range 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 Start Date. Specifies the begin date to view income activity. Displayed when you select Yes in the Select Date Range for Income History Query field.
  • Income Report End Date. Specifies the end date to view income activity. Displayed when you select Yes in the Select Date Range for Income History Query field.
  • Max Items Composite. Specifies the maximum number of rows of data to return.
  • Page Rows. Specifies the number of rows to return on the Query Result console, up to the maximum specified in the Max Items Composite field.
  • Search. Executes the query based on the current query parameters. Returns data from the database in the Query Result view.
  • Resubmit. Resubmits a query after you change some query parameters.
  • Cancel. Stops the query that is currently executing.
  • Clear Query. Clears the current query criteria from the query fields. This button is located both in the main toolbar and halfway down the right side.
  • AutoSave Requests. Automatically saves queries for future use as you execute them.
  • Save Query. Saves a query for use in future sessions of Position Viewer.
  • Save as Default Query. Saves a query as the default query. The default query automatically runs each time you open Position Viewer.
  • Delete. Permanently deletes the selected query.
  • Clear. Permanently deletes all queries from the Position Viewer query list for your user ID. This includes the default query which will no longer be available when you access Position Viewer.
  • Properties. Opens the Query Properties dialog box where you can review the query parameters and enter a custom caption for the query.
  • No labels

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.