MCC Country Selection Indicators For FY14

CREATE TABLE business_start_up_indicator_calculation_details_for_fy14 (
  "busstartupcountrycode" VARCHAR,
  "n__busstartupyear" BIGINT  -- BusStartUpYear,
  "n__busstartupinccat" VARCHAR  -- BusStartUpIncCat,
  "n__busstartupdatadays" VARCHAR  -- BusStartUpDataDays,
  "n__busstartupdaysmin" DOUBLE  -- BusStartUpDaysMin,
  "n__busstartupdaysmax" DOUBLE  -- BusStartUpDaysMax,
  "n__busstartupdaysnormal" VARCHAR  -- BusStartUpDaysNormal,
  "n__busstartupdatacost" VARCHAR  -- BusStartUpDataCost,
  "n__busstartupcostmin" DOUBLE  -- BusStartUpCostMin,
  "n__busstartupcostmax" DOUBLE  -- BusStartUpCostMax,
  "n__busstartupcostnormal" VARCHAR  -- BusStartUpCostNormal,
  "n__busstartupagg" VARCHAR  -- BusStartUpAgg,
  "n__busstartupdisplay" VARCHAR  -- BusStartupDisplay,
  "n__busstartupmedianvalue" VARCHAR  -- BusStartUpMedianValue,
  "n__busstartupprvalue" VARCHAR  -- BusStartUpPRValue
);

CREATE TABLE child_health_indicator_calculation_details_for_fy14 (
  "chcountrycode" VARCHAR,
  "n__chyear" BIGINT  -- CHYear,
  "n__chinccat" VARCHAR  -- CHIncCat,
  "n__chdata" VARCHAR  -- CHData,
  "n__chdisplay" VARCHAR  -- CHDisplay,
  "n__chmedianvalue" VARCHAR  -- CHMedianValue,
  "n__chprvalue" VARCHAR  -- CHPRValue
);

CREATE TABLE civil_liberties_indicator_calculation_details_for_fy14 (
  "civlibcountrycode" VARCHAR,
  "n__civlibyear" BIGINT  -- CivlibYear,
  "n__civlibinccat" VARCHAR  -- CivlibIncCat,
  "n__civlibdata" VARCHAR  -- CivlibData,
  "n__civlibdisplay" VARCHAR  -- CivLibDisplay,
  "n__civlibmedianvalue" VARCHAR  -- CivlibMedianValue,
  "n__civlibprvalue" VARCHAR  -- CivlibPRValue
);

CREATE TABLE control_of_corruption_indicator_calculation_details_for_fy14 (
  "concorcountrycode" VARCHAR,
  "n__concoryear" BIGINT  -- ConCorYear,
  "n__concorinccat" VARCHAR  -- ConCorIncCat,
  "n__concordata" VARCHAR  -- ConCorData,
  "n__concoragg" VARCHAR  -- ConCorAgg,
  "n__concordisplay" VARCHAR  -- ConCorDisplay,
  "n__concorse" VARCHAR  -- ConCorSE,
  "n__concormedianvalue" VARCHAR  -- ConCorMedianValue,
  "n__concornormalizedmedianvalue" VARCHAR  -- ConCorNormalizedMedianValue,
  "n__concorprvalue" VARCHAR  -- ConCorPRValue
);

CREATE TABLE education_expenditures_indicator_calculation_details_for_fy14 (
  "educexpcountrycode" VARCHAR,
  "n__educexpyear" BIGINT  -- EducExpYear,
  "n__educexpinccat" VARCHAR  -- EducExpIncCat,
  "n__educexpdatapost" VARCHAR  -- EducExpDataPOST,
  "n__educexpdataunesco" VARCHAR  -- EducExpDataUNESCO,
  "n__educexpagg" VARCHAR  -- EducExpAgg,
  "n__educexpdisplay" VARCHAR  -- EducExpDisplay,
  "n__educexpmedianvalue" VARCHAR  -- EducExpMedianValue,
  "n__educexpprvalue" VARCHAR  -- EducExpPRValue
);

CREATE TABLE fiscal_policy_indicator_calculation_details_for_fy14 (
  "fispolcountrycode" VARCHAR,
  "n__fispolyear" BIGINT  -- FisPolYear,
  "n__fispolinccat" VARCHAR  -- FisPolIncCat,
  "n__fispoldata" VARCHAR  -- FisPolData,
  "n__fispolagg" VARCHAR  -- FisPolAgg,
  "n__fispoldisplay" VARCHAR  -- FisPolDisplay,
  "n__fispolmedianvalue" VARCHAR  -- FisPolMedianValue,
  "n__fispolprvalue" VARCHAR  -- FisPolPRValue
);

