Upcoming database changes RELEASE 7 November 2024

-ActiveRecord::Schema[7.0].define(version: 2024_10_15_141414) do
+ActiveRecord::Schema[7.0].define(version: 2024_10_25_095358) do
   # These are extensions that must be enabled in order to support this database
   enable_extension "citext"
   enable_extension "hstore"
@@ -1530,6 +1530,8 @@
     t.string "name", default: "", null: false
     t.datetime "started_at", precision: nil
     t.datetime "completed_at", precision: nil
+    t.index ["klass"], name: "index_exportling_exports_on_klass"
+    t.index ["owner_id"], name: "index_exportling_exports_on_owner_id"
   end
 
   create_table "filter_bar_configurations", id: :serial, force: :cascade do |t|
@@ -1961,6 +1963,13 @@
     t.index ["name"], name: "index_jobseeker_suggestion_rejection_reasons_on_name", unique: true
   end
 
+  create_table "jobseeker_suggestion_statuses", force: :cascade do |t|
+    t.text "name", null: false
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+    t.index ["name"], name: "index_jobseeker_suggestion_statuses_on_name"
+  end
+
   create_table "jobseeker_suggestions", id: :serial, force: :cascade do |t|
     t.integer "jobseeker_id"
     t.integer "vacancy_id"
@@ -1973,7 +1982,9 @@
     t.integer "rejection_reason_id"
     t.datetime "marketo_synced_at", precision: nil
     t.string "engaged"
+    t.integer "jobseeker_suggestion_status_id"
     t.index ["jobseeker_id"], name: "index_jobseeker_suggestions_on_jobseeker_id"
+    t.index ["jobseeker_suggestion_status_id"], name: "index_jobseeker_suggestions_on_jobseeker_suggestion_status_id"
     t.index ["rejection_reason_id"], name: "index_jobseeker_suggestions_on_rejection_reason_id"
     t.index ["suggested_by_id"], name: "index_jobseeker_suggestions_on_suggested_by_id"
     t.index ["vacancy_id"], name: "index_jobseeker_suggestions_on_vacancy_id"
@@ -3999,38 +4010,21 @@
     t.citext "ess_identifier"
     t.decimal "expenses_approval_limit", precision: 8, default: "0", null: false
     t.string "time_zone"
-    t.string "role"
     t.integer "site_id"
-    t.boolean "second_approver", default: false
-    t.boolean "manage_national_employers", default: false
-    t.boolean "manage_regional_employers", default: false
     t.string "phone"
     t.text "email_signature"
-    t.boolean "vacancy_ess_service", default: false
-    t.boolean "employer_ess_service", default: false
     t.boolean "active", default: true, null: false
-    t.boolean "manage_claim_states", default: false
     t.boolean "jobready_admin"
-    t.boolean "can_stop_pps_schedule", default: false
     t.string "job_title"
-    t.boolean "expense_master_editor", default: false
     t.integer "reverse_marketing_activities_count", default: 0
-    t.boolean "tableau_license", default: false
     t.string "ccu_role"
     t.json "kanban_board_last_search", default: {}, null: false
-    t.boolean "can_mark_non_payable", default: false
-    t.boolean "can_unmark_non_payable", default: false
-    t.boolean "can_reinstate_claim", default: false
-    t.boolean "can_export_data", default: true
     t.integer "accessible_site_ids", default: [], array: true
     t.datetime "updated_at", precision: nil, null: false
     t.datetime "created_at", precision: nil, null: false
     t.datetime "locked_at", precision: nil
-    t.boolean "can_view_and_mark_confidential_jobseekers", default: false, null: false
     t.string "expense_approval_level"
-    t.boolean "can_cancel_expense", default: true, null: false
     t.integer "delegate_id"
-    t.boolean "manage_allied_health", default: false
     t.string "encrypted_password", default: "", null: false
     t.string "reset_password_token"
     t.datetime "reset_password_sent_at", precision: nil
@@ -4050,42 +4044,16 @@
     t.string "invited_by_type"
     t.integer "invitations_count", default: 0
     t.integer "failed_attempts", default: 0, null: false
-    t.boolean "can_create_des_placement", default: false, null: false
-    t.boolean "can_remove_wage_history", default: false, null: false
     t.integer "locked_by_id"
-    t.boolean "kanban_board_readonly", default: false
-    t.boolean "can_bulk_update_support_schedule", default: false, null: false
     t.string "confirmation_token"
     t.datetime "confirmed_at", precision: nil
     t.datetime "confirmation_sent_at", precision: nil
     t.citext "unconfirmed_email"
-    t.boolean "can_approve_own_expenses", default: true, null: false
-    t.boolean "can_update_tracking_behaviour", default: false, null: false
     t.boolean "restrict_site_communication", default: false, null: false
-    t.boolean "can_send_bulk_sms", default: false, null: false
     t.string "batch_access_type", default: "own", null: false
     t.string "export_access_type", default: "own", null: false
-    t.boolean "can_manage_admin_settings", default: false, null: false
-    t.boolean "can_send_bulk_email", default: false, null: false
-    t.boolean "site_float_management", default: false, null: false
-    t.boolean "can_merge_jobseekers", default: false, null: false
-    t.boolean "employment_fund", default: false, null: false
-    t.boolean "can_receive_voucher_at_site", default: false, null: false
-    t.boolean "can_manage_organisation_leads", default: false, null: false
-    t.boolean "can_manage_customer_leads", default: false, null: false
-    t.boolean "can_manage_employer_campaigns", default: false, null: false
-    t.boolean "can_create_ja_placement", default: false, null: false
     t.boolean "can_manage_queries", default: false
-    t.boolean "can_override_period_of_service", default: false
-    t.boolean "can_reconcile_bank_transaction", default: false
-    t.boolean "can_end_placement", default: true, null: false
-    t.boolean "can_manage_basic_benefit_rates", default: false, null: false
     t.boolean "query_notification_subscribed", default: true
-    t.boolean "can_edit_job_readiness", default: false, null: false
-    t.boolean "can_bulk_update_customer_coordinator", default: false, null: false
-    t.boolean "can_add_permissible_break", default: true, null: false
-    t.boolean "can_update_supplier_paid_date", default: false, null: false
-    t.boolean "can_create_wfa_placement", default: false, null: false
     t.boolean "mfa_enabled", default: false
     t.string "encrypted_otp_secret"
     t.string "encrypted_otp_secret_iv"
@@ -4094,20 +4062,7 @@
     t.boolean "otp_required_for_login"
     t.integer "manageable_query_type_ids", default: [], array: true
     t.string "locale"
-    t.boolean "can_send_sms", default: true, null: false
-    t.boolean "ess_subs_admin", default: false, null: false
-    t.boolean "can_create_and_import_jobseekers", default: false, null: false
-    t.boolean "can_access_ai_copilot", default: false, null: false
-    t.boolean "can_create_rom2_placement", default: false, null: false
-    t.boolean "can_view_superset_dashboards", default: false, null: false
-    t.boolean "can_manage_wage_subsidy_requests", default: false, null: false
-    t.boolean "can_bulk_update_jobseeker_status", default: false, null: false
-    t.boolean "can_create_sta2_placement", default: false
     t.string "personal_number"
-    t.boolean "can_manage_calendar_templates", default: false, null: false
-    t.boolean "can_edit_suppliers", default: false
-    t.boolean "can_contact_jr_support", default: false
-    t.boolean "can_delete_ancillary_records", default: false
     t.string "scim_uid"
     t.string "otp_secret"
     t.index ["active"], name: "index_users_on_active"