Versions Compared

Old Version 3

changes.mady.by.user Former user

Saved on

compared with

New Version 4

changes.mady.by.user Nancy Cohn

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Before you can set up the Cash reconciliation, you must decide on the location of the data to reconcile, the level of reconciliation, and the mode of comparison suitable for the location of records. You can specify traded (that is, pre-settled) or settled cash activity cash data for reconciliation.

Anchor
_Toc439930503
_Toc439930503
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 or the ESTAR Portfolio Valuation tables.

...

  • Flat files sent by a custodian/external sources
  • ESTAR database for settled/pre-settled activity
  • Eagle data warehouse

Anchor
_Toc439930504
_Toc439930504
Decide on the Level of Reconciliation

You must decide whether to reconcile at the security level or reconcile at the transaction level. For example, you can post both the paydown and a coupon for a mortgage backed security to Eagle Accounting but reconcile to a custodian that sends one amount for the security, by selecting to reconcile at the security level.

...

  • 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
2cashrecn_plan_cash_recon_htm_de_8332
2cashrecn_plan_cash_recon_htm_de_8332
Anchor
_Toc439930505
_Toc439930505
Decide on the Mode of Comparison

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.

...

The following are the DataSet Options.

OptionDescription
DataSetOption = 1Specifies 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 -2Specifies 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 -3Specifies 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 -4Specifies 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.