Back to Table list

Table board_grant_effectuations

Columns

  id
      bigserial


  appeal_id
      int8


  contention_reference_id
      varchar


  created_at
      timestamp


  decision_document_id
      int8


  decision_sync_attempted_at
      timestamp


  decision_sync_canceled_at
      timestamp


  decision_sync_error
      varchar


  decision_sync_last_submitted_at
      timestamp


  decision_sync_processed_at
      timestamp


  decision_sync_submitted_at
      timestamp


  end_product_establishment_id
      int8


  granted_decision_issue_id
      int8


  last_submitted_at
      timestamp


  updated_at
      timestamp


Associations

depends on

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

  decision_documents
  n:1
  on 
 board_grant_effectuations.decision_document_id=decision_documents.id

  decision_issues
  n:1
  on 
 board_grant_effectuations.granted_decision_issue_id=decision_issues.id

  end_product_establishments
  n:1
  on 
 board_grant_effectuations.end_product_establishment_id=end_product_establishments.id

Closure

  distance 0

 
 board_grant_effectuations

  distance 1

 
 appeals, decision_documents, decision_issues, end_product_establishments

  distance 2

 
 advance_on_docket_motions, appeal_states, appeal_views, appellant_substitutions, attorney_case_reviews, available_hearing_locations, cavc_remands, claimants, claims_folder_searches, docket_switches, end_product_code_updates, end_product_updates, hearing_email_recipients, hearings, higher_level_reviews, ihp_drafts, intakes, judge_case_reviews, legacy_appeals, nod_date_updates, post_decision_motions, priority_end_product_sync_queue, ramp_elections, ramp_issues, ramp_refilings, record_synced_by_jobs, remand_reasons, request_decision_issues, request_issues, request_issues_updates, special_issue_lists, supplemental_claims, tasks, users, vbms_communication_packages, vbms_uploaded_documents, work_modes

  distance 3

 
 annotations, appeal_series, batch_processes, caseflow_stuck_records, cavc_dashboard_dispositions, cavc_dashboard_issues, cavc_dashboards, cavc_dispositions_to_reasons, cavc_reasons_to_bases, cavc_remands_appellant_substitutions, certifications, conference_links, dispatch_tasks, distributed_cases, distributions, document_views, hearing_appeal_stream_snapshots, hearing_days, hearing_issue_notes, hearing_locations, hearing_task_associations, hearing_views, job_notes, legacy_hearings, legacy_issue_optins, legacy_issues, membership_requests, messages, metrics, organizations, organizations_users, people, ramp_closed_appeals, ramp_election_rollbacks, schedule_periods, sent_hearing_email_events, split_correlation_tables, system_admin_events, task_timers, transcriptions, unrecognized_appellants, user_quotas, vbms_distribution_destinations, vbms_distributions, veterans, virtual_hearings, worksheet_issues

  distance 4

 
 allocations, cavc_decision_reasons, cavc_selection_bases, certification_cancellations, claim_establishments, non_availabilities, sent_hearing_admin_email_events, team_quotas, unrecognized_party_details, virtual_hearing_establishments, vso_configs