Back to Table list

Table hearings

Columns

  id
      bigserial



  appeal_id
      int4



  bva_poc
      varchar



  created_at
      timestamp



  created_by_id
      int8



  disposition
      varchar



  evidence_window_waived
      bool



  hearing_day_id
      int4



  judge_id
      int4



  military_service
      varchar



  notes
      varchar



  prepped
      bool



  representative_name
      varchar



  room
      varchar



  scheduled_time
      time



  summary
      text



  transcript_requested
      bool



  transcript_sent_date
      date



  updated_at
      timestamp



  updated_by_id
      int8



  uuid
      uuid



  witness
      varchar



Associations

depends on

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

  hearing_days
  n:1
 on 
hearings.hearing_day_id=hearing_days.id

  users
  n:1
 on 
hearings.judge_id=users.id

  users
  n:1
 on 
hearings.created_by_id=users.id

  users
  n:1
 on 
hearings.updated_by_id=users.id

 
has dependent


  hearing_issue_notes
  1:n
 on 
hearing_issue_notes.hearing_id=hearings.id

  transcriptions
  1:n
 on 
transcriptions.hearing_id=hearings.id

 
is associated with


  hearing_email_recipients
  n:m
 on 
hearing_email_recipients.hearing_id=hearings.id AND hearing_email_recipients.hearing_type='Hearing'

  hearing_locations
  1:1
 on 
hearing_locations.hearing_id=hearings.id AND hearing_locations.hearing_type='Hearing'

  hearing_task_associations
  1:1
 on 
hearing_task_associations.hearing_id=hearings.id AND hearing_task_associations.hearing_type='Hearing'

  hearing_views
  n:1
 on 
hearing_views.hearing_id=hearings.id AND hearing_views.hearing_type='Hearing'

  sent_hearing_email_events
  n:m
 on 
sent_hearing_email_events.hearing_id=hearings.id AND sent_hearing_email_events.hearing_type='Hearing'

  virtual_hearings
  1:1
 on 
virtual_hearings.hearing_id=hearings.id AND virtual_hearings.hearing_type='Hearing'

Closure

  distance 0

 
hearings

  distance 1

 
appeals, hearing_days, hearing_email_recipients, hearing_issue_notes, hearing_locations, hearing_task_associations, hearing_views, sent_hearing_email_events, transcriptions, users, virtual_hearings

  distance 2

 
advance_on_docket_motions, annotations, appeal_states, appeal_views, appellant_substitutions, attorney_case_reviews, available_hearing_locations, board_grant_effectuations, cavc_dashboard_dispositions, cavc_dashboard_issues, cavc_dashboards, cavc_dispositions_to_reasons, cavc_reasons_to_bases, cavc_remands, cavc_remands_appellant_substitutions, certifications, claimants, claims_folder_searches, conference_links, decision_documents, decision_issues, dispatch_tasks, distributions, docket_switches, document_views, end_product_establishments, end_product_updates, ihp_drafts, intakes, job_notes, judge_case_reviews, legacy_appeals, legacy_hearings, membership_requests, messages, metrics, nod_date_updates, organizations_users, post_decision_motions, ramp_election_rollbacks, ramp_issues, record_synced_by_jobs, request_issues, request_issues_updates, schedule_periods, sent_hearing_admin_email_events, special_issue_lists, split_correlation_tables, supplemental_claims, system_admin_events, tasks, unrecognized_appellants, user_quotas, vbms_communication_packages, vbms_distribution_destinations, vbms_distributions, vbms_uploaded_documents, virtual_hearing_establishments, work_modes

  distance 3

 
allocations, appeal_series, cavc_decision_reasons, cavc_selection_bases, certification_cancellations, claim_establishments, distributed_cases, end_product_code_updates, hearing_appeal_stream_snapshots, higher_level_reviews, legacy_issue_optins, legacy_issues, non_availabilities, organizations, people, priority_end_product_sync_queue, ramp_elections, ramp_refilings, remand_reasons, request_decision_issues, task_timers, team_quotas, unrecognized_party_details, veterans, worksheet_issues

  distance 4

 
batch_processes, caseflow_stuck_records, ramp_closed_appeals, vso_configs