CREATE TABLE freedom_of_information_indicator_calculation_details_for_fy14 (
  "freedominfocountrycode" VARCHAR,
  "n__freedominfoyear" BIGINT  -- FreedomInfoYear,
  "n__freedominfoinccat" VARCHAR  -- FreedomInfoIncCat,
  "n__freedominfodatafreepress" VARCHAR  -- FreedomInfoDataFreePress,
  "n__freedominfodatafoia" VARCHAR  -- FreedomInfoDataFOIA,
  "n__freedominfodataintertools" VARCHAR  -- FreedomInfoDataInterTools,
  "n__freedominfodatapolynet" VARCHAR  -- FreedomInfoDataPolyNet,
  "n__freedominfoagg" VARCHAR  -- FreedomInfoAgg,
  "n__freedominfodisplay" VARCHAR  -- FreedomInfoDisplay,
  "n__freedominfomedianvalue" VARCHAR  -- FreedomInfoMedianValue,
  "n__freedominfoprvalue" VARCHAR  -- FreedomInfoPRValue
);

CREATE TABLE gender_in_the_economy_indicator_calculation_details_for_fy14 (
  "gendereconcountrycode" VARCHAR,
  "n__gendereconyear" BIGINT  -- GenderEconYear,
  "n__gendereconinccat" VARCHAR  -- GenderEconIncCat,
  "n__genderecondata" VARCHAR  -- GenderEconData,
  "n__genderecondisplay" VARCHAR  -- GenderEconDisplay,
  "n__gendereconmedianvalue" VARCHAR  -- GenderEconMedianValue,
  "n__gendereconprvalue" VARCHAR  -- GenderEconPRValue
);

CREATE TABLE girls_primary_education_completion_rates_indicator_cal_a78a3bbc (
  "girlsprimcountrycode" VARCHAR,
  "n__girlsprimyear" BIGINT  -- GirlsPrimYear,
  "n__girlspriminccat" VARCHAR  -- GirlsPrimIncCat,
  "n__girlsprimdata" VARCHAR  -- GirlsPrimData,
  "n__girlsprimagg" VARCHAR  -- GirlsPrimAgg,
  "n__girlsprimmedianvalue" VARCHAR  -- GirlsPrimMedianValue,
  "n__girlsprimprvalue" VARCHAR  -- GirlsPrimPRValue
);

CREATE TABLE girls_secondary_education_enrollment_rates_indicator_c_e6bde5c7 (
  "girlsseccountrycode" VARCHAR,
  "n__girlssecyear" BIGINT  -- GirlsSecYear,
  "n__girlssecinccat" VARCHAR  -- GirlsSecIncCat,
  "n__girlssecdata" VARCHAR  -- GirlsSecData,
  "n__girlssecagg" VARCHAR  -- GirlsSecAgg,
  "n__girlssecmedianvalue" VARCHAR  -- GirlsSecMedianValue,
  "n__girlssecprvalue" VARCHAR  -- GirlsSecPRValue
);

CREATE TABLE gni_indicator_calculation_details_for_fy14 (
  "countrycode" VARCHAR,
  "n__gnicapyear" BIGINT  -- GNICapYear,
  "n__gnicap" VARCHAR  -- GNIcap,
  "n__gniinccatoverride" VARCHAR  -- GNIIncCatOverride
);

CREATE TABLE gni_limits_indicator_calculation_details_for_fy14 (
  "gnilimityear" BIGINT,
  "n__gnilimitinccat" VARCHAR  -- GNILimitIncCat,
  "n__gnilimitlow" BIGINT  -- GNILimitLow,
  "n__gnilimithigh" BIGINT  -- GNILimitHigh
);

CREATE TABLE government_effectiveness_indicator_calculation_details_for_fy14 (
  "govteffcountrycode" VARCHAR,
  "n__govteffyear" BIGINT  -- GovtEffYear,
  "n__govteffinccat" VARCHAR  -- GovtEffIncCat,
  "n__govteffdata" VARCHAR  -- GovtEffData,
  "n__govteffagg" VARCHAR  -- GovtEffAgg,
  "n__govteffdisplay" VARCHAR  -- GovtEffDisplay,
  "n__govteffse" VARCHAR  -- GovtEffSE,
  "n__govteffmedianvalue" VARCHAR  -- GovtEffMedianValue,
  "n__govteffnormalizedmedianvalue" VARCHAR  -- GovtEffNormalizedMedianValue,
  "n__govteffprvalue" VARCHAR  -- GovtEffPRValue
);

