5.3.9.3.5.2 Understand the Ledger Migration

To understand the process of creating Average Transfer Rate, Adjustment Rates, Option Cost, and Charge/Credit rows in the Management Ledger table (financial elements 170/172, 174-177, and 450, 414-417, 452, respectively), you need to make the following assumptions:

  • All rows in the relevant Instrument tables have already been transfer-priced and/or assigned an option cost.
  • All rows contain a valid rate in one or more of the following columns:
    • TRANSFER_RATE
    • TRAN_RATE_REM_TERM
    • LIQUIDITY_PREMIUM_RATE
    • BASIS_RISK_RATE
    • PRICING_INCENTIVE_RATE
    • OTHER_ADJUSTMENTS_RATE
    • ALL IN TP RATE
  • Average Balance or Ending Balance (financial element 140/100) information has been loaded into the Management Ledger table with a dimensionality that matches the instrument table data being migrated.

This document describes the mechanics, which occur just after the Instrument tables transfer pricing or option cost calculations are completed successfully and just before Transfer Rate, Add-On Rate, or Option Cost (Rate Lock) Ledger migration starts. For example, the mechanics that occur just after Instrument tables are populated with valid Transfer Rates and just before the Weighted Average Transfer Rate (WATR) and the Charge/Credit rows in the Management Ledger table are updated.

The Ledger Migration of option costs works on the same lines as Transfer Rate and Add-On Rate migration. However, there are certain differences.