Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Anchor
_Toc439930421
_Toc439930421
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

Anchor
_Toc439930422
_Toc439930422
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.

Anchor
1posrecn_plan_pos_recon_htm_deci_3952
1posrecn_plan_pos_recon_htm_deci_3952
Anchor
_Toc439930423
_Toc439930423
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.

Noteinfo

Eagle's best practice is matching positions directly to data warehouse tables or the ESTAR database, eliminating the prerequisite of position records to work tables.

The following are the DataSet options.

Option

Description

DataSetOption = 1

Specifies the local to local custodian mode of comparison for reconciling the POSITIONS and POSITIONS_CUST tables in the MSGCENTER database.

DataSetOption = 2

Specifies the data warehouse to data warehouse mode of comparison for reconciling different sources on the POSITION or LOT_LEVEL_POSITION tables in the HOLDING database. Or, different sources on Ledger tables in the LEDGER database.

DataSetOption = 3

Specifies the local Eagle STAR to data warehouse mode of comparison for reconciling the POSITIONS table in the MSGCENTER database to the POSITION table in the HOLDING database.

DataSetOption = 4

Specifies the local custodian to data warehouse mode of comparison for reconciling the POSITIONS_CUST table in the MSGCENTER database to the POSITION table in the HOLDING database.

DataSetOption = 5

Specifies the Eagle STAR to data warehouse mode of comparison for reconciling the ESTAR_PORTFOLIO_VALUATION table in the ESTAR database to the POSITION table in the HOLDING database.