Baselight

NSCHC Rule Change Data

AmeriCorps

@usgov.americorps_gov_nschc_rule_change_data

Loading...
Loading...

About this Dataset

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

Tables

Table 1

@usgov.americorps_gov_nschc_rule_change_data.table_1
  • 89.74 kB
  • 38 rows
  • 56 columns
Loading...
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
);

Share link

Anyone who has the link will be able to view this.