6.13 Configuring the Look Back Period

This parameter specifies the look back period for the transactions and related CTR in the Exemption Details section.

To add a new look back period, execute the following script in the MANTAS schema of the database with an appropriate user.

For example, a look back period of 5 days must be inserted:

INSERT INTO KDD_CODE_SET_TRNLN (CODE_SET,
CODE_VAL, SRC_SYS_CD, CODE_DISP_TX)
VALUES('CTRTranLkBckPrd',
'5', NULL,
'Last 5 days');
COMMIT;

To modify the value of an existing look back period parameter, execute the script in the MANTAS schema of the database with an appropriate user.

For example if the user modifies Last 5 days to Last 7 Days.

Deleting an Existing Record

To delete an existing record, execute the following query:

DELETE kdd_code_set_trnln
WHERE code_set='CTRTranLkBckPrd' AND code_val ='5';
COMMIT;

Inserting a New Value

To insert a new value, execute the following query:

INSERT INTO KDD_CODE_SET_TRNLN (CODE_SET,
CODE_VAL, SRC_SYS_CD, CODE_DISP_TX)
VALUES('CTRTranLkBckPrd',
 
'7',
 
NULL,
'Last 7 days');
 
COMMIT;