You can use the Position Recon console to create a total summary and detail report of positions exceptions, ledger balance exceptions, and open lot exceptions.

...

To create the Total Summary report for positions: 1.    From

1. From the Position Recon console, double click Total Summary in the left pane.

...

1. Click the Query Total Summary tab.
   

...

1. You see the Query Total Summary panel

...

1. .

...

2. Complete the options on the Query Total Summary panel.

...

1. Click Search.
   

...

1. You see the Total Summary report.

Anchor
_Toc439930474 _Toc439930474

Query Total Summary Panel Options

The following describes the key options on the

• Entity List ID. Specifies the Entity list to filter query results. Or, you can select by composite entity ID to roll up all entities in the composite to the security level.

...

• Select by Post Date. Specifies whether an exact date or date range is used to filter query results.
  

...

• Options include:
  –  Exact Value (Default)
  –  Range

...

• Position Date. Specifies the position date to exactly match to query results. To use this option, you must select Exact Value as your post date selection.

...

• Start Position Date. Specifies the low position date in a date range to include in query results. To use this option, you must select Range as your post date selection.

...

• End Position Date. Specifies the high position date in a date range to include in query results. To use this option, you must select Range as your post date selection.

...

• Cust Source Name. Specifies the custodian data source to filter query results. This is the left side of the mathematical match.

...

• Pos Source Name. Specifies the second data source to filter query results. This is the right side of the mathematical match.

...

• Query Based On. Specifies additional filter to use for query results. Options include Primary Asset ID, Issue Name, and Xref ID.

...

• Max Items. Specifies the maximum number of result records that are returned for viewing. Default is 100 records.

...

• Table Option. Specifies the database tables to use for querying results. You select the tables to use when you decide on the mode of comparison during Position Recon setup.
  

...

• 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.
  –  ESTAR_Cost/Warehouse. Specifies the reconcilaition of ESTAR Cost to the warehouse records.

Anchor
_Toc439930475 _Toc439930475

Create the Result Positions Report

...

To create the Position Results report for a given position date: 1.    From

1. From the Position Recon console, double click Result Positions in the left pane.

...

1. Click the Query Positions Result tab.
   

...

1. You see the Query Positions Result panel.

...

1. Complete the options on the Query Positions Result panel.

...

1. Click Search.
   

...

1. You see the Result Positions report.

Anchor
_Toc439930476 _Toc439930476

Query Positions Result Panel Options

The following describes the key options on the Query Positions Result panel. ■      

• Business Date. Specifies the position effective date to filter query results.

...

• Entity Query Based On. Specifies the entity qualification to use to filter query results.
  

...

• Options include:
  –  Entity ID/Entity Composite ID
  –  Process Center
  –  Entity List
  –  All Entities

...

• Entity ID. Specifies the Entity ID to filter query results. Available when the Entity Query Based On option is set to Entity ID.

...

• Query Based On. Specifies the security qualification to use to filter query results.
  

...

• Options include:
  –  Primary Asset ID
  –  Issue Name (Default)
  –  Xref ID

...

• Primary Asset ID. Specifies the asset identifier to filter query results. Available when the Query Based On option is set to Primary Asset 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.

...

• Table Option. Specifies the data location assumed for the query.
  

...

• 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.

...

• Custom Xref Type. Specifies the security xref ID type to filter results.

...

• 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 match status (Not Reconed, Auto Recon, Auto Recon With Tolerance, Manual Recon, Out of Balance), category and sub-category classifications, STAR source, custodian source, post date, is open, group by, approved (yes/no), match assets type, assigned to user, and assigned from user.

Anchor
_Toc439930477 _Toc439930477

Create the Lots Total Summary Report

...

To create the Total Summary report for open lots: 1.    From

1. From the Position Recon console, double click Lot Total Summary in the left pane.

...

1. Click the Query Lots Total Summary tab.
   

...

1. You see the Query Lots Total Summary panel.

...

1. Complete the options on the Query Lots Total Summary panel.

...

1. Click Search.
   

...

1. You see the Lots Total Summary report.

Anchor
_Toc439930478 _Toc439930478

Query Lots Total Summary Panel Options

The following describes the key options on the Query Total Summary panel. ■      

• Entity List ID. Specifies the Entity list to filter query results. Or, you can select by composite entity ID to roll up all entities in the composite to the security level.

...

• Select by Post Date. Specifies whether an exact date or date range is used to filter query results.
  

...

• Options include:
  –  Exact Value (Default)
  –  Range

...

• Position Date. Specifies the position date to exactly match to query results. To use this option, you must select Exact Value as your post date selection.

...

• Start Position Date. Specifies the low position date in a date range to include in query results. To use this option, you must select Range as your post date selection.

...

• End Position Date. Specifies the high position date in a date range to include in query results. To use this option, you must select Range as your post date selection.

...

• Right Source Name. Specifies the custodian data source to filter query results. This is the right side of the mathematical match.

...

