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 4 Next »


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.

OptionTagDescription
Pos Recon Process

Event Type55Specifies the event used to reconcile positions. Default is RECON_POSITION2.
Data Set Option989Specifies 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 Source1102Specifies the data source or source list to use for the left match.
Right Source1104Specifies the data source or source list to use for the right match.
Effective Date1109Specifies the effective date of the records to match.
Entity Name1164Specifies the name of the entity to match on ledger balances.
Entity ID / Composite ID1163Specifies the entity ID or composite entity ID to match on ledger balances.
Active Status1283Specifies the entity status. Options include Active (default) and Both.
Tolerance Rule ID4256Specifies the tolerance rule with the filters to apply for position reconciliation.
Unmatch Only Flag List7050Indicates whether to store only unmatched and out of balance records to the Exception tables to conserve table space. Default is store all records.
Match Nulls1018Indicates whether to reconcile to null values or flag as unmatched.

Tolerances



Position Units by Percentage1019Indicates whether to use a percentage tolerance check.
Position Units Tolerance963Specifies the tolerance amount allowed for Position Units. Default is 0.25.
Original Face by Percentage1021Indicates whether to use a percentage tolerance check.
Original Face Tolerance964Specifies the tolerance amount allowed for Original Face. Default is 0.25.
Market Value by Percentage1023Indicates whether to use a percentage tolerance check.
Market Value Tolerance965Specifies the tolerance amount allowed for Market Value. Default is 0.25.
Cost by Percentage1025Indicates whether to use a percentage tolerance check.
Cost Tolerance966Specifies the tolerance amount allowed for Cost. Default is 0.25.
Book Value by Percentage1027Indicates whether to use a percentage tolerance check.
Book Value Tolerance967Specifies the tolerance amount allowed for Book Value. Default is 0.25.
Accruals by Percentage1029 Indicates whether to use a percentage tolerance check.
Accruals Tolerance968Specifies 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 Percentag1030Indicates whether to use a percentage tolerance check.
Book Value Base Tolerance7661Specifies the tolerance amount allowed for Book Value Base. Default is 0.25.
Market Value Base by Percentage1031Indicates whether to use a percentage tolerance check.
Market Value Base Tolerance7662Specifies the tolerance amount allowed for Market Value Base. Default is 0.25.
Accrued Income by Percentage1032Indicates whether to use a percentage tolerance check.
Accrued Income Tolerance7663Specifies the tolerance amount allowed for Accrued Income. Default is 0.25.
Notional Cost Base by Percentage1033Indicates whether to use a percentage tolerance check.
Notional Cost Base Tolerance7664Specifies the tolerance amount allowed for Notional Cost Base. Default is 0.25.
Unrealized GL Base by Percentage1034Indicates whether to use a percentage tolerance check.
Unrealized GL Base Tolerance7665Specifies the tolerance amount allowed for Unrealized Gain/Loss Base. Default is 0.25.
Unrealized GL by Percentage1035Indicates whether to use a percentage tolerance check.
Unrealized GL Tolerance7666Specifies the tolerance amount allowed for Unrealized Gain/Loss. Default is 0.25.
Dividend Receivable by Percentage1036Indicates whether to use a percentage tolerance check.
Dividend Receivable Tolerance7667Specifies the tolerance amount allowed for Dividend Receivable. Default is 0.25.
Dividend Receivable Base by Percentage1037Indicates whether to use a percentage tolerance check.
Dividend Receivable Base Tolerance 7668Specifies the tolerance amount allowed for Dividend Receivable Base. Default is 0.25.
Reclaim Receivable Tolerance1038Indicates whether to use a percentage tolerance check.
Reclaim Receivable Tolerance7669Specifies the tolerance amount allowed for Reclaim Receivable. Default is 0.25.
Reclaim Receivable Base by Percentage1039Indicates whether to use a percentage tolerance check.
Reclaim Receivable Base Tolerance7670Specifies the tolerance amount allowed for Reclaim Receivable Base. Default is 0.25.
Settled Position by Percentage1040Indicates whether to apply a percentage instead of a difference as the tolerance check.
Settled Position Tolerance7671Specifies the tolerance amount allowed for Settled Position. Default is 0.25.

User Defined



User Float21 Tolerance7676Indicates/specifies the tolerance amount allowed for User Float21.
User Float22 Tolerance7677Indicates/specifies the tolerance amount allowed for User Float22.
User Group1 Tolerance Switch7051Indicates whether to reconcile for matching User Group1 values.
User Group2 Tolerance Switch7052Indicates whether to reconcile for matching User Group2 values.
User Date1 Tolerance Switch7053Indicates whether to reconcile for matching User Date1 values.
User Date2 Tolerance Switch7054

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.

