Versions Compared

Old Version 1

changes.mady.by.user Copy Page Tree

Saved on

compared with

New Version Current

changes.mady.by.user Nancy Cohn

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of ContentsmaxLevel2indent2 px

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.

Anchor
1posrecn_recon_event_opts_htm_re_1331
1posrecn_recon_event_opts_htm_re_1331
Anchor
_Toc439930449
_Toc439930449
Recon Positions Event Panel Options

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

Option

Tag

Description

Pos Recon Process



Event Type

(tag 55). Specifies

55

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

Data Set Option

(tag 989). Specifies

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.

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

Left Source

(tag

1102

).

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

Right Source

(tag

1104

).

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

Effective Date

(tag

1109

).

Specifies the effective date of the records to match.

Entity Name

(tag

1164

).

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

Entity ID / Composite ID

(tag

1163

).

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

Active Status

(tag

1283

).

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

Tolerance Rule

ID (tag 4256).

ID

4256

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

Unmatch Only Flag List

(tag

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

(tag1018).

1018

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

Anchor
_Toc439930451
_Toc439930451
Tolerances



Position Units by Percentage

(tag

1019

).

Indicates whether to use a percentage tolerance check.

Position Units Tolerance

(tag

963

).

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

Original Face by Percentage

(tag

1021

).

Indicates whether to use a percentage tolerance check.

Original Face Tolerance

(tag

964

).

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

Market Value by Percentage

(tag

1023

).

Indicates whether to use a percentage tolerance check.

Market Value Tolerance

(tag

965

).

Specifies the tolerance amount allowed for Market Value.

Default

 Default is 0.25.

Cost by Percentage

(tag

1025

).

Indicates whether to use a percentage tolerance check.

Cost Tolerance

(tag

966

).

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

Book Value by Percentage

(tag

1027

).

Indicates whether to use a percentage tolerance check.

Book Value Tolerance

(tag

967

).

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

Accruals by Percentage

(tag 1029). Indicates

1029

 Indicates whether to use a percentage tolerance check.

Accruals Tolerance

(tag

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

Percentage (tag 1030).

Percentag

1030

Indicates whether to use a percentage tolerance check.

Book Value Base Tolerance

(tag

7661

).

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

Market Value Base by Percentage

(tag

1031

).

Indicates whether to use a percentage tolerance check.

Market Value Base Tolerance

(tag

7662

).

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

Accrued Income by Percentage

(tag

1032

).

Indicates whether to use a percentage tolerance check.

Accrued Income Tolerance

(tag

7663

).

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

Notional Cost Base by Percentage

(tag

1033

).

Indicates whether to use a percentage tolerance check.

Notional Cost Base Tolerance

(tag

7664

).

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

Unrealized GL Base by Percentage

(tag

1034

).

Indicates whether to use a percentage tolerance check.

Unrealized GL Base Tolerance

(tag

7665

).

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

Unrealized GL by Percentage

(tag

1035

).

Indicates whether to use a percentage tolerance check.

Unrealized GL Tolerance

(tag

7666

).

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

Dividend Receivable by Percentage

(tag

1036

).

Indicates whether to use a percentage tolerance check.

Dividend Receivable Tolerance

(tag

7667

).

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

Dividend Receivable Base by Percentage

(tag

1037

).

Indicates whether to use a percentage tolerance check.

Dividend Receivable Base

Tolerance (tag 7668).

Tolerance 

7668

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

Reclaim Receivable

by Percentage (tag 1038).

Tolerance

1038

Indicates whether to use a percentage tolerance check.

Reclaim Receivable Tolerance

(tag

7669

).

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

Reclaim Receivable Base by Percentage

(tag

1039

).

Indicates whether to use a percentage tolerance check.

Reclaim Receivable Base Tolerance

(tag

7670

).

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

Settled Position by Percentage

(tag

1040

).

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

Settled Position Tolerance

(tag

7671

).

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

Anchor
_Toc439930452
_Toc439930452
User Defined



User Float21 Tolerance

(tag

7676

).

Indicates/specifies the tolerance amount allowed for User Float21.

User Float22 Tolerance

(tag 7677). Indicates

7677

Indicates/specifies the tolerance amount allowed for User Float22.

User Group1 Tolerance Switch

(tag

7051

).

Indicates whether to reconcile for matching User Group1 values.

User Group2 Tolerance Switch

(tag

7052

).

Indicates whether to reconcile for matching User Group2 values.

User Date1 Tolerance Switch

(tag

7053

).

Indicates whether to reconcile for matching User Date1 values.

User Date2 Tolerance Switch

(tag

7054

).

Indicates whether to reconcile for matching User Date2 values.

Note

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

On this page

Table of Contents
maxLevel2
indent2 px


Anchor
1posrecn_recon_event_opts_htm_re_5951
1posrecn_recon_event_opts_htm_re_5951
Anchor
_Toc439930453
_Toc439930453
Recon Ledger Event Panel Options

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

Option

Tag

Description

Anchor
_Toc439930454
_Toc439930454
Ledger Matching Process



Event Type

(tag

55

).

Displays the event used to reconcile positions as LEDGER_RECON.

Table Option

(tag

989

).

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

Left Source ID

(tag

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

(tag

1102

).

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

Left Source List

(tag

373

).

Specifies the source list to use for the left match.

Right Source ID

(tag

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

(tag

1104

).

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

Right Source List

(tag

323

).

Specifies the source list to use for the right match.

Effective Date

(tag

1109

).

Specifies the effective date of the records to match.

Entity Name

(tag

1164

).

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

Entity ID / Composite ID

(tag

1163

).

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

Active Status

(tag

1283

).

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

Match Nulls

(tag

1018

).

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

Unmatch Only Flag List

(tag

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

(tag

7060

).

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

Currency Flag List

(tag 7179). Indicates

7179

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

Tolerance Rule

ID (tag 4256).

ID

4256

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

Anchor
_Toc439930455
_Toc439930455
Tolerances



Ledger Balance by Percentage

(tag 930). Indicates

930

 Indicates whether to apply percentage tolerances. Default is No.

Ledger Balance

Tol (tag 922).

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.

Anchor
1posrecn_recon_event_opts_htm_re_4952
1posrecn_recon_event_opts_htm_re_4952
Anchor
_Toc439930456
_Toc439930456
Recon Lots Event Panel Options

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

Option

Tag

Description

Anchor
_Toc439930457
_Toc439930457
Lot Recon Process



Event Type

(tag

55

).

Displays the event used to reconcile positions as LOTS_RECON.

Dataset Option

(tag

989

).

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

Left Source ID / Source List

(tag

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

(tag

1102

).

Specifies the source ID to use for the left match.

Left Source List

(tag

373

).

Specifies the source list to use for the left match.

Right Source ID / Source List

(tag

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

(tag

1104

).

Specifies the source ID to use for the right match.

Right Source List

(tag

323

).

Specifies the source list to use for the right match.

Effective Date

(tag

1109

).

Specifies the effective date of the records to match.

Entity Name

(tag

1164

).

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

Entity ID / Composite ID

(tag

1163

).

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

Active Status

(tag

1283

).

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

Tolerance Rule

ID (tag 4256).

ID

4256

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

Unmatch Only Flag List

(tag

7050

).

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

Match Nulls

(tag1018).

1018

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

Matching by Orig Event ID

(tag

7043

).

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

Anchor
_Toc439930458
_Toc439930458
Tolerances



Original Face by Percentage

(tag

4064

).

Indicates whether to use a percentage tolerance check.

Original Face Tolerance

(tag

8608

).

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

Par of Shares by Percentage

(tag

4065

).

Indicates whether to use a percentage tolerance check.

Par of Shares Tolerance

(tag

8609

).

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

Book Value by Percentage

(tag

4066

).

Indicates whether to use a percentage tolerance check.

Book Value Tolerance

(tag

8610

).

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

Accrued Income by Percentage

(tag

4067

).

Indicates whether to use a percentage tolerance check.

Accrued Income Tolerance

(tag

8611

).

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

Amort LTD Base by Percentage

(tag

4068

).

Indicates whether to use a percentage tolerance check.

Amort LTD Base Tolerance

(tag

8612

).

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

Interest Sold Base by Percentage

(tag

4069

).

Indicates whether to use a percentage tolerance check.

Interest Sold Base Tolerance

(tag

8613

).

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

Int Received by Percentage

(tag

4070

).

Indicates whether to use a percentage tolerance check.

Int Received Tolerance

(tag

8614

).

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

OID LTD Income by Percentage

(tag

4071

).

Indicates whether to use a percentage tolerance check.

OID LTD Income Tolerance

(tag

8615

).

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

Market Value Income by Percentage

(tag

4072

).

Indicates whether to use a percentage tolerance check.

Market Value Income Tolerance

(tag

8616

).

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

Notional Cost by Percentage

(tag

4073

).

Indicates whether to use a percentage tolerance check.

Notional Cost Tolerance

(tag

8617

).

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

Mkt Value Base by Percentage

(tag

4074

).

Indicates whether to use a percentage tolerance check.

Mkt Value Base Tolerance

(tag

8618

).

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

Notional Market Value by Percentage

(tag

4075

).

Indicates whether to use a percentage tolerance check.

Notional Market Value Tolerance

(tag

8619

).

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

TIP LTD Income by Percentage

(tag

4076

).

Indicates whether to use a percentage tolerance check.

TIP LTD Income Tolerance

(tag

8620

).

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

Cls Amort Base by Percentage

(tag 4077). Indicates

4077

 Indicates whether to use a percentage tolerance check.

Cls Amort Base Tolerance

(tag

8621

).

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

Cls OID Income by Percentage

(tag

4078

).

Indicates whether to use a percentage tolerance check.

Cls OID Income Tolerance

(tag

8622

).

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

Cls TIPs Income by Percentage

(tag

4079

).

Indicates whether to use a percentage tolerance check.

Cls TIPs Income Tolerance

(tag

8623

).

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

Accr LTD Base by Percentage

(tag

4080

).

Indicates whether to use a percentage tolerance check.

Accr LTD Base Tolerance

(tag

8624

).

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

Amort PTD Base by Percentage

(tag

4081

).

Indicates whether to use a percentage tolerance check.

Amort PTD Base Tolerance

(tag

8625

).

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

Credit Loss Base by Percentage

(tag

4082

).

Indicates whether to use a percentage tolerance check.

Credit Loss Base Tolerance

(tag

8626

).

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

Def Income Total PTD Base by Percentage

(tag

4083

).

Indicates whether to use a percentage tolerance check.

Def Income Total PTD Base Tolerance

(tag

8627

).

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

Impairment LTD Base by Percentage

(tag

4084

).

Indicates whether to use a percentage tolerance check.

Impairment LTD Base Tolerance

(tag

8628

).

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

Non Credit Loss Base by Percentage

(tag

4085

).

Indicates whether to use a percentage tolerance check.

Non Credit Loss Base Tolerance

(tag

8629

).

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

OID PTD Base by Percentage

(tag

4086

).

Indicates whether to use a percentage tolerance check.

OID PTD Base Tolerance

(tag

8630

).

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

Orig Accr PTD by Percentage

(tag

4087

).

Indicates whether to use a percentage tolerance check.

Orig Accr PTD Tolerance

(tag

8631

).

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

Orig Sold Interest Base by Percentage

(tag 4088). Indicates

4088

 Indicates whether to use a percentage tolerance check.

Orig Sold Interest Base Tolerance

(tag

8632

).

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

Orig Traded Interest Base by Percentage

(tag

4089

).

Indicates whether to use a percentage tolerance check.

Orig Traded Interest Base Tolerance

(tag

8633

).

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

Orig Acq Cost Base by Percentage

(tag

4090

).

Indicates whether to use a percentage tolerance check.

Orig Acq Cost Base Tolerance

(tag

8634

).

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

TIPs PTD Base by Percentage

(tag

4091

).

Indicates whether to use a percentage tolerance check.

TIPs PTD Base Tolerance

(tag

8635

).

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

Curr Ws Dis Loss Base by Percentage

(tag

4092

).

Indicates whether to use a percentage tolerance check.

Curr Ws Dis Loss Base Tolerance

(tag

8636

).

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


Anchor
1posrecn_pos_match_stat_htm_top__1881
1posrecn_pos_match_stat_htm_top__1881