Plan the Position Recon Setup

Before you can set up the Position reconciliation, you must decide on the location of the data to reconcile, the handling of securities versus cash holdings, and the mode of comparison suitable for the location of records. You can use position reconciliation for positions, ledger balances, and lot level positions data. For positions, you can use both ESTAR portfolio valuation and Eagle data warehouse tables.

Decide on the Location of Data

To define your business data model, you must decide where to locate your data. Ledger balances and lot level positions reside on the Eagle data warehouse. You can copy positions data to local work tables or use the data directly from the Eagle data warehouse and the Portfolio Valuation (ESTAR) tables.
Options include:

• Flat files sent by a custodian

• Eagle STAR

• Flat files sent from external sources

• ESTAR database

• Eagle data warehouse

Decide on Security and Cash Holdings

You must decide which types of holdings to reconcile. Positions information includes both securities and cash balances. The Eagle default streams reconcile traded positions and settled cash balances. You can reconcile only securities, only cash balances, or both securities and cash balances. You can reconcile settled or traded positions and cash balances.

Decide on the Mode of Comparison

You must decide on the mode of comparison for reconciling your records. There are several possible modes for matching records, depending on the combination of source and data location assumed for position reconciliation. You must choose one combination for your overall reconciliation strategy and configure the MSGSERVICE.INI parameters for DataSetOption option. See the Configure the MSGSERVICE.INI Parameters section for additional information.

The following are the DataSet options.