CALL FSI_CREATE_SEQUENCE('SEQ_DIM_COUNTRY','DIM_COUNTRY','N_COUNTRY_SKEY')
/
DECLARE
 BEGIN
  DELETE FROM DIM_COUNTRY WHERE V_COUNTRY_ID IN ('MSG','MIS') AND N_COUNTRY_SKEY != 0;
EXCEPTION
 WHEN OTHERS THEN
  UPDATE DIM_COUNTRY SET F_LATEST_RECORD_INDICATOR = 'N', D_RECORD_START_DATE = '01-JAN-1900', D_RECORD_END_DATE = '01-JAN-1900' WHERE V_COUNTRY_ID IN ('MSG','MIS') AND N_COUNTRY_SKEY != 0;
END;
/
DECLARE
 BEGIN
  DELETE FROM DIM_COUNTRY WHERE V_COUNTRY_ID IN ('OTH') AND N_COUNTRY_SKEY != -1;
EXCEPTION
 WHEN OTHERS THEN
  UPDATE DIM_COUNTRY SET F_LATEST_RECORD_INDICATOR = 'N', D_RECORD_START_DATE = '01-JAN-1900', D_RECORD_END_DATE = '01-JAN-1900' WHERE V_COUNTRY_ID IN ('OTH') AND N_COUNTRY_SKEY != -1;
END;
/
MERGE INTO DIM_COUNTRY T 
USING ( 
 SELECT '-1' N_COUNTRY_SKEY,'OTH' V_COUNTRY_ID,'Other Countries' V_COUNTRY_DESC,'Other Countries' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'OTH' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Other Countries' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'OTH' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'OTH' V_REGION_CD FROM DUAL
 UNION 
 SELECT '0' N_COUNTRY_SKEY,'MSG' V_COUNTRY_ID,'Missing Countries' V_COUNTRY_DESC,'Missing Countries' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'MSG' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Missing Countries' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MSG' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MSG' V_REGION_CD FROM DUAL
 ) S
ON (T.N_COUNTRY_SKEY = S.N_COUNTRY_SKEY)
WHEN MATCHED THEN 
 UPDATE 
 SET T.V_COUNTRY_ID = S.V_COUNTRY_ID,
     T.V_COUNTRY_DESC = S.V_COUNTRY_DESC,
     T.V_COUNTRY_LONG_DESC = S.V_COUNTRY_LONG_DESC,
     T.V_CLS_WTCHD_FACTOR = S.V_CLS_WTCHD_FACTOR,
     T.V_CURRENCY_CODE = S.V_CURRENCY_CODE,
     T.N_COUNTRY_RISK_FACTOR = S.N_COUNTRY_RISK_FACTOR,
     T.FIC_MIS_DATE = S.FIC_MIS_DATE,
     T.D_RECORD_START_DATE = S.D_RECORD_START_DATE,
     T.D_RECORD_END_DATE = S.D_RECORD_END_DATE,
     T.F_LATEST_RECORD_INDICATOR = S.F_LATEST_RECORD_INDICATOR,
     T.N_ALPHA_VALUE = S.N_ALPHA_VALUE,
     T.V_PROV_STATE_DESC = S.V_PROV_STATE_DESC,
     T.V_PROV_STATE_ID = S.V_PROV_STATE_ID,
     T.V_RATING_ID = S.V_RATING_ID,
     T.V_COUNTRY_NAME = S.V_COUNTRY_NAME,
     T.F_OECD_INDICATOR = S.F_OECD_INDICATOR,
     T.F_DEFAULT_FLAG = S.F_DEFAULT_FLAG,
     T.V_ISO_COUNTRY_CD = S.V_ISO_COUNTRY_CD,
     T.N_REGION_SKEY = S.N_REGION_SKEY,
     T.F_EU_APPROVED_THIRD_COUNTRY = S.F_EU_APPROVED_THIRD_COUNTRY,
     T.F_EEA_COUNTRY_FLAG = S.F_EEA_COUNTRY_FLAG,
     T.F_EU_MEMBER_STATE_FLAG = S.F_EU_MEMBER_STATE_FLAG,
     T.V_STD_CENTRAL_BANK_CD = S.V_STD_CENTRAL_BANK_CD,
     T.V_CONTINENT_CODE = S.V_CONTINENT_CODE,
     T.V_ADVANCE_ECONOMY_IND = S.V_ADVANCE_ECONOMY_IND,
     T.V_REGION_CD = S.V_REGION_CD
WHEN NOT MATCHED THEN 
 INSERT 
  (N_COUNTRY_SKEY,V_COUNTRY_ID,V_COUNTRY_DESC,V_COUNTRY_LONG_DESC,V_CLS_WTCHD_FACTOR,V_CURRENCY_CODE,N_COUNTRY_RISK_FACTOR,FIC_MIS_DATE,D_RECORD_START_DATE,D_RECORD_END_DATE,F_LATEST_RECORD_INDICATOR,N_ALPHA_VALUE,V_PROV_STATE_DESC,V_PROV_STATE_ID,V_RATING_ID,V_COUNTRY_NAME,F_OECD_INDICATOR,F_DEFAULT_FLAG,V_ISO_COUNTRY_CD,N_REGION_SKEY,F_EU_APPROVED_THIRD_COUNTRY,F_EEA_COUNTRY_FLAG,F_EU_MEMBER_STATE_FLAG,V_STD_CENTRAL_BANK_CD,V_CONTINENT_CODE,V_ADVANCE_ECONOMY_IND,V_REGION_CD)
 VALUES
  (S.N_COUNTRY_SKEY,S.V_COUNTRY_ID,S.V_COUNTRY_DESC,S.V_COUNTRY_LONG_DESC,S.V_CLS_WTCHD_FACTOR,S.V_CURRENCY_CODE,S.N_COUNTRY_RISK_FACTOR,S.FIC_MIS_DATE,S.D_RECORD_START_DATE,S.D_RECORD_END_DATE,S.F_LATEST_RECORD_INDICATOR,S.N_ALPHA_VALUE,S.V_PROV_STATE_DESC,S.V_PROV_STATE_ID,S.V_RATING_ID,S.V_COUNTRY_NAME,S.F_OECD_INDICATOR,S.F_DEFAULT_FLAG,S.V_ISO_COUNTRY_CD,S.N_REGION_SKEY,S.F_EU_APPROVED_THIRD_COUNTRY,S.F_EEA_COUNTRY_FLAG,S.F_EU_MEMBER_STATE_FLAG,S.V_STD_CENTRAL_BANK_CD,S.V_CONTINENT_CODE,S.V_ADVANCE_ECONOMY_IND,S.V_REGION_CD )
