6.5.1 Sample Auto-Closing Alert Rule

You may want to close an alert when the match score is less than 75 and the status code is equal to NW (New), or the review is more than 30 days old. If so, follow these steps:

  1. Determine the ATTR_ID for the columns to reference in the KDD_REVIEW table.
    • SCORE has ATTR_ID 113000022.
    • STATUS has ATTR_ID 113000008.
    • AGE has ATTR_ID 113000057.
  2. Formulate the operations.
    The match score is less than 75 and the status code is equal to NW = (SCORE < 75) AND (STATUS = NW)
    Reviews more than thirty days old = (AGE > 30)
  3. Determine an order of precedence for the criteria.
    For example, to determine whether reviews are more than thirty days old, assign (AGE > 30) a precedence of 1, and (SCORE < 75) AND (STATUS = NW) a precedence of 2.
  4. Assign an operation ID to each operation within the operation set.
    The operation ID must be unique within the database. The numbers may be any number not already in the table.
     OPRTN_SET_ID 100 -> (SCORE < 75) AND (STATUS = NW) 
OPRTN_SET_ID 200 -> (AGE > 30)
  5. Assign an ID to each operation within the already divided operations:
    OPRTN_SET_ID 100 -> (SCORE < 75)
OPRTN_SET_ID 101 -> (STATUS = NW)
OPRTN_SET_ID 200 -> (AGE > 30)
  6. Assign the next operation set to chain the operations together.
    • Optionally: assign or close an activity type code and/or comment to the operation.
  7. Insert the rows into the KDD_AUTO_CLOSE_ALERT table.
    The following table resembles the entries into the KDD_AUTO_CLOSE_ALERT table for the (AGE > 30) auto-close alert.

    Table 6-2 KDD_AUTO_CLOSE_ALERT (AGE > 30)

    OPRT- N_SET_I D XPRSN_OR DER_ID ALERT_ ATTR_ID OPRTR_ CD VALUE_ TX NEXT_OPRTN_ SET_ID DMN _CD CLS_ACTIVITY_- TYPE_CD CMMNT_TX
    200 1 1130000 057 > 30 NULL MTS MTS 203 Close if age greater than 30

    Note:

    The NEXT_OPRTN_SET_ID is NULL because this operation set contains only one operation. The following table shows how to set it to the next operation’s ID within the operation set.
    The following table resembles entries into the KDD_AUTO_CLOSE_ALERT table for the (SCORE < 75) and (STATUS = NW) auto-close alert.

    Table 6-3 KDD_AUTO_CLOSE_ALERT (SCORE < 75) and (STATUS = “NW”)

    OPRT- N_SET_I D XPRSN_OR DER_ID ALERT_ ATTR_ID OPRTR_ CD VALUE_ TX NEXT_OPRTN_ SET_ID DMN _CD CLS_ACTIVITY_- TYPE_CD CMMNT_TX
    100 2 11300002 2 < 75 101 MTS NULL NULL
    101 NULL 1130000 08 = NW NULL MTS NULL NULL