...
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 or the ESTAR Portfolio Valuation tables.
Options include:
Flat files sent by a custodian/external sources
ESTAR database for settled/pre-settled activity
Eagle data warehouse
| Anchor | ||||
|---|---|---|---|---|
|
...
When you reconcile at the security level, the system matches cash activity records on:
Transaction Date
Fund
Security
When you reconcile at the transaction level, you additionally match on:
Cash Event Type
Cash Category
Transaction Type
Settlement Currency
...
The arithmetic sign of the Data Set Option parameter indicates whether the system reconciles at the security level or the transaction level.
The type of transaction date used in the match depends on the mode of comparison you choose for reconciling cash activity. The system selects cash activity records by:
Post Date for data warehouse to data warehouse comparisons
Trade Date for ESTAR traded cash activity to data warehouse comparisons
Settlement Date for ESTAR settled cash activity to data warehouse comparisons
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
You must decide on the mode of comparison for reconciling cash activity. There are several possible modes for matching records, depending on the combination of source and data location assumed for cash activity 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. The system uses positive values (such as 2, 3, and 4) to indicate that cash reconciliation occurs at the transaction level. And the system uses negative values (such as -2, -3, and -4) to indicate that cash reconciliation occurs at the security level.
...
Eagle best practice is matching cash activity directly to warehouse tables or the ESTAR database, eliminating the prerequisite load of cash activity 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 CUST_CASH_TXNS and CASH_TXNS tables in the MSGCENTER database. |
DataSetOption = 2 or -2 | Specifies the data warehouse to data warehouse mode of comparison for reconciling different sources on the CASH_ACTIVITY table in the CASH database. |
DataSetOption = 3 or -3 | Specifies the traded cash activity to data warehouse mode of comparison for reconciling the ESTAR_TRADED_CASH_ACTIVITY table in the ESTAR database to the CASH_ACTIVITY table in the CASH database. |
DataSetOption = 4 or -4 | Specifies the settled cash activity to data warehouse mode of comparison for reconciling the ESTAR_SETTLED_CASH_ACTIVITY table in the ESTAR database to the CASH_ACTIVITY table in the CASH database. |