• Left Source Name. Specifies the second data source to filter query results. This is the left side of the mathematical match.

...

• Query Based On. Specifies additional filter to use for query results. Options include Primary Asset ID, Issue Name, and Xref ID.

...

• Max Items. Specifies the maximum number of result records that are returned for viewing. Default is 100 records.

Anchor
_Toc439930479 _Toc439930479

Create the Lot Exceptions Report

...

To create the Lot Exceptions report: 1.    From

1. From the Position Recon console, double click Lot Exceptions in the left pane.

...

1. Click the Lot Exceptions tab.
   

...

1. You see the Query Lot Exceptions panel.

...

1. Complete the options on the Query Lot Exceptions panel.

...

1. Click Search.
   

...

1. You see the Lot Exceptions report.

Anchor
_Toc439930480 _Toc439930480

Query Lot Exceptions Panel Options

The following describes the key options on the Query Lot Exceptions panel. ■      

• Position Date. Specifies the position effective date to filter query results.

...

• Entity Query Based On. Specifies the entity qualification to use to filter query results.
  

...

• Options include:
  –  Entity ID/Entity Composite ID
  –  Process Center
  –  Entity List
  –  All Entities

...

• Entity ID. Specifies the Entity ID to filter query results. Available when the Entity Query Based On option is set to Entity ID.

...

• Query Based On. Specifies the security qualification to use to filter query results.
  

...

• Options include:
  –  Primary Asset ID
  –  Issue Name (Default)
  –  Xref ID

...

• Primary Asset ID. Specifies the asset identifier to filter query results. Available when the Query Based On option is set to Primary Asset 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 to use 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 match status, category and sub-category classifications, STAR source, custodian source, post date, entity name, is open, group by, approved (yes/no), assigned to user, assigned from user, ledger account, and base currency.

Anchor
_Toc439930481 _Toc439930481

Create the Ledger Total Summary Report

...

To create the Total Summary report for ledger balances: 1.    From

1. From the Position Recon console, double click Total Summary in the left pane.

...

1. Click the Query Ledger Total Summary tab.
   

...

1. You see the Query Ledger Total Summary panel.

...

1. Complete the options on the Query Ledger Total Summary panel.

...

1. Click Search.
   

...

1. You see the Ledger Total Summary report.

Anchor
_Toc439930482 _Toc439930482

Query Ledger Total Summary Panel Options

The following describes the key options on the Query Ledger Total Summary panel. ■      

• Entity List ID. Specifies the Entity list to filter query results. Or, you can select by composite entity ID to roll up all entities in the composite to the security level.

...

• Select by Post Date. Specifies whether an exact date or date range is used to filter query results.
  

...

• Options include:
  –  Exact Value (Default)
  –  Range

...

• Position Date. Specifies the position date to exactly match to query results. To use this option, you must select Exact Value as your post date selection.

...

• Start Position Date. Specifies the low position date in a date range to include in query results. To use this option, you must select Range as your post date selection.

...

• End Position Date. Specifies the high position date in a date range to include in query results. To use this option, you must select Range as your post date selection.

...

• Cust Source Name. Specifies the custodian data source to filter query results. This is the left side of the mathematical match.

...

• Pos Source Name. Specifies the second data source to filter query results. This is the right side of the mathematical match.

...

• Query Based On. Specifies additional filter to use for query results. Options include Primary Asset ID, Issue Name, and Xref ID.

...

• Max Items. Specifies the maximum number of result records that are returned for viewing. Default is 100 records.

Anchor
_Toc439930483 _Toc439930483

Create the Ledger Exceptions Report

...

To create the Ledger Exceptions report: 1.    From

1. From the Position Recon console, double click Ledger Exceptions in the left pane.

...

1. Click the Ledger Exceptions tab.
   

...

1. You see the Query Ledger Exceptions panel.

...

1. Complete the fields on the Query Ledger Exceptions panel.

...

1. Click Search.
   

...

1. You see the Query Ledger Exceptions report.

Anchor
_Toc439930484 _Toc439930484

Query Ledger Exceptions Panel Options

The following describes the key options on the Query Ledger Exceptions panel. ■      

• Position Date. Specifies the position effective date to filter query results.

...

• Entity Query Based On. Specifies the entity qualification to use to filter query results.
  

...

• Options include:
  –  Entity ID/Entity Composite ID
  –  Process Center
  –  Entity List
  –  All Entities

...

• Entity ID. Specifies the Entity ID to filter query results. Available when the Entity Query Based On option is set to Entity ID.

...

• Query Based On. Specifies the security qualification to use to filter query results.
  

...

• Options include:
  –  Primary Asset ID
  –  Issue Name (Default)
  –  Xref ID

...

• Primary Asset ID. Specifies the asset identifier to filter query results. Available when the Query Based On option is set to Primary Asset 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 to use 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 match status, category and sub-category classifications, STAR source, custodian source, post date, entity name, is open, group by, approved (yes/no), assigned to user, assigned from user, ledger account, and base currency.