Versions Compared

Old Version 2

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

You can use the Position Recon console to view the position match results. You can also directly query the MSGCENTER work tables to view the source data loaded to work tables from Eagle PACE, Eagle STAR, and custodian information.

...

Note

You must set DataSetOption=1 to view work table queries for the MSGCENTER database.

Anchor
_Toc439930493
_Toc439930493
Query Position Results

You can query match results stored to the POSITIONS_RESULTS and RECON_COMMENTS tables in the MSGCENTER database using Eagle STAR panels.

To query position results on MSGCENTER work tables for a given position date:

Panel
borderColor#9F9F9F
titleColor#F7F9F9
titleBGColor#B48436
borderStyledashed
titleContent on this page:

Table of Contents
maxLevel2
indent2 px

  1. From the Position Recon console, click Positions Results Data in the left pane.
  2. Click the Query Positions Results Data tab.
    You see the Query Positions Results Data panel.
  3. Complete the options on the Query Positions Results Data panel.
  4. Click Submit.

Anchor
_Toc439930494
_Toc439930494
Query Positions Results Panel Options

The following are the key options on the Query Positions Results Data panel.

  • Position Date. Specifies the position effective date for positions results.
  • Entity Name. Specifies the entity name. Resolves to an entity id used for query qualification.
  • Entity ID. Specifies the Entity ID. You can query by composite entity ID to view the rollup of all entities in the composite.
  • Entity Active Status. Specifies the entity status. Options include Active and Both (Default).
  • Issue Name. Specifies the Issue Name.
  • Primary Asset ID. Specifies the primary asset ID of the security.
  • Entity List ID. Specifies the Entity List with entity IDs for query qualification.
  • Status. Specifies the position match statuses to filter results.
    Options include:
    –  Not Reconed
    –  Auto Recon
    –  Auto Recon With Tolerance
    –  Manual Recon
    –  Out-of-Balance
  • Assigned User. Specifies the LAN id of the person assigned by the supervisor to research the position break.
  • Position Category. Specifies the category assigned by the business team to the position break.
  • Post Date. Specifies the date the results were posted to the work tables.
  • Long Short. Indicates whether a Long (Default) or Short position is used to qualify filter results. Eagle STAR cash balances display as Long positions.
  • Table Option. Specifies the DataSetOption configuration setting for Position Recon environment.
    Options include:
    –  Position/Position Cust. Specifies the reconciliation of local Eagle STAR work records to local custodian work records.
    –  Warehouse/Warehouse. Specifies the reconciliation of warehouse records to warehouse records.
    –  Position/Warehouse. Specifies the reconciliation of local Eagle STAR work records to the warehouse records.
    –  Position Cust/Warehouse. Specifies the reconciliation of local custodian work records to the warehouse records.
    –  Portfolio Valuation/Warehouse. Specifies the reconciliation of ESTAR to the warehouse records.
  • Max Items. Specifies the maximum number of result records that are returned for viewing. Default is 100 records.

...

Note

You can build custom reports based on this panel and build custom message streams to create files for external systems or distribute report results to the organization. The panel name is pan-qry_positions_results_event for event QRY_POSITIONS_RESULTS_EVENT.

Anchor
_Toc439930495
_Toc439930495
Query Positions

The Positions report displays work records from the POSITIONS and POSITIONS_EXT work tables of the MSGCENTER database.

To submit the Positions query for the MSGCENTER work tables:

  1. From the Position Recon console, click Query Positions in the left pane.
  2. Click the Query Positions tab.
    You see the Query Positions panel.
  3. Complete the options on the Query Positions panel.
  4. Click Submit.

Anchor
_Toc439930496
_Toc439930496
Query Positions Panel Options

The following are the key options on the Query Positions panel.

  • Business Date. Specifies the position effective date for positions results.
  • Entity Name. Specifies the entity name. Resolves to an entity id used for query qualification.
  • Entity ID. Specifies the Entity ID. You can query by composite entity ID to view the roll up of all entities in the composite.
  • Query Based On. Specifies the security qualification to use to filter query results. Options include Issue Name (Default) and Xref ID.
  • Issue Name. Specifies the issue name to filter query results. Available when the Query Based On option is set to Issue Name.
  • Xref Type. Specifies the security xreference type used to filter query results. Available when the Query Based On field is set to Xref ID.
  • Xref ID. Specifies the security xreference for the Xref ID type to filter query results. Required when the Query Based On option is set to Xref ID.
  • Max Items. Specifies the maximum number of result records that are returned for viewing. Default is 100 records.

You can optionally qualify report results by post date, source, entity list ID, primary asset id, assets type, and long/short indicator.

Anchor
_Toc439930497
_Toc439930497
Query Custody Positions

The Custody Positions query displays work records from the POSITIONS_CUST and POSITIONS_CUST_EXT work tables of the MSGCENTER database.

To submit the Custody Positions query for the MSGCENTER work tables:

  1. From the Position Recon console, click Custody Positions in the left pane and then click the Query Custody Positions tab in the right pane.
    You see the Query Custody Positions panel.
  2. Complete the options on the Query Custody Positions panel.
  3. Click Submit.
    You see the Custody Position query results.

Anchor
_Toc439930498
_Toc439930498
Query Custody Positions Panel Options

The following are the key options on the Query Custodian Positions panel.

  • Business Date. Specifies the position effective date for positions results.
  • Entity Name. Specifies the entity name. Resolves to an entity id used for query qualification.
  • Entity ID. Specifies the Entity ID. You can query by composite entity ID to view the roll up of all entities in the composite.
  • Query Based On. Specifies the security qualification to use to filter query results. Options include Issue Name (Default) and Xref ID.
  • Issue Name. Specifies the issue name to filter query results. Available when the Query Based On option is set to Issue Name.
  • Xref Type. Specifies the security xreference type used to filter query results. Available when the Query Based On field is set to Xref ID.
  • Xref ID. Specifies the security xreference for the Xref ID type to filter query results. Required when the Query Based On option is set to Xref ID.
  • Max Items. Specifies the maximum number of result records that are returned for viewing. Default is 100 records.

You can optionally qualify report results by post date, custodian source, entity list ID, primary asset id, assets type, and long/short indicator.