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