19.9 Custom Rule Attributes

This section describes the Custom Rule Attributes.

Ifyou want to define a rule for an attribute that is not seeded, then use SQL script to define an attribute and insert that as the V_FILTER_VAL in the FCC_ASSGN_RULE_DEFN table.

Below is an example to define and insert the Event Scenario as a rule attribute.

A case can have multiple scenarios as a case can have multiple events and in turn these events can be generated for different queries. Insert below query to filter scenario through a rule:
insert into FCC_ASSGN_RULE_DEFN
          (V_RULE_NAME, N_RULE_ID, V_FILTER_NM, V_FIL- TER_OPERATOR,
        V_FILTER_VAL)values ('rule1', 1, 'case_intrl_id', 'in
          ',('(Select t.case_intrl_id from kdd_cases tinner join fcc_precase_case_map pcm on
          pcm.v_case_id = t.case_intrl_idinner join fcc_correlation_event_map cor
          on cor.n_event_correlation_skey =
      pcm.n_event_correlation_skey
    inner join fcc_event_details s on s.n_event_skey = cor.n_event_skey where s.N_SCENARIO_SKEY
        in (XXX,XXX))'));

In the above query, XXX,XXX represents the scenarios that can be used in this attribute. This is obtained

from the N_SCENARIO_SKEY field in the FCC_SCENARIO_MASTER table.

Configuring Case Age

Case age can be calculated based on Business Days or Calendar Days by updating the configurable parameter set in the Installation Parameter table, from the Manage Parameters screen.

Calculation of Case Age is done by running the Batch <INFODOM>_CASE_AGE_CALC_BATCH. For more information, see the Executing Case Age Calculation Batch section.

This will update the KDD_CASES_AGE column with the age of the case, calculated in business days or calendar days based on the configuration made in the Installation Parameter table.

Executing Case Age Calculation Batch

To execute the Case Age Calculation batch <INFODOM>_CASE_AGE_CALC_BATCH, follow these steps:
  1. Login as ECM Administrator.
  2. Navigate to the Common Tasks option.
  3. SelectOperations.
  4. Click Batch Execution.

    Figure 19-2 Batch Execution

    This image shows the Batch Execution screen.
  5. Search for <INFODOM>_CASE_AGE_CALC_BATCH (batch and enter the Information Date (MIS date) using Calendar. Click Execute Batch.

    Figure 19-3 Execute Batch

    This image shows the Execute Batch screen.
  6. Click OK on the confirmation box. A batch execution triggered message is displayed.
  7. To view the status of the batch, navigate to Batch Monitor under Operations.