To search position data for one portfolio and one security:
- From any Eagle window, click the Eagle Navigator button to access the Eagle Navigator.
- Enter Position Viewer in the Start Search text box.
- Click the Position Viewer (Accounting Center) link to access the Position Viewer.
You see the Query Positions window. - From the Query Based On field, select One Portfolio - One Security.
- Complete the options on the Query Positions window. See the Query Positions Window Options - Query Based on One Portfolio and One Security section.
- 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.
0 Comments