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 must define the out-of-balance tolerances and tolerance rules to apply during the reconciliation of positions, ledger balances, and lots. For positions, you can define tolerances for ESTAR database reconciliation as well as data warehouse reconciliation.

Anchor
_Toc439930432
_Toc439930432
Define the Out-of-Balance Tolerances

You need to establish the field tolerances for out of balance conditions on matched positions. Matched positions are paired by like security, entity, business date, and long/short indicator. You can define field tolerances for the fields reconciled in your workflow using several approaches:

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

Table of Contents
maxLevel2
indent2 px

  • Direct Approach. You can edit the runmatch_db2.xml rule in the position match stream to configure specific tolerance amounts for each available reconciliation field. You must use the Message Center Editor to apply these edits.
  • Indirect Approach. You can create tolerance rules using the Position Recon console to apply to the position, lot, and ledger balance recon event panels. You can then run the panels manually or from within the position match stream.

When using the warehouse to warehouse reconciliation option for positions, you can reconcile the several fields on the POSITION_DETAIL table in the HOLDING database to specific tolerances:

  • SHARE_PAR_VALUE. Specifies the position units
  • ORIG_FACE. Specifies the original face
  • LOCAL_MARKET_VALUE. Specifies the market value
  • ACCRUED_INCOME_LOCAL. Specifies the accruals
  • NOTIONAL_COST. Specifies the cost
  • BOOK_VALUE_LOCAL. Specifies the book value

When using the ESTAR to warehouse reconciliation option, you can reconcile several fields on the ESTAR_PORTFOLIO_VALUATION table in the ESTAR database to specific tolerances:

  • QTY_PRICED. Specifies the position units.
  • TOT_URGL_B. Specifies the original face
  • AMORT_COST_BASE. Specifies the cost

When using the Eagle default streams to load the local tables, you can customize the position fields stored on the work tables and build a custom reconciliation for specific tolerances. For example, you can:

  • Load settled positions in place of traded positions
  • Load traded cash balances in place of settled cash balances
  • Load both traded and settled cash balances
  • Load both base and local cash balances

Tolerances are applied as a +/- absolute amounts that classify the difference, if any, between matched records as in balance, out of balance within tolerance, and out of balance.

Anchor
_Toc439930433
_Toc439930433
Define Tolerance Rules

You can define tolerance rules to use to apply custom tolerance checks to a segment of your data, prior to the default Run Match Now reconciliation. For example, you can use a tolerance rule to reconcile specific entities and securities types for different tolerances than the default Run Match Now rules and recon event panels.

...

Note

Any special tolerance check for a field must use the same type as used by the default Run Match Now processing for the field. For example, you may not apply percentage checks using a tolerance rule when the default rule applies amount checks for that field.

To define a Positions, Ledger Balances, or Lots tolerance rule:

  1. From the Position Recon console, click Tolerance Rules.
    You see the Tolerance Rules pane with the current list of tolerance rules and the Tolerance Rule Detail pane with the list of details for the rule selected.
  2. Right click New Rule.
    You see the Add New Rule dialog box.
  3. In the Rule Name text box, enter the name of the new rule.
  4. Click the Module drop down and select the type of reconciliation.
    Options include:
    –  Positions (Default)
    –  Lot
    –  Ledger
  5. Specify whether you want the rule inactive or available for use.
    Options include:
    –  Is Active (Default). The rule is available for use.
  6. Click OK to save the rule.
    You see the Tolerance Rules pane with the refreshed list of rules.
  7. Select the rule from the list.
  8. In the Tolerance Rule Details pane, select and right click Add Rule Condition.
    You see the New Rule Details dialog box.
  9. Click the Data Field drop down and select the database and column values used to qualify the selection of exceptions, including database filter logic using Boolean operators.
  10. Click the Field Name drop down and select the field to reconcile.
  11. In the Value text box, enter the tolerance to apply. For amount differences, enter the arithmetic value. For percentage differences, enter the percent value in one-hundredths.
    NOTE: You can enter values with 2-digit or 12-digit precision, depending on the setting of the Low/High Precision Switch (tag 7003) indicator in the default rule.
  12. Click the Type drop down and select the type of tolerance check.
    Options include:
    –  Value (Default). Specifies that amount differences are tolerance checked.
    –  Percent. Specifies that percentage differences are tolerance checked.
  13. Repeat Step 9 to Step 12 to define additional conditions, as required.
  14. When complete, click OK.
    You see the new rule detail displayed in the Tolerance Rule Detail pane.