Back to Table list

Table higher_level_reviews

Columns

  id
      bigserial


  benefit_type
      varchar


  created_at
      timestamp


  establishment_attempted_at
      timestamp


  establishment_canceled_at
      timestamp


  establishment_error
      varchar


  establishment_last_submitted_at
      timestamp


  establishment_processed_at
      timestamp


  establishment_submitted_at
      timestamp


  filed_by_va_gov
      bool


  informal_conference
      bool


  legacy_opt_in_approved
      bool


  receipt_date
      date


  same_office
      bool


  updated_at
      timestamp


  uuid
      uuid


  veteran_file_number
      varchar


  veteran_is_not_claimant
      bool


Associations

is associated with

  claimants
  n:1
  on 
 claimants.decision_review_id=higher_level_reviews.id AND claimants.decision_review_type='HigherLevelReview'

  decision_issues
  n:1
  on 
 decision_issues.decision_review_id=higher_level_reviews.id AND decision_issues.decision_review_type='HigherLevelReview'

  end_product_establishments
  n:1
  on 
 end_product_establishments.source_id=higher_level_reviews.id AND end_product_establishments.source_type='HigherLevelReview'

  end_product_updates
  n:m
  on 
 end_product_updates.original_decision_review_id=higher_level_reviews.id AND end_product_updates.original_decision_review_type='HigherLevelReview'

  intakes
  1:1
  on 
 intakes.detail_id=higher_level_reviews.id AND intakes.detail_type='HigherLevelReview'

  job_notes
  n:1
  on 
 job_notes.job_id=higher_level_reviews.id AND job_notes.job_type='HigherLevelReview'

  messages
  n:1
  on 
 messages.detail_id=higher_level_reviews.id AND messages.detail_type='HigherLevelReview'

  ramp_issues
  n:m
  on 
 ramp_issues.review_id=higher_level_reviews.id AND ramp_issues.review_type='HigherLevelReview'

  request_issues
  n:1
  on 
 request_issues.decision_review_id=higher_level_reviews.id AND request_issues.decision_review_type='HigherLevelReview'

  request_issues_updates
  n:1
  on 
 request_issues_updates.review_id=higher_level_reviews.id AND request_issues_updates.review_type='HigherLevelReview'

  supplemental_claims
  n:m
  on 
 supplemental_claims.decision_review_remanded_id=higher_level_reviews.id AND supplemental_claims.decision_review_remanded_type='HigherLevelReview'

Closure

  distance 0

 
 higher_level_reviews

  distance 1

 
 claimants, decision_issues, end_product_establishments, end_product_updates, intakes, job_notes, messages, ramp_issues, request_issues, request_issues_updates, supplemental_claims

  distance 2

 
 appeals, board_grant_effectuations, decision_documents, end_product_code_updates, hearing_issue_notes, legacy_issue_optins, legacy_issues, priority_end_product_sync_queue, ramp_elections, ramp_refilings, remand_reasons, request_decision_issues, unrecognized_appellants, users, veterans

  distance 3

 
 advance_on_docket_motions, annotations, appeal_states, appeal_views, appellant_substitutions, attorney_case_reviews, available_hearing_locations, batch_processes, caseflow_stuck_records, cavc_dashboard_dispositions, cavc_dashboard_issues, cavc_dashboards, cavc_dispositions_to_reasons, cavc_reasons_to_bases, cavc_remands, cavc_remands_appellant_substitutions, certifications, claims_folder_searches, conference_links, dispatch_tasks, distributions, docket_switches, document_views, hearing_days, hearing_email_recipients, hearing_views, hearings, ihp_drafts, judge_case_reviews, legacy_appeals, legacy_hearings, membership_requests, metrics, nod_date_updates, organizations_users, post_decision_motions, ramp_closed_appeals, ramp_election_rollbacks, record_synced_by_jobs, schedule_periods, sent_hearing_email_events, special_issue_lists, split_correlation_tables, system_admin_events, tasks, unrecognized_party_details, user_quotas, vbms_communication_packages, vbms_distribution_destinations, vbms_distributions, vbms_uploaded_documents, virtual_hearings, work_modes

  distance 4

 
 allocations, appeal_series, cavc_decision_reasons, cavc_selection_bases, certification_cancellations, claim_establishments, distributed_cases, hearing_appeal_stream_snapshots, hearing_locations, hearing_task_associations, non_availabilities, organizations, people, sent_hearing_admin_email_events, task_timers, team_quotas, transcriptions, virtual_hearing_establishments, worksheet_issues

  distance 5

 
 vso_configs