Update MICR Modulus Validation to Allow Additional Modulus Operations

Previously, MICR modulus validation in Business Rules Server was limited to at most two modulus operations and their accompanying modulus parameters. MICR modulus validation has been enhanced to support a user specified number of modulus operations to be performed. To enable this new MICR modulus validation functionality, the old MICR modulus validation configuration must be migrated to the new format. The old configuration can still be used, but it limits the number of modulus operations that can be performed to two.

To migrate the old MICR modulus validation configuration to the new configuration format, perform the following steps:
  1. Keep a copy of the current data setup utility spreadsheet used for the MICR edit rules
  2. Drop the EXT_MICR_VALIDATION table and the Ext_Micr_Validation_V view from the FTM database
  3. Recreate the table and view using the latest database definitions
  4. Create the new Ext_Mod_Routines_V view
  5. Update the new data setup utility spreadsheet for the MICR edit rules by copying values from the spreadsheet saved in step 1.
    1. For each row in the old spreadsheet that contains a value in the Mod Routine column, copy that value into the new Mod Routines column for the same row in the new spreadsheet.
    2. For each row in the old spreadsheet that contains a value in the Mod Routine 2 column, update the Mod Routines column for the same row in the new spreadsheet by adding this second value after the first value that was copied. Separate the values with a comma. For example, a row that had a value of five in the Mod Routine column and a value of 10 in the Mod Routine 2 column would contain 10,5 in the Mod Routines column of the new spreadsheet.
  6. Import the new spreadsheets into the database and activate a new release