CREATE TABLE health_expenditures_indicator_calculation_details_for_fy14 (
  "healthcountrycode" VARCHAR,
  "n__healthyear" BIGINT  -- HealthYear,
  "n__healthinccat" VARCHAR  -- HealthIncCat,
  "n__healthdata" VARCHAR  -- HealthData,
  "n__healthdisplay" VARCHAR  -- HealthDisplay,
  "n__healthmedianvalue" VARCHAR  -- HealthMedianValue,
  "n__healthprvalue" VARCHAR  -- HealthPRValue
);

CREATE TABLE immunization_rates_indicator_calculation_details_for_fy14 (
  "immuncountrycode" VARCHAR,
  "n__immunyear" BIGINT  -- ImmunYear,
  "n__immuninccat" VARCHAR  -- ImmunIncCat,
  "n__immundatadpt3" VARCHAR  -- ImmunDataDPT3,
  "n__immundatamcv" VARCHAR  -- ImmunDataMCV,
  "n__immunagg" VARCHAR  -- ImmunAgg,
  "n__immundisplay" VARCHAR  -- ImmunDisplay,
  "n__immunmedianvalue" VARCHAR  -- ImmunMedianValue,
  "n__immunprvalue" VARCHAR  -- ImmunPRValue
);

CREATE TABLE income_categories_indicator_calculation_details_for_fy14 (
  "incomecategory" VARCHAR,
  "n__incomecategorydesc" VARCHAR  -- IncomeCategoryDesc
);

CREATE TABLE indicator_categories_calculation_details_for_fy14 (
  "category" VARCHAR,
  "description" VARCHAR
);

CREATE TABLE indicators_calculation_details_for_fy14 (
  "indicator" VARCHAR,
  "category" VARCHAR,
  "description" VARCHAR,
  "source" VARCHAR
);

CREATE TABLE indicators_thresholds_calculation_details_for_fy14 (
  "indicatorcode" VARCHAR,
  "n__incomecategory" VARCHAR  -- IncomeCategory,
  "n__reportyear" BIGINT  -- ReportYear,
  "n__medianvalue" DOUBLE  -- MedianValue,
  "n__sevalue" VARCHAR  -- SEValue,
  "n__thresholdcode" VARCHAR  -- ThresholdCode
);

CREATE TABLE inflation_indicator_calculation_details_for_fy14 (
  "inflcountrycode" VARCHAR,
  "n__inflyear" BIGINT  -- InflYear,
  "n__inflinccat" VARCHAR  -- InflIncCat,
  "n__infldata" VARCHAR  -- InflData,
  "n__infldisplay" VARCHAR  -- InflDisplay,
  "n__inflmedianvalue" VARCHAR  -- InflMedianValue,
  "n__inflprvalue" VARCHAR  -- InflPRValue
);

CREATE TABLE land_rights_and_access_indicator_calculation_details_for_fy14 (
  "lracountrycode" VARCHAR,
  "n__lrayear" BIGINT  -- LRAYear,
  "n__lrainccat" VARCHAR  -- LRAIncCat,
  "n__lradataifad" VARCHAR  -- LRADataIFAD,
  "n__lraifadmin" DOUBLE  -- LRAIFADMin,
  "n__lraifadmax" DOUBLE  -- LRAIFADMax,
  "n__lraifadnormal" VARCHAR  -- LRAIFADNormal,
  "n__lradataifctime" VARCHAR  -- LRADataIFCTime,
  "n__lraifctimemin" DOUBLE  -- LRAIFCTimeMin,
  "n__lraifctimemax" DOUBLE  -- LRAIFCTimeMax,
  "n__lraifctimenormal" VARCHAR  -- LRAIFCTimeNormal,
  "n__lradataifccost" VARCHAR  -- LRADataIFCCost,
  "n__lraifccostmin" DOUBLE  -- LRAIFCCostMin,
  "n__lraifccostmax" DOUBLE  -- LRAIFCCostMax,
  "n__lraifccostnormal" VARCHAR  -- LRAIFCCostNormal,
  "n__lraagg" VARCHAR  -- LRAAgg,
  "n__lradisplay" VARCHAR  -- LRADisplay,
  "n__lramedianvalue" VARCHAR  -- LRAMedianValue,
  "n__lraprvalue" VARCHAR  -- LRAPRValue
);

