Freedom Of Information Case Logs

CREATE TABLE freedom_of_information_case_logs (
  "n_1915_2016_07_25_procurement_hr_member_of_the_public__04e76edf" VARCHAR  -- 1915,"2016-07-25","Procurement / HR","Member Of The Public","All Provided","n/a","2016-08-19","19","To Assist You, I Believe This May Best Be Sourced From Your Category Manager For Professional Services Within Your Procurement Section, Or Procurement/ Purchasing/ Finance And HR/ Personnel/ Recruitment Sections, Depending On The Organisational Structure Of The Food Standards Agency.1. Please Advise The Total Staff Headcount That Are Employed Directly By The Food Standards Agency, With Each Part-time Employee Counted As One Employee. Please Exclude All Temporary Agency Workers From This Figure.2. Please Identify Each Supplier That The Food Standards Agency Has A Contract With To Supply Temporary Agency Workers.3. Please Identify: A. The Type Of Contract That The Food Standards Agency Has With Each Of These Suppliers (preferred Supplier List/ Framework/ Etc. If Framework, Please Indicate B. Which - E.g. MSTAR/ YPO/ Panel London/ Pan London/ NPS All Wales/ Crown Commercial Services/ Etc,
  "n__and_c_whether_this_is_on_a_neutral_master_hybrid_ve_9fd14f2d" VARCHAR  -- And C. Whether This Is On A Neutral/ Master/ Hybrid Vender Model, Or The Lot Number.4. Please Advise For Each Contract Identified Within (2) Above Of: A. The Current End Date Of The Contract,
  "n__b_the_date_s_that_any_break_clause_s_can_be_enabled" VARCHAR  -- B. The Date(s) That Any Break Clause(s) Can Be Enabled,
  "n__and_c_the_length_of_time_of_any_extension_that_can__02283119" VARCHAR  -- And C. The Length Of Time Of Any Extension That Can Be Enabled.5. Please Advise Of The A. Full Name Of The Main Contact At The Food Standards Agency Who Is Responsible For The Main (or Majority Of The) Contract(s) Identified Within (2) Above, Together With Their:b. Job Title,
  "c_group_either_team_division_or_department_whichever_i_ab9d7056" VARCHAR  -- C. Group (either Team, Division Or Department, Whichever Is The Smallest Identifiable Group),
  "d_telephone_number" VARCHAR  -- D. Telephone Number,
  "e_email" VARCHAR  -- E. Email,
  "n__andf_full_postal_address_inc_postcode_6_please_iden_7137becc" VARCHAR  -- Andf. Full Postal Address, Inc Postcode.6. Please Identify All Suppliers That The Food Standards Agency Has Sourced A Temporary Agency Worker From - But Does Not Have A Contract With - From 1 April 2015 To 31 March 2016.7. For Each Temporary Agency Supplier (either A. Contracted As Identified Within (2) Above,
  "n__b_non_contracted_as_identified_within_6_above" VARCHAR  -- B. Non-contracted As Identified Within (6) Above,
  "n__and_c_all_temporary_workers_the_food_standards_agen_001475cc" VARCHAR  -- And C. All Temporary Workers The Food Standards Agency Has Sourced Directly), How Much Has Been Spent On Each Supplier (or Directly), From 1 April 2015 To 31 March 2016?I Would Like The Above Information To Be Provided In Electronic Copy, Sent By Reply Of This Request.If You Believe This Request Is Too Wide Or Unclear, I Would Be Grateful If You Could Contact Me For Clarification, As I Understand That Under The Act, You Are Required To Advise And Assist Requesters. If Any Of This Information Is Already In The Public Domain, Please Would You Direct Me To It, With Page References And URLs, As Appropriate."
);

CREATE TABLE freedom_of_information_case_logs_for_2018 (
  "casenumber" BIGINT,
  "dateofrequestreceived" TIMESTAMP,
  "division_branch" VARCHAR,
  "applicantcategory" VARCHAR,
  "outcomes" VARCHAR,
  "exemptionsapplied" VARCHAR,
  "dateofresponsesent" TIMESTAMP,
  "daystakentocomplete" VARCHAR,
  "requestwording" VARCHAR
);