OIP Master UIPA Record Request Semiannual Log For FY 2016
State of Hawaii
@usgov.state_of_hawaii_oip_master_uipa_request_semiannual_log_1d115445
State of Hawaii
@usgov.state_of_hawaii_oip_master_uipa_request_semiannual_log_1d115445
OIP Master UIPA Record Request Semiannual Log For FY 2016 (record requests received July 1, 2015, through December 31, 2015)
Organization: State of Hawaii
Last updated: 2024-04-10T22:39:05.910236
CREATE TABLE table_1 (
"department" VARCHAR,
"agency" VARCHAR,
"personal_records_request" DOUBLE -- Personal Records Request?,
"date_agency_received_request" DOUBLE,
"date_agency_s_notice_was_sent" DOUBLE,
"agency_s_initial_response_sent_within_10_work_days" DOUBLE -- Agency 's Initial Response Sent Within 10 Work Days,
"request_needed_initial_clarification" DOUBLE,
"complex_request" DOUBLE -- Complex Request?,
"n__agency_gave_incremental_responses" DOUBLE -- Agency Gave Incremental Responses?,
"date_completed" DOUBLE,
"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
);Anyone who has the link will be able to view this.