/
MERGE INTO DIM_COUNTRY T 
USING ( 
 SELECT '1' N_COUNTRY_SKEY,'AD' V_COUNTRY_ID,'Andorra' V_COUNTRY_DESC,'Andorra' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Andorra' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'AD' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'AD' V_REGION_CD FROM DUAL
 UNION 
 SELECT '2' N_COUNTRY_SKEY,'SG' V_COUNTRY_ID,'Singapore' V_COUNTRY_DESC,'Singapore' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'SGD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Singapore' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'SG' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'SG' V_REGION_CD FROM DUAL
 UNION 
 SELECT '3' N_COUNTRY_SKEY,'CR' V_COUNTRY_ID,'Costa Rica' V_COUNTRY_DESC,'Costa Rica' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'CRC' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Costa Rica' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'CR' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'CR' V_REGION_CD FROM DUAL
 UNION 
 SELECT '4' N_COUNTRY_SKEY,'KH' V_COUNTRY_ID,'Cambodia' V_COUNTRY_DESC,'Cambodia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'KHR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Cambodia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'KH' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'KH' V_REGION_CD FROM DUAL
 UNION 
 SELECT '5' N_COUNTRY_SKEY,'AI' V_COUNTRY_ID,'Anguilla' V_COUNTRY_DESC,'Anguilla' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XCD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Anguilla' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'AI' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'AI' V_REGION_CD FROM DUAL
 UNION 
 SELECT '6' N_COUNTRY_SKEY,'CU' V_COUNTRY_ID,'Cuba' V_COUNTRY_DESC,'Cuba' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'CUP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Cuba' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'CU' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'CU' V_REGION_CD FROM DUAL
 UNION 
 SELECT '7' N_COUNTRY_SKEY,'CV' V_COUNTRY_ID,'Cape Verde' V_COUNTRY_DESC,'Cape Verde' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'CVE' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Cape Verde' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'CV' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'CV' V_REGION_CD FROM DUAL
 UNION 
 SELECT '8' N_COUNTRY_SKEY,'CW' V_COUNTRY_ID,'Curacao' V_COUNTRY_DESC,'Curacao' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'ANG' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Curacao' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'CW' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'CW' V_REGION_CD FROM DUAL
 UNION 
 SELECT '9' N_COUNTRY_SKEY,'CX' V_COUNTRY_ID,'Christmas Island' V_COUNTRY_DESC,'Christmas Island' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'AUD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Christmas Island' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'CX' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'CX' V_REGION_CD FROM DUAL
 UNION 
 SELECT '10' N_COUNTRY_SKEY,'CY' V_COUNTRY_ID,'Cyprus' V_COUNTRY_DESC,'Cyprus' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Cyprus' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'CY' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'CBC' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'CY' V_REGION_CD FROM DUAL
 UNION 
 SELECT '11' N_COUNTRY_SKEY,'CZ' V_COUNTRY_ID,'Czech Republic' V_COUNTRY_DESC,'Czech Republic' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'CZK' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Czech Republic' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'CZ' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'CZNB' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'CZ' V_REGION_CD FROM DUAL
 UNION 
 SELECT '12' N_COUNTRY_SKEY,'DE' V_COUNTRY_ID,'Germany' V_COUNTRY_DESC,'Germany' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Germany' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'DE' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'DBB' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'DE' V_REGION_CD FROM DUAL
 UNION 
 SELECT '13' N_COUNTRY_SKEY,'SH' V_COUNTRY_ID,'St Helena' V_COUNTRY_DESC,'St Helena' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'SHP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'St Helena' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'SH' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'SH' V_REGION_CD FROM DUAL
 UNION 
 SELECT '14' N_COUNTRY_SKEY,'DJ' V_COUNTRY_ID,'Djibouti' V_COUNTRY_DESC,'Djibouti' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'DJF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Djibouti' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'DJ' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'DJ' V_REGION_CD FROM DUAL
 UNION 
 SELECT '15' N_COUNTRY_SKEY,'DK' V_COUNTRY_ID,'Denmark' V_COUNTRY_DESC,'Denmark' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'DKK' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Denmark' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'DK' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'NBD' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'DK' V_REGION_CD FROM DUAL
 UNION 
 SELECT '16' N_COUNTRY_SKEY,'AQ' V_COUNTRY_ID,'Antarctica' V_COUNTRY_DESC,'Antarctica' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EDD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Antarctica' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'AQ' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'AQ' V_REGION_CD FROM DUAL
 UNION 
 SELECT '17' N_COUNTRY_SKEY,'KI' V_COUNTRY_ID,'Kiribati' V_COUNTRY_DESC,'Kiribati' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'AUD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Kiribati' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'KI' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'KI' V_REGION_CD FROM DUAL
 UNION 
 SELECT '18' N_COUNTRY_SKEY,'DM' V_COUNTRY_ID,'Dominica' V_COUNTRY_DESC,'Dominica' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XCD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Dominica' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'DM' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'DM' V_REGION_CD FROM DUAL
 UNION 
 SELECT '19' N_COUNTRY_SKEY,'AL' V_COUNTRY_ID,'Albania' V_COUNTRY_DESC,'Albania' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'ALL' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Albania' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'AL' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'AL' V_REGION_CD FROM DUAL
 UNION 
 SELECT '20' N_COUNTRY_SKEY,'DO' V_COUNTRY_ID,'Dominican Republic' V_COUNTRY_DESC,'Dominican Republic' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'DOP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Dominican Republic' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'DO' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'DO' V_REGION_CD FROM DUAL
 UNION 
 SELECT '21' N_COUNTRY_SKEY,'DZ' V_COUNTRY_ID,'Algeria' V_COUNTRY_DESC,'Algeria' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'DZD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Algeria' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'DZ' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'DZ' V_REGION_CD FROM DUAL
 UNION 
 SELECT '22' N_COUNTRY_SKEY,'EC' V_COUNTRY_ID,'Ecuador' V_COUNTRY_DESC,'Ecuador' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'USD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Ecuador' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'EC' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'EC' V_REGION_CD FROM DUAL
 UNION 
 SELECT '23' N_COUNTRY_SKEY,'EE' V_COUNTRY_ID,'Estonia' V_COUNTRY_DESC,'Estonia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EEK' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Estonia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'EE' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'EEP' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'EE' V_REGION_CD FROM DUAL
 UNION 
 SELECT '24' N_COUNTRY_SKEY,'SI' V_COUNTRY_ID,'Slovenia' V_COUNTRY_DESC,'Slovenia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Slovenia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'SI' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'BOS' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'SI' V_REGION_CD FROM DUAL
 UNION 
 SELECT '25' N_COUNTRY_SKEY,'EG' V_COUNTRY_ID,'Egypt' V_COUNTRY_DESC,'Egypt' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EGP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Egypt' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'EG' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'EG' V_REGION_CD FROM DUAL
 UNION 
 SELECT '26' N_COUNTRY_SKEY,'EH' V_COUNTRY_ID,'Western Sahara' V_COUNTRY_DESC,'Western Sahara' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'MAD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Western Sahara' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'EH' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'EH' V_REGION_CD FROM DUAL
 UNION 
 SELECT '27' N_COUNTRY_SKEY,'ER' V_COUNTRY_ID,'Eritrea' V_COUNTRY_DESC,'Eritrea' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'ERN' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Eritrea' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'ER' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'ER' V_REGION_CD FROM DUAL
 UNION 
 SELECT '28' N_COUNTRY_SKEY,'ES' V_COUNTRY_ID,'Spain' V_COUNTRY_DESC,'Spain' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Spain' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'ES' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'BDE' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'ES' V_REGION_CD FROM DUAL
 UNION 
 SELECT '29' N_COUNTRY_SKEY,'KM' V_COUNTRY_ID,'Comoros' V_COUNTRY_DESC,'Comoros' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'KMF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Comoros' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'KM' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'KM' V_REGION_CD FROM DUAL
 UNION 
 SELECT '30' N_COUNTRY_SKEY,'ET' V_COUNTRY_ID,'Ethiopia' V_COUNTRY_DESC,'Ethiopia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'ETB' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Ethiopia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'ET' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'ET' V_REGION_CD FROM DUAL
 UNION 
 SELECT '31' N_COUNTRY_SKEY,'FI' V_COUNTRY_ID,'Finland' V_COUNTRY_DESC,'Finland' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Finland' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'FI' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'BOF' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'FI' V_REGION_CD FROM DUAL
 UNION 
 SELECT '32' N_COUNTRY_SKEY,'AM' V_COUNTRY_ID,'Armenia' V_COUNTRY_DESC,'Armenia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'AMD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Armenia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'AM' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'AM' V_REGION_CD FROM DUAL
 UNION 
 SELECT '33' N_COUNTRY_SKEY,'FJ' V_COUNTRY_ID,'Fiji Islands' V_COUNTRY_DESC,'Fiji Islands' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'FJD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Fiji Islands' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'FJ' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'FJ' V_REGION_CD FROM DUAL
 UNION 
 SELECT '34' N_COUNTRY_SKEY,'FK' V_COUNTRY_ID,'Falkland Islands' V_COUNTRY_DESC,'Falkland Islands' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'FKP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Falkland Islands' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'FK' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'FK' V_REGION_CD FROM DUAL
 UNION 
 SELECT '35' N_COUNTRY_SKEY,'IS' V_COUNTRY_ID,'Iceland' V_COUNTRY_DESC,'Iceland' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'ISK' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Iceland' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'IS' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'CBIC' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'IS' V_REGION_CD FROM DUAL
 UNION 
 SELECT '36' N_COUNTRY_SKEY,'FM' V_COUNTRY_ID,'Federated States Of Micronesia' V_COUNTRY_DESC,'Federated States Of Micronesia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'USD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Federated States Of Micronesia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'FM' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'FM' V_REGION_CD FROM DUAL
 UNION 
 SELECT '37' N_COUNTRY_SKEY,'FO' V_COUNTRY_ID,'Faroe Islands' V_COUNTRY_DESC,'Faroe Islands' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'DKK' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Faroe Islands' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'FO' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'FO' V_REGION_CD FROM DUAL
 UNION 
 SELECT '38' N_COUNTRY_SKEY,'FR' V_COUNTRY_ID,'France' V_COUNTRY_DESC,'France' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'France' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'FR' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'BDF' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'FR' V_REGION_CD FROM DUAL
 UNION 
 SELECT '39' N_COUNTRY_SKEY,'FX' V_COUNTRY_ID,'France Metropolitan' V_COUNTRY_DESC,'France Metropolitan' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'France Metropolitan' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'FX' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'FX' V_REGION_CD FROM DUAL
 UNION 
 SELECT '40' N_COUNTRY_SKEY,'GA' V_COUNTRY_ID,'Gabon' V_COUNTRY_DESC,'Gabon' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XAF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Gabon' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'GA' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'GA' V_REGION_CD FROM DUAL
 UNION 
 SELECT '41' N_COUNTRY_SKEY,'KN' V_COUNTRY_ID,'Saint Kitts And Nevis' V_COUNTRY_DESC,'Saint Kitts And Nevis' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XCD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Saint Kitts And Nevis' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'KN' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'KN' V_REGION_CD FROM DUAL
 UNION 
 SELECT '42' N_COUNTRY_SKEY,'GB' V_COUNTRY_ID,'United Kingdom' V_COUNTRY_DESC,'United Kingdom' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'GBP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'United Kingdom' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'GB' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'BOE' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'GB' V_REGION_CD FROM DUAL
 UNION 
 SELECT '43' N_COUNTRY_SKEY,'GD' V_COUNTRY_ID,'Grenada' V_COUNTRY_DESC,'Grenada' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XCD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Grenada' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'GD' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'GD' V_REGION_CD FROM DUAL
 UNION 
 SELECT '44' N_COUNTRY_SKEY,'GE' V_COUNTRY_ID,'Georgia' V_COUNTRY_DESC,'Georgia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'GEL' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Georgia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'GE' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'GE' V_REGION_CD FROM DUAL
 UNION 
 SELECT '45' N_COUNTRY_SKEY,'AN' V_COUNTRY_ID,'Netherlands Antilles' V_COUNTRY_DESC,'Netherlands Antilles' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'ANG' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Netherlands Antilles' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'AN' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'AN' V_REGION_CD FROM DUAL
 UNION 
 SELECT '46' N_COUNTRY_SKEY,'SJ' V_COUNTRY_ID,'Svalbard And Jan Mayen Islands' V_COUNTRY_DESC,'Svalbard And Jan Mayen Islands' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'NOK' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Svalbard And Jan Mayen Islands' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'SJ' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'SJ' V_REGION_CD FROM DUAL
 UNION 
 SELECT '47' N_COUNTRY_SKEY,'GF' V_COUNTRY_ID,'French Guiana' V_COUNTRY_DESC,'French Guiana' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'French Guiana' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'GF' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'GF' V_REGION_CD FROM DUAL
 UNION 
 SELECT '48' N_COUNTRY_SKEY,'GH' V_COUNTRY_ID,'Ghana' V_COUNTRY_DESC,'Ghana' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'GHC' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Ghana' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'GH' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'GH' V_REGION_CD FROM DUAL
 UNION 
 SELECT '49' N_COUNTRY_SKEY,'GI' V_COUNTRY_ID,'Gibraltar' V_COUNTRY_DESC,'Gibraltar' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'GIP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Gibraltar' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'GI' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'GI' V_REGION_CD FROM DUAL
 UNION 
 SELECT '50' N_COUNTRY_SKEY,'GL' V_COUNTRY_ID,'Greenland' V_COUNTRY_DESC,'Greenland' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'DKK' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Greenland' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'GL' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'GL' V_REGION_CD FROM DUAL
 UNION 
 SELECT '51' N_COUNTRY_SKEY,'GM' V_COUNTRY_ID,'Gambia' V_COUNTRY_DESC,'Gambia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'GMD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Gambia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'GM' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'GM' V_REGION_CD FROM DUAL
 UNION 
 SELECT '52' N_COUNTRY_SKEY,'GN' V_COUNTRY_ID,'Guinea' V_COUNTRY_DESC,'Guinea' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'GNS' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Guinea' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'GN' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'GN' V_REGION_CD FROM DUAL
 UNION 
 SELECT '53' N_COUNTRY_SKEY,'KP' V_COUNTRY_ID,'North Korea' V_COUNTRY_DESC,'North Korea' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'KPW' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'North Korea' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'KP' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'KP' V_REGION_CD FROM DUAL
 UNION 
 SELECT '54' N_COUNTRY_SKEY,'GP' V_COUNTRY_ID,'Guadeloupe' V_COUNTRY_DESC,'Guadeloupe' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Guadeloupe' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'GP' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'GP' V_REGION_CD FROM DUAL
 UNION 
 SELECT '55' N_COUNTRY_SKEY,'GQ' V_COUNTRY_ID,'Guinea' V_COUNTRY_DESC,'Guinea' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XAF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Guinea' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'GQ' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'GQ' V_REGION_CD FROM DUAL
 UNION 
 SELECT '56' N_COUNTRY_SKEY,'GR' V_COUNTRY_ID,'Greece' V_COUNTRY_DESC,'Greece' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Greece' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'GR' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'BOG' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'GR' V_REGION_CD FROM DUAL
 UNION 
 SELECT '57' N_COUNTRY_SKEY,'SK' V_COUNTRY_ID,'Slovakia' V_COUNTRY_DESC,'Slovakia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Slovakia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'SK' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'NBS' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'SK' V_REGION_CD FROM DUAL
 UNION 
 SELECT '58' N_COUNTRY_SKEY,'GS' V_COUNTRY_ID,'South Georgia' V_COUNTRY_DESC,'South Georgia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'GBP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'South Georgia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'GS' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'GS' V_REGION_CD FROM DUAL
 UNION 
 SELECT '59' N_COUNTRY_SKEY,'AO' V_COUNTRY_ID,'Angola' V_COUNTRY_DESC,'Angola' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'AOA' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Angola' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'AO' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'AO' V_REGION_CD FROM DUAL
 UNION 
 SELECT '60' N_COUNTRY_SKEY,'GT' V_COUNTRY_ID,'Guatemala' V_COUNTRY_DESC,'Guatemala' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'GTQ' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Guatemala' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'GT' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'GT' V_REGION_CD FROM DUAL
 UNION 
 SELECT '61' N_COUNTRY_SKEY,'GU' V_COUNTRY_ID,'Guam' V_COUNTRY_DESC,'Guam' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'USD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Guam' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'GU' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'US' V_REGION_CD FROM DUAL
 UNION 
 SELECT '62' N_COUNTRY_SKEY,'GW' V_COUNTRY_ID,'Guinea Bissau' V_COUNTRY_DESC,'Guinea Bissau' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'GWP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Guinea Bissau' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'GW' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'GW' V_REGION_CD FROM DUAL
 UNION 
 SELECT '63' N_COUNTRY_SKEY,'GY' V_COUNTRY_ID,'Guyana' V_COUNTRY_DESC,'Guyana' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'GYD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Guyana' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'GY' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'GY' V_REGION_CD FROM DUAL
 UNION 
 SELECT '64' N_COUNTRY_SKEY,'HK' V_COUNTRY_ID,'Hong Kong' V_COUNTRY_DESC,'Hong Kong' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'HKD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Hong Kong' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'HK' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'HK' V_REGION_CD FROM DUAL
 UNION 
 SELECT '65' N_COUNTRY_SKEY,'AS' V_COUNTRY_ID,'American Samoa' V_COUNTRY_DESC,'American Samoa' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'USD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'American Samoa' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'AS' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'US' V_REGION_CD FROM DUAL
 UNION 
 SELECT '66' N_COUNTRY_SKEY,'HM' V_COUNTRY_ID,'Heard And Mcdonald Islands' V_COUNTRY_DESC,'Heard And Mcdonald Islands' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'AUD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Heard And Mcdonald Islands' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'HM' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'HM' V_REGION_CD FROM DUAL
 UNION 
 SELECT '67' N_COUNTRY_SKEY,'HN' V_COUNTRY_ID,'Honduras' V_COUNTRY_DESC,'Honduras' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'HNL' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Honduras' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'HN' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'HN' V_REGION_CD FROM DUAL
 UNION 
 SELECT '68' N_COUNTRY_SKEY,'AE' V_COUNTRY_ID,'United Arab Emirates' V_COUNTRY_DESC,'United Arab Emirates' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'AED' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'United Arab Emirates' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'AE' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'AE' V_REGION_CD FROM DUAL
 UNION 
 SELECT '69' N_COUNTRY_SKEY,'HR' V_COUNTRY_ID,'Croatia' V_COUNTRY_DESC,'Croatia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'HRK' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Croatia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'HR' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'CNB' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'HR' V_REGION_CD FROM DUAL
 UNION 
 SELECT '70' N_COUNTRY_SKEY,'HT' V_COUNTRY_ID,'Haiti' V_COUNTRY_DESC,'Haiti' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'HTG' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Haiti' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'HT' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'HT' V_REGION_CD FROM DUAL
 UNION 
 SELECT '71' N_COUNTRY_SKEY,'HU' V_COUNTRY_ID,'Hungary' V_COUNTRY_DESC,'Hungary' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'HUF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Hungary' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'HU' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'MNB' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'HU' V_REGION_CD FROM DUAL
 UNION 
 SELECT '72' N_COUNTRY_SKEY,'BL' V_COUNTRY_ID,'Saint Barthelemy' V_COUNTRY_DESC,'Saint Barthelemy' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Saint Barthelemy' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BL' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BL' V_REGION_CD FROM DUAL
 UNION 
 SELECT '73' N_COUNTRY_SKEY,'GG' V_COUNTRY_ID,'Guernsey' V_COUNTRY_DESC,'Guernsey' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'GGP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Guernsey' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'GG' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'GG' V_REGION_CD FROM DUAL
 UNION 
 SELECT '74' N_COUNTRY_SKEY,'ME' V_COUNTRY_ID,'Montenegro' V_COUNTRY_DESC,'Montenegro' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Montenegro' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'ME' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'ME' V_REGION_CD FROM DUAL
 UNION 
 SELECT '75' N_COUNTRY_SKEY,'SS' V_COUNTRY_ID,'South Sudan' V_COUNTRY_DESC,'South Sudan' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'SSP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'South Sudan' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'SS' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'SS' V_REGION_CD FROM DUAL
 UNION 
 SELECT '76' N_COUNTRY_SKEY,'BQ' V_COUNTRY_ID,'Bonaire, St. Eustatius & Saba' V_COUNTRY_DESC,'Bonaire, St. Eustatius & Saba' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'USD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Bonaire, St. Eustatius & Saba' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BQ' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BQ' V_REGION_CD FROM DUAL
 UNION 
 SELECT '77' N_COUNTRY_SKEY,'KR' V_COUNTRY_ID,'South Korea' V_COUNTRY_DESC,'South Korea' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'KRW' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'South Korea' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'KR' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'KR' V_REGION_CD FROM DUAL
 UNION 
 SELECT '78' N_COUNTRY_SKEY,'JE' V_COUNTRY_ID,'Jersey' V_COUNTRY_DESC,'Jersey' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'JEP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Jersey' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'JE' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'JE' V_REGION_CD FROM DUAL
 UNION 
 SELECT '79' N_COUNTRY_SKEY,'BD' V_COUNTRY_ID,'Bangladesh' V_COUNTRY_DESC,'Bangladesh' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'BDT' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Bangladesh' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BD' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BD' V_REGION_CD FROM DUAL
 UNION 
 SELECT '80' N_COUNTRY_SKEY,'SX' V_COUNTRY_ID,'St. Maarten' V_COUNTRY_DESC,'St. Maarten' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'St. Maarten' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'SX' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'SX' V_REGION_CD FROM DUAL
 UNION 
 SELECT '81' N_COUNTRY_SKEY,'XK' V_COUNTRY_ID,'Kosovo' V_COUNTRY_DESC,'Kosovo' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Kosovo' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'XK' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'XK' V_REGION_CD FROM DUAL
 UNION 
 SELECT '82' N_COUNTRY_SKEY,'KW' V_COUNTRY_ID,'Kuwait' V_COUNTRY_DESC,'Kuwait' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'KWD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Kuwait' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'KW' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'KW' V_REGION_CD FROM DUAL
 UNION 
 SELECT '83' N_COUNTRY_SKEY,'KY' V_COUNTRY_ID,'Cayman Islands' V_COUNTRY_DESC,'Cayman Islands' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'KYD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Cayman Islands' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'KY' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'KY' V_REGION_CD FROM DUAL
 UNION 
 SELECT '84' N_COUNTRY_SKEY,'KZ' V_COUNTRY_ID,'Kazakhstan' V_COUNTRY_DESC,'Kazakhstan' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'KZT' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Kazakhstan' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'KZ' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'KZ' V_REGION_CD FROM DUAL
 UNION 
 SELECT '85' N_COUNTRY_SKEY,'LA' V_COUNTRY_ID,'Laos' V_COUNTRY_DESC,'Laos' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'LAK' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Laos' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'LA' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'LA' V_REGION_CD FROM DUAL
 UNION 
 SELECT '86' N_COUNTRY_SKEY,'ID' V_COUNTRY_ID,'Indonesia' V_COUNTRY_DESC,'Indonesia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'IDR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Indonesia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'ID' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'ID' V_REGION_CD FROM DUAL
 UNION 
 SELECT '87' N_COUNTRY_SKEY,'LB' V_COUNTRY_ID,'Lebanon' V_COUNTRY_DESC,'Lebanon' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'LBP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Lebanon' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'LB' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'LB' V_REGION_CD FROM DUAL
 UNION 
 SELECT '88' N_COUNTRY_SKEY,'LC' V_COUNTRY_ID,'Saint Lucia' V_COUNTRY_DESC,'Saint Lucia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XCD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Saint Lucia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'LC' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'LC' V_REGION_CD FROM DUAL
 UNION 
 SELECT '89' N_COUNTRY_SKEY,'LI' V_COUNTRY_ID,'Liechtenstein' V_COUNTRY_DESC,'Liechtenstein' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'CHF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Liechtenstein' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'LI' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'LLB' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'LI' V_REGION_CD FROM DUAL
 UNION 
 SELECT '90' N_COUNTRY_SKEY,'SL' V_COUNTRY_ID,'Sierra Leone' V_COUNTRY_DESC,'Sierra Leone' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'SLL' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Sierra Leone' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'SL' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'SL' V_REGION_CD FROM DUAL
 UNION 
 SELECT '91' N_COUNTRY_SKEY,'LK' V_COUNTRY_ID,'Sri Lanka' V_COUNTRY_DESC,'Sri Lanka' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'LKR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Sri Lanka' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'LK' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'LK' V_REGION_CD FROM DUAL
 UNION 
 SELECT '92' N_COUNTRY_SKEY,'LR' V_COUNTRY_ID,'Liberia' V_COUNTRY_DESC,'Liberia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'LRD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Liberia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'LR' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'LR' V_REGION_CD FROM DUAL
 UNION 
 SELECT '93' N_COUNTRY_SKEY,'AT' V_COUNTRY_ID,'Austria' V_COUNTRY_DESC,'Austria' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Austria' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'AT' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'ONB' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'AT' V_REGION_CD FROM DUAL
 UNION 
 SELECT '94' N_COUNTRY_SKEY,'LS' V_COUNTRY_ID,'Lesotho' V_COUNTRY_DESC,'Lesotho' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'LSL' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Lesotho' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'LS' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'LS' V_REGION_CD FROM DUAL
 UNION 
 SELECT '95' N_COUNTRY_SKEY,'LT' V_COUNTRY_ID,'Lithuania' V_COUNTRY_DESC,'Lithuania' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'LTL' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Lithuania' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'LT' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'BOL' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'LT' V_REGION_CD FROM DUAL
 UNION 
 SELECT '96' N_COUNTRY_SKEY,'LU' V_COUNTRY_ID,'Luxembourg' V_COUNTRY_DESC,'Luxembourg' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Luxembourg' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'LU' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'BCL' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'LU' V_REGION_CD FROM DUAL
 UNION 
 SELECT '97' N_COUNTRY_SKEY,'LV' V_COUNTRY_ID,'Latvia' V_COUNTRY_DESC,'Latvia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'LVL' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Latvia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'LV' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'LB' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'LV' V_REGION_CD FROM DUAL
 UNION 
 SELECT '98' N_COUNTRY_SKEY,'IE' V_COUNTRY_ID,'Ireland' V_COUNTRY_DESC,'Ireland' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Ireland' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'IE' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'CBIR' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'IE' V_REGION_CD FROM DUAL
 UNION 
 SELECT '99' N_COUNTRY_SKEY,'LY' V_COUNTRY_ID,'Libyan Arab Jamahiriya' V_COUNTRY_DESC,'Libyan Arab Jamahiriya' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'LYD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Libyan Arab Jamahiriya' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'LY' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'LY' V_REGION_CD FROM DUAL
 UNION 
 SELECT '100' N_COUNTRY_SKEY,'MA' V_COUNTRY_ID,'Morocco' V_COUNTRY_DESC,'Morocco' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'MAD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Morocco' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MA' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MA' V_REGION_CD FROM DUAL
 UNION 
 SELECT '101' N_COUNTRY_SKEY,'SM' V_COUNTRY_ID,'San Marino' V_COUNTRY_DESC,'San Marino' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'San Marino' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'SM' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'SM' V_REGION_CD FROM DUAL
 UNION 
 SELECT '102' N_COUNTRY_SKEY,'MC' V_COUNTRY_ID,'Monaco' V_COUNTRY_DESC,'Monaco' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Monaco' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MC' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MC' V_REGION_CD FROM DUAL
 UNION 
 SELECT '103' N_COUNTRY_SKEY,'MD' V_COUNTRY_ID,'Moldova' V_COUNTRY_DESC,'Moldova' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'MDL' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Moldova' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MD' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MD' V_REGION_CD FROM DUAL
 UNION 
 SELECT '104' N_COUNTRY_SKEY,'MF' V_COUNTRY_ID,'Saint Martin' V_COUNTRY_DESC,'Saint Martin' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Saint Martin' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MF' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MF' V_REGION_CD FROM DUAL
 UNION 
 SELECT '105' N_COUNTRY_SKEY,'MG' V_COUNTRY_ID,'Madagascar' V_COUNTRY_DESC,'Madagascar' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'MGF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Madagascar' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MG' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MG' V_REGION_CD FROM DUAL
 UNION 
 SELECT '106' N_COUNTRY_SKEY,'AU' V_COUNTRY_ID,'Australia' V_COUNTRY_DESC,'Australia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'AUD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Australia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'AU' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'AU' V_REGION_CD FROM DUAL
 UNION 
 SELECT '107' N_COUNTRY_SKEY,'MH' V_COUNTRY_ID,'Marshall Islands' V_COUNTRY_DESC,'Marshall Islands' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'USD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Marshall Islands' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MH' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MH' V_REGION_CD FROM DUAL
 UNION 
 SELECT '108' N_COUNTRY_SKEY,'MK' V_COUNTRY_ID,'Macedonia' V_COUNTRY_DESC,'Macedonia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'MKD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Macedonia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MK' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MK' V_REGION_CD FROM DUAL
 UNION 
 SELECT '109' N_COUNTRY_SKEY,'ML' V_COUNTRY_ID,'Mali' V_COUNTRY_DESC,'Mali' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XOF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Mali' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'ML' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'ML' V_REGION_CD FROM DUAL
 UNION 
 SELECT '110' N_COUNTRY_SKEY,'IL' V_COUNTRY_ID,'Israel' V_COUNTRY_DESC,'Israel' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'ILS' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Israel' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'IL' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'IL' V_REGION_CD FROM DUAL
 UNION 
 SELECT '111' N_COUNTRY_SKEY,'MM' V_COUNTRY_ID,'Myanmar' V_COUNTRY_DESC,'Myanmar' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'MMK' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Myanmar' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MM' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MM' V_REGION_CD FROM DUAL
 UNION 
 SELECT '112' N_COUNTRY_SKEY,'IR' V_COUNTRY_ID,'Islamic Republic Of Iran' V_COUNTRY_DESC,'Islamic Republic Of Iran' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'IRR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Islamic Republic Of Iran' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'IR' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'IR' V_REGION_CD FROM DUAL
 UNION 
 SELECT '113' N_COUNTRY_SKEY,'SN' V_COUNTRY_ID,'Senegal' V_COUNTRY_DESC,'Senegal' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XOF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Senegal' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'SN' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'SN' V_REGION_CD FROM DUAL
 UNION 
 SELECT '114' N_COUNTRY_SKEY,'MN' V_COUNTRY_ID,'Mongolia' V_COUNTRY_DESC,'Mongolia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'MNT' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Mongolia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MN' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MN' V_REGION_CD FROM DUAL
 UNION 
 SELECT '115' N_COUNTRY_SKEY,'MO' V_COUNTRY_ID,'Macao' V_COUNTRY_DESC,'Macao' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'MOP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Macao' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MO' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MO' V_REGION_CD FROM DUAL
 UNION 
 SELECT '116' N_COUNTRY_SKEY,'MP' V_COUNTRY_ID,'Northern Mariana Islands' V_COUNTRY_DESC,'Northern Mariana Islands' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'USD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Northern Mariana Islands' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MP' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'US' V_REGION_CD FROM DUAL
 UNION 
 SELECT '117' N_COUNTRY_SKEY,'MQ' V_COUNTRY_ID,'Martinique' V_COUNTRY_DESC,'Martinique' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Martinique' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MQ' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MQ' V_REGION_CD FROM DUAL
 UNION 
 SELECT '118' N_COUNTRY_SKEY,'MR' V_COUNTRY_ID,'Mauritania' V_COUNTRY_DESC,'Mauritania' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'MRO' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Mauritania' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MR' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MR' V_REGION_CD FROM DUAL
 UNION 
 SELECT '119' N_COUNTRY_SKEY,'MS' V_COUNTRY_ID,'Montserrat' V_COUNTRY_DESC,'Montserrat' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XCD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Montserrat' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MS' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MS' V_REGION_CD FROM DUAL
 UNION 
 SELECT '120' N_COUNTRY_SKEY,'AW' V_COUNTRY_ID,'Aruba' V_COUNTRY_DESC,'Aruba' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'AWG' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Aruba' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'AW' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'AW' V_REGION_CD FROM DUAL
 UNION 
 SELECT '121' N_COUNTRY_SKEY,'MT' V_COUNTRY_ID,'Malta' V_COUNTRY_DESC,'Malta' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Malta' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MT' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'CBM' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MT' V_REGION_CD FROM DUAL
 UNION 
 SELECT '122' N_COUNTRY_SKEY,'MU' V_COUNTRY_ID,'Mauritius' V_COUNTRY_DESC,'Mauritius' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'MUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Mauritius' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MU' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MU' V_REGION_CD FROM DUAL
 UNION 
 SELECT '123' N_COUNTRY_SKEY,'IM' V_COUNTRY_ID,'Isle Of Man' V_COUNTRY_DESC,'Isle Of Man' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'IMP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Isle Of Man' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'IM' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'IM' V_REGION_CD FROM DUAL
 UNION 
 SELECT '124' N_COUNTRY_SKEY,'SO' V_COUNTRY_ID,'Somalia' V_COUNTRY_DESC,'Somalia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'SOS' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Somalia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'SO' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'SO' V_REGION_CD FROM DUAL
 UNION 
 SELECT '125' N_COUNTRY_SKEY,'MV' V_COUNTRY_ID,'Maldives' V_COUNTRY_DESC,'Maldives' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'MVR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Maldives' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MV' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MV' V_REGION_CD FROM DUAL
 UNION 
 SELECT '126' N_COUNTRY_SKEY,'MW' V_COUNTRY_ID,'Malawi' V_COUNTRY_DESC,'Malawi' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'MWK' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Malawi' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MW' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MW' V_REGION_CD FROM DUAL
 UNION 
 SELECT '127' N_COUNTRY_SKEY,'MX' V_COUNTRY_ID,'Mexico' V_COUNTRY_DESC,'Mexico' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'MXN' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Mexico' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MX' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MX' V_REGION_CD FROM DUAL
 UNION 
 SELECT '128' N_COUNTRY_SKEY,'MY' V_COUNTRY_ID,'Malaysia' V_COUNTRY_DESC,'Malaysia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'MYR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Malaysia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MY' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MY' V_REGION_CD FROM DUAL
 UNION 
 SELECT '129' N_COUNTRY_SKEY,'MZ' V_COUNTRY_ID,'Mozambique' V_COUNTRY_DESC,'Mozambique' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'MZM' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Mozambique' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'MZ' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'MZ' V_REGION_CD FROM DUAL
 UNION 
 SELECT '130' N_COUNTRY_SKEY,'NA' V_COUNTRY_ID,'Namibia' V_COUNTRY_DESC,'Namibia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'NAD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Namibia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'NA' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'NA' V_REGION_CD FROM DUAL
 UNION 
 SELECT '131' N_COUNTRY_SKEY,'NC' V_COUNTRY_ID,'New Caledonia' V_COUNTRY_DESC,'New Caledonia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XPF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'New Caledonia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'NC' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'NC' V_REGION_CD FROM DUAL
 UNION 
 SELECT '132' N_COUNTRY_SKEY,'NE' V_COUNTRY_ID,'Niger' V_COUNTRY_DESC,'Niger' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XOF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Niger' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'NE' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'NE' V_REGION_CD FROM DUAL
 UNION 
 SELECT '133' N_COUNTRY_SKEY,'AX' V_COUNTRY_ID,'Aland Islands' V_COUNTRY_DESC,'Aland Islands' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Aland Islands' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'AX' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'AX' V_REGION_CD FROM DUAL
 UNION 
 SELECT '134' N_COUNTRY_SKEY,'NF' V_COUNTRY_ID,'Norfolk Island' V_COUNTRY_DESC,'Norfolk Island' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'AUD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Norfolk Island' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'NF' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'NF' V_REGION_CD FROM DUAL
 UNION 
 SELECT '135' N_COUNTRY_SKEY,'SR' V_COUNTRY_ID,'Suriname' V_COUNTRY_DESC,'Suriname' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'SRG' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Suriname' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'SR' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'SR' V_REGION_CD FROM DUAL
 UNION 
 SELECT '136' N_COUNTRY_SKEY,'IN' V_COUNTRY_ID,'India' V_COUNTRY_DESC,'India' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'INR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'India' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'IN' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'IN' V_REGION_CD FROM DUAL
 UNION 
 SELECT '137' N_COUNTRY_SKEY,'NG' V_COUNTRY_ID,'Nigeria' V_COUNTRY_DESC,'Nigeria' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'NGN' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Nigeria' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'NG' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'NG' V_REGION_CD FROM DUAL
 UNION 
 SELECT '138' N_COUNTRY_SKEY,'NI' V_COUNTRY_ID,'Nicaragua' V_COUNTRY_DESC,'Nicaragua' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'NIC' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Nicaragua' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'NI' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'NI' V_REGION_CD FROM DUAL
 UNION 
 SELECT '139' N_COUNTRY_SKEY,'NL' V_COUNTRY_ID,'Netherlands' V_COUNTRY_DESC,'Netherlands' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Netherlands' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'NL' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'DNB' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'NL' V_REGION_CD FROM DUAL
 UNION 
 SELECT '140' N_COUNTRY_SKEY,'NO' V_COUNTRY_ID,'Norway' V_COUNTRY_DESC,'Norway' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'NOK' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Norway' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'NO' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'NB' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'NO' V_REGION_CD FROM DUAL
 UNION 
 SELECT '141' N_COUNTRY_SKEY,'NP' V_COUNTRY_ID,'Nepal' V_COUNTRY_DESC,'Nepal' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'NPR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Nepal' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'NP' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'NP' V_REGION_CD FROM DUAL
 UNION 
 SELECT '142' N_COUNTRY_SKEY,'NR' V_COUNTRY_ID,'Nauru' V_COUNTRY_DESC,'Nauru' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'AUD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Nauru' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'NR' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'NR' V_REGION_CD FROM DUAL
 UNION 
 SELECT '143' N_COUNTRY_SKEY,'NU' V_COUNTRY_ID,'Niue' V_COUNTRY_DESC,'Niue' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'NZD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Niue' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'NU' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'NU' V_REGION_CD FROM DUAL
 UNION 
 SELECT '144' N_COUNTRY_SKEY,'NZ' V_COUNTRY_ID,'New Zealand' V_COUNTRY_DESC,'New Zealand' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'NZD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'New Zealand' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'NZ' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'NZ' V_REGION_CD FROM DUAL
 UNION 
 SELECT '145' N_COUNTRY_SKEY,'OM' V_COUNTRY_ID,'Oman' V_COUNTRY_DESC,'Oman' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'OMR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Oman' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'OM' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'OM' V_REGION_CD FROM DUAL
 UNION 
 SELECT '146' N_COUNTRY_SKEY,'ST' V_COUNTRY_ID,'Soi Tomi And Principe' V_COUNTRY_DESC,'Soi Tomi And Principe' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'STD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Soi Tomi And Principe' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'ST' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'ST' V_REGION_CD FROM DUAL
 UNION 
 SELECT '147' N_COUNTRY_SKEY,'AZ' V_COUNTRY_ID,'Azerbaijan' V_COUNTRY_DESC,'Azerbaijan' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'AZN' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Azerbaijan' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'AZ' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'AZ' V_REGION_CD FROM DUAL
 UNION 
 SELECT '148' N_COUNTRY_SKEY,'IO' V_COUNTRY_ID,'British Indian Ocean Territory' V_COUNTRY_DESC,'British Indian Ocean Territory' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'SCR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'British Indian Ocean Territory' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'IO' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'IO' V_REGION_CD FROM DUAL
 UNION 
 SELECT '149' N_COUNTRY_SKEY,'PA' V_COUNTRY_ID,'Panama' V_COUNTRY_DESC,'Panama' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'PAB' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Panama' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'PA' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'PA' V_REGION_CD FROM DUAL
 UNION 
 SELECT '150' N_COUNTRY_SKEY,'PE' V_COUNTRY_ID,'Peru' V_COUNTRY_DESC,'Peru' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'PEN' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Peru' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'PE' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'PE' V_REGION_CD FROM DUAL
 UNION 
 SELECT '151' N_COUNTRY_SKEY,'PF' V_COUNTRY_ID,'Polynesia' V_COUNTRY_DESC,'Polynesia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XPF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Polynesia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'PF' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'PF' V_REGION_CD FROM DUAL
 UNION 
 SELECT '152' N_COUNTRY_SKEY,'PG' V_COUNTRY_ID,'Papua New Guinea' V_COUNTRY_DESC,'Papua New Guinea' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'PGK' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Papua New Guinea' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'PG' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'PG' V_REGION_CD FROM DUAL
 UNION 
 SELECT '153' N_COUNTRY_SKEY,'PH' V_COUNTRY_ID,'Philippines' V_COUNTRY_DESC,'Philippines' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'PHP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Philippines' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'PH' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'PH' V_REGION_CD FROM DUAL
 UNION 
 SELECT '154' N_COUNTRY_SKEY,'PK' V_COUNTRY_ID,'Pakistan' V_COUNTRY_DESC,'Pakistan' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'PKR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Pakistan' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'PK' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'PK' V_REGION_CD FROM DUAL
 UNION 
 SELECT '155' N_COUNTRY_SKEY,'PL' V_COUNTRY_ID,'Poland' V_COUNTRY_DESC,'Poland' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'PLN' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Poland' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'PL' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'NBP' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'PL' V_REGION_CD FROM DUAL
 UNION 
 SELECT '156' N_COUNTRY_SKEY,'PM' V_COUNTRY_ID,'St Pierre And Miquelon' V_COUNTRY_DESC,'St Pierre And Miquelon' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'St Pierre And Miquelon' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'PM' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'PM' V_REGION_CD FROM DUAL
 UNION 
 SELECT '157' N_COUNTRY_SKEY,'IT' V_COUNTRY_ID,'Italy' V_COUNTRY_DESC,'Italy' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Italy' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'IT' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'BOI' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'IT' V_REGION_CD FROM DUAL
 UNION 
 SELECT '158' N_COUNTRY_SKEY,'PN' V_COUNTRY_ID,'Pitcairn Island' V_COUNTRY_DESC,'Pitcairn Island' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'NZD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Pitcairn Island' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'PN' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'PN' V_REGION_CD FROM DUAL
 UNION 
 SELECT '159' N_COUNTRY_SKEY,'PR' V_COUNTRY_ID,'Puerto Rico' V_COUNTRY_DESC,'Puerto Rico' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'USD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Puerto Rico' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'PR' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'US' V_REGION_CD FROM DUAL
 UNION 
 SELECT '160' N_COUNTRY_SKEY,'IQ' V_COUNTRY_ID,'Iraq' V_COUNTRY_DESC,'Iraq' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'IQD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Iraq' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'IQ' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'IQ' V_REGION_CD FROM DUAL
 UNION 
 SELECT '161' N_COUNTRY_SKEY,'BA' V_COUNTRY_ID,'Bosnia' V_COUNTRY_DESC,'Bosnia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'BAM' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Bosnia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BA' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BA' V_REGION_CD FROM DUAL
 UNION 
 SELECT '162' N_COUNTRY_SKEY,'PS' V_COUNTRY_ID,'Palestine' V_COUNTRY_DESC,'Palestine' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EGP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Palestine' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'PS' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'PS' V_REGION_CD FROM DUAL
 UNION 
 SELECT '163' N_COUNTRY_SKEY,'PT' V_COUNTRY_ID,'Portugal' V_COUNTRY_DESC,'Portugal' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Portugal' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'PT' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'BDP' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'PT' V_REGION_CD FROM DUAL
 UNION 
 SELECT '164' N_COUNTRY_SKEY,'PW' V_COUNTRY_ID,'Palau' V_COUNTRY_DESC,'Palau' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'USD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Palau' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'PW' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'PW' V_REGION_CD FROM DUAL
 UNION 
 SELECT '165' N_COUNTRY_SKEY,'PY' V_COUNTRY_ID,'Paraguay' V_COUNTRY_DESC,'Paraguay' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'PYG' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Paraguay' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'PY' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'PY' V_REGION_CD FROM DUAL
 UNION 
 SELECT '166' N_COUNTRY_SKEY,'QA' V_COUNTRY_ID,'Qatar' V_COUNTRY_DESC,'Qatar' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'QAR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Qatar' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'QA' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'QA' V_REGION_CD FROM DUAL
 UNION 
 SELECT '167' N_COUNTRY_SKEY,'RE' V_COUNTRY_ID,'Reunion' V_COUNTRY_DESC,'Reunion' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Reunion' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'RE' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'RE' V_REGION_CD FROM DUAL
 UNION 
 SELECT '168' N_COUNTRY_SKEY,'SV' V_COUNTRY_ID,'El Salvador' V_COUNTRY_DESC,'El Salvador' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'USD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'El Salvador' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'SV' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'SV' V_REGION_CD FROM DUAL
 UNION 
 SELECT '169' N_COUNTRY_SKEY,'RO' V_COUNTRY_ID,'Romania' V_COUNTRY_DESC,'Romania' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'ROL' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Romania' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'RO' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'NBR' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'RO' V_REGION_CD FROM DUAL
 UNION 
 SELECT '170' N_COUNTRY_SKEY,'RS' V_COUNTRY_ID,'Serbia' V_COUNTRY_DESC,'Serbia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'RSD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Serbia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'RS' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'RS' V_REGION_CD FROM DUAL
 UNION 
 SELECT '171' N_COUNTRY_SKEY,'RU' V_COUNTRY_ID,'Russian Federation' V_COUNTRY_DESC,'Russian Federation' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'RUB' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Russian Federation' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'RU' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'RU' V_REGION_CD FROM DUAL
 UNION 
 SELECT '172' N_COUNTRY_SKEY,'SY' V_COUNTRY_ID,'Syrian Arab Republic' V_COUNTRY_DESC,'Syrian Arab Republic' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'SYP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Syrian Arab Republic' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'SY' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'SY' V_REGION_CD FROM DUAL
 UNION 
 SELECT '173' N_COUNTRY_SKEY,'SZ' V_COUNTRY_ID,'Swaziland' V_COUNTRY_DESC,'Swaziland' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'SZL' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Swaziland' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'SZ' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'SZ' V_REGION_CD FROM DUAL
 UNION 
 SELECT '174' N_COUNTRY_SKEY,'TC' V_COUNTRY_ID,'Turks And Caicos Islands' V_COUNTRY_DESC,'Turks And Caicos Islands' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'USD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Turks And Caicos Islands' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'TC' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'TC' V_REGION_CD FROM DUAL
 UNION 
 SELECT '175' N_COUNTRY_SKEY,'BE' V_COUNTRY_ID,'Belgium' V_COUNTRY_DESC,'Belgium' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Belgium' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BE' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'NBB' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BE' V_REGION_CD FROM DUAL
 UNION 
 SELECT '176' N_COUNTRY_SKEY,'RW' V_COUNTRY_ID,'Rwanda' V_COUNTRY_DESC,'Rwanda' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'RWF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Rwanda' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'RW' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'RW' V_REGION_CD FROM DUAL
 UNION 
 SELECT '177' N_COUNTRY_SKEY,'TD' V_COUNTRY_ID,'Chad' V_COUNTRY_DESC,'Chad' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XAF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Chad' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'TD' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'TD' V_REGION_CD FROM DUAL
 UNION 
 SELECT '178' N_COUNTRY_SKEY,'TF' V_COUNTRY_ID,'French Southern Territories' V_COUNTRY_DESC,'French Southern Territories' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'French Southern Territories' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'TF' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'TF' V_REGION_CD FROM DUAL
 UNION 
 SELECT '179' N_COUNTRY_SKEY,'TG' V_COUNTRY_ID,'Togo' V_COUNTRY_DESC,'Togo' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XOF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Togo' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'TG' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'TG' V_REGION_CD FROM DUAL
 UNION 
 SELECT '180' N_COUNTRY_SKEY,'TH' V_COUNTRY_ID,'Thailand' V_COUNTRY_DESC,'Thailand' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'THB' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Thailand' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'TH' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'TH' V_REGION_CD FROM DUAL
 UNION 
 SELECT '181' N_COUNTRY_SKEY,'TJ' V_COUNTRY_ID,'Tajikistan' V_COUNTRY_DESC,'Tajikistan' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'TJS' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Tajikistan' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'TJ' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'TJ' V_REGION_CD FROM DUAL
 UNION 
 SELECT '182' N_COUNTRY_SKEY,'AR' V_COUNTRY_ID,'Argentina' V_COUNTRY_DESC,'Argentina' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'ARS' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Argentina' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'AR' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'AR' V_REGION_CD FROM DUAL
 UNION 
 SELECT '183' N_COUNTRY_SKEY,'TK' V_COUNTRY_ID,'Tokelau' V_COUNTRY_DESC,'Tokelau' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'NZD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Tokelau' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'TK' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'TK' V_REGION_CD FROM DUAL
 UNION 
 SELECT '184' N_COUNTRY_SKEY,'TL' V_COUNTRY_ID,'Timor-Leste' V_COUNTRY_DESC,'Timor-Leste' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'TPE' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Timor-Leste' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'TL' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'TL' V_REGION_CD FROM DUAL
 UNION 
 SELECT '185' N_COUNTRY_SKEY,'TM' V_COUNTRY_ID,'Turkmenistan' V_COUNTRY_DESC,'Turkmenistan' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'TMM' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Turkmenistan' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'TM' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'TM' V_REGION_CD FROM DUAL
 UNION 
 SELECT '186' N_COUNTRY_SKEY,'TN' V_COUNTRY_ID,'Tunisia' V_COUNTRY_DESC,'Tunisia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'TND' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Tunisia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'TN' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'TN' V_REGION_CD FROM DUAL
 UNION 
 SELECT '187' N_COUNTRY_SKEY,'BB' V_COUNTRY_ID,'Barbados' V_COUNTRY_DESC,'Barbados' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'BBD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Barbados' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BB' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BB' V_REGION_CD FROM DUAL
 UNION 
 SELECT '188' N_COUNTRY_SKEY,'TO' V_COUNTRY_ID,'Tonga' V_COUNTRY_DESC,'Tonga' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'TOP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Tonga' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'TO' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'TO' V_REGION_CD FROM DUAL
 UNION 
 SELECT '189' N_COUNTRY_SKEY,'BF' V_COUNTRY_ID,'Burkina Faso' V_COUNTRY_DESC,'Burkina Faso' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XOF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Burkina Faso' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BF' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BF' V_REGION_CD FROM DUAL
 UNION 
 SELECT '190' N_COUNTRY_SKEY,'TR' V_COUNTRY_ID,'Turkey' V_COUNTRY_DESC,'Turkey' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'TRY' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Turkey' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'TR' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'TR' V_REGION_CD FROM DUAL
 UNION 
 SELECT '191' N_COUNTRY_SKEY,'TT' V_COUNTRY_ID,'Trinidad And Tobago' V_COUNTRY_DESC,'Trinidad And Tobago' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'TTD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Trinidad And Tobago' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'TT' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'TT' V_REGION_CD FROM DUAL
 UNION 
 SELECT '192' N_COUNTRY_SKEY,'TV' V_COUNTRY_ID,'Tuvalu' V_COUNTRY_DESC,'Tuvalu' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'AUD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Tuvalu' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'TV' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'TV' V_REGION_CD FROM DUAL
 UNION 
 SELECT '193' N_COUNTRY_SKEY,'TW' V_COUNTRY_ID,'Taiwan' V_COUNTRY_DESC,'Taiwan' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'TWD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Taiwan' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'TW' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'TW' V_REGION_CD FROM DUAL
 UNION 
 SELECT '194' N_COUNTRY_SKEY,'JM' V_COUNTRY_ID,'Jamaica' V_COUNTRY_DESC,'Jamaica' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'JMD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Jamaica' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'JM' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'JM' V_REGION_CD FROM DUAL
 UNION 
 SELECT '195' N_COUNTRY_SKEY,'TZ' V_COUNTRY_ID,'United Republic Of Tanzania' V_COUNTRY_DESC,'United Republic Of Tanzania' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'TZS' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'United Republic Of Tanzania' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'TZ' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'TZ' V_REGION_CD FROM DUAL
 UNION 
 SELECT '196' N_COUNTRY_SKEY,'UA' V_COUNTRY_ID,'Ukraine' V_COUNTRY_DESC,'Ukraine' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'UAH' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Ukraine' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'UA' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'UA' V_REGION_CD FROM DUAL
 UNION 
 SELECT '197' N_COUNTRY_SKEY,'UG' V_COUNTRY_ID,'Uganda' V_COUNTRY_DESC,'Uganda' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'UGS' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Uganda' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'UG' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'UG' V_REGION_CD FROM DUAL
 UNION 
 SELECT '198' N_COUNTRY_SKEY,'SA' V_COUNTRY_ID,'Saudi Arabia' V_COUNTRY_DESC,'Saudi Arabia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'SAR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Saudi Arabia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'SA' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'SA' V_REGION_CD FROM DUAL
 UNION 
 SELECT '199' N_COUNTRY_SKEY,'UM' V_COUNTRY_ID,'United States Minor Outlying Islands' V_COUNTRY_DESC,'United States Minor Outlying Islands' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'USD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'United States Minor Outlying Islands' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'UM' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'UM' V_REGION_CD FROM DUAL
 UNION 
 SELECT '200' N_COUNTRY_SKEY,'US' V_COUNTRY_ID,'United States Of America' V_COUNTRY_DESC,'United States Of America' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'USD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'United States Of America' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'US' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'US' V_REGION_CD FROM DUAL
 UNION 
 SELECT '201' N_COUNTRY_SKEY,'UY' V_COUNTRY_ID,'Uruguay' V_COUNTRY_DESC,'Uruguay' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'UYU' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Uruguay' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'UY' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'UY' V_REGION_CD FROM DUAL
 UNION 
 SELECT '202' N_COUNTRY_SKEY,'BG' V_COUNTRY_ID,'Bulgaria' V_COUNTRY_DESC,'Bulgaria' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'BGL' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Bulgaria' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BG' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'BNB' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BG' V_REGION_CD FROM DUAL
 UNION 
 SELECT '203' N_COUNTRY_SKEY,'UZ' V_COUNTRY_ID,'Uzbekistan' V_COUNTRY_DESC,'Uzbekistan' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'UZS' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Uzbekistan' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'UZ' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'UZ' V_REGION_CD FROM DUAL
 UNION 
 SELECT '204' N_COUNTRY_SKEY,'VA' V_COUNTRY_ID,'Vatican City State' V_COUNTRY_DESC,'Vatican City State' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Vatican City State' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'VA' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'VA' V_REGION_CD FROM DUAL
 UNION 
 SELECT '205' N_COUNTRY_SKEY,'VC' V_COUNTRY_ID,'Saint Vincent' V_COUNTRY_DESC,'Saint Vincent' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XCD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Saint Vincent' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'VC' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'VC' V_REGION_CD FROM DUAL
 UNION 
 SELECT '206' N_COUNTRY_SKEY,'JO' V_COUNTRY_ID,'Jordan' V_COUNTRY_DESC,'Jordan' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'JOD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Jordan' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'JO' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'JO' V_REGION_CD FROM DUAL
 UNION 
 SELECT '207' N_COUNTRY_SKEY,'VE' V_COUNTRY_ID,'Venezuela' V_COUNTRY_DESC,'Venezuela' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'VEF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Venezuela' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'VE' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'VE' V_REGION_CD FROM DUAL
 UNION 
 SELECT '208' N_COUNTRY_SKEY,'VG' V_COUNTRY_ID,'Virgin Islands' V_COUNTRY_DESC,'Virgin Islands' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'USD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Virgin Islands' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'VG' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'VG' V_REGION_CD FROM DUAL
 UNION 
 SELECT '209' N_COUNTRY_SKEY,'SB' V_COUNTRY_ID,'Solomon Islands' V_COUNTRY_DESC,'Solomon Islands' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'SBD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Solomon Islands' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'SB' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'SB' V_REGION_CD FROM DUAL
 UNION 
 SELECT '210' N_COUNTRY_SKEY,'VI' V_COUNTRY_ID,'Us Virgin Islands' V_COUNTRY_DESC,'Us Virgin Islands' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'USD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Us Virgin Islands' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'VI' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'US' V_REGION_CD FROM DUAL
 UNION 
 SELECT '211' N_COUNTRY_SKEY,'VN' V_COUNTRY_ID,'Viet Nam' V_COUNTRY_DESC,'Viet Nam' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'VND' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Viet Nam' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'VN' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'VN' V_REGION_CD FROM DUAL
 UNION 
 SELECT '212' N_COUNTRY_SKEY,'VU' V_COUNTRY_ID,'Vanautu' V_COUNTRY_DESC,'Vanautu' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'VUV' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Vanautu' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'VU' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'VU' V_REGION_CD FROM DUAL
 UNION 
 SELECT '213' N_COUNTRY_SKEY,'WF' V_COUNTRY_ID,'Wf Islands' V_COUNTRY_DESC,'Wf Islands' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XPF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Wf Islands' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'WF' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'WF' V_REGION_CD FROM DUAL
 UNION 
 SELECT '214' N_COUNTRY_SKEY,'WS' V_COUNTRY_ID,'Samoa' V_COUNTRY_DESC,'Samoa' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'WST' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Samoa' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'WS' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'WS' V_REGION_CD FROM DUAL
 UNION 
 SELECT '215' N_COUNTRY_SKEY,'BH' V_COUNTRY_ID,'Bahrain' V_COUNTRY_DESC,'Bahrain' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'BHD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Bahrain' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BH' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BH' V_REGION_CD FROM DUAL
 UNION 
 SELECT '216' N_COUNTRY_SKEY,'YE' V_COUNTRY_ID,'Yemen' V_COUNTRY_DESC,'Yemen' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'YER' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Yemen' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'YE' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'YE' V_REGION_CD FROM DUAL
 UNION 
 SELECT '217' N_COUNTRY_SKEY,'YT' V_COUNTRY_ID,'Mayotte' V_COUNTRY_DESC,'Mayotte' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'EUR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Mayotte' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'YT' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'YT' V_REGION_CD FROM DUAL
 UNION 
 SELECT '218' N_COUNTRY_SKEY,'JP' V_COUNTRY_ID,'Japan' V_COUNTRY_DESC,'Japan' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'JPY' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Japan' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'JP' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'JP' V_REGION_CD FROM DUAL
 UNION 
 SELECT '219' N_COUNTRY_SKEY,'ZA' V_COUNTRY_ID,'South Africa' V_COUNTRY_DESC,'South Africa' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'ZAR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'South Africa' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'ZA' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'ZA' V_REGION_CD FROM DUAL
 UNION 
 SELECT '220' N_COUNTRY_SKEY,'SC' V_COUNTRY_ID,'Seychelles' V_COUNTRY_DESC,'Seychelles' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'SCR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Seychelles' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'SC' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'SC' V_REGION_CD FROM DUAL
 UNION 
 SELECT '221' N_COUNTRY_SKEY,'ZM' V_COUNTRY_ID,'Zambia' V_COUNTRY_DESC,'Zambia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'ZWD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Zambia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'ZM' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'ZM' V_REGION_CD FROM DUAL
 UNION 
 SELECT '222' N_COUNTRY_SKEY,'ZW' V_COUNTRY_ID,'Zimbabwe' V_COUNTRY_DESC,'Zimbabwe' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'USD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Zimbabwe' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'ZW' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'ZW' V_REGION_CD FROM DUAL
 UNION 
 SELECT '223' N_COUNTRY_SKEY,'BI' V_COUNTRY_ID,'Burundi' V_COUNTRY_DESC,'Burundi' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'BIF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Burundi' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BI' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BI' V_REGION_CD FROM DUAL
 UNION 
 SELECT '224' N_COUNTRY_SKEY,'BJ' V_COUNTRY_ID,'Benin' V_COUNTRY_DESC,'Benin' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XOF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Benin' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BJ' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BJ' V_REGION_CD FROM DUAL
 UNION 
 SELECT '225' N_COUNTRY_SKEY,'BM' V_COUNTRY_ID,'Bermuda' V_COUNTRY_DESC,'Bermuda' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'BMD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Bermuda' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BM' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BM' V_REGION_CD FROM DUAL
 UNION 
 SELECT '226' N_COUNTRY_SKEY,'BN' V_COUNTRY_ID,'Brunei Darussalam' V_COUNTRY_DESC,'Brunei Darussalam' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'BND' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Brunei Darussalam' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BN' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BN' V_REGION_CD FROM DUAL
 UNION 
 SELECT '227' N_COUNTRY_SKEY,'BO' V_COUNTRY_ID,'Bolivia' V_COUNTRY_DESC,'Bolivia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'BOB' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Bolivia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BO' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BO' V_REGION_CD FROM DUAL
 UNION 
 SELECT '228' N_COUNTRY_SKEY,'AF' V_COUNTRY_ID,'Afghanistan' V_COUNTRY_DESC,'Afghanistan' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'AFA' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Afghanistan' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'AF' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'AF' V_REGION_CD FROM DUAL
 UNION 
 SELECT '229' N_COUNTRY_SKEY,'BR' V_COUNTRY_ID,'Brazil' V_COUNTRY_DESC,'Brazil' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'BRL' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Brazil' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BR' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BR' V_REGION_CD FROM DUAL
 UNION 
 SELECT '230' N_COUNTRY_SKEY,'KE' V_COUNTRY_ID,'Kenya' V_COUNTRY_DESC,'Kenya' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'KES' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Kenya' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'KE' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'KE' V_REGION_CD FROM DUAL
 UNION 
 SELECT '231' N_COUNTRY_SKEY,'SD' V_COUNTRY_ID,'Sudan' V_COUNTRY_DESC,'Sudan' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'SDG' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Sudan' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'SD' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'SD' V_REGION_CD FROM DUAL
 UNION 
 SELECT '232' N_COUNTRY_SKEY,'BS' V_COUNTRY_ID,'Bahamas' V_COUNTRY_DESC,'Bahamas' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'BSD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Bahamas' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BS' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BS' V_REGION_CD FROM DUAL
 UNION 
 SELECT '233' N_COUNTRY_SKEY,'BT' V_COUNTRY_ID,'Bhutan' V_COUNTRY_DESC,'Bhutan' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'BTN' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Bhutan' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BT' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BT' V_REGION_CD FROM DUAL
 UNION 
 SELECT '234' N_COUNTRY_SKEY,'BV' V_COUNTRY_ID,'Bouvet Island' V_COUNTRY_DESC,'Bouvet Island' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'NOK' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Bouvet Island' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BV' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BV' V_REGION_CD FROM DUAL
 UNION 
 SELECT '235' N_COUNTRY_SKEY,'BW' V_COUNTRY_ID,'Botswana' V_COUNTRY_DESC,'Botswana' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'BWP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Botswana' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BW' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BW' V_REGION_CD FROM DUAL
 UNION 
 SELECT '236' N_COUNTRY_SKEY,'BY' V_COUNTRY_ID,'Belarus' V_COUNTRY_DESC,'Belarus' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'BYR' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Belarus' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BY' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BY' V_REGION_CD FROM DUAL
 UNION 
 SELECT '237' N_COUNTRY_SKEY,'BZ' V_COUNTRY_ID,'Belize' V_COUNTRY_DESC,'Belize' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'BZD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Belize' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'BZ' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'BZ' V_REGION_CD FROM DUAL
 UNION 
 SELECT '238' N_COUNTRY_SKEY,'CA' V_COUNTRY_ID,'Canada' V_COUNTRY_DESC,'Canada' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'CAD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Canada' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'CA' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'CA' V_REGION_CD FROM DUAL
 UNION 
 SELECT '239' N_COUNTRY_SKEY,'CC' V_COUNTRY_ID,'Cocos (Keeling) Islands' V_COUNTRY_DESC,'Cocos (Keeling) Islands' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'AUD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Cocos (Keeling) Islands' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'CC' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'CC' V_REGION_CD FROM DUAL
 UNION 
 SELECT '240' N_COUNTRY_SKEY,'CD' V_COUNTRY_ID,'Congo Demo' V_COUNTRY_DESC,'Congo Demo' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'CDF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Congo Demo' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'CD' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'CD' V_REGION_CD FROM DUAL
 UNION 
 SELECT '241' N_COUNTRY_SKEY,'AG' V_COUNTRY_ID,'Antigua' V_COUNTRY_DESC,'Antigua' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XCD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Antigua' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'AG' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'AG' V_REGION_CD FROM DUAL
 UNION 
 SELECT '242' N_COUNTRY_SKEY,'SE' V_COUNTRY_ID,'Sweden' V_COUNTRY_DESC,'Sweden' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'SEK' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Sweden' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'SE' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'Y' F_EU_MEMBER_STATE_FLAG,'SRB' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'SE' V_REGION_CD FROM DUAL
 UNION 
 SELECT '243' N_COUNTRY_SKEY,'KG' V_COUNTRY_ID,'Kyrgyzstan' V_COUNTRY_DESC,'Kyrgyzstan' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'KGS' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Kyrgyzstan' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'KG' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'KG' V_REGION_CD FROM DUAL
 UNION 
 SELECT '244' N_COUNTRY_SKEY,'CF' V_COUNTRY_ID,'African Republic' V_COUNTRY_DESC,'African Republic' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XAF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'African Republic' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'CF' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'CF' V_REGION_CD FROM DUAL
 UNION 
 SELECT '245' N_COUNTRY_SKEY,'CG' V_COUNTRY_ID,'Congo, Repub' V_COUNTRY_DESC,'Congo, Repub' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XAF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Congo, Repub' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'CG' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'CG' V_REGION_CD FROM DUAL
 UNION 
 SELECT '246' N_COUNTRY_SKEY,'CH' V_COUNTRY_ID,'Switzerland' V_COUNTRY_DESC,'Switzerland' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'CHF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Switzerland' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'CH' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'Y' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'SNB' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'CH' V_REGION_CD FROM DUAL
 UNION 
 SELECT '247' N_COUNTRY_SKEY,'CI' V_COUNTRY_ID,'Cote D''ivoire' V_COUNTRY_DESC,'Cote D''ivoire' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XOF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Cote D''ivoire' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'CI' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'CI' V_REGION_CD FROM DUAL
 UNION 
 SELECT '248' N_COUNTRY_SKEY,'CK' V_COUNTRY_ID,'Cook Islands' V_COUNTRY_DESC,'Cook Islands' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'NZD' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Cook Islands' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'CK' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'CK' V_REGION_CD FROM DUAL
 UNION 
 SELECT '249' N_COUNTRY_SKEY,'CL' V_COUNTRY_ID,'Chile' V_COUNTRY_DESC,'Chile' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'CLF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Chile' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'CL' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'Y' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'CL' V_REGION_CD FROM DUAL
 UNION 
 SELECT '250' N_COUNTRY_SKEY,'CM' V_COUNTRY_ID,'Cameroon' V_COUNTRY_DESC,'Cameroon' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'XAF' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Cameroon' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'CM' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'CM' V_REGION_CD FROM DUAL
 UNION 
 SELECT '251' N_COUNTRY_SKEY,'CN' V_COUNTRY_ID,'China' V_COUNTRY_DESC,'China' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'CNY' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'China' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'CN' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'CN' V_REGION_CD FROM DUAL
 UNION 
 SELECT '252' N_COUNTRY_SKEY,'CO' V_COUNTRY_ID,'Colombia' V_COUNTRY_DESC,'Colombia' V_COUNTRY_LONG_DESC,'' V_CLS_WTCHD_FACTOR,'COP' V_CURRENCY_CODE,'' N_COUNTRY_RISK_FACTOR,to_date('01-01-1900','dd-mm-yyyy') FIC_MIS_DATE,to_date('01-01-1900','dd-mm-yyyy') D_RECORD_START_DATE,to_date('31-12-9999','dd-mm-yyyy') D_RECORD_END_DATE,'Y' F_LATEST_RECORD_INDICATOR,'' N_ALPHA_VALUE,'' V_PROV_STATE_DESC,'' V_PROV_STATE_ID,'' V_RATING_ID,'Colombia' V_COUNTRY_NAME,'' F_OECD_INDICATOR,'' F_DEFAULT_FLAG,'CO' V_ISO_COUNTRY_CD,'' N_REGION_SKEY,'' F_EU_APPROVED_THIRD_COUNTRY,'' F_EEA_COUNTRY_FLAG,'' F_EU_MEMBER_STATE_FLAG,'' V_STD_CENTRAL_BANK_CD,'' V_CONTINENT_CODE,'' V_ADVANCE_ECONOMY_IND,'CO' V_REGION_CD FROM DUAL
 ) S
