2014 Capital Project Budgets

CREATE TABLE project_budgets_for_2015_2020 (
  "project_name" VARCHAR,
  "functional_area" VARCHAR,
  "responsible_department" VARCHAR,
  "project_manager" VARCHAR,
  "n_2014_cdbg" VARCHAR  -- 2014 CDBG,
  "n_2014_bond" VARCHAR  -- 2014 Bond,
  "n_2014_paygo" VARCHAR  -- 2014 Paygo,
  "n_2014_other" VARCHAR  -- 2014 Other,
  "n_2014_total" VARCHAR  -- 2014 Total,
  "n_2015_cdbg" VARCHAR  -- 2015 CDBG,
  "n_2015_bond" VARCHAR  -- 2015 Bond,
  "n_2015_paygo" VARCHAR  -- 2015 Paygo,
  "n_2015_other" VARCHAR  -- 2015 Other,
  "n_2015_total" VARCHAR  -- 2015 Total,
  "n_2016_cdbg" VARCHAR  -- 2016 CDBG,
  "n_2016_bond" VARCHAR  -- 2016 Bond,
  "n_2016_paygo" VARCHAR  -- 2016 Paygo,
  "n_2016_other" VARCHAR  -- 2016 Other,
  "n_2016_total" VARCHAR  -- 2016 Total,
  "n_2017_cdbg" VARCHAR  -- 2017 CDBG,
  "n_2017_bond" VARCHAR  -- 2017 Bond,
  "n_2017_paygo" VARCHAR  -- 2017 Paygo,
  "n_2017_other" VARCHAR  -- 2017 Other,
  "n_2017_total" VARCHAR  -- 2017 Total,
  "n_2018_cdbg" VARCHAR  -- 2018 CDBG,
  "n_2018_bond" VARCHAR  -- 2018 Bond,
  "n_2018_paygo" VARCHAR  -- 2018 Paygo,
  "n_2018_other" VARCHAR  -- 2018 Other,
  "n_2018_total" VARCHAR  -- 2018 Total,
  "n_2019_cdbg" VARCHAR  -- 2019 CDBG,
  "n_2019_bond" VARCHAR  -- 2019 Bond,
  "n_2019_paygo" VARCHAR  -- 2019 Paygo,
  "n_2019_other" VARCHAR  -- 2019 Other,
  "n_2019_total" VARCHAR  -- 2019 Total,
  "n_2020_cdbg" VARCHAR  -- 2020 CDBG,
  "n_2020_bond" VARCHAR  -- 2020 Bond,
  "n_2020_paygo" VARCHAR  -- 2020 Paygo,
  "n_2020_other" VARCHAR  -- 2020 Other,
  "n_2020_total" VARCHAR  -- 2020 Total,
  "total_cdbg" VARCHAR,
  "total_bond" VARCHAR,
  "total_paygo" VARCHAR,
  "total_other" VARCHAR,
  "total_total" VARCHAR,
  "project_description" VARCHAR,
  "project_justification" VARCHAR,
  "prior_year_funds_as_of_11_30_2014" VARCHAR  -- Prior Year Funds (As Of 11/30/2014),
  "jde_number_cdbg" VARCHAR  -- JDE Number (CDBG),
  "jde_number_bond_paygo" VARCHAR  -- JDE Number (Bond/Paygo),
  "new_recurring_continuing" VARCHAR,
  "operating_budget_impact" VARCHAR,
  "project_type" VARCHAR,
  "deliverable_1" VARCHAR,
  "location_1" VARCHAR,
  "duration_1" VARCHAR,
  "cost_1" VARCHAR,
  "deliverable_2" VARCHAR,
  "location_2" VARCHAR,
  "duration_2" VARCHAR,
  "cost_2" VARCHAR,
  "deliverable_3" VARCHAR,
  "location_3" VARCHAR,
  "duration_3" VARCHAR,
  "cost_3" VARCHAR,
  "deliverable_4" VARCHAR,
  "location_4" VARCHAR,
  "duration_4" VARCHAR,
  "cost_4" VARCHAR,
  "deliverable_5" VARCHAR,
  "location_5" VARCHAR,
  "duration_5" VARCHAR,
  "cost_5" DOUBLE,
  "deliverable_6" VARCHAR,
  "location_6" VARCHAR,
  "duration_6" VARCHAR,
  "cost_6" DOUBLE,
  "deliverable_7" VARCHAR,
  "location_7" VARCHAR,
  "duration_7" VARCHAR,
  "cost_7" DOUBLE,
  "deliverable_8" VARCHAR,
  "location_8" VARCHAR,
  "duration_8" VARCHAR,
  "cost_8" DOUBLE,
  "deliverable_9" VARCHAR,
  "location_9" VARCHAR,
  "duration_9" VARCHAR,
  "cost_9" DOUBLE,
  "deliverable_10" VARCHAR,
  "location_10" VARCHAR,
  "duration_10" VARCHAR,
  "cost_10" VARCHAR,
  "deliverable_11" VARCHAR,
  "location_11" VARCHAR,
  "duration_11" VARCHAR,
  "cost_11" VARCHAR,
  "deliverable_12" VARCHAR,
  "location_12" VARCHAR,
  "duration_12" VARCHAR,
  "cost_12" DOUBLE
);