Recon Event Panel Options

When you use Position Recon panels to submit events to match positions, ledger balances, and lots. You can select various event options based on the business requirements for your reconciliation. See the Match Positions, Ledger Balances and Lots page for details about using these panels.

Recon Positions Event Panel Options

The following are the key options when you match using the Recon Position Event panel.

Option

Tag

Description

Option

Tag

Description

Pos Recon Process





Event Type

55

Specifies the event used to reconcile positions. Default is RECON_POSITION2.

Data Set Option

989

Specifies the location of the position records for reconciliation. 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.

Left Source

1102

Specifies the data source or source list to use for the left match.

Right Source

1104

Specifies the data source or source list to use for the right match.

Effective Date

1109

Specifies the effective date of the records to match.

Entity Name

1164

Specifies the name of the entity to match on ledger balances.

Entity ID / Composite ID

1163

Specifies the entity ID or composite entity ID to match on ledger balances.

Active Status

1283

Specifies the entity status. Options include Active (default) and Both.

Tolerance Rule ID

4256

Specifies the tolerance rule with the filters to apply for position reconciliation.

Unmatch Only Flag List

7050

Indicates whether to store only unmatched and out of balance records to the Exception tables to conserve table space. Default is store all records.

Match Nulls

1018

Indicates whether to reconcile to null values or flag as unmatched.

Tolerances





Position Units by Percentage

1019

Indicates whether to use a percentage tolerance check.

Position Units Tolerance

963

Specifies the tolerance amount allowed for Position Units. Default is 0.25.

Original Face by Percentage

1021

Indicates whether to use a percentage tolerance check.

Original Face Tolerance

964

Specifies the tolerance amount allowed for Original Face. Default is 0.25.

Market Value by Percentage

1023

Indicates whether to use a percentage tolerance check.

Market Value Tolerance

965

Specifies the tolerance amount allowed for Market Value. Default is 0.25.

Cost by Percentage

1025

Indicates whether to use a percentage tolerance check.

Cost Tolerance

966

Specifies the tolerance amount allowed for Cost. Default is 0.25.

Book Value by Percentage

1027

Indicates whether to use a percentage tolerance check.

Book Value Tolerance

967

Specifies the tolerance amount allowed for Book Value. Default is 0.25.

Accruals by Percentage

1029

 Indicates whether to use a percentage tolerance check.

Accruals Tolerance

968

Specifies the tolerance amount allowed for Accruals. Default is 0.25.

For warehouse to warehouse position matching, you can specify tolerances for these additional fields on the data warehouse:





Book Value Base by Percentag

1030

Indicates whether to use a percentage tolerance check.

Book Value Base Tolerance

7661

Specifies the tolerance amount allowed for Book Value Base. Default is 0.25.

Market Value Base by Percentage

1031

Indicates whether to use a percentage tolerance check.

Market Value Base Tolerance

7662

Specifies the tolerance amount allowed for Market Value Base. Default is 0.25.

Accrued Income by Percentage

1032

Indicates whether to use a percentage tolerance check.

Accrued Income Tolerance

7663

Specifies the tolerance amount allowed for Accrued Income. Default is 0.25.

Notional Cost Base by Percentage

1033

Indicates whether to use a percentage tolerance check.

Notional Cost Base Tolerance

7664

Specifies the tolerance amount allowed for Notional Cost Base. Default is 0.25.

Unrealized GL Base by Percentage

1034

Indicates whether to use a percentage tolerance check.

Unrealized GL Base Tolerance

7665

Specifies the tolerance amount allowed for Unrealized Gain/Loss Base. Default is 0.25.

Unrealized GL by Percentage

1035

Indicates whether to use a percentage tolerance check.

Unrealized GL Tolerance

7666

Specifies the tolerance amount allowed for Unrealized Gain/Loss. Default is 0.25.

Dividend Receivable by Percentage

1036

