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 6 Current »

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.

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:

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

On this page

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:

OptionDescription
SHARE_PAR_VALUESpecifies the position units.
ORIG_FACESpecifies the original face.
LOCAL_MARKET_VALUE

Specifies the market value.

ACCRUED_INCOME_LOCALSpecifies the accruals.
NOTIONAL_COSTSpecifies the cost.
BOOK_VALUE_LOCALSpecifies 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.

OptionDescription
QTY_PRICEDSpecifies the position units.
TOT_URGL_BSpecifies the original face.
AMORT_COST_BASESpecifies 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.

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.

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