4.8 ALM Table Cleanup

This module discusses the procedure to delete data from ALM Output Tables. During the delete process, partitions of Output Tables are truncated. The procedure deletes the data from Output Tables permanently and no backup is retained.

Steps

To clean up the ALM Output, follow these steps:

1. Navigate to Operations and Processes menu, and select Scheduler.
2. Select Define Batch. Create a new batch by entering Code, Name and Description.
3. Save the batch.
4. Navigate to Define Task.
5. Select the Batch created above from the Batch drop-down list.
6. Click the Add button from Actions drop-down.
7. Enter the following details in the Task Details Section:
   • Task Code: Enter a Code for the task.
   • Task Name: Enter Name for the task.

     The Task Name must be alphanumeric and must not start with a number. The Task Name must not exceed 60 characters in length. The Task Name must not contain any special characters except underscore (_).

   • Description: Enter the Task Description. Special characters are not allowed in Task Description. Words like Select From or Delete From (identified as potential SQL injection vulnerable strings) should not be entered in the Description.
8. Select the Task Type as REST.
9. Select Component as Transform Data.
10. Select Batch Service URL as DMT_SERVICE.
11. Select name as ALM Process Results Data Delete from Name drop-down. This a mandatory Task Parameter.
12. Enter the following extra parameters: These are mandatory Task Parameters.
    • TABLE_GROUP: Name of the Group ID (1 to 6) of table. The following tables store output from the ALM Engine.

      Group_Id	Group_Name	Table_Name
      1	Process Output	FSI_ALM_CASHFLOW_OUTPUT_HIST
      1	Process Output	FSI_ALM_CASHFLOW_DYN_MV_OUTPUT_HIST
      1	Process Output	FSI_CFA_RESULT_DETAILS
      1	Process Output	FSI_CFA_LR_RESULT_DETAILS
      1	Process Output	FSI_CFA_IR_RESULT_DETAILS
      1	Process Output	FSI_CFA_ALM_RESULT_MASTER
      1	Process Output	FSI_CFA_ALM_ACCOUNT_SUMMARY
      1	Process Output	FSI_CFA_DIMENSION_MAP_DTL
      1	Process Output	FSI_CFA_TIME_BUCKET
      1	Process Output	FSI_O_CFE_MESSAGES_HIST
      1	Process Output	FSI_ALM_CFA_FCAST_INSTRUMENTS
      2	Forecast Rates	FSI_O_FCAST_IRC_RATES_HIST
      2	Forecast Rates	FSI_O_FCAST_IRC_IF_COEFF_HIST
      2	Forecast Rates	FSI_O_FCAST_ECO_IND_RATES_HIST
      2	Forecast Rates	FSI_O_FCAST_CCY_RATES_HIST
      2	Forecast Rates	FSI_O_FCAST_VOL_RATES_HIST
      4	Cash Flow Edits	FSI_O_CFE_EDITS_MESSAGES_HIST
      5	Reporting Table	FSI_BI_ALM_FINANCIAL_RESULT
      5	Reporting Table	FSI_BI_ALM_INTEREST_RATE_RISK
      5	Reporting Table	FSI_BI_ALM_LIQUIDITY_RISK
      5	Reporting Table	FSI_BI_ALM_RESULT_MASTER
      5	Reporting Table	FSI_BI_ALM_ACCOUNT_SUMMARY
      5	Reporting Table	FSI_ALM_CASHFLOW_OUTPUT_HIST
      5	Reporting Table	FSI_ALM_CASHFLOW_DYN_MV_OUTPUT_HIST
      6	Reporting Table Transposed	FSI_BI_ALM_FINANCIAL_RESULT_TRANSPOSE
      6	Reporting Table Transposed	FSI_BI_ALM_INTEREST_RATE_RISK_TRANSPOSE
      6	Reporting Table Transposed	FSI_BI_ALM_LIQUIDITY_RISK_TRANSPOSE
      6	Reporting Table Transposed	FSI_BI_ALM_RESULT_MASTER_TRANSPOSE

    • EXECUTION_ID_VALUE: Enter the Execution ID of ALM Process
13. Use Effective Date: Select this as YES or NO. This parameter does not impact on ALM Table Cleanup functionality.
14. Save the Task.
15. Navigate to Schedule Batch and execute the batch created above created batch with Batch ID and MIS Date.

For more information, see the Scheduler Service.