Indicates whether to use a percentage tolerance check.

Dividend Receivable Tolerance

7667

Specifies the tolerance amount allowed for Dividend Receivable. Default is 0.25.

Dividend Receivable Base by Percentage

1037

Indicates whether to use a percentage tolerance check.

Dividend Receivable Base Tolerance 

7668

Specifies the tolerance amount allowed for Dividend Receivable Base. Default is 0.25.

Reclaim Receivable Tolerance

1038

Indicates whether to use a percentage tolerance check.

Reclaim Receivable Tolerance

7669

Specifies the tolerance amount allowed for Reclaim Receivable. Default is 0.25.

Reclaim Receivable Base by Percentage

1039

Indicates whether to use a percentage tolerance check.

Reclaim Receivable Base Tolerance

7670

Specifies the tolerance amount allowed for Reclaim Receivable Base. Default is 0.25.

Settled Position by Percentage

1040

Indicates whether to apply a percentage instead of a difference as the tolerance check.

Settled Position Tolerance

7671

Specifies the tolerance amount allowed for Settled Position. Default is 0.25.

User Defined





User Float21 Tolerance

7676

Indicates/specifies the tolerance amount allowed for User Float21.

User Float22 Tolerance

7677

Indicates/specifies the tolerance amount allowed for User Float22.

User Group1 Tolerance Switch

7051

Indicates whether to reconcile for matching User Group1 values.

User Group2 Tolerance Switch

7052

Indicates whether to reconcile for matching User Group2 values.

User Date1 Tolerance Switch

7053

Indicates whether to reconcile for matching User Date1 values.

User Date2 Tolerance Switch

7054

Indicates whether to reconcile for matching User Date2 values.

NOTE: For Portfolio Valuation to Warehouse position matching, you can only use Positions Units, Cost, and Unrealized Gain/Loss tolerances.

Recon Ledger Event Panel Options

The following are the options when you match using the Recon Ledger Event panel.

Option

Tag

Description

Option

Tag

Description

Ledger Matching Process





Event Type

55

Displays the event used to reconcile positions as LEDGER_RECON.

Table Option

989

Specifies the location of the ledger balance records as Warehouse/Warehouse.

Left Source ID

7002

Indicates whether a source ID or source list is used to locate the records for the left match. Default is Source ID.

Left Source

1102

Specifies the source ID or source list to use for the left match.

Left Source List

373

Specifies the source list to use for the left match.

Right Source ID

7004

Indicates whether a source ID or source list is used to locate the records for the right match. Default is Source ID.

Right Source

1104

Specifies the source ID or source list to use for the right match.

Right Source List

323

Specifies the source list to use for the right match.

Effective Date

1109

Specifies the effective date of the records to match.

Entity Name

1164

Specifies the name of the entity to match on ledger balances.

Entity ID / Composite ID

1163

Specifies the entity ID or composite entity ID to match on ledger balances.

Active Status

1283

Specifies the entity status. Options include Active (default) and Both.

Match Nulls

1018

Indicates whether to reconcile to null values or flag as unmatched.

Unmatch Only Flag List

7050

Indicates whether to store only unmatched and out of balance records to the Exception tables to conserve table space. Default is store all records.

Roll Up Indicator List

7060

Indicates whether to roll up security level balances to the ledger account for reconciliation.

Currency Flag List

7179

 Indicates whether to reconcile local currency balances in addition to base currency balances.

Tolerance Rule ID

4256

Specifies the tolerance rule with the filters to apply for ledger balance reconciliation.

Tolerances





Ledger Balance by Percentage

930

 Indicates whether to apply percentage tolerances. Default is No.

Ledger Balance Tol 

922

Specifies the tolerance amount to apply to ledger balance matches to determine in balance, in balance within tolerance, and out of balance match statuses. Default is 0.25.

Recon Lots Event Panel Options

The following are the options when you match using the Recon Lots Event panel.

