Back to Table list

Table decision_issues

Columns

  id
      bigserial


  benefit_type
      varchar


  caseflow_decision_date
      date


  created_at
      timestamp


  decision_review_id
      int4


  decision_review_type
      varchar


  decision_text
      varchar


  deleted_at
      timestamp


  description
      varchar


  diagnostic_code
      varchar


  disposition
      varchar


  end_product_last_action_date
      date


  participant_id
      varchar


  percent_number
      varchar


  rating_issue_reference_id
      varchar


  rating_profile_date
      timestamp


  rating_promulgation_date
      timestamp


  subject_text
      text


  updated_at
      timestamp


Associations

has dependent

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

  remand_reasons
  1:n
  on 
 remand_reasons.decision_issue_id=decision_issues.id

  request_decision_issues
  1:n
  on 
 request_decision_issues.decision_issue_id=decision_issues.id

  request_issues
  1:n
  on 
 request_issues.contested_decision_issue_id=decision_issues.id

 
is associated with

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

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

  supplemental_claims
  1:n
  on 
 decision_issues.decision_review_id=supplemental_claims.id AND decision_issues.decision_review_type='SupplementalClaim'

Closure

  distance 0

 
 decision_issues

  distance 1

 
 appeals, board_grant_effectuations, higher_level_reviews, remand_reasons, request_decision_issues, request_issues, supplemental_claims

  distance 2

 
 advance_on_docket_motions, appeal_states, appeal_views, appellant_substitutions, attorney_case_reviews, available_hearing_locations, cavc_remands, claimants, claims_folder_searches, decision_documents, docket_switches, end_product_establishments, end_product_updates, hearing_email_recipients, hearing_issue_notes, hearings, ihp_drafts, intakes, job_notes, judge_case_reviews, legacy_issue_optins, legacy_issues, messages, nod_date_updates, post_decision_motions, ramp_issues, record_synced_by_jobs, request_issues_updates, special_issue_lists, tasks, vbms_uploaded_documents, work_modes

  distance 3

 
 cavc_dashboards, cavc_remands_appellant_substitutions, distributed_cases, end_product_code_updates, hearing_days, hearing_locations, hearing_task_associations, hearing_views, legacy_appeals, legacy_hearings, organizations, people, priority_end_product_sync_queue, ramp_elections, ramp_refilings, sent_hearing_email_events, task_timers, transcriptions, unrecognized_appellants, users, vbms_communication_packages, veterans, virtual_hearings

  distance 4

 
 annotations, appeal_series, batch_processes, caseflow_stuck_records, cavc_dashboard_dispositions, cavc_dashboard_issues, cavc_dispositions_to_reasons, cavc_reasons_to_bases, certifications, conference_links, dispatch_tasks, distributions, document_views, hearing_appeal_stream_snapshots, membership_requests, metrics, organizations_users, 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 5

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