8.2.129.3 Data Verification Requirements and Suggested Defaults

  • If REPRICE_FREQ > 0, MATURITY_DATE >= NEXT_REPRICE_DATE > AS_ OF_DATE.
  • If REPRICE_FREQ > 0, INTEREST_RATE_CD is in the range of 1 - 99999.
  • If REPRICE_FREQ > 0, ADJUSTABLE_TYPE_CD > 0.

REPRICE_FREQ must be either 0 or positive.

Note:

In Oracle ALM, ADJUSTABLE_TYPE_CD is used in conjunction with REPRICE_FREQ to define adjustable-rate records.