28.2 Registering Alternate Output Columns for Account Tables

It is possible to add User-Defined 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. Create the new user-defined column(s) in the Erwin Model and define the new User- Defined Property (UDP) for the column(s).
  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:

    When adding or modifying an instrument table column within Erwin, the UDP properties tab lists all the applicable properties available at a column level. 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. Upload the modified Data Model. After the saved model is uploaded, and the table classification procedure re-executed, 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.
    After you make appropriate Column User-Defined Property Assignment to the alternate columns, they become available in the Alternate Rate Output Mapping rule under the appropriate result types. 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.

    Note:

    For further information on the Table Column User-Defined Property Assignment step of the table registration process, see the OFS Analytical Applications Infrastructure Installation and Configuration Guide and OFS Data Model Utilities User Guide.