OIP Master UIPA Record Request Semiannual Log For FY 2015

CREATE TABLE table_1 (
  "department" VARCHAR,
  "agency" VARCHAR,
  "n__of_personal_records_requests" DOUBLE  -- # Of Personal Records Requests,
  "n__of_requests_received" DOUBLE  -- # Of Requests Received,
  "n__of_notices_sent" DOUBLE  -- # Of Notices Sent,
  "n__of_initial_responses_sent_within_10_work_days" DOUBLE  -- # Of Initial Responses Sent Within 10 Work Days,
  "n__of_requests_needing_initial_clarification" DOUBLE  -- # Of Requests Needing Initial Clarification,
  "n__of_complex_requests" DOUBLE  -- # Of Complex Requests,
  "n__of_requests_with_incremental_responses" DOUBLE  -- # Of Requests With Incremental Responses,
  "n__of_requests_completed" DOUBLE  -- # Of Requests Completed,
  "n__of_workdays_to_complete" DOUBLE  -- # Of Workdays To Complete,
  "request_granted_in_full" DOUBLE,
  "request_denied_in_full" DOUBLE,
  "request_denied_in_part" DOUBLE,
  "agency_ultimately_unable_to_respond" DOUBLE,
  "requester_withdrew" DOUBLE,
  "requester_abandoned_or_failed_to_pay" DOUBLE,
  "uipa_lawsuit_filed_against_agency" DOUBLE  -- UIPA Lawsuit Filed Against Agency?,
  "actual_search_hours" DOUBLE,
  "n__actual_review_segregation_hours" DOUBLE  -- Actual Review/ Segregation Hours,
  "actual_legal_review_hours" DOUBLE,
  "total_actual_srs_legal_review_hours" DOUBLE  -- TOTAL Actual SRS & Legal Review Hours,
  "total_gross_srs_fees_incurred" DOUBLE,
  "additional_response_fees_incurred_but_not_chargeable" DOUBLE,
  "minus_30_fee_waiver" DOUBLE  -- Minus $30 Fee Waiver,
  "minus_60_fee_waiver" DOUBLE  -- Minus $60 Fee Waiver,
  "fees_for_personal_records" DOUBLE,
  "total_net_srs_fees_chargeable" DOUBLE,
  "gross_copy_delivery_costs_that_agency_incurred" DOUBLE,
  "net_copy_delivery_costs_chargeable_to_requester" DOUBLE,
  "total_fees_costs_actually_paid_by_requesters_for_all_requests" DOUBLE  -- TOTAL Fees & Costs ACTUALLY PAID By Requesters For ALL Requests,
  "total_net_fees_costs_chargeable_for_all_requests" DOUBLE  -- TOTAL NET Fees & Costs CHARGEABLE For ALL Requests,
  "total_gross_fees_costs_agency_incurred_for_all_requests" DOUBLE  -- TOTAL GROSS Fees & Costs Agency INCURRED For ALL Requests,
  "total_gross_fees_costs_incurred_but_not_charged_for_al_0e2843fa" DOUBLE  -- TOTAL GROSS Fees & Costs INCURRED BUT NOT CHARGED For ALL Requests,
  "total_net_fees_costs_actually_paid_for_complex_requests" DOUBLE  -- TOTAL NET Fees & Costs ACTUALLY PAID For COMPLEX Requests,
  "total_net_fees_costs_chargeable_for_complex_requests" DOUBLE  -- TOTAL NET Fees & Costs CHARGEABLE For COMPLEX Requests,
  "total_gross_fees_costs_incurred_for_complex_requests" DOUBLE  -- TOTAL GROSS Fees & Costs INCURRED For COMPLEX Requests,
  "total_gross_fees_costs_incurred_but_not_charged_for_co_7c531c9b" DOUBLE  -- TOTAL GROSS Fees & Costs INCURRED BUT NOT CHARGED For COMPLEX Requests,
  "n__of_workdays_to_complete_all_requests" DOUBLE  -- # Of Workdays To Complete ALL Requests,
  "n__of_workdays_to_complete_complex_requests" DOUBLE  -- # Of Workdays To Complete COMPLEX Requests,
  "n__of_workdays_to_complete_noncomplex_nonpersonal_requests" DOUBLE  -- # Of Workdays To Complete NONCOMPLEX, NONPERSONAL RECORD Requests,
  "n__of_workdays_to_complete_personal_record_requests" DOUBLE  -- # Of Workdays To Complete PERSONAL RECORD Requests,
  "n__of_search_hours_incurred_for_all_requests" DOUBLE  -- # Of Search Hours Incurred For ALL Requests,
  "n__of_search_hours_incurred_for_complex_requests" DOUBLE  -- # Of Search Hours Incurred For COMPLEX Requests,
  "n__of_search_hours_incurred_for_noncomplex_nonpersonal_requests" DOUBLE  -- # Of Search Hours Incurred For NONCOMPLEX, NONPERSONAL RECORD Requests,
  "n__of_search_hours_incurred_for_personal_record_requests" DOUBLE  -- # Of Search Hours Incurred For PERSONAL RECORD Requests,
  "n__of_review_segregation_hours_incurred_for_all_requests" DOUBLE  -- # Of Review & Segregation Hours Incurred For ALL Requests,
  "n__of_review_segregation_hours_incurred_for_complex_requests" DOUBLE  -- # Of Review & Segregation Hours Incurred For COMPLEX Requests,
  "n__of_review_segregation_hours_incurred_for_noncomplex_22579cf1" DOUBLE  -- # Of Review & Segregation Hours Incurred For NONCOMPLEX, NONPERSONAL RECORD Requests,
  "n__of_review_segregation_hours_incurred_for_personal_requests" DOUBLE  -- # Of Review & Segregation Hours Incurred For PERSONAL RECORD Requests,
  "total_routine_requests" DOUBLE
);