1. User Guide
  2. Business Rules Administration
  3. Alternate Rate Output Mapping Rules
  4. Registering Alternate Output Columns for Account Tables

3.17.2 Registering Alternate Output Columns for Account Tables

It is possible to add Placeholder Columns to your instrument tables and to designate certain columns as target columns for Alternate Rate Output. The following steps will allow you to register these columns for use within the application and will allow you to select the columns from within the Alternate Rate Output Mapping Rule screen.

  1. Using the available Placeholder Columns, enable the User – Defined Properties (UDPs) in the Data Model extension. For more information, see the Data Model Extension documentation.
  2. For Alternate Rate Output Mapping, the following are the applicable UDP's:
    • Transfer Pricing Output (80)
    • Option Cost Output (81)
    • Liquidity_rate_column (95)
    • Liquidity_amount_column (96)
    • Basis_rate_column (97)
    • Basis_amount_column (98)
    • Pricing_rate_column (99)
    • Pricing_amount_column (100)
    • Other Adjustment Spread Output (82)
    • Other Adjustment Amount Output (83)
    • Economic Value Output (86)
    • Break Funding Market Value (91)
    • Break Funding Amount (90)
    • Break Funding Rate (92)
    • Break Funding Amount Charge (93)
    • Transfer Pricing Charge Credit (101)
    • Liquidity Premium Charge Credit (102)
    • Basis Risk Charge Credit (103)
    • Pricing Incentive Charge Credit (104)
    • Other Adjustment Charge Credit (105)

    Note:

    The above UDP's will correspond to the Alternate Rate Output Column types noted above. You need to specify the value of the relevant property as YES (in CAPS) to enable display in the appropriate section of the Alternate Rate Output Mapping screen.
  3. After the placeholder column is approved and UDP is assigned, the Alternate Rate Output Mapping screen displays the new columns.
  4. Depending on the selected UDP's, the new column(s) appear in the appropriate drop list within the Alternate Rate Output Mapping Definition screen.

    Selecting Alternate Output Columns for each Transfer Pricing Column is a one-time setup process. However, the application lets you modify the Alternate Output Columns setup, if necessary.