On this page

Recon Ledger Event Panel Options

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

OptionTagDescription

Ledger Matching Process



Event Type55Displays the event used to reconcile positions as LEDGER_RECON.
Table Option989Specifies the location of the ledger balance records as Warehouse/Warehouse.
Left Source ID7002Indicates whether a source ID or source list is used to locate the records for the left match. Default is Source ID.
Left Source1102Specifies the source ID or source list to use for the left match.
Left Source List373Specifies the source list to use for the left match.
Right Source ID7004Indicates whether a source ID or source list is used to locate the records for the right match. Default is Source ID.
Right Source1104Specifies the source ID or source list to use for the right match.
Right Source List323Specifies the source list to use for the right match.
Effective Date1109Specifies the effective date of the records to match.
Entity Name1164Specifies the name of the entity to match on ledger balances.
Entity ID / Composite ID1163Specifies the entity ID or composite entity ID to match on ledger balances.
Active Status1283Specifies the entity status. Options include Active (default) and Both.
Match Nulls1018Indicates whether to reconcile to null values or flag as unmatched.
Unmatch Only Flag List7050Indicates 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 List7060Indicates whether to roll up security level balances to the ledger account for reconciliation.
Currency Flag List7179 Indicates whether to reconcile local currency balances in addition to base currency balances.
Tolerance Rule ID4256Specifies the tolerance rule with the filters to apply for ledger balance reconciliation.

Tolerances



Ledger Balance by Percentage930 Indicates whether to apply percentage tolerances. Default is No.
Ledger Balance Tol 922Specifies 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.

OptionTagDescription

Lot Recon Process



Event Type55Displays the event used to reconcile positions as LOTS_RECON.
Dataset Option989Specifies the location of the ledger balance records as Warehouse/Warehouse.
Left Source ID / Source List7002Indicates whether a source ID or source list is used to locate the records for the left match. Default is Source ID.
Left Source Name1102Specifies the source ID to use for the left match.
Left Source List373Specifies the source list to use for the left match.
Right Source ID / Source List7004Indicates whether a source ID or source list is used to locate the records for the right match. Default is Source ID.
Right Source Name1104Specifies the source ID to use for the right match.
Right Source List323Specifies the source list to use for the right match.
Effective Date1109Specifies the effective date of the records to match.
Entity Name1164Specifies the name of the entity to match on ledger balances.
Entity ID / Composite ID1163Specifies the entity ID or composite entity ID to match on ledger balances.
Active Status1283Specifies the entity status. Options include Active (default) and Both.
Tolerance Rule ID4256Specifies the tolerance rule with the filter to apply for lot reconciliation.
Unmatch Only Flag List7050Indicates whether to store only unmatched and out of balance records to the Exception tables to conserve table space.
Match Nulls1018Indicates whether to reconcile to null values or flag as unmatched.
Matching by Orig Event ID7043Indicates whether to match lots by Original Event ID as an additional match key. Default is No.

Tolerances



