8.2 Populating Country Data in KDD_CODE_SET_TRNLN Table

Note:

Ignore this step if it is already performed during the use administration process.

KYC has multiple risk parameters which are country-based values. KYC uses the code set translation table for all code sets and their values. The country data is already available in the Geography table. The same data must also be available in the kdd_code_set_trnln table.

To do this, run the following script:

insert into kdd_code_set_trnln select distinct 'ISOCountryCode', g.geo_cntry_cd, null, g.geo_nm, null from GEOGRAPHY g;
Commit;