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 6 Current »

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.

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.

OptionDescription
DataSetOption = 1Specifies the local to local custodian mode of comparison for reconciling the POSITIONS and POSITIONS_CUST tables in the MSGCENTER database.
DataSetOption = 2Specifies 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 = 3Specifies 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 = 4Specifies 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 = 5Specifies 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.
  • No labels