NSCHC Rule Change Data
AmeriCorps
@usgov.americorps_gov_nschc_rule_change_data
AmeriCorps
@usgov.americorps_gov_nschc_rule_change_data
CREATE TABLE table_1 (
"docket_id" VARCHAR,
"document_id" VARCHAR,
"original_document_id" VARCHAR,
"attachments" VARCHAR,
"rin" VARCHAR,
"title" VARCHAR,
"document_type" VARCHAR,
"document_subtype" VARCHAR,
"include_submitter_information" BOOLEAN,
"comment_on_doc_id" VARCHAR,
"status" VARCHAR,
"status_set_date" VARCHAR,
"current_assignee" VARCHAR,
"status_set_by" VARCHAR,
"received_date" VARCHAR,
"date_posted" VARCHAR,
"posting_restriction" VARCHAR,
"reason_restricted" VARCHAR,
"restriction_explanation" VARCHAR,
"post_mark_date" VARCHAR,
"tracking_number" VARCHAR,
"total_page_count_including_attachments" BIGINT,
"submission_type" BIGINT,
"number_of_submissions" BIGINT,
"first_name" VARCHAR,
"last_name" VARCHAR,
"mailing_address" VARCHAR,
"city" VARCHAR,
"country" VARCHAR,
"state_or_province" VARCHAR,
"zip_postal_code" VARCHAR,
"email_address" VARCHAR,
"phone_number" VARCHAR,
"fax_number" VARCHAR,
"organization_name" VARCHAR,
"submitter_s_representative" VARCHAR,
"government_agency_type" VARCHAR,
"government_agency" VARCHAR,
"category" VARCHAR,
"comment" VARCHAR,
"n_1_additional_screening_still_needed_no_rap_sheet" VARCHAR,
"n_2_added_expense" DOUBLE,
"n_3_livescan_difficult_to_access" DOUBLE,
"n_4_concern_about_checks_completed_before_start" VARCHAR,
"n_5_having_to_redo_all_checks" VARCHAR,
"n_6_vendors_difficult_to_use" VARCHAR,
"n_7_does_not_keep_vps_safer" DOUBLE,
"n_8_pii_security" DOUBLE,
"n_9_states_not_included_in_ts" DOUBLE,
"n_10_slower_adjudication" DOUBLE,
"n_11_barrier_to_service_recruitment" DOUBLE,
"n_12_current_process_works_well" DOUBLE,
"positives" DOUBLE,
"recommendations" VARCHAR,
"state_process_working_well" VARCHAR,
"new_georeferenced_column" VARCHAR
);
Anyone who has the link will be able to view this.