Data Series Schema Track

[Napho]

Issue for tracking actual update on tables and table dependencies for data_series schema. When update on the tables is completed, the checkbox will be marked to indicate updated. Every table that has a dependency has its dependency listed and a link to the issue list for it

Table list

• [x] largest_intl_flow References di_largest_intl_flow
• [x] intl_flows_recipients References reference.di_flow_type reference.di_flow_name
• [x] 2013_p20_population
• [x] fragile_states
• [x] climate_vulnerability
• [x] forgotten_crisis
• [ ] percent_in_p20_national
• [ ] ssc_percent_gni
• [ ] agricultural_census
• [ ] civil_reg_births
• [ ] civil_reg_deaths
• [x] depth_of_extreme_poverty_190
• [ ] dfis_out_dev
• [ ] displacement
• [ ] domestic
• [x] fdi_percent_gdp
• [ ] educ_mis
• [x] fdi_pp
• [ ] fdi_out References reference.di_financing_type
• [ ] govt_revenue_pc_gdp
• [ ] govt_spend_pc
• [ ] iati_budgets_be
• [ ] iati_budgets_ca
• [ ] iati_budgets_dk
• [ ] iati_budgets_gb
• [ ] iati_budgets_nl
• [x] in_ha
• [ ] in_oof_gross
• [ ] grants_percent_total_revenue
• [ ] health_mis
• [x] human_hazard
• [x] intl_resources_total_percent_gdp
• [ ] latest_census
• [ ] latest_hh_survey
• [ ] long_debt_disbursement_in References reference.di_destination_institution_type reference.di_finance_type
• [ ] intl_flows_donors References reference.di_flow_type reference.di_flow_name
• [x] number_of_un_appeals
• [ ] oda_capital_repayments
• [ ] oda_interest_payments
• [x] oda_percent_intl_resources
• [ ] oof
• [ ] long_debt_net_official_in References reference.di_destination_institution_type reference.di_financing_type
• [x] natural_hazard
• [ ] non_grant_revenue_ppp_pc
• [ ] number_of_surveys
• [x] poverty_190
• [x] poverty_310
• [ ] remittances
• [x] remittances_pp
• [ ] stat_capacity
• [ ] out_oof_net
• [ ] out_ssc_net
• [x] poor_people_190
• [ ] poorest_20_percent
• [x] total_revenue_percent_gdp
• [x] total_revenue_ppp_pc

Referenced by most tables

• [x] dimension.di_id
• [ ] reference.di_budget_type Referenced by total_revenue_percent_gdp grants_percent_total_revenue total_revenue_ppp_pc domestic govt_spend_pc non_grant_revenue_ppp_pc

[Duncan-Knox]

Some of the above is not used or will need updating once the new data comes in. This should be revisited next year.