Back to Table list

Table appeals

Columns

  id
      bigserial


  aod_based_on_age
      bool


  changed_hearing_request_type
      varchar


  closest_regional_office
      varchar


  created_at
      timestamp


  docket_range_date
      date


  docket_type
      varchar


  established_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


  homelessness
      bool


  legacy_opt_in_approved
      bool


  original_hearing_request_type
      varchar


  poa_participant_id
      varchar


  receipt_date
      date


  stream_docket_number
      varchar


  stream_type
      varchar


  target_decision_date
      date


  updated_at
      timestamp


  uuid
      uuid


  veteran_file_number
      varchar


  veteran_is_not_claimant
      bool


Associations

has dependent

  appellant_substitutions
  1:n
  on 
 appellant_substitutions.source_appeal_id=appeals.id

  appellant_substitutions
  1:n
  on 
 appellant_substitutions.target_appeal_id=appeals.id

  board_grant_effectuations
  1:n
  on 
 board_grant_effectuations.appeal_id=appeals.id

  cavc_remands
  1:n
  on 
 cavc_remands.source_appeal_id=appeals.id

  cavc_remands
  1:n
  on 
 cavc_remands.remand_appeal_id=appeals.id

  docket_switches
  1:n
  on 
 docket_switches.old_docket_stream_id=appeals.id

  docket_switches
  1:n
  on 
 docket_switches.new_docket_stream_id=appeals.id

  hearings
  1:n
  on 
 hearings.appeal_id=appeals.id

  nod_date_updates
  1:n
  on 
 nod_date_updates.appeal_id=appeals.id

  post_decision_motions
  1:n
  on 
 post_decision_motions.appeal_id=appeals.id

 
is associated with

  advance_on_docket_motions
  n:m
  on 
 advance_on_docket_motions.appeal_id=appeals.id AND advance_on_docket_motions.appeal_type='Appeal'

  appeal_states
  1:1
  on 
 appeal_states.appeal_id=appeals.id AND appeal_states.appeal_type='Appeal'

  appeal_views
  n:1
  on 
 appeal_views.appeal_id=appeals.id AND appeal_views.appeal_type='Appeal'

  attorney_case_reviews
  n:1
  on 
 attorney_case_reviews.appeal_id=appeals.id AND attorney_case_reviews.appeal_type='Appeal'

  available_hearing_locations
  n:1
  on 
 available_hearing_locations.appeal_id=appeals.id AND available_hearing_locations.appeal_type='Appeal'

  claimants
  n:1
  on 
 claimants.decision_review_id=appeals.id AND claimants.decision_review_type='Appeal'

  claims_folder_searches
  n:1
  on 
 claims_folder_searches.appeal_id=appeals.id AND claims_folder_searches.appeal_type='Appeal'

  decision_documents
  n:1
  on 
 decision_documents.appeal_id=appeals.id AND decision_documents.appeal_type='Appeal'

  decision_issues
  n:1
  on 
 decision_issues.decision_review_id=appeals.id AND decision_issues.decision_review_type='Appeal'

  hearing_email_recipients
  n:m
  on 
 hearing_email_recipients.appeal_id=appeals.id AND hearing_email_recipients.appeal_type='Appeal'

  ihp_drafts
  n:m
  on 
 ihp_drafts.appeal_id=appeals.id AND ihp_drafts.appeal_type='Appeal'

  intakes
  1:1
  on 
 intakes.detail_id=appeals.id AND intakes.detail_type='Appeal'

  judge_case_reviews
  n:1
  on 
 judge_case_reviews.appeal_id=appeals.id AND judge_case_reviews.appeal_type='Appeal'

  ramp_issues
  n:m
  on 
 ramp_issues.review_id=appeals.id AND ramp_issues.review_type='Appeal'

  record_synced_by_jobs
  1:1
  on 
 record_synced_by_jobs.record_id=appeals.id AND record_synced_by_jobs.record_type='Appeal'

  request_issues
  n:1
  on 
 request_issues.decision_review_id=appeals.id AND request_issues.decision_review_type='Appeal'

  request_issues_updates
  n:1
  on 
 request_issues_updates.review_id=appeals.id AND request_issues_updates.review_type='Appeal'

  special_issue_lists
  1:1
  on 
 special_issue_lists.appeal_id=appeals.id AND special_issue_lists.appeal_type='Appeal'

  supplemental_claims
  n:m
  on 
 supplemental_claims.decision_review_remanded_id=appeals.id AND supplemental_claims.decision_review_remanded_type='Appeal'

  tasks
  n:1
  on 
 tasks.appeal_id=appeals.id AND tasks.appeal_type='Appeal'

  vbms_uploaded_documents
  n:1
  on 
 vbms_uploaded_documents.appeal_id=appeals.id AND vbms_uploaded_documents.appeal_type='Appeal'

  work_modes
  1:1
  on 
 work_modes.appeal_id=appeals.id AND work_modes.appeal_type='Appeal'

Closure

  distance 0

 
 appeals

  distance 1

 
 advance_on_docket_motions, appeal_states, appeal_views, appellant_substitutions, attorney_case_reviews, available_hearing_locations, board_grant_effectuations, cavc_remands, claimants, claims_folder_searches, decision_documents, decision_issues, docket_switches, hearing_email_recipients, hearings, ihp_drafts, intakes, judge_case_reviews, nod_date_updates, post_decision_motions, ramp_issues, record_synced_by_jobs, request_issues, request_issues_updates, special_issue_lists, supplemental_claims, tasks, vbms_uploaded_documents, work_modes

  distance 2

 
 cavc_dashboards, cavc_remands_appellant_substitutions, distributed_cases, end_product_establishments, end_product_updates, hearing_days, hearing_issue_notes, hearing_locations, hearing_task_associations, hearing_views, higher_level_reviews, job_notes, legacy_appeals, legacy_hearings, legacy_issue_optins, legacy_issues, messages, organizations, people, ramp_elections, ramp_refilings, remand_reasons, request_decision_issues, sent_hearing_email_events, task_timers, transcriptions, unrecognized_appellants, users, vbms_communication_packages, veterans, virtual_hearings

  distance 3

 
 annotations, appeal_series, cavc_dashboard_dispositions, cavc_dashboard_issues, cavc_dispositions_to_reasons, cavc_reasons_to_bases, certifications, conference_links, dispatch_tasks, distributions, document_views, end_product_code_updates, hearing_appeal_stream_snapshots, membership_requests, metrics, organizations_users, priority_end_product_sync_queue, ramp_closed_appeals, ramp_election_rollbacks, schedule_periods, sent_hearing_admin_email_events, split_correlation_tables, system_admin_events, unrecognized_party_details, user_quotas, vbms_distribution_destinations, vbms_distributions, virtual_hearing_establishments, vso_configs, worksheet_issues

  distance 4

 
 allocations, batch_processes, caseflow_stuck_records, cavc_decision_reasons, cavc_selection_bases, certification_cancellations, claim_establishments, non_availabilities, team_quotas