...
| 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. |
The following are the DataSet options for deciding the mode of comparison.
| 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. |
...