ON (T.V_COUNTRY_ID = S.V_COUNTRY_ID)
WHEN MATCHED THEN 
 UPDATE 
 SET T.V_COUNTRY_DESC = S.V_COUNTRY_DESC,
     T.V_COUNTRY_LONG_DESC = S.V_COUNTRY_LONG_DESC,
     T.V_CLS_WTCHD_FACTOR = S.V_CLS_WTCHD_FACTOR,
     T.V_CURRENCY_CODE = S.V_CURRENCY_CODE,
     T.N_COUNTRY_RISK_FACTOR = S.N_COUNTRY_RISK_FACTOR,
     T.FIC_MIS_DATE = S.FIC_MIS_DATE,
     T.D_RECORD_START_DATE = S.D_RECORD_START_DATE,
     T.D_RECORD_END_DATE = S.D_RECORD_END_DATE,
     T.F_LATEST_RECORD_INDICATOR = S.F_LATEST_RECORD_INDICATOR,
     T.N_ALPHA_VALUE = S.N_ALPHA_VALUE,
     T.V_PROV_STATE_DESC = S.V_PROV_STATE_DESC,
     T.V_PROV_STATE_ID = S.V_PROV_STATE_ID,
     T.V_RATING_ID = S.V_RATING_ID,
     T.V_COUNTRY_NAME = S.V_COUNTRY_NAME,
     T.F_OECD_INDICATOR = S.F_OECD_INDICATOR,
     T.F_DEFAULT_FLAG = S.F_DEFAULT_FLAG,
     T.V_ISO_COUNTRY_CD = S.V_ISO_COUNTRY_CD,
     T.N_REGION_SKEY = S.N_REGION_SKEY,
     T.F_EU_APPROVED_THIRD_COUNTRY = S.F_EU_APPROVED_THIRD_COUNTRY,
     T.F_EEA_COUNTRY_FLAG = S.F_EEA_COUNTRY_FLAG,
     T.F_EU_MEMBER_STATE_FLAG = S.F_EU_MEMBER_STATE_FLAG,
     T.V_STD_CENTRAL_BANK_CD = S.V_STD_CENTRAL_BANK_CD,
     T.V_CONTINENT_CODE = S.V_CONTINENT_CODE,
     T.V_ADVANCE_ECONOMY_IND = S.V_ADVANCE_ECONOMY_IND,
     T.V_REGION_CD = S.V_REGION_CD
