C.1.6 TIME_ZONE Configurations Required for the dim_- sanctions_status Table

To configure the table in the ATOMIC schema, follow these steps:

  1. Create a unique value for the new PMF status in the n_sanction_status_code column. This value must be the same in the AAI_WF_STATUS_B and AAI_WF_STATUS_TL columns. For more information, see Configurations Required for the Audit Tables.
  2. Provide the activity name as mentioned in step 4 of the Configuring the Human Task in the PMF Page section in the v_remarks column.
  3. Provide a unique data field value in the v_applicable_params column where n_sanc- tion_staus_key = 101 (ApplicationParams) and n_sanction_staus_key = 202 (PMF- Params).
  4. To update the image path for the alert status, update the v_sanction_status_img_path value.
  5. To update the image path for the list of actions, update the v_sanction_dropdown_img_path value.
  6. To configure the action status:
    • Provide the value StatusActon if a status action must be fired.
    • Provide the value PendingTrxnsCount if the count of pending transactions is required for a particular action.
    • Provide the value PendingTrxnsSuspiciousCountAndStatusActon if the count of pending transactions and count of pending suspicious transactions are both required.
  7. In the v_data_field column, give the same data field created in the PMF page data field section.
  8. Update the v_owner_update column in the fsi_rt_alerts table if the owner must be updated.
  9. Provide the audit message in the v_audit_msg column. This value must be the same as the value provided in the v_sanction_status_name column. For more information, see Configurations Required for the Audit Tables .

    Note:

    For a new status, the v_applicable_params column must be left blank.