CREATE TABLE lic_indicator_calculation_details_for_fy14 (
  "countrycode" VARCHAR,
  "n__polrigdisplay" DOUBLE  -- PolRigDisplay,
  "n__civlibdisplay" DOUBLE  -- CivLibDisplay,
  "n__concordisplay" DOUBLE  -- ConCorDisplay,
  "n__govteffdisplay" DOUBLE  -- GovtEffDisplay,
  "n__rulelawdisplay" DOUBLE  -- RuleLawDisplay,
  "n__freedominfodisplay" DOUBLE  -- FreedomInfoDisplay,
  "n__immundisplay" DOUBLE  -- ImmunDisplay,
  "n__healthdisplay" VARCHAR  -- HealthDisplay,
  "n__educexpdisplay" VARCHAR  -- EducExpDisplay,
  "n__girlsprimagg" VARCHAR  -- GirlsPrimAgg,
  "n__chdisplay" DOUBLE  -- CHDisplay,
  "n__nrmdisplay" VARCHAR  -- NRMDisplay,
  "n__regqualitydisplay" DOUBLE  -- RegQualityDisplay,
  "n__lradisplay" VARCHAR  -- LRADisplay,
  "n__busstartupdisplay" VARCHAR  -- BusStartupDisplay,
  "n__tradedisplay" VARCHAR  -- TradeDisplay,
  "n__infldisplay" VARCHAR  -- InflDisplay,
  "n__fispoldisplay" VARCHAR  -- FisPolDisplay,
  "n__accesscreditdisplay" VARCHAR  -- AccessCreditDisplay,
  "n__genderecondisplay" VARCHAR  -- GenderEconDisplay
);

CREATE TABLE lmic_indicator_calculation_details_for_fy14 (
  "countrycode" VARCHAR,
  "n__polrigdisplay" DOUBLE  -- PolRigDisplay,
  "n__civlibdisplay" DOUBLE  -- CivLibDisplay,
  "n__concordisplay" DOUBLE  -- ConCorDisplay,
  "n__govteffdisplay" DOUBLE  -- GovtEffDisplay,
  "n__rulelawdisplay" DOUBLE  -- RuleLawDisplay,
  "n__freedominfodisplay" DOUBLE  -- FreedomInfoDisplay,
  "n__immundisplay" VARCHAR  -- ImmunDisplay,
  "n__healthdisplay" VARCHAR  -- HealthDisplay,
  "n__educexpdisplay" VARCHAR  -- EducExpDisplay,
  "n__girlssecagg" VARCHAR  -- GirlsSecAgg,
  "n__chdisplay" VARCHAR  -- CHDisplay,
  "n__nrmdisplay" DOUBLE  -- NRMDisplay,
  "n__regqualitydisplay" DOUBLE  -- RegQualityDisplay,
  "n__lradisplay" VARCHAR  -- LRADisplay,
  "n__busstartupdisplay" DOUBLE  -- BusStartupDisplay,
  "n__tradedisplay" VARCHAR  -- TradeDisplay,
  "n__infldisplay" VARCHAR  -- InflDisplay,
  "n__fispoldisplay" DOUBLE  -- FisPolDisplay,
  "n__accesscreditdisplay" DOUBLE  -- AccessCreditDisplay,
  "n__genderecondisplay" VARCHAR  -- GenderEconDisplay
);

CREATE TABLE natural_resource_protection_indicator_calculation_deta_ce95521c (
  "nrmcountrycode" VARCHAR,
  "n__nrmyear" BIGINT  -- NRMYear,
  "n__nrminccat" VARCHAR  -- NRMIncCat,
  "n__nrmdata" VARCHAR  -- NRMData,
  "n__nrmdisplay" VARCHAR  -- NRMDisplay,
  "n__nrmmedianvalue" VARCHAR  -- NRMMedianValue,
  "n__nrmprvalue" VARCHAR  -- NRMPRValue
);

CREATE TABLE political_rights_indicator_calculation_details_for_fy14 (
  "polrigcountrycode" VARCHAR,
  "n__polrigyear" BIGINT  -- PolRigYear,
  "n__polriginccat" VARCHAR  -- PolRigIncCat,
  "n__polrigdata" VARCHAR  -- PolRigData,
  "n__polrigdisplay" VARCHAR  -- PolRigDisplay,
  "n__polrigmedianvalue" VARCHAR  -- PolRigMedianValue,
  "n__polrigprvalue" VARCHAR  -- PolRigPRValue
);