Exceptions To Cross-Government Moratoria On Spend In The Department For Work And Pensions
Department for Work and Pensions
@ukgov.exceptions_to_government_moratoria_department_work_and_pensions
Department for Work and Pensions
@ukgov.exceptions_to_government_moratoria_department_work_and_pensions
CREATE TABLE advertising_marketing_and_commercial_jul_to_sep_2019 (
"reference_number" VARCHAR,
"owning_dept_alb_department" VARCHAR,
"alb" VARCHAR,
"case_name" VARCHAR,
"value_excluding_vat" VARCHAR,
"approval_date" TIMESTAMP,
"control" VARCHAR
);
CREATE TABLE advertising_marketing_apr_to_jun_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"dept" VARCHAR,
"control_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" TIMESTAMP
);
CREATE TABLE advertising_marketing_apr_to_jun_2019 (
"case_name" VARCHAR,
"control" VARCHAR,
"n__value" VARCHAR,
"n__approval_date" TIMESTAMP
);
CREATE TABLE advertising_marketing_jan_to_mar_2019 (
"case_name" VARCHAR,
"control" VARCHAR,
"n__value" VARCHAR,
"n__approval_date" TIMESTAMP
);
CREATE TABLE advertising_marketing_oct_to_dec_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"department" VARCHAR,
"arms_length_body" VARCHAR,
"control_type" VARCHAR,
"activity_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" TIMESTAMP
);
CREATE TABLE commercial_apr_to_jun_2018 (
"updated_dwp_commercial_transparency_2018_19_q1_april_t_ab208e8b" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR
);
CREATE TABLE commercial_apr_to_jun_2019 (
"case_name" VARCHAR,
"control" VARCHAR,
"n__value" VARCHAR,
"n__approval_date" TIMESTAMP
);
CREATE TABLE commercial_oct_to_dec_2018 (
"updated_dwp_commercial_transparency_2018_19_q3_oct_to_dec_2018" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR
);
CREATE TABLE consultancy_apr_to_jun_2018 (
"reference_number" VARCHAR,
"case_name" VARCHAR,
"case_description" VARCHAR,
"department" VARCHAR,
"alb" VARCHAR,
"lead_control" VARCHAR,
"controls_entry_stage" VARCHAR,
"total_value_approved_revised_value" VARCHAR,
"decision" VARCHAR,
"decision_sent_to_department" TIMESTAMP
);
CREATE TABLE consultancy_jul_to_sept_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"department" VARCHAR,
"arms_length_body" VARCHAR,
"control_type" VARCHAR,
"activity_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" VARCHAR
);
CREATE TABLE consultancy_oct_to_dec_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"department" VARCHAR,
"arms_length_body" VARCHAR,
"control_type" VARCHAR,
"activity_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" VARCHAR
);
CREATE TABLE exceptions_for_jul_to_sep_2022 (
"reference_number" VARCHAR,
"owning_dept_alb_department" VARCHAR,
"case_name" VARCHAR,
"value_excluding_vat" BIGINT,
"approval_date" TIMESTAMP,
"control" VARCHAR
);
CREATE TABLE exceptions_to_cross_government_moratoria_on_spend_in_t_cb269e7d (
"department" VARCHAR,
"unnamed_1" VARCHAR,
"project_name" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"basis_for" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"total_value" VARCHAR,
"unnamed_9" VARCHAR,
"date_of_approval" VARCHAR
);
CREATE TABLE ict_apr_to_jun_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"dept" VARCHAR,
"control_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" TIMESTAMP
);
CREATE TABLE ict_apr_to_jun_2019 (
"case_name" VARCHAR,
"control" VARCHAR,
"n__value" VARCHAR,
"n__approval_date" VARCHAR
);
CREATE TABLE ict_jan_to_mar_2019 (
"case_name" VARCHAR,
"control" VARCHAR,
"n__value" VARCHAR,
"n__approval_date" TIMESTAMP
);
CREATE TABLE ict_jul_to_sept_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"department" VARCHAR,
"arms_length_body" VARCHAR,
"control_type" VARCHAR,
"activity_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" TIMESTAMP
);
CREATE TABLE ict_oct_to_dec_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"department" VARCHAR,
"arms_length_body" VARCHAR,
"control_type" VARCHAR,
"activity_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" VARCHAR
);
CREATE TABLE property_apr_to_jun_2018 (
"reference_number" VARCHAR,
"case_name" VARCHAR,
"case_description" VARCHAR,
"department" VARCHAR,
"arms_length_body" VARCHAR,
"lead_control" VARCHAR,
"controls_entry_stage" VARCHAR,
"total_value_approved_revised_value" VARCHAR,
"decision" VARCHAR,
"decision_sent_to_department" VARCHAR
);
CREATE TABLE property_jul_to_sept_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"department" VARCHAR,
"arms_length_body" VARCHAR,
"control_type" VARCHAR,
"activity_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" VARCHAR
);
CREATE TABLE property_oct_to_dec_2018 (
"hmg_ref" VARCHAR,
"title" VARCHAR,
"description_notes_for_minister" VARCHAR,
"department" VARCHAR,
"arms_length_body" VARCHAR,
"control_type" VARCHAR,
"activity_type" VARCHAR,
"requested_value" VARCHAR,
"status_decision_result" VARCHAR,
"minister_sub_date" VARCHAR
);
CREATE TABLE recruitment_apr_to_jun_2018 (
"departmernt" VARCHAR,
"organisation_name" VARCHAR,
"basis_for_expenditure_approval" VARCHAR,
"project_name" VARCHAR,
"total_value_apporved" DOUBLE,
"basis_for_exception" VARCHAR,
"approval_month" VARCHAR,
"civil_service_grade_full_time_equivalent" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"civil_service_grade_headcount" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"total_approvals_headcount" DOUBLE,
"total_approvals_full_time_equivalent" DOUBLE,
"date_of_approval" TIMESTAMP
);
CREATE TABLE recruitment_apr_to_jun_2019 (
"department" VARCHAR,
"organisation_name" VARCHAR,
"basis_for_expenditure_approval" VARCHAR,
"project_name" VARCHAR,
"total_value_approved" DOUBLE,
"basis_for_exception" VARCHAR,
"approval_month" VARCHAR,
"civil_service_grade_fte" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"civil_service_grade_headcount" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"total_approvals_headcount" DOUBLE,
"total_approvals_fte" DOUBLE,
"date_of_approval" TIMESTAMP
);
CREATE TABLE recruitment_jan_to_mar_2019 (
"department" VARCHAR,
"organisation_name" VARCHAR,
"basis_for_expenditure_approval" VARCHAR,
"project_name" VARCHAR,
"total_value_approved" DOUBLE,
"basis_for_exception" VARCHAR,
"approval_month" VARCHAR,
"civil_service_grade_fte" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"civil_service_grade_headcount" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"total_approvals_headcount" DOUBLE,
"total_approvals_fte" DOUBLE,
"date_of_approval" TIMESTAMP
);
CREATE TABLE recruitment_jul_to_sep_2019 (
"department" VARCHAR,
"organisation_name" VARCHAR,
"basis_for_expenditure_approval" VARCHAR,
"project_name" VARCHAR,
"total_value_approved" VARCHAR,
"basis_for_exception" VARCHAR,
"approval_month" VARCHAR,
"civil_service_grade_fte" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"civil_service_grade_headcount" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"total_approvals_headcount" DOUBLE,
"total_approvals_fte" DOUBLE,
"date_of_approval" VARCHAR
);
Anyone who has the link will be able to view this.