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 2 Next »


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.

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

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:

Content on this page:

  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.

Query Positions Results Panel Options

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

OptionDescription
Position DateSpecifies the position effective date for positions results.
Entity NameSpecifies the entity name. Resolves to an entity id used for query qualification.
Entity IDSpecifies the Entity ID. You can query by composite entity ID to view the rollup of all entities in the composite.
Entity Active StatusSpecifies the entity status. Options include Active and Both (Default).
Issue NameSpecifies the Issue Name.
Primary Asset IDSpecifies the primary asset ID of the security.
Entity List IDSpecifies the Entity List with entity IDs for query qualification.
StatusSpecifies the position match statuses to filter results.
Options include:
  • Not Reconed
  • Auto Recon
  • Auto Recon With Tolerance
  • Manual Recon
  • Out-of-Balance
Assigned UserSpecifies the LAN id of the person assigned by the supervisor to research the position break.
Position CategorySpecifies the category assigned by the business team to the position break.
Post DateSpecifies the date the results were posted to the work tables.
Long ShortIndicates whether a Long (Default) or Short position is used to qualify filter results. Eagle STAR cash balances display as Long positions.
Table OptionSpecifies 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.

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.

Query Positions Panel Options

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

OptionDescription
Business DateSpecifies the position effective date for positions results.
Entity NameSpecifies the entity name. Resolves to an entity id used for query qualification.
Entity IDSpecifies the Entity ID. You can query by composite entity ID to view the roll up of all entities in the composite.
Query Based OnSpecifies the security qualification to use to filter query results. Options include Issue Name (Default) and Xref ID.
Issue NameSpecifies the issue name to filter query results. Available when the Query Based On option is set to Issue Name.
Xref TypeSpecifies the security xreference type used to filter query results. Available when the Query Based On field is set to Xref ID.
Xref IDSpecifies 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 ItemsSpecifies 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.

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.

Query Custody Positions Panel Options

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

OptionDescription
Business DateSpecifies the position effective date for positions results.
Entity NameSpecifies the entity name. Resolves to an entity id used for query qualification.
Entity IDSpecifies the Entity ID. You can query by composite entity ID to view the roll up of all entities in the composite.
Query Based OnSpecifies the security qualification to use to filter query results. Options include Issue Name (Default) and Xref ID.
Issue NameSpecifies the issue name to filter query results. Available when the Query Based On option is set to Issue Name.
Xref TypeSpecifies the security xreference type used to filter query results. Available when the Query Based On field is set to Xref ID.
Xref IDSpecifies 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 ItemsSpecifies 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.

  • No labels