5.2.1.10 Populating Data in the KDD_CODE_SET_TRNLN Table

The data from the KDD_CODE_SET_TRNLN table is available in the UI when you click the Auto-Populate button on the Risk Score for Parameter/Rule Value page.

Every code set has one or more seeded code values. You can add a code value in a code set or modify an existing code value in a code set.

To add a code value in a code set, execute the following script:

insert into KDD_CODE_SET_TRNLN (CODE_SET, CODE_VAL, SRC_SYS_CD, CODE_DISP_TX)
values ('', '', null, '');

To modify an existing code value in a code set, execute the following script:

update kdd_code_set_trnln set code_val='', code_disp_tx = '' where code_val = '' and code_set='';