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:
| Option | Description |
|---|---|
| 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.
| Option | Description |
|---|---|
| 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.
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:
- 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. - Right click New Rule.
You see the Add New Rule dialog box. - In the Rule Name text box, enter the name of the new rule.
- Click the Module drop down and select the type of reconciliation.
Options include:
– Positions (Default)
– Lot
– Ledger - Specify whether you want the rule inactive or available for use.
Options include:
– Is Active (Default). The rule is available for use. - Click OK to save the rule.
You see the Tolerance Rules pane with the refreshed list of rules. - Select the rule from the list.
- In the Tolerance Rule Details pane, select and right click Add Rule Condition.
You see the New Rule Details dialog box. - 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.
- Click the Field Name drop down and select the field to reconcile.
- 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. - 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. - Repeat Step 9 to Step 12 to define additional conditions, as required.
- When complete, click OK.
You see the new rule detail displayed in the Tolerance Rule Detail pane.
0 Comments