Create Positions Exception Reports

Owned by Tom Fahey (Unlicensed)
Last updated: Sept 27, 2016 by Former user (Deleted)
8 min read

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.

Create the Total Summary Report

The Total Summary report displays the statistical counts of position matches and non-matches for each entity. You can submit the report using a position date range, source, and entity list.

To create the Total Summary report for positions:

  1. From the Position Recon console, double click Total Summary in the left pane.
  2. Click the Query Total Summary tab.
    You see the Query Total Summary panel.
  3. Complete the options on the Query Total Summary panel.
  4. Click Search.
    You see the Total Summary report.

Query 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.
Content on this page:

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

Create the Result Positions Report

The Result Positions report displays matched and unmatched records for a given position date, including the match status, out of balance amounts, researched comments, and position details. Results are based on the POSITIONS_RESULTS table in the MSGCENTER database.

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

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

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.

Create the Lots Total Summary Report

The Total Summary report displays the statistical counts of position lots matches and non-matches for each entity. You can submit the report using a position date range, source, and entity list.

To create the Total Summary report for open lots:

  1. From the Position Recon console, double click Lot Total Summary in the left pane.
  2. Click the Query Lots Total Summary tab.
    You see the Query Lots Total Summary panel.
  3. Complete the options on the Query Lots Total Summary panel.
  4. Click Search.
    You see the Lots Total Summary report.

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.

Create the Lot Exceptions Report

The Lot Exceptions report displays the match exceptions for position lots for a given effective date. Results are based on the LOT_EXCEPTION table in the MSGCENTER database.

To create the Lot Exceptions report:

  1. From the Position Recon console, double click Lot Exceptions in the left pane.
  2. Click the Lot Exceptions tab.
    You see the Query Lot Exceptions panel.
  3. Complete the options on the Query Lot Exceptions panel.
  4. Click Search.
    You see the Lot Exceptions report.

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.

Create the Ledger Total Summary Report

The Ledger Total Summary report displays the statistical counts of ledger balance matches and non-matches for each entity. You can submit the report using a position date range, source, and entity list.

To create the Total Summary report for ledger balances:

  1. From the Position Recon console, double click Total Summary in the left pane.
  2. Click the Query Ledger Total Summary tab.
    You see the Query Ledger Total Summary panel.
  3. Complete the options on the Query Ledger Total Summary panel.
  4. Click Search.
    You see the Ledger Total Summary report.

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.

Create the Ledger Exceptions Report

The Ledger Exceptions report displays ledger account breaks at the entity and ledger account level, matched across different sources, such as STARUSTAX and STARDIRECT. You can drill down into the entity match to view matches and out of balances at the security level. Results are based on the LEDGER_BALANCES_EXCEPTION table in the MSGCENTER database.

To create the Ledger Exceptions report:

  1. From the Position Recon console, double click Ledger Exceptions in the left pane.
  2. Click the Ledger Exceptions tab.
    You see the Query Ledger Exceptions panel.
  3. Complete the fields on the Query Ledger Exceptions panel.
  4. Click Search.
    You see the Query Ledger Exceptions report.

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.