WHEN NOT MATCHED THEN 
 INSERT 
  (N_COUNTRY_SKEY,V_COUNTRY_ID,V_COUNTRY_DESC,V_COUNTRY_LONG_DESC,V_CLS_WTCHD_FACTOR,V_CURRENCY_CODE,N_COUNTRY_RISK_FACTOR,FIC_MIS_DATE,D_RECORD_START_DATE,D_RECORD_END_DATE,F_LATEST_RECORD_INDICATOR,N_ALPHA_VALUE,V_PROV_STATE_DESC,V_PROV_STATE_ID,V_RATING_ID,V_COUNTRY_NAME,F_OECD_INDICATOR,F_DEFAULT_FLAG,V_ISO_COUNTRY_CD,N_REGION_SKEY,F_EU_APPROVED_THIRD_COUNTRY,F_EEA_COUNTRY_FLAG,F_EU_MEMBER_STATE_FLAG,V_STD_CENTRAL_BANK_CD,V_CONTINENT_CODE,V_ADVANCE_ECONOMY_IND,V_REGION_CD)
 VALUES
  (FSI_CALL_SEQUENCE('SEQ_DIM_COUNTRY'),S.V_COUNTRY_ID,S.V_COUNTRY_DESC,S.V_COUNTRY_LONG_DESC,S.V_CLS_WTCHD_FACTOR,S.V_CURRENCY_CODE,S.N_COUNTRY_RISK_FACTOR,S.FIC_MIS_DATE,S.D_RECORD_START_DATE,S.D_RECORD_END_DATE,S.F_LATEST_RECORD_INDICATOR,S.N_ALPHA_VALUE,S.V_PROV_STATE_DESC,S.V_PROV_STATE_ID,S.V_RATING_ID,S.V_COUNTRY_NAME,S.F_OECD_INDICATOR,S.F_DEFAULT_FLAG,S.V_ISO_COUNTRY_CD,S.N_REGION_SKEY,S.F_EU_APPROVED_THIRD_COUNTRY,S.F_EEA_COUNTRY_FLAG,S.F_EU_MEMBER_STATE_FLAG,S.V_STD_CENTRAL_BANK_CD,S.V_CONTINENT_CODE,S.V_ADVANCE_ECONOMY_IND,S.V_REGION_CD )
/