Option

Tag

Description

Option

Tag

Description

Lot Recon Process





Event Type

55

Displays the event used to reconcile positions as LOTS_RECON.

Dataset Option

989

Specifies the location of the ledger balance records as Warehouse/Warehouse.

Left Source ID / Source List

7002

Indicates whether a source ID or source list is used to locate the records for the left match. Default is Source ID.

Left Source Name

1102

Specifies the source ID to use for the left match.

Left Source List

373

Specifies the source list to use for the left match.

Right Source ID / Source List

7004

Indicates whether a source ID or source list is used to locate the records for the right match. Default is Source ID.

Right Source Name

1104

Specifies the source ID to use for the right match.

Right Source List

323

Specifies the source list to use for the right match.

Effective Date

1109

Specifies the effective date of the records to match.

Entity Name

1164

Specifies the name of the entity to match on ledger balances.

Entity ID / Composite ID

1163

Specifies the entity ID or composite entity ID to match on ledger balances.

Active Status

1283

Specifies the entity status. Options include Active (default) and Both.

Tolerance Rule ID

4256

Specifies the tolerance rule with the filter to apply for lot reconciliation.

Unmatch Only Flag List

7050

Indicates whether to store only unmatched and out of balance records to the Exception tables to conserve table space.

Match Nulls

1018

Indicates whether to reconcile to null values or flag as unmatched.

Matching by Orig Event ID

7043

Indicates whether to match lots by Original Event ID as an additional match key. Default is No.

Tolerances





Original Face by Percentage

4064

Indicates whether to use a percentage tolerance check.

Original Face Tolerance

8608

Specifies the tolerance amount allowed for Original Face. Default is 0.25.

Par of Shares by Percentage

4065

Indicates whether to use a percentage tolerance check.

Par of Shares Tolerance

8609

Specifies the tolerance amount allowed for Par of Shares. Default is 0.25.

Book Value by Percentage

4066

Indicates whether to use a percentage tolerance check.

Book Value Tolerance

8610

Specifies the tolerance amount allowed for Book Value. Default is 0.25.

Accrued Income by Percentage

4067

Indicates whether to use a percentage tolerance check.

Accrued Income Tolerance

8611

Specifies the tolerance amount allowed for Accrued Income. Default is 0.25.

Amort LTD Base by Percentage

4068

Indicates whether to use a percentage tolerance check.

Amort LTD Base Tolerance

8612

Specifies the tolerance amount allowed for Amort LTD Base. Default is 0.25.

Interest Sold Base by Percentage

4069

Indicates whether to use a percentage tolerance check.

Interest Sold Base Tolerance

8613

Specifies the tolerance amount allowed for Interest Sold Base. Default is 0.25.

Int Received by Percentage

4070

Indicates whether to use a percentage tolerance check.

Int Received Tolerance

8614

Specifies the tolerance amount allowed for int_received. Default is 0.25.

OID LTD Income by Percentage

4071

Indicates whether to use a percentage tolerance check.

OID LTD Income Tolerance

8615

Specifies the tolerance amount allowed for oid_ltd_income. Default is 0.25.

Market Value Income by Percentage

4072

Indicates whether to use a percentage tolerance check.

Market Value Income Tolerance

8616

Specifies the tolerance amount allowed for market_value_income. Default is 0.25.

Notional Cost by Percentage

4073

Indicates whether to use a percentage tolerance check.

Notional Cost Tolerance

8617

Specifies the tolerance amount allowed for notional_cost. Default is 0.25.

Mkt Value Base by Percentage

4074

Indicates whether to use a percentage tolerance check.

Mkt Value Base Tolerance

8618

Specifies the tolerance amount allowed for mkt_value_base. Default is 0.25.

Notional Market Value by Percentage

4075

Indicates whether to use a percentage tolerance check.

Notional Market Value Tolerance

8619

