...
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.NOTE:
| Note |
|---|
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. |
Options include:
- 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.