NSCHC Rule Change Data
AmeriCorps
@usgov.americorps_gov_nschc_rule_change_data
AmeriCorps
@usgov.americorps_gov_nschc_rule_change_data
National Service Criminal History Check Rule Change Data
Organization: AmeriCorps
Last updated: 2023-11-15T17:17:53.538909
Tags: americorps, criminal-history-checks
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 -- 1. Additional Screening Still Needed/no Rap Sheet,
"n_2_added_expense" DOUBLE -- 2. Added Expense,
"n_3_livescan_difficult_to_access" DOUBLE -- 3. Livescan Difficult To Access,
"n_4_concern_about_checks_completed_before_start" VARCHAR -- 4. Concern About Checks Completed Before Start,
"n_5_having_to_redo_all_checks" VARCHAR -- 5. Having To Redo All Checks,
"n_6_vendors_difficult_to_use" VARCHAR -- 6. Vendors Difficult To Use,
"n_7_does_not_keep_vps_safer" DOUBLE -- 7. Does Not Keep VPs Safer,
"n_8_pii_security" DOUBLE -- 8. PII Security,
"n_9_states_not_included_in_ts" DOUBLE -- 9. States Not Included In TS,
"n_10_slower_adjudication" DOUBLE -- 10. Slower Adjudication,
"n_11_barrier_to_service_recruitment" DOUBLE -- 11. Barrier To Service/recruitment,
"n_12_current_process_works_well" DOUBLE -- 12. Current Process Works Well,
"positives" DOUBLE,
"recommendations" VARCHAR,
"state_process_working_well" VARCHAR,
"new_georeferenced_column" VARCHAR
);Anyone who has the link will be able to view this.