Risk Management engine database table usage

The Risk Management engine requires additional database tables to be added to the FTM database. The tables are used for:
  • Risk monitor definitions (RISK_MONITOR_DEF)
  • Risk monitor accumulations (RISK_ACT_MONITOR)
  • Temporary risk limit overrides (RISK_TEMP_MONITOR_CHANGE)
  • Tracking rejected batches (ICLs) (RISK_DEPOSIT_REJECT)
  • Tracking rejected transactions (RISK_PAYMENT_MONITOR_REJECT)
  • Risk rules for partner accounts (RISK_PARTNER_ACCOUNTS)
  • Authorization and blocking filters (RISK_PAYMENT_FILTER)
  • Stop pay and positive pay definitions (RISK_PAYMENT_AUTH)
  • Tracking transactions rejected by the authorization process (RISK_PAYMENT_REJECT)
  • Tracking accepted transactions and the monitors to which they were applied (RISK_PAYMENT_MONITOR_XREF)
  • Tracking accepted transactions and the velocity monitors to which they were applied (RISK_VEL_MONITOR)
  • Tracking accepted batches (ICLs) and the monitors to which they were applied (RISK_DEPOSIT_MONITOR_XREF)
  • Tracking accepted transmissions and the monitors to which they were applied (RISK_TRANSMISSION_MONITOR_XREF)
  • Tracking rejected transmissions (RISK_TRANSMISSION_REJECT)
  • Tracking lifetime counts and amounts for the global monitors (RISK_MON_LIFETIME_TOTALS)
  • Tracking global monitor limit change rules (RISK_LIM_CHG_RULE)
  • Determining whether a global monitor limit change rule should take effect (RISK_LIM_CHG_COND)
  • Saving additional data for the limit change conditions (RISK_LIM_CHG_COND_ATTR)

The ACTIVITY_MONITORED and RISK_REVIEWED columns in the PRESENTMENT table of Transaction Server are used to indicate when a batch (ICL) has been checked by the Risk monitoring service and when all of the transactions for a batch (ICL) have been reviewed.

The AUTH_CHECKED and AUTH_REVIEWED columns in the PRESENTMENT table are used to indicate when a batch (ICL) has been checked by the Risk authorization service and when all of the transactions rejected by the authorization service have been reviewed.

The EXP_LIMIT_CHECKED and EXP_LIMIT_REVIEWED columns in the PRESENTMENT_GROUP table are used to indicate when a transmission has been checked by the Risk authorization service and when a transmission rejected by the authorization service has been reviewed.