5.2.1.3 Moving the Country Data in the KDD_CODE_SET_TRNLN table

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 perform this activity, 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;