JR Live Database Schema

 

Please see below the database schema as at 17 March 2021

 

  table "activities"

    t.string "ess_identifier", null: false

    t.string "name", null: false

    t.string "description"

    t.string "activity_type"

    t.string "activity_sub_type"

    t.string "status"

    t.string "priority"

    t.date "start_date"

    t.date "end_date"

    t.boolean "group_based_activity", default: false

    t.boolean "multiple_location", default: false

    t.string "general_related_id"

    t.boolean "externally_hosted", default: false

    t.string "contract_id", null: false

    t.string "contract_name"

    t.string "contract_type"

    t.integer "site_id"

    t.string "supervising_office_code"

    t.boolean "police_check", default: false

    t.text "related_activity_ids", array: true

    t.string "host_type_code"

    t.string "host_organisation_name"

    t.string "host_organisation_status"

    t.string "host_social_enterprise_indicator"

    t.string "host_contact_person_position_title"

    t.string "host_contact_person_title"

    t.string "host_contact_name"

    t.string "host_address"

    t.string "host_town_or_suburb"

    t.string "host_state"

    t.string "host_postcode"

    t.string "host_contact_phone_number"

    t.string "host_contact_mobile_number"

    t.string "host_fax_number"

    t.string "host_email_address"

    t.string "related_industry_codes"

    t.integer "created_by_user_id"

    t.integer "updated_by_user_id"

    t.string "sourcing_contract_type"

    t.string "sourcing_organisation_code"

    t.boolean "overarching_activity", default: false

    t.string "overarching_activity_id"

    t.text "related_sub_activity_ids", array: true

    t.boolean "my_organisation_only"

    t.string "advertise_activity_type"

    t.string "advertising_to_organisation_list"

    t.string "advertising_to_site_list"

    t.string "lead_provider_organisation_code"

    t.integer "lead_provider_site_id"

    t.date "risk_assessment_place_completed_date"

    t.date "host_agreement_executed_date"

    t.decimal "individual_place_fee_host_amount"

    t.decimal "group_based_place_fee_amount"

    t.decimal "activity_overhead_cost_amount_including_gst"

    t.decimal "activity_participant_cost_amount_including_gst"

    t.decimal "total_budgeted_cost_amount_including_gst"

    t.decimal "advance_payment_amount"

    t.date "acquittal_due_date"

    t.boolean "acquittal_completed"

    t.integer "place_hours"

    t.string "place_type_description"

    t.string "total_activity_places_sourced"

    t.integer "activity_places_active"

    t.integer "activity_places_active_claimed"

    t.integer "activity_places_active_available"

    t.string "activity_places_active_claimed_by_own_org"

    t.string "activity_places_active_current_commencement"

    t.string "activity_places_active_claimed_pending_commencement"

    t.string "location_status"

    t.string "location_contact_person_position_title"

    t.string "location_contact_person_title"

    t.string "location_contact_name"

    t.string "location_address"

    t.string "location_town_or_suburb"

    t.string "location_state"

    t.string "location_postcode"

    t.string "location_er_code"

    t.string "location_phone_number"

    t.string "location_mobile_number"

    t.string "location_fax_number"

    t.string "location_email_address"

    t.string "activity_ef_reimbursed_amount"

    t.integer "location_places_active"

    t.integer "location_places_active_current_commencement"

    t.string "place_id"

    t.integer "place_sequence_number"

    t.date "place_start_date"

    t.date "place_end_date"

    t.integer "place_duration"

    t.boolean "currently_active_place"

    t.string "place_status"

    t.date "place_status_date"

    t.boolean "place_claimed"

    t.date "date_claimed"

    t.boolean "place_claimed_pending_commencement"

    t.integer "days_since_claimed"

    t.string "claiming_organisation_code"

    t.integer "claiming_site_id"

    t.integer "place_referrals"

    t.integer "place_commencements"

    t.integer "place_current_commencements"

    t.string "place_utilisation"

    t.string "wfd_fee_paid_to_provider"

    t.integer "location_place_available"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.string "sourcing_organisation_name"

    t.string "claiming_organisation_name"

    t.string "lead_provider_organisation_name"

    t.string "organisation_code"

    t.string "organisation_name"

    t.string "supervising_office_name"

    t.string "host_type_description"

    t.integer "sourcing_site_id"

    t.string "created_by_user_ess_identifier"

    t.string "updated_by_user_ess_identifier"

    t.string "site_name"

    t.string "site_code"

    t.string "claiming_site_code"

    t.string "claiming_site_name"

    t.string "sourcing_site_code"

    t.string "sourcing_site_name"

    t.string "lead_provider_site_code"

    t.string "lead_provider_site_name"

  end

 

  table "appointments"

    t.integer "stream_participant_id", null: false

    t.integer "consultant_id"

    t.integer "created_by_id"

    t.integer "result_updated_by_id"

    t.date "ess_created_on"

    t.string "ess_identifier"

    t.string "session_ess_identifier"

    t.date "scheduled_on", null: false

    t.string "start_time", null: false

    t.string "end_time", null: false

    t.string "type", null: false

    t.string "format_info"

    t.string "reason"

    t.string "interpreter_language"

    t.string "result_type"

    t.datetime "result_updated_at"

    t.date "result_ess_updated_on"

    t.boolean "imported_from_ess", default: false, null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.string "consultant_name"

    t.string "location"

    t.string "next_appointment_reason"

    t.string "des_program_type"

    t.string "timeslot_ess_identifier"

    t.string "next_appointment_type"

    t.date "next_appointment_date"

  end

 

  table "apprenticeship_actives"

    t.integer "placement_id", null: false

    t.integer "apprenticeship_id", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "apprenticeships"

    t.integer "host_company_id", null: false

    t.integer "placement_id", null: false

    t.integer "contact_id"

    t.date "start_date"

    t.date "end_date"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "assessment_outcomes"

    t.string "type", null: false

    t.integer "from", null: false

    t.integer "to"

    t.string "text", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.string "status"

    t.uuid "smart_form_id"

  end

 

  table "attachments"

    t.integer "user_id"

    t.integer "attachable_id", null: false

    t.string "attachable_type", limit: 255, null: false

    t.string "file", limit: 512, null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.text "tags", default: [], array: true

    t.datetime "deleted_at"

    t.boolean "jobseeker_portal_accessible", default: false

    t.string "previous_system_identifier"

    t.string "user_type"

    t.string "av_status", default: "unknown", null: false

    t.datetime "av_timestamp"

    t.string "av_signature"

  end

 

  table "bank_accounts"

    t.string "encrypted_name", null: false

    t.string "encrypted_name_iv", null: false

    t.string "encrypted_number", null: false

    t.string "encrypted_number_iv", null: false

    t.string "encrypted_bsb", null: false

    t.string "encrypted_bsb_iv", null: false

    t.datetime "deleted_at"

  end

 

  table "batches"

    t.string "batch_type", null: false

    t.json "parameters"

    t.string "status", default: "created", null: false

    t.json "failures", default: []

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "caseloads"

    t.integer "site_id", null: false

    t.string "stream_type", null: false

    t.integer "commenced", default: 0, null: false

    t.integer "pending", default: 0, null: false

    t.integer "year", null: false

    t.integer "month", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "claim_ccu_change_reasons"

    t.string "reason"

    t.string "workflow_state"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "claim_ess_identifiers"

    t.string "ess_identifier"

    t.string "entity_type"

    t.integer "entity_id"

    t.datetime "created_at"

    t.datetime "updated_at"

  end

 

  table "claim_rate_types"

    t.string "claimable_type", null: false

    t.string "rate_type_code", null: false

    t.string "rate_type", null: false

    t.datetime "created_at"

    t.datetime "updated_at"

    t.string "programme", default: "jobActive"

  end

 

  table "claim_transitions"

    t.string "to_state", null: false

    t.json "metadata", default: {}

    t.integer "sort_key", null: false

    t.integer "claim_id", null: false

    t.boolean "most_recent", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "claims"

    t.string "ess_identifier"

    t.integer "placement_id"

    t.boolean "special"

    t.string "invoice_number"

    t.string "recovery_reason"

    t.decimal "amount", null: false

    t.decimal "gst", null: false

    t.decimal "approved_amount", null: false

    t.string "rate_type"

    t.string "base_rate_type"

    t.string "status"

    t.date "updated_on"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.string "type"

    t.date "due_on"

    t.integer "week_number"

    t.string "state"

    t.integer "jobseeker_id"

    t.integer "expense_id"

    t.integer "site_id"

    t.string "rate_type_code"

    t.string "status_code"

    t.date "ess_created_on"

    t.date "status_date"

    t.string "base_rate_type_code"

    t.integer "created_by_id"

    t.datetime "deleted_at"

    t.datetime "state_updated_at"

    t.string "outcome_type"

    t.boolean "psv", default: false

    t.integer "submitted_to_ccu_by_id"

    t.datetime "submitted_to_ccu_at"

    t.integer "assigned_to_id"

    t.datetime "assigned_at"

    t.string "activity_id"

    t.string "programme", default: "jobActive"

    t.string "anchor_id"

    t.date "anchor_date"

    t.date "start_date"

    t.date "end_date"

    t.date "available_date"

    t.string "placement_type"

    t.date "forecast_date"

  end

 

  table "claims_weekly_snapshots"

    t.integer "site_id", null: false

    t.date "week_starting_on"

    t.float "week4_outstanding_amount"

    t.float "week12_outstanding_amount"

    t.float "week26_outstanding_amount"

    t.integer "week4_outstanding_count"

    t.integer "week12_outstanding_count"

    t.integer "week26_outstanding_count"

    t.float "week4_lodged_amount"

    t.float "week12_lodged_amount"

    t.float "week26_lodged_amount"

    t.integer "week4_lodged_count"

    t.integer "week12_lodged_count"

    t.integer "week26_lodged_count"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "companies"

    t.integer "site_id"

    t.string "name", null: false

    t.string "abn"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.string "company_type"

    t.string "email"

    t.datetime "details_updated_at"

    t.string "ess_identifier"

    t.string "address_line_1"

    t.string "address_line_2"

    t.string "address_line_3"

    t.string "address_suburb"

    t.string "address_state"

    t.string "address_postcode"

    t.string "phone_area_code"

    t.string "phone_number"

    t.string "phone_extension"

    t.string "fax_area_code"

    t.string "fax_number"

    t.string "anzsic_code"

    t.string "status", default: "Active", null: false

    t.date "ess_created_on"

    t.date "ess_updated_on"

    t.date "ess_extracted_on"

    t.datetime "status_updated_at"

    t.datetime "address_updated_at"

    t.datetime "contact_details_updated_at"

    t.string "contact_name"

    t.float "latitude"

    t.float "longitude"

    t.string "external_reference", default: ""

    t.string "abn_name"

    t.integer "parent_id"

    t.string "level", default: "employer"

    t.datetime "account_manager_updated_at"

    t.integer "account_manager_id"

    t.integer "region_id"

    t.string "activity_status", default: "prospect"

    t.boolean "optional_abn", default: false

    t.string "entity_type"

    t.text "ess_comment"

    t.integer "recruitment_coordinator_id"

    t.boolean "active", default: true

    t.text "comments"

    t.text "tags", default: [], array: true

    t.boolean "do_not_use", default: false

    t.integer "marked_as_not_used_by_id"

    t.datetime "marked_as_not_used_at"

    t.string "anzsic_code_second"

    t.text "contact_preferences"

    t.integer "contact_preferences_updated_by_id"

    t.datetime "contact_preferences_updated_at"

    t.boolean "default_own_organisation"

    t.boolean "default_related_entity"

    t.boolean "employer_privacy_guide_provided"

    t.text "previous_system_identifiers", default: [], array: true

  end

 

  table "company_types", force: :cascade do |t|

    t.string "company_type", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "contact_types"

    t.string "name", null: false

  end

 

  table "contacts"

    t.boolean "primary"

    t.string "title", null: false

    t.string "position"

    t.string "first_name", null: false

    t.string "middle_names"

    t.string "last_name", null: false

    t.string "email"

    t.string "mobile_phone_number"

    t.string "office_phone_number"

    t.integer "contactable_id"

    t.string "contactable_type"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.string "status", default: "Active"

    t.boolean "mailing_list"

    t.text "comments"

    t.boolean "ess_employer_contact"

    t.integer "contact_type_id"

    t.string "relationship"

    t.datetime "deleted_at"

    t.string "organisation_name"

    t.string "address_lines"

    t.string "address_suburb"

    t.string "address_state"

    t.string "address_postcode"

    t.text "previous_system_identifiers", default: [], array: true

    t.bigint "created_by_id"

  end

 

  table "contacts_jobseeker_portal_privacy_document_consents"

    t.integer "contact_id", null: false

    t.integer "jobseeker_portal_privacy_document_consent_id", null: false

  end

 

  table "custom_expense_types"

    t.string "code", null: false

    t.string "description", null: false

    t.boolean "active", default: true, null: false

    t.string "programme", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.integer "gl_account_code"

    t.boolean "wage_subsidy", default: false, null: false

    t.boolean "employment_fund", default: false

    t.text "description_of_purchase"

    t.boolean "claimable", default: false, null: false

    t.boolean "second_approval_required", default: false

  end

 

  table "des_placements"

    t.date "phase_start_date"

    t.date "placement_verification_date"

    t.string "previous_phase"

    t.integer "phase_duration_in_weeks"

    t.string "phase_status"

    t.string "site_specialisation_code"

    t.string "current_des_funding_level"

    t.string "des_funding_level_at_placement"

    t.string "benchmark_hours_at_placement"

    t.string "current_benchmark_hours"

    t.boolean "suspended"

    t.boolean "volunteer"

    t.string "placement_hours_worked"

    t.date "semester_1_start_date"

    t.date "semester_1_end_date"

    t.date "semester_2_start_date"

    t.date "semester_2_end_date"

    t.string "contact_hours_per_week"

    t.string "w13_outcome_not_payable_reason"

    t.string "w26_outcome_not_payable_reason"

    t.string "des_program_type"

    t.string "modern_awards"

    t.string "federal_minimum_wage"

    t.date "result_entered_on"

    t.string "activity_name"

    t.string "activity_status"

    t.string "activity_placement_status"

    t.date "activity_placement_actual_start_date"

    t.date "activity_placement_actual_end_date"

    t.date "pps_phase_start_date"

    t.datetime "created_at"

    t.datetime "updated_at"

  end

 

  table "document_library_files", force: :cascade do |t|

    t.bigint "user_id"

    t.string "file", limit: 512, null: false

    t.datetime "deleted_at"

    t.text "categories", default: [], array: true

    t.string "av_status", default: "unknown", null: false

    t.datetime "av_timestamp"

    t.string "av_signature"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "elcapitan_tenant_configurations"

    t.text "name", null: false

    t.text "value", null: false

    t.datetime "created_at"

    t.datetime "updated_at"

  end

 

  table "email_templates"

    t.string "name", null: false

    t.text "content", null: false

    t.text "types", default: [], array: true

    t.datetime "deleted_at"

    t.string "subject"

    t.datetime "created_at"

    t.datetime "updated_at"

  end

 

  table "emails"

    t.text "subject", null: false

    t.text "body", null: false

    t.integer "user_id", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.string "emailable_type"

    t.integer "emailable_id"

    t.string "to"

    t.string "from"

    t.string "cc"

    t.string "bcc"

    t.string "reply_to"

    t.text "html_body"

    t.text "text_body"

    t.datetime "received_at"

    t.date "follow_up_date"

    t.string "previous_system_identifier"

    t.integer "reminder_id"

    t.string "status", default: "in_progress", null: false

    t.string "message_id"

    t.json "headers", default: {}, null: false

  end

 

  table "embed_reports"

    t.string "name"

    t.string "url"

    t.text "embed_code"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "employment_properties"

    t.string "name", null: false

    t.string "resource_type", null: false

    t.string "field_type", default: "text", null: false

    t.boolean "filterable", default: false, null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "employment_property_options", force: :cascade do |t|

    t.bigint "employment_property_id"

    t.string "name", null: false

    t.string "category"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "employment_property_options_jobseekers"

    t.bigint "employment_property_option_id", null: false

    t.bigint "jobseeker_id", null: false

  end

 

  table "employment_property_options_vacancies"

    t.bigint "employment_property_option_id", null: false

    t.bigint "vacancy_id", null: false

  end

 

  table "entity_programmes"

    t.integer "entity_id", null: false

    t.string "entity_type", null: false

    t.string "programme", null: false

  end

 

  table "ess_access_tokens"

    t.string "access_token"

    t.string "refresh_token"

    t.string "expires_at"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "ess_users"

    t.integer "site_id", null: false

    t.string "ess_identifier", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "events"

    t.integer "eventable_id"

    t.string "eventable_type"

    t.jsonb "data", default: {}, null: false

    t.string "type", null: false

    t.datetime "timestamp", null: false

  end

 

  table "evidence_attachments"

    t.string "file", null: false

    t.integer "user_id", null: false

    t.integer "placement_id", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.string "status", default: "review", null: false

    t.integer "updated_by_id"

    t.string "stage"

    t.text "status_comments"

    t.datetime "status_updated_at"

    t.datetime "deleted_at"

    t.integer "deleted_by_id"

    t.text "tags", default: [], array: true

    t.string "av_status", default: "unknown", null: false

    t.datetime "av_timestamp"

    t.string "av_signature"

  end

 

  table "expense_approvals"

    t.integer "expense_id"

    t.string "approval_level"

    t.integer "approver_id"

    t.datetime "approved_at"

    t.text "comment"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "expense_credit_cards"

    t.string "name", null: false

    t.string "code", null: false

    t.string "last_four_digits", limit: 4, null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.datetime "deleted_at"

  end

 

  table "expense_exports"

    t.integer "created_by_id", null: false

    t.string "type", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "expense_imports"

    t.integer "created_by_id"

    t.boolean "processed", default: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.integer "expense_export_id"

  end

 

  table "expense_payment_types"

    t.string "name", null: false

    t.boolean "active", default: true

    t.string "finance_system_code"

    t.datetime "created_at"

    t.datetime "updated_at"

    t.boolean "credit_card_payment"

    t.boolean "bank_details_required", default: false

    t.boolean "nat_exportable", default: false, null: false

    t.boolean "gst_not_applicable", default: false, null: false

    t.boolean "autofill_invoice_details", default: false, null: false

    t.integer "company_id"

  end

 

  table "expenses"

    t.date "occurred_on", null: false

    t.integer "company_id"

    t.integer "jobseeker_id"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.integer "created_by_id"

    t.string "type", default: "other", null: false

    t.string "status", default: "pending", null: false

    t.integer "approver_id"

    t.date "approved_on"

    t.text "justification"

    t.boolean "related_entity", default: false

    t.boolean "own_organisation", default: false

    t.decimal "invoice_gst", default: "0.0"

    t.decimal "invoice_total", default: "0.0"

    t.date "invoice_date"

    t.string "invoice_number"

    t.decimal "claim_amount", default: "0.0"

    t.decimal "total", default: "0.0"

    t.decimal "gst", default: "0.0"

    t.json "properties", default: {}

    t.string "export_state", default: "waiting_for_approval"

    t.string "finance_status", default: "in_progress"

    t.boolean "gst_applied", default: true

    t.datetime "cancelled_at"

    t.integer "cancelled_by_id"

    t.integer "second_approver_id"

    t.date "second_approved_on"

    t.integer "rejected_by_id"

    t.date "rejected_on"

    t.json "type_properties", default: {}

    t.string "claim_ess_identifier"

    t.string "commitment_id"

    t.boolean "invoice_paid", default: false

    t.string "withdrawal_reason"

    t.datetime "withdrawn_at"

    t.integer "withdrawn_by_id"

    t.integer "updated_by_id"

    t.string "cancel_reason"

    t.integer "expense_credit_card_id"

    t.boolean "provider_to_pay"

    t.datetime "finance_system_export_created_at"

    t.integer "expense_payment_type_id"

    t.datetime "invoice_number_updated_at"

    t.integer "invoice_number_updated_by_id"

    t.integer "site_id"

    t.string "new_company_trading_name"

    t.string "new_company_abn"

    t.integer "indigenous_mentoring_activity_id"

    t.integer "marked_as_supplier_paid_by_id"

    t.datetime "marked_as_supplier_paid_at"

    t.datetime "claimed_at"

    t.datetime "committed_at"

    t.string "claim_cancellation_reason"

    t.datetime "exported_for_bulk_commitment_at"

    t.boolean "invoice_gst_applied", default: true

    t.date "supplier_paid_on"

    t.datetime "exported_for_bulk_reimbursement_at"

    t.integer "original_expense_id"

    t.json "commitment_data", default: {}

    t.string "programme", default: "jobActive"

    t.text "tag", default: [], array: true

    t.string "previous_system_identifier"

    t.string "initial_stream"

    t.integer "bank_account_id"

    t.datetime "nat_export_created_at"

    t.string "new_company_address"

    t.string "new_company_contact"

    t.string "new_company_contact_phone"

    t.integer "purchase_order_id"

    t.integer "supplier_purchase_order_id"

    t.boolean "mismatching_payment_imports"

    t.datetime "payment_details_imported_at"

    t.date "invoice_actual_date_of_service"

  end

 

  table "exportling_exports"

    t.integer "owner_id"

    t.string "klass", null: false

    t.string "status", default: "created", null: false

    t.string "file_type", null: false

    t.string "output"

    t.text "params"

    t.datetime "created_at"

    t.datetime "updated_at"

    t.string "name", default: "", null: false

    t.datetime "started_at"

    t.datetime "completed_at"

  end

 

  table "filter_bar_configurations"

    t.integer "user_id", null: false

    t.string "page", null: false

    t.text "columns", default: [], null: false, array: true

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "imported_documents"

    t.string "file"

    t.integer "batch_id"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "intervention_detail_templates"

    t.string "name"

    t.text "content"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "interviews"

    t.integer "jobseeker_id"

    t.integer "vacancy_id"

    t.datetime "scheduled_for", null: false

    t.text "comments", null: false

    t.string "result"

    t.text "result_comments"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "job_categories"

    t.json "fetch_attributes"

    t.string "category"

    t.string "sub_category"

    t.datetime "created_at"

    t.datetime "updated_at"

  end

 

  table "job_end_reasons"

    t.string "name"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "jobseeker_portal_contact_us_query_types"

    t.string "query_type", null: false

  end

 

  table "jobseeker_portal_links"

    t.string "href"

    t.string "title"

    t.string "description"

    t.datetime "created_at"

    t.datetime "updated_at"

    t.string "logo"

  end

 

  table "jobseeker_portal_logs"

    t.datetime "last_login_at", null: false

    t.integer "user_id", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "jobseeker_portal_privacy_document_consents"

    t.integer "user_id"

    t.integer "privacy_document_id"

    t.string "decision"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.integer "agreed_by_id"

    t.datetime "agreed_at"

    t.string "agreed_from_ip"

    t.integer "privacy_document_file_id"

    t.bigint "archived_by_id"

    t.inet "archived_from_ip"

    t.datetime "archived_at"

  end

 

  table "jobseeker_portal_privacy_document_files"

    t.integer "privacy_document_id"

    t.string "file", limit: 512, null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.string "av_status", default: "unknown", null: false

    t.datetime "av_timestamp"

    t.string "av_signature"

  end

 

  table "jobseeker_portal_privacy_documents"

    t.string "name", null: false

    t.text "description"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.text "upper_description"

    t.integer "order_number"

    t.string "mandatory_state", default: "mandatory", null: false

    t.boolean "jobactive", default: true

    t.boolean "des", default: false

  end

 

  table "jobseeker_portal_users"

    t.integer "jobseeker_id", null: false

    t.boolean "active", default: false, null: false

    t.string "first_name"

    t.string "last_name"

    t.string "preferred_name"

    t.string "mobile_phone_number"

    t.boolean "currently_employed", default: false, null: false

    t.string "consultant_first_name"

    t.string "consultant_last_name"

    t.string "email"

    t.string "crypted_password"

    t.string "password_salt"

    t.string "persistence_token"

    t.string "perishable_token"

    t.integer "login_count", default: 0, null: false

    t.integer "failed_login_count", default: 0, null: false

    t.datetime "last_request_at"

    t.datetime "current_login_at"

    t.datetime "last_login_at"

    t.string "current_login_ip"

    t.string "last_login_ip"

    t.datetime "created_at"

    t.datetime "updated_at"

    t.uuid "uuid"

    t.datetime "terms_and_conditions_accepted_at"

    t.datetime "password_changed_at"

    t.datetime "deleted_at"

    t.datetime "locked_at"

    t.integer "locked_by_id"

    t.string "unique_session_id", limit: 32

  end

 

  table "jobseeker_suggestion_rejection_reasons"

    t.string "name", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "jobseeker_suggestions"

    t.integer "jobseeker_id"

    t.integer "vacancy_id"

    t.integer "suggested_by_id"

    t.text "comments"

    t.string "result"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.text "result_comments"

    t.integer "rejection_reason_id"

  end

 

  table "jobseekers"

    t.integer "site_id", null: false

    t.string "ess_identifier"

    t.string "title"

    t.string "first_name"

    t.string "middle_names"

    t.string "last_name"

    t.string "email"

    t.string "gender"

    t.date "date_of_birth"

    t.string "nationality"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.string "country_of_birth"

    t.string "residential_address_lines"

    t.string "residential_address_suburb"

    t.string "residential_address_state"

    t.string "residential_address_postcode"

    t.string "postal_address_lines"

    t.string "postal_address_suburb"

    t.string "postal_address_state"

    t.string "postal_address_postcode"

    t.date "ess_created_on"

    t.date "ess_updated_on"

    t.string "mobile_phone"

    t.string "community_name"

    t.string "country_of_birth_code"

    t.string "interpreter_language"

    t.string "interpreter_language_code"

    t.string "education"

    t.string "education_code"

    t.string "home_phone"

    t.string "home_fax"

    t.string "centrelink_reference_number"

    t.date "resume_completed_on"

    t.date "resume_last_updated_on"

    t.date "employment_pathway_plan_started_on"

    t.date "jsci_last_updated_on"

    t.boolean "principle_parent_carer"

    t.boolean "sensitive", default: false, null: false

    t.string "licence_type"

    t.string "licence_type_code"

    t.integer "job_ready", default: 0, null: false

    t.json "categories", default: {}, null: false

    t.string "hub_invitation_url"

    t.boolean "hub_invitation_accepted", default: false

    t.float "latitude"

    t.float "longitude"

    t.integer "search_distance", default: 25

    t.date "discover_u_started_at"

    t.date "discover_u_stopped_at"

    t.date "last_provider_rating_date"

    t.datetime "deleted_at"

    t.text "comments"

    t.string "referring_organisation"

    t.text "why_choose"

    t.integer "referral_source_id"

    t.integer "registered_by_id"

    t.integer "second_user_id"

    t.date "job_plan_last_update_date"

    t.date "archive_date"

    t.text "tags", default: [], array: true

    t.text "previous_system_identifiers", default: [], array: true

    t.boolean "direct_registration", default: false, null: false

    t.integer "why_choose_id"

    t.text "transitioning_programmes", default: [], array: true

    t.text "private_comment"

    t.string "programme"

    t.string "job_match_headline"

    t.text "job_match_summary"

    t.integer "referring_company_id"

    t.text "action_plan_goal"

    t.boolean "unsubscribed_from_bulk_emails", default: false

  end

 

  table "letters_letter_heads"

    t.string "name", null: false

    t.string "file", null: false

    t.boolean "enabled", default: true

    t.datetime "deleted_at"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "letters_letter_templates"

    t.integer "letter_head_id"

    t.string "name", null: false

    t.text "content", null: false

    t.float "margin_top", default: 0.0, null: false

    t.float "margin_right", default: 0.0, null: false

    t.float "margin_bottom", default: 0.0, null: false

    t.float "margin_left", default: 0.0, null: false

    t.string "orientation", null: false

    t.string "page_size", null: false

    t.datetime "deleted_at"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.text "categories", default: [], array: true

  end

 

  table "letters_letters"

    t.string "letterable_type", null: false

    t.integer "letterable_id", null: false

    t.integer "created_by_id", null: false

    t.integer "letter_head_id"

    t.string "name", null: false

    t.text "content", null: false

    t.float "margin_top", default: 0.0, null: false

    t.float "margin_right", default: 0.0, null: false

    t.float "margin_bottom", default: 0.0, null: false

    t.float "margin_left", default: 0.0, null: false

    t.string "orientation", null: false

    t.string "page_size", null: false

    t.datetime "deleted_at"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.integer "letter_template_id"

  end

 

  table "licence_requirements"

    t.string "requirement", null: false

    t.datetime "deleted_at"

  end

 

  table "line_items"

    t.string "description", null: false

    t.decimal "quantity", null: false

    t.decimal "price", null: false

    t.json "properties", default: {}, null: false

    t.integer "expense_id", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.boolean "gst_applied", default: false

    t.string "previous_system_identifier"

  end

 

  table "locations"

    t.string "address_line_1", null: false

    t.string "address_line_2"

    t.string "suburb", null: false

    t.string "state", null: false

    t.string "postcode", null: false

    t.integer "resource_id"

    t.string "resource_type"

    t.datetime "created_at"

    t.datetime "updated_at"

  end

 

  table "note_templates"

    t.string "name", null: false

    t.text "content"

    t.datetime "deleted_at"

    t.string "template_type", default: "basic", null: false

    t.json "form_fields", default: []

    t.text "categories", default: [], array: true

  end

 

  table "notes"

    t.integer "user_id", null: false

    t.string "noteable_type", null: false

    t.integer "noteable_id", null: false

    t.text "comments", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.text "tags", default: [], array: true

    t.datetime "occurred_at"

    t.integer "version", default: 1, null: false

    t.integer "updated_by_id"

    t.datetime "deleted_at"

    t.string "deletion_reason"

    t.date "deprecated_occurred_on"

    t.boolean "private_note", default: false

    t.integer "time_spent"

    t.integer "travel_time"

    t.integer "attachment_id"

    t.date "follow_up_date"

    t.string "previous_system_identifier"

    t.integer "reminder_id"

    t.string "template_type", default: "basic", null: false

    t.boolean "confidential", default: false, null: false

  end

 

  table "old_passwords", force: :cascade do |t|

    t.string "password_archivable_type", null: false

    t.integer "password_archivable_id", null: false

    t.string "encrypted_password", null: false

    t.string "password_salt"

    t.datetime "created_at"

    t.datetime "updated_at"

  end

 

  table "patches_patches"

    t.string "path", null: false

    t.datetime "created_at"

    t.datetime "updated_at"

  end

 

  table "permissible_breaks"

    t.integer "placement_id", null: false

    t.date "start_date"

    t.date "end_date"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "placements"

    t.integer "referral_id"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.integer "managed_by_id"

    t.string "outcome_description"

    t.boolean "upgraded"

    t.date "upgraded_on"

    t.date "started_on"

    t.date "job_ended_on"

    t.integer "weeks_unemployed"

    t.string "type"

    t.string "declaration_result"

    t.string "evidence_status"

    t.date "centrelink_outcome_started_on"

    t.integer "site_id"

    t.string "stream_type"

    t.string "phase_type"

    t.string "placement_type"

    t.boolean "indigenous"

    t.string "wage_subsidy_type"

    t.boolean "ws_vacancy_eligibility"

    t.string "ws_agreement_id"

    t.string "bdf_resource_id"

    t.string "risk_assessment_score"

    t.string "outcome_type", default: "Full"

    t.string "outcome_not_pay_reason"

    t.datetime "deleted_at"

    t.date "twenty_six_week_outcome_started_on"

    t.date "permissible_break_one"

    t.date "permissible_break_two"

    t.date "ess_calculated_outcome_started_on"

    t.date "overridden_outcome_started_on"

    t.datetime "outcome_start_date_overridden_at"

    t.integer "outcome_start_date_overridden_by_id"

    t.date "next_pps_due_date"

    t.string "pps_frequency"

    t.text "pps_comment"

    t.integer "pps_updated_by_id"

    t.datetime "pps_updated_at"

    t.integer "pps_managed_by_id"

    t.string "activity_id"

    t.string "activity_type"

    t.string "activity_sub_type"

    t.date "course_start_date"

    t.date "course_end_date"

    t.string "institution_name"

    t.string "institution_contact"

    t.string "institution_phone_number"

    t.integer "jobseeker_id"

    t.date "claim_due_date"

    t.boolean "tracking", default: false

    t.datetime "job_ended_on_at"

    t.integer "job_ended_on_by_id"

    t.string "ws_agreement_type"

    t.string "ws_agreement_status"

    t.integer "created_by_id"

    t.integer "programme_id"

    t.string "programme_type"

    t.text "comment"

    t.string "previous_system_identifier"

    t.integer "job_end_reason_id"

    t.string "tracking_behaviour", default: "default", null: false

    t.bigint "job_support_coach_id"

    t.bigint "employer_engagement_consultant_id"

    t.decimal "completion", precision: 5, scale: 2

    t.datetime "completion_updated_at"

    t.bigint "completion_updated_by_id"

    t.decimal "completion_expected", precision: 5, scale: 2

    t.datetime "completion_expected_updated_at"

    t.bigint "completion_expected_updated_by_id"

    t.string "programme", default: "jobActive"

    t.jsonb "additional_ess_data", default: {}, null: false

    t.string "os_frequency"

    t.date "next_os_due_date"

    t.text "tags", default: [], array: true

    t.integer "activity_sequence_number"where: "((deleted_at IS NULL) AND (referral_id IS NULL))"NULL) AND (referral_id IS NOT NULL))"

  end

 

  table "police_checks"

    t.integer "jobseeker_id"

    t.integer "requested_by_id"

    t.integer "ncc_id"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.datetime "result_received_at"

    t.string "result_type"

    t.string "reason"

  end

 

  table "pps_records"

    t.integer "schedule_id_old"

    t.integer "number_old"

    t.date "due_on"

    t.datetime "completed_at"

    t.integer "updated_by_id", null: false

    t.integer "managed_by_id", null: false

    t.string "form_id"

    t.string "form_submission_id"

    t.string "form_submission_sequence"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.string "type"

    t.text "comment"

    t.string "result"

    t.integer "placement_id"

    t.date "next_pps_due_date"

    t.date "contact_date"

    t.datetime "deleted_at"

    t.string "stage"

    t.string "form_submission_reference"

    t.string "phase_type"

    t.integer "time_spent"

    t.string "previous_system_identifier"

    t.string "deletion_reason"

  end

 

  table "professional_service_activities"

    t.integer "jobseeker_id", null: false

    t.integer "intervention_provided_by_id", null: false

    t.date "date_of_service", null: false

    t.text "identified_barriers"

    t.text "details_of_intervention", null: false

    t.integer "time_spent", null: false

    t.integer "travel_time"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.string "status"

    t.integer "actioned_by_id"

    t.datetime "actioned_at"

    t.text "reject_reason"

    t.integer "declaration_accepted_by_id"

    t.string "sti_type", null: false

    t.json "sti_store"

    t.text "description_of_services"

    t.integer "updated_by_id"

    t.integer "notified_user_id"

    t.integer "template_id"

  end

 

  table "professional_service_staff"

    t.integer "user_id"

    t.boolean "active", default: true, null: false

    t.string "title", null: false

    t.string "first_name", null: false

    t.string "last_name", null: false

    t.string "ahpra_number"

    t.string "qualification_type", null: false

  end

 

  table "programmes"

    t.string "name"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "programmes_users"

    t.integer "programme_id", null: false

    t.integer "user_id", null: false

  end

 

  table "provider_ratings"

    t.integer "jobseeker_id", null: false

    t.integer "value"

    t.text "comments"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "purchase_orders"

    t.integer "number_part", null: false

    t.string "prefix", default: "PO", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "quest_engine_pdf_templates", force: :cascade do |t|

    t.string "name", null: false

    t.string "file", null: false

    t.datetime "deleted_at"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "quest_fields"

    t.integer "section_id", null: false

    t.boolean "allows_multiple_responses"

    t.boolean "required", default: false

    t.string "label", null: false

    t.integer "element", null: false

    t.string "default", default: "", null: false

    t.integer "sort", null: false

    t.hstore "preferences", default: {}, null: false

    t.text "help_text", default: "", null: false

    t.boolean "allow_comments", default: true

    t.datetime "created_at"

    t.datetime "updated_at"

    t.string "name", default: "", null: false

    t.string "merge_field"

    t.integer "previous_question_id"

    t.string "previous_question_value"

    t.boolean "locked_merge_value", default: false, null: false

    t.jsonb "choices", default: {}, null: false

    t.jsonb "scores", default: {}, null: false

    t.datetime "deleted_at"

  end

 

  table "quest_form_versions"

    t.uuid "form_id", null: false

    t.uuid "versioned_form_id", null: false

    t.datetime "versioned_at", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "quest_forms"

    t.string "name"

    t.text "description"

    t.integer "template_id"

    t.boolean "published", default: false

    t.datetime "created_at"

    t.datetime "updated_at"

    t.datetime "deleted_at"

    t.text "help_text"

    t.text "tags", array: true

    t.string "merge_fields_context"

    t.string "type", null: false

  end

 

  table "quest_forms_smart_forms"

    t.uuid "quest_form_id", null: false

    t.uuid "smart_form_id", null: false

  end

 

  table "quest_images"

    t.string "title", default: "", null: false

    t.string "file", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "quest_public_form_submission_tokens"

    t.datetime "submitted_at"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.uuid "quest_submission_id", null: false

  end

 

  table "quest_sections"

    t.uuid "form_id", null: false

    t.string "name", null: false

    t.integer "sort", null: false

    t.datetime "created_at"

    t.datetime "updated_at"

    t.integer "position"

    t.text "description"

    t.datetime "deleted_at"

  end

 

  table "quest_submission_meta"

    t.uuid "submission_id", null: false

    t.jsonb "data"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "quest_submission_view_tokens"

    t.uuid "quest_submission_id"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "quest_submissions"

    t.uuid "form_id", null: false

    t.integer "submittable_id"

    t.string "submittable_type"

    t.json "values"

    t.datetime "created_at"

    t.datetime "updated_at"

    t.integer "user_id"

    t.string "reference", default: ""

    t.string "user_agent", default: "", null: false

    t.inet "ip_address"

    t.string "referrer", default: "", null: false

    t.string "client_sequence"

    t.decimal "score", default: "0.0"

    t.datetime "completed_at"

    t.datetime "deleted_at"

    t.datetime "locked_at"

    t.string "locked_notice"

    t.uuid "versioned_form_id"

  end

 

  table "quest_tags"

    t.uuid "form_id", null: false

    t.string "value", null: false

    t.datetime "created_at"

    t.datetime "updated_at"

  end

 

  table "quest_templates"

    t.string "name", null: false

    t.text "description"

    t.json "options"

    t.string "layout"

    t.text "content"

    t.datetime "created_at"

    t.datetime "updated_at"

  end

 

  table "quest_tenants"

    t.string "name", null: false

    t.string "domain", null: false

    t.string "database", null: false

    t.boolean "enabled", default: false, null: false

    t.datetime "created_at"

    t.datetime "updated_at"

  end

 

  table "referral_sources"

    t.string "name", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "referrals"

    t.integer "vacancy_id", null: false

    t.integer "stream_participant_id", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.string "ess_identifier"

    t.integer "created_by_id"

    t.date "referred_on"

    t.string "result_status"

    t.date "result_entered_on"

    t.date "result_effective_on"

    t.date "ess_created_on"

    t.integer "jobseeker_id", null: false

    t.datetime "deleted_at"

    t.string "site_type"

    t.integer "site_id"

    t.integer "verifying_update_user_id"

    t.date "verifying_updated_on"

    t.integer "referral_creation_site_id"

    t.integer "vacancy_owning_site_id"

    t.integer "vacancy_creation_user_id"

    t.string "vacancy_referral_end_reason"

    t.date "vacancy_referral_ended_on"

    t.json "batch_data"

  end

 

  table "regions"

    t.string "name"

    t.datetime "deleted_at"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "reminders"

    t.integer "remindable_id", null: false

    t.string "remindable_type", null: false

    t.text "description", null: false

    t.integer "created_by_id", null: false

    t.integer "assigned_to_id", null: false

    t.integer "completed_by_id"

    t.datetime "completed_at"

    t.datetime "due_at_unfixed"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.integer "repeat_id"

    t.datetime "deleted_at"

    t.string "type", default: "Reminder", null: false

    t.datetime "due_at"

    t.integer "updated_by_id"

    t.text "tags", default: [], array: true

    t.boolean "jobseeker_to_action", default: false, null: false

    t.text "comment"

  end

 

  table "repeats"

    t.text "schedule", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.boolean "active", default: true, null: false

  end

 

  table "resume_attachments"

    t.string "file", null: false

    t.integer "user_id"

    t.integer "stream_participant_id", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.datetime "deleted_at"

    t.string "previous_system_identifier"

    t.string "av_status", default: "unknown", null: false

    t.datetime "av_timestamp"

    t.string "av_signature"

  end

 

  table "reverse_marketing_activities"

    t.integer "jobseeker_id", null: false

    t.integer "created_by_id", null: false

    t.integer "company_id"

    t.text "details_of_conversation", null: false

    t.string "result", null: false

    t.datetime "next_contact_at"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.string "previous_system_identifier"

  end

 

  table "reverse_marketing_activity_results", force: :cascade do |t|

    t.string "result", null: false

  end

 

  table "saved_searches"

    t.integer "user_id", null: false

    t.text "resource_type", null: false

    t.text "search_title", null: false

    t.text "filters"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.datetime "deleted_at"

  end

 

  table "scanned_document_images"

    t.integer "scanned_document_id"

    t.integer "serial_number"

    t.string "file"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "scanned_documents"

    t.string "file"

    t.integer "batch_id"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "schedules"

    t.string "form_id"

    t.string "interval", null: false

    t.integer "managed_by_id", null: false

    t.integer "updated_by_id", null: false

    t.date "started_on", null: false

    t.integer "schedulable_id", null: false

    t.string "schedulable_type", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.string "type"

    t.boolean "completed", default: false

    t.datetime "completed_at"

    t.integer "completed_by_id"

  end

 

  table "settings"

    t.integer "four_week_target"

    t.integer "twelve_week_target"

    t.integer "twenty_six_week_target"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.integer "placement_target"

    t.string "business_rules_document"

    t.string "jobseeker_portal_email_invitation_subject"

    t.text "jobseeker_portal_email_invitation_body"

    t.text "jobseeker_portal_sms_invitation_body"

    t.text "jobseeker_portal_terms_and_conditions"

    t.text "jobseeker_portal_welcome_message"

    t.json "vacancy_jobs_board_custom_fields", default: {}, null: false

    t.string "default_pps_schedule_interval", default: "Fortnightly"

    t.integer "unsuccessful_pps_days_offset", default: 1, null: false

    t.string "pps_schedule_interval_stream_a", default: "Fortnightly"

    t.string "pps_schedule_interval_stream_a_volunteer", default: "Fortnightly"

    t.string "pps_schedule_interval_stream_b", default: "Weekly"

    t.string "pps_schedule_interval_stream_c", default: "Weekly"

    t.boolean "use_placement_next_pps_due_date_for_unsuccessful_contacts", default: false

    t.string "next_pps_due_date_type", default: "contact_date"

    t.string "pps_schedule_interval_indigenous", default: "Weekly"

    t.integer "vacancy_recently_created_period_in_days", default: 20, null: false

    t.integer "indigenous_mentoring_expense_payment_type_id"

    t.integer "indigenous_mentoring_company_id"

    t.string "finance_system"

    t.string "whitelisted_emails", default: [], array: true

    t.string "intercepted_emails_to", default: [], array: true

    t.boolean "intercept_emails", default: false

    t.jsonb "support_types_requiring_forms", default: {}, null: false

    t.jsonb "trackable_placement_forms", default: {}, null: false

    t.integer "number_of_characters_per_sms", default: 160, null: false

    t.integer "number_of_sms_per_message"

    t.integer "allied_health_company_id"

    t.integer "expense_tolerance_percent"

    t.string "flexible_ongoing_support", default: "Fortnightly"

    t.string "moderate_ongoing_support", default: "Monthly"

    t.string "high_ongoing_support", default: "Monthly"

    t.jsonb "placement_creation", default: {}, null: false

    t.integer "session_timeout_in_seconds"

    t.string "private_note_color", default: "#ec7500"

    t.text "sso_saml_metadata_xml"

    t.text "sso_saml_x509_public_key"

    t.text "sso_saml_x509_private_key"

    t.boolean "force_sso", default: false, null: false

    t.string "sms_mobile_number_whitelist", default: [], array: true

    t.string "default_email_signature_logo"

  end

 

  table "short_message_replies"

    t.integer "short_message_id", null: false

    t.text "content", null: false

    t.string "number", null: false

    t.datetime "received_at", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "short_messages"

    t.integer "recipient_id", null: false

    t.integer "user_id", null: false

    t.string "status", null: false

    t.text "content", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.string "number", default: "", null: false

    t.string "client_id"

    t.string "recipient_type"

    t.string "previous_system_identifier"

    t.date "follow_up_date"

    t.integer "reminder_id"

  end

 

  table "short_urls"

    t.string "alias", null: false

    t.string "long_url", null: false

  end

 

  table "site_groupings"

    t.string "name"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.string "level", default: "first"

    t.string "logo"

  end

 

  table "site_groupings_users"

    t.integer "site_grouping_id", null: false

    t.integer "user_id", null: false

  end

 

  table "sites"

    t.string "name", null: false

    t.string "ess_identifier", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.integer "location_id"

    t.text "tags", default: [], array: true

    t.string "phone"

    t.string "contract_sequence_number"

    t.boolean "active", default: true, null: false

    t.integer "site_grouping_id"

    t.integer "second_level_site_grouping_id"

    t.string "contract_ess_identifier"

    t.integer "site_manager_id"

    t.string "email"

    t.string "finance_code"

  end

 

  table "smart_forms"

    t.uuid "quest_form_id", null: false

    t.string "name"

    t.string "category"

    t.string "programme"

    t.datetime "created_at"

    t.datetime "updated_at"

    t.boolean "can_complete_again", default: false, null: false

  end

 

  table "sms_templates"

    t.string "name", null: false

    t.text "content", null: false

    t.datetime "deleted_at"

    t.text "categories", default: [], array: true

    t.boolean "editable", default: true

  end

 

  table "smtp_settings", force: :cascade do |t|

    t.string "address"

    t.integer "port"

    t.string "user_name"

    t.string "encrypted_password"

    t.string "encrypted_password_iv"

    t.string "authentication"

    t.string "enable_starttls_auto"

    t.string "noreply_email"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "stream_participant_versions", force: :cascade do |t|

    t.string "item_type", null: false

    t.bigint "item_id", null: false

    t.string "event", null: false

    t.string "whodunnit"

    t.json "object"

    t.json "object_changes"

    t.datetime "created_at"

    t.date "anchor_date"

    t.string "des_program_type_code"

    t.string "funding_level_code"

    t.bigint "managed_by_id"

    t.string "ongoing_support_level_code"

    t.string "phase"

    t.boolean "phase_changed"

    t.date "phase_commenced_on"

    t.bigint "site_id"

    t.string "status"

    t.boolean "status_changed"

  end

 

  table "stream_participants"

    t.string "stage", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.integer "jobseeker_id", null: false

    t.string "service"

    t.string "status"

    t.integer "managed_by_id"

    t.string "contract_ess_identifier"

    t.date "ess_last_synced_on"

    t.date "suspended_on"

    t.date "exited_on"

    t.date "placed_on"

    t.date "ended_on"

    t.date "commenced_on"

    t.date "registered_on"

    t.date "referred_on"

    t.string "allowance_type"

    t.string "allowance_rate"

    t.date "allowance_started_on"

    t.date "allowance_ended_on"

    t.date "work_experience_phase_pending_on"

    t.string "special_requirements"

    t.boolean "indigenous"

    t.boolean "apprentice_trainee"

    t.boolean "mature_age"

    t.boolean "refuge_humanitarian_visa"

    t.boolean "remote"

    t.boolean "culturally_and_linguistically_diverse"

    t.boolean "participation_requirement"

    t.date "next_diary_appointment_scheduled_on"

    t.date "work_experience_phase_commenced_on"

    t.integer "time_in_stream"

    t.integer "time_in_program"

    t.integer "time_in_site"

    t.integer "time_in_provider"

    t.string "employment_pathway_plan_status"

    t.string "outcome"

    t.string "registration_eligibility"

    t.string "next_diary_appointment_session_type"

    t.date "last_job_placement_referred_on"

    t.boolean "referred_to_activity", default: false

    t.string "employment_service_area"

    t.string "labour_market_region"

    t.string "specialisation"

    t.string "community_code"

    t.string "community"

    t.boolean "redundant_worker"

    t.boolean "vulnerable_youth"

    t.boolean "vulnerable_youth_student"

    t.boolean "career_advice_eligible"

    t.boolean "cap_eligible"

    t.date "volunteer_exit_expected_on"

    t.string "end_reason"

    t.integer "sequence"

    t.string "status_description"

    t.string "phase"

    t.date "phase_commenced_on"

    t.date "phase_ended_on"

    t.integer "weeks_unemployed", default: 0

    t.date "registered_as_unemployed_on"

    t.integer "placement_sequence"

    t.boolean "aar_activity"

    t.integer "aar_hours_required"

    t.boolean "aar_met"

    t.boolean "aar_required"

    t.boolean "wfd_priority"

    t.date "job_plan_started_on"

    t.string "job_plan_status"

    t.date "suspension_end_on"

    t.string "suspension_reason_code"

    t.string "suspension_reason_description"

    t.boolean "disability"

    t.boolean "homeless"

    t.boolean "mental_illness"

    t.boolean "cald"

    t.boolean "spi"

    t.boolean "early_school_leaver"

    t.boolean "pre_release_prisoner"

    t.boolean "ex_offender"

    t.boolean "regional"

    t.string "wage_subsidy_type"

    t.boolean "wage_subsidy_eligible"

    t.boolean "new_enterprise_incentive_scheme"

    t.boolean "ess_initial_interview"

    t.string "jsci_status"

    t.string "transition_code"

    t.string "last_compl_rpt_outcome_desc"

    t.string "last_appointment_result"

    t.integer "time_in_phase"

    t.datetime "deleted_at"

    t.string "participation_requirement_code"

    t.integer "sub_status_id"

    t.string "programme"

    t.jsonb "additional_ess_data", default: {}, null: false

  end

 

  table "sub_statuses"

    t.string "name", null: false

    t.string "status"

  end

 

  table "supplier_purchase_orders"

    t.integer "company_id", null: false

    t.integer "expense_credit_card_id"

    t.integer "expense_payment_type_id", null: false

    t.date "occurred_on", null: false

    t.boolean "related_entity", null: false

    t.boolean "own_organisation", null: false

    t.boolean "provider_to_pay", null: false

    t.text "justification", null: false

    t.datetime "created_at"

    t.datetime "updated_at"

    t.integer "reviewer_id"

    t.integer "created_by_id"

    t.integer "approver_id"

    t.string "status", default: "pending", null: false

    t.date "reviewed_on"

    t.text "review_comment"

    t.integer "purchase_order_id"

    t.string "reject_reason"

  end

 

  table "system_email_templates"

    t.string "email_type"

    t.string "name"

    t.string "subject"

    t.text "text_template"

    t.text "html_template"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "tags"

    t.string "name", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.text "categories", default: [], array: true

    t.string "entity"

  end

 

  table "temp_pps_records"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.integer "actioned_by_id"

    t.string "form_id"

    t.integer "placement_id"

    t.text "params", null: false

  end

 

  table "tenants"

    t.string "name", null: false

    t.string "domain", null: false

    t.string "database", null: false

    t.boolean "enabled", default: false, null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.string "logo"

    t.integer "load_priority"

    t.string "login_logo"

  end

 

  table "time_logs"

    t.integer "site_id"

    t.integer "user_id", null: false

    t.integer "created_by_id", null: false

    t.integer "updated_by_id", null: false

    t.text "comments"

    t.datetime "started_at", null: false

    t.datetime "ended_at", null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "user_expense_approval_limits"

    t.integer "user_id"

    t.string "programme", null: false

    t.boolean "wage_subsidy", null: false

    t.integer "approval_limit", default: 0, null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "users"

    t.citext "email", default: "", null: false

    t.datetime "remember_created_at"

    t.string "uid", default: "", null: false

    t.string "avatar_url"

    t.string "access_token"

    t.datetime "access_token_expires_at"

    t.string "first_name", default: "", null: false

    t.string "last_name", default: "", null: false

    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", null: false

    t.datetime "created_at", null: false

    t.datetime "locked_at"

    t.boolean "can_view_confidential_notes", 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"

    t.integer "sign_in_count", default: 0, null: false

    t.datetime "current_sign_in_at"

    t.datetime "last_sign_in_at"

    t.inet "current_sign_in_ip"

    t.inet "last_sign_in_ip"

    t.datetime "password_changed_at"

    t.string "unique_session_id", limit: 20

    t.string "invitation_token"

    t.datetime "invitation_created_at"

    t.datetime "invitation_sent_at"

    t.datetime "invitation_accepted_at"

    t.integer "invitation_limit"

    t.integer "invited_by_id"

    t.string "invited_by_type"

    t.integer "invitations_count", default: 0

    t.integer "failed_attempts", default: 0, null: false

    t.boolean "can_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"

    t.datetime "confirmation_sent_at"

    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 "can_access_employers", default: true, null: false

    t.boolean "can_access_contacts", default: true, 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

  end

 

  table "vacancies"

    t.string "job_title", null: false

    t.text "job_description"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.string "job_ess_identifier"

    t.string "occupation"

    t.string "status", default: "Active", null: false

    t.string "work_type"

    t.string "type"

    t.date "ess_created_on"

    t.date "ess_deactiviated_on"

    t.datetime "details_updated_at"

    t.datetime "status_updated_at"

    t.datetime "limit_updated_at"

    t.string "to_apply"

    t.json "categories", default: {}, null: false

    t.integer "company_id"

    t.integer "position_limit", default: 1, null: false

    t.integer "referrals_made", default: 0, null: false

    t.integer "placements_made", default: 0, null: false

    t.string "tenure"

    t.boolean "found_own_employment", default: false, null: false

    t.string "site_ess_identifier"

    t.text "requirements"

    t.date "start_on"

    t.date "end_on"

    t.string "remuneration"

    t.string "working_time"

    t.text "dress_requirements"

    t.string "transport"

    t.string "interview_times"

    t.string "display", default: "N", null: false

    t.integer "site_id"

    t.string "outcome_level"

    t.string "duration"

    t.string "placement_type"

    t.integer "job_placement_officer_id"

    t.integer "contact_id"

    t.string "address_suburb"

    t.string "address_state"

    t.string "address_postcode"

    t.string "salary"

    t.integer "licence_requirement_id"

    t.json "jobs_board_custom_fields", default: {}, null: false

    t.integer "created_by_id"

    t.boolean "ongoing", default: false

    t.boolean "minimum_wage_verified", default: false

    t.string "programme", default: "jobActive"

    t.string "hours_description"

    t.string "contract_type_code"

    t.string "previous_system_identifier"

    t.text "comment"

    t.json "batch_data"

  end

 

  table "vacancy_checklist_items"

    t.integer "vacancy_id"

    t.text "description"

    t.datetime "created_at"

    t.datetime "updated_at"

  end

 

  table "verification_sources"

    t.string "name", null: false

    t.boolean "active", default: true

    t.datetime "created_at"

    t.datetime "updated_at"

  end

 

  table "versions"

    t.string "item_type", null: false

    t.integer "item_id", null: false

    t.string "event", null: false

    t.string "whodunnit"

    t.text "yaml_object"

    t.datetime "created_at"

    t.text "yaml_object_changes"

    t.json "object"

    t.json "object_changes"

  end

 

  table "voucher_types", force: :cascade do |t|

    t.string "name", null: false

    t.boolean "electronic", default: false, null: false

    t.boolean "gst", default: false, null: false

    t.boolean "active", default: false, null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "wage_histories"

    t.integer "placement_id", null: false

    t.date "pay_period_ending_date", null: false

    t.decimal "hours_worked", null: false

    t.decimal "rate"

    t.decimal "gross_income"

    t.text "comments"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

    t.integer "verification_source_id"

    t.integer "attachment_id"

    t.string "previous_system_identifier"

    t.integer "user_id"

    t.integer "updated_by_id"

    t.string "stage", default: [], array: true

    t.date "pay_period_start_date"

    t.datetime "deleted_at"

  end

 

  table "why_chooses"

    t.string "name"

    t.datetime "deleted_at"

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

  table "widget_configurations"

    t.integer "user_id", null: false

    t.string "widget_name", null: false

    t.boolean "enabled", default: true, null: false

    t.datetime "created_at", null: false

    t.datetime "updated_at", null: false

  end

 

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.