Original Face by Percentage4064Indicates whether to use a percentage tolerance check.
Original Face Tolerance8608Specifies the tolerance amount allowed for Original Face. Default is 0.25.
Par of Shares by Percentage4065Indicates whether to use a percentage tolerance check.
Par of Shares Tolerance8609Specifies the tolerance amount allowed for Par of Shares. Default is 0.25.
Book Value by Percentage4066Indicates whether to use a percentage tolerance check.
Book Value Tolerance8610Specifies the tolerance amount allowed for Book Value. Default is 0.25.
Accrued Income by Percentage4067Indicates whether to use a percentage tolerance check.
Accrued Income Tolerance8611Specifies the tolerance amount allowed for Accrued Income. Default is 0.25.
Amort LTD Base by Percentage4068Indicates whether to use a percentage tolerance check.
Amort LTD Base Tolerance8612Specifies the tolerance amount allowed for Amort LTD Base. Default is 0.25.
Interest Sold Base by Percentage4069Indicates whether to use a percentage tolerance check.
Interest Sold Base Tolerance8613Specifies the tolerance amount allowed for Interest Sold Base. Default is 0.25.
Int Received by Percentage4070Indicates whether to use a percentage tolerance check.
Int Received Tolerance8614Specifies the tolerance amount allowed for int_received. Default is 0.25.
OID LTD Income by Percentage4071Indicates whether to use a percentage tolerance check.
OID LTD Income Tolerance8615Specifies the tolerance amount allowed for oid_ltd_income. Default is 0.25.
Market Value Income by Percentage4072Indicates whether to use a percentage tolerance check.
Market Value Income Tolerance8616Specifies the tolerance amount allowed for market_value_income. Default is 0.25.
Notional Cost by Percentage4073Indicates whether to use a percentage tolerance check.
Notional Cost Tolerance8617Specifies the tolerance amount allowed for notional_cost. Default is 0.25.
Mkt Value Base by Percentage4074Indicates whether to use a percentage tolerance check.
Mkt Value Base Tolerance8618Specifies the tolerance amount allowed for mkt_value_base. Default is 0.25.
Notional Market Value by Percentage4075Indicates whether to use a percentage tolerance check.
Notional Market Value Tolerance8619Specifies the tolerance amount allowed for notional_market_value. Default is 0.25.
TIP LTD Income by Percentage4076Indicates whether to use a percentage tolerance check.
TIP LTD Income Tolerance8620Specifies the tolerance amount allowed for tip_ltd_income. Default is 0.25.
Cls Amort Base by Percentage4077 Indicates whether to use a percentage tolerance check.
Cls Amort Base Tolerance8621Specifies the tolerance amount allowed for cls_amort_base. Default is 0.25.
Cls OID Income by Percentage4078Indicates whether to use a percentage tolerance check.
Cls OID Income Tolerance8622Specifies the tolerance amount allowed for cls_oid_income. Default is 0.25.
Cls TIPs Income by Percentage4079Indicates whether to use a percentage tolerance check.
Cls TIPs Income Tolerance8623Specifies the tolerance amount allowed for cls_tips_income. Default is 0.25.
Accr LTD Base by Percentage4080Indicates whether to use a percentage tolerance check.
Accr LTD Base Tolerance8624Specifies the tolerance amount allowed for accr_ltd_base. Default is 0.25.
Amort PTD Base by Percentage4081Indicates whether to use a percentage tolerance check.
Amort PTD Base Tolerance8625Specifies the tolerance amount allowed for amort_ptd_base. Default is 0.25.
Credit Loss Base by Percentage4082Indicates whether to use a percentage tolerance check.
Credit Loss Base Tolerance8626Specifies the tolerance amount allowed for credit_loss_base. Default is 0.25.
Def Income Total PTD Base by Percentage4083Indicates whether to use a percentage tolerance check.
Def Income Total PTD Base Tolerance8627Specifies the tolerance amount allowed for def_income_total_ptd_base. Default is 0.25.
Impairment LTD Base by Percentage4084Indicates whether to use a percentage tolerance check.
Impairment LTD Base Tolerance8628Specifies the tolerance amount allowed for impairment_ltd_base. Default is 0.25.
Non Credit Loss Base by Percentage4085Indicates whether to use a percentage tolerance check.
Non Credit Loss Base Tolerance8629Specifies the tolerance amount allowed for non_credit_loss_base. Default is 0.25.
OID PTD Base by Percentage4086Indicates whether to use a percentage tolerance check.
OID PTD Base Tolerance8630Specifies the tolerance amount allowed for oid_ptd_base. Default is 0.25.
Orig Accr PTD by Percentage4087Indicates whether to use a percentage tolerance check.
Orig Accr PTD Tolerance8631Specifies the tolerance amount allowed for orig_accr_ptd. Default is 0.25.
Orig Sold Interest Base by Percentage4088 Indicates whether to use a percentage tolerance check.
Orig Sold Interest Base Tolerance8632Specifies the tolerance amount allowed for orig_sold_interest_base. Default is 0.25.
Orig Traded Interest Base by Percentage4089Indicates whether to use a percentage tolerance check.
Orig Traded Interest Base Tolerance8633Specifies the tolerance amount allowed for orig_traded_interest_base. Default is 0.25.
Orig Acq Cost Base by Percentage4090Indicates whether to use a percentage tolerance check.
Orig Acq Cost Base Tolerance8634Specifies the tolerance amount allowed for orig_acq_cost_base. Default is 0.25.
TIPs PTD Base by Percentage4091Indicates whether to use a percentage tolerance check.
TIPs PTD Base Tolerance8635Specifies the tolerance amount allowed for tips_ptd_base. Default is 0.25.
Curr Ws Dis Loss Base by Percentage4092Indicates whether to use a percentage tolerance check.
Curr Ws Dis Loss Base Tolerance8636Specifies the tolerance amount allowed for curr_ws_dis_loss_base. Default is 0.25.


  • No labels