Specifies the tolerance amount allowed for notional_market_value. Default is 0.25.

TIP LTD Income by Percentage

4076

Indicates whether to use a percentage tolerance check.

TIP LTD Income Tolerance

8620

Specifies the tolerance amount allowed for tip_ltd_income. Default is 0.25.

Cls Amort Base by Percentage

4077

 Indicates whether to use a percentage tolerance check.

Cls Amort Base Tolerance

8621

Specifies the tolerance amount allowed for cls_amort_base. Default is 0.25.

Cls OID Income by Percentage

4078

Indicates whether to use a percentage tolerance check.

Cls OID Income Tolerance

8622

Specifies the tolerance amount allowed for cls_oid_income. Default is 0.25.

Cls TIPs Income by Percentage

4079

Indicates whether to use a percentage tolerance check.

Cls TIPs Income Tolerance

8623

Specifies the tolerance amount allowed for cls_tips_income. Default is 0.25.

Accr LTD Base by Percentage

4080

Indicates whether to use a percentage tolerance check.

Accr LTD Base Tolerance

8624

Specifies the tolerance amount allowed for accr_ltd_base. Default is 0.25.

Amort PTD Base by Percentage

4081

Indicates whether to use a percentage tolerance check.

Amort PTD Base Tolerance

8625

Specifies the tolerance amount allowed for amort_ptd_base. Default is 0.25.

Credit Loss Base by Percentage

4082

Indicates whether to use a percentage tolerance check.

Credit Loss Base Tolerance

8626

Specifies the tolerance amount allowed for credit_loss_base. Default is 0.25.

Def Income Total PTD Base by Percentage

4083

Indicates whether to use a percentage tolerance check.

Def Income Total PTD Base Tolerance

8627

Specifies the tolerance amount allowed for def_income_total_ptd_base. Default is 0.25.

Impairment LTD Base by Percentage

4084

Indicates whether to use a percentage tolerance check.

Impairment LTD Base Tolerance

8628

Specifies the tolerance amount allowed for impairment_ltd_base. Default is 0.25.

Non Credit Loss Base by Percentage

4085

Indicates whether to use a percentage tolerance check.

Non Credit Loss Base Tolerance

8629

Specifies the tolerance amount allowed for non_credit_loss_base. Default is 0.25.

OID PTD Base by Percentage

4086

Indicates whether to use a percentage tolerance check.

OID PTD Base Tolerance

8630

Specifies the tolerance amount allowed for oid_ptd_base. Default is 0.25.

Orig Accr PTD by Percentage

4087

Indicates whether to use a percentage tolerance check.

Orig Accr PTD Tolerance

8631

Specifies the tolerance amount allowed for orig_accr_ptd. Default is 0.25.

Orig Sold Interest Base by Percentage

4088

 Indicates whether to use a percentage tolerance check.

Orig Sold Interest Base Tolerance

8632

Specifies the tolerance amount allowed for orig_sold_interest_base. Default is 0.25.

Orig Traded Interest Base by Percentage

4089

Indicates whether to use a percentage tolerance check.

Orig Traded Interest Base Tolerance

8633

Specifies the tolerance amount allowed for orig_traded_interest_base. Default is 0.25.

Orig Acq Cost Base by Percentage

4090

Indicates whether to use a percentage tolerance check.

Orig Acq Cost Base Tolerance

8634

Specifies the tolerance amount allowed for orig_acq_cost_base. Default is 0.25.

TIPs PTD Base by Percentage

4091

Indicates whether to use a percentage tolerance check.

TIPs PTD Base Tolerance

8635

Specifies the tolerance amount allowed for tips_ptd_base. Default is 0.25.

Curr Ws Dis Loss Base by Percentage

4092

Indicates whether to use a percentage tolerance check.

Curr Ws Dis Loss Base Tolerance

8636

Specifies the tolerance amount allowed for curr_ws_dis_loss_base. Default is 0.25.