1. User Guide
  2. Appendix J – Frequently Asked Questions

19 Appendix J – Frequently Asked Questions

This Appendix includes the frequently asked questions about the OFS HM application.

  1. Only 12 Instrument Types are available in the UI, but there are around 34 listed in the User Guide. Am I missing something in installation or setup?

    The 12 instrument types are specific to Level 1 and Level 2. OFS ALM is a prerequisite for OFS HM. Once installed, the entire list of instrument types will appear and these (beyond the initial 12) are eligible for Level 3 valuation only.

  2. From which table the aforementioned instrument types are retrieved?

    DIM_INSTRUMENT_TYPE

  3. Is bond the only instrument Type supported by the proxy method in level 2? In that case, how to look up near values in level 2 for other Instrument Types? Or, is level 2 value calculation skipped for another instrument type?

    Amongst all Instrument Types, it is possible for Bonds to be valued under a proxy approach where the fair values of similar instruments with similar characteristics are picked up (of the instrument being valued) and then a weighted average is computed to arrive at the final FV.

  4. How does "Market Data Provider" (n_market_data_provider_id) link to the market data? Which tables are the lookup tables? Does n_market_data_provider_id represent interest_rate_cd?

    The user needs to select the Market Data provider for each Instrument Type through the User Interface. The dimension table is fsi_mkt_data_provider_cd/fsi_mkt_data_provider_mls which is populated via the AMHM screens. For more information, see Creating a Fair Value Definition section.

  5. Is fsi_d_market_quote the table for lookup quotation? If so, how to link to this table in the setup?

    This table stores download information for all market quotes and depending upon the preferred market data provider selected (refer to question 4), the application picks the corresponding quote as the fair value.

  6. Is fct_account_fair_value the only result table for FV calculation? Which columns if updated to instrument tables?

    There are two output tables for FV. FCT_ACCOUNT_FAIR_VALUE stores the fair value per run. FCT_HM_ACCOUNT_GAIN_LOSS stores the Fair value gain or loss.