14.8 Configuring Case Due Date

This section describes how to configure Case Due Date.

Case Due Date is determined based on the configured data on the following three tables:

  1. KDD_ACTION
  2. KDD_CASE_TYPE_PARAM_CONFIG
  3. KDD_INSTALL_PARAM

Scenario 1: Using KDD_ACTION

If the DFLT_DUE_DT_LM column value for the particular action in question (e.g., CREATE_CASE) is defined, the case due date is created based on it. And the process ignores the remaining two tables.

For example:

SELECT DFLT_DUE_DT_LM FROM KDD_ACTION ka;

The due date for the newly created case will be selected from the KDD_ACTION table's DFLT_DUE_DT_LM column.

Scenario 2: Using KDD_CASE_TYPE_PARAM_CONFIG

If the KDD_ACTION table does not have a preconfigured value for case due date, then it is determined based on the configurations done in the KDD_CASETYPE_PARAM_CONFIG for the specific Case Type and V_PARAM_CDDUE_DT_LMT.

In the KDD_CASETYPE_PARAM_CONFIG table, define the Case Type and Due Date.

For example: 
SELECT * FROM KDD_CASETYPE_PARAM_CONFIG kcpc;
V_PARAM_CD-DUE_DT_LMT
V_CASE_TYPE-AML_SURV
V_PARAM_VALUE-10

The AML_SURV Case Type has a due date of 10 days in the KDD_CASETYPE_PARAM_CONFIG table. You can change the case due date. In the KDD_ACTION table, clear the default due date, and configure the AML_SURV case type in the KDD_CASETYPE_PARAM_CONFIG table.

You can also configure different due dates for Case Types. For more information, see Configuring Different Due Dates for Case Types.

Scenario 3: Using KDD_INSTALL_PARAM

If both the KDD_ACTION and KDD_CASE_TYPE_PARAM_CONFIG tables do not contain any preconfigured value for case due date; Case due date is determined based on the KDD_INSTALL_PARAM table.

You can also configure the case due date via the UI.

To configure case due date via the UI, follow these steps:
  1. Open the Manage Common Parameters screen.
  2. Select Used for Design from the Parameter Category drop-down list.
  3. Select Default Due Date Calculationfrom the Parameter Name drop-down list.
  4. Edit the required parameter details (specify if calendar or business days will be used for due date calculation. Allowed values are C for Calendar days and B for Business days.):
    1. Parameter Value = B
    2. Attribute 1 Value = 30
  5. Scroll down and click Save. A confirmation dialog box appears asking: Would you like to Save these actions?
  6. Click OK. A Confirmation dialog box appears with the message: Update Operation Successful.
  7. Click OK. The Manage Common Parameters page is displayed.