Back to Table list

Table cavc_decision_reasons

Columns

  id
      bigserial



  basis_for_selection_category
      varchar



  created_at
      timestamp



  decision_reason
      varchar



  "order"
      int4



  parent_decision_reason_id
      int4



Associations

depends on

  cavc_decision_reasons
  n:1
 on 
A.parent_decision_reason_id=B.id

 
has dependent


  cavc_decision_reasons
  1:n
 on 
B.parent_decision_reason_id=A.id

  cavc_dispositions_to_reasons
  1:n
 on 
cavc_dispositions_to_reasons.cavc_decision_reason_id=cavc_decision_reasons.id

Closure

  distance 0

 
cavc_decision_reasons

  distance 1

 
cavc_dispositions_to_reasons

  distance 2

 
cavc_dashboard_dispositions, cavc_reasons_to_bases, users

  distance 3

 
advance_on_docket_motions, annotations, appeal_states, appeal_views, appellant_substitutions, attorney_case_reviews, cavc_dashboard_issues, cavc_dashboards, cavc_remands, cavc_remands_appellant_substitutions, cavc_selection_bases, certifications, claims_folder_searches, conference_links, dispatch_tasks, distributions, document_views, end_product_establishments, end_product_updates, hearing_days, hearing_views, hearings, intakes, job_notes, judge_case_reviews, legacy_hearings, membership_requests, messages, metrics, nod_date_updates, organizations_users, ramp_election_rollbacks, request_issues_updates, schedule_periods, sent_hearing_email_events, split_correlation_tables, system_admin_events, tasks, unrecognized_appellants, user_quotas, vbms_communication_packages, vbms_distribution_destinations, vbms_distributions, virtual_hearings

  distance 4

 
allocations, appeals, board_grant_effectuations, certification_cancellations, claim_establishments, claimants, decision_documents, distributed_cases, docket_switches, end_product_code_updates, hearing_appeal_stream_snapshots, hearing_email_recipients, hearing_issue_notes, hearing_locations, hearing_task_associations, higher_level_reviews, legacy_appeals, non_availabilities, organizations, people, post_decision_motions, priority_end_product_sync_queue, ramp_elections, ramp_refilings, request_issues, sent_hearing_admin_email_events, supplemental_claims, task_timers, team_quotas, transcriptions, unrecognized_party_details, vbms_uploaded_documents, veterans, virtual_hearing_establishments

  distance 5

 
appeal_series, available_hearing_locations, batch_processes, caseflow_stuck_records, decision_issues, ihp_drafts, legacy_issue_optins, legacy_issues, ramp_closed_appeals, ramp_issues, record_synced_by_jobs, request_decision_issues, special_issue_lists, vso_configs, work_modes, worksheet_issues

  distance 6

 
remand_reasons