Versions Compared

Old Version 2

changes.mady.by.user Former user

Saved on

compared with

New Version 3

changes.mady.by.user Nancy Cohn

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.


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

Table of Contents
maxLevel2
indent2 px


Anchor
_Toc439930494
_Toc439930494
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.

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.

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.

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.

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.