Back to Table list

Table tasks

Columns

  id
      bigserial


  appeal_id
      int4


  appeal_type
      varchar


  assigned_at
      timestamp


  assigned_by_id
      int4


  assigned_to_id
      int4


  assigned_to_type
      varchar


  cancellation_reason
      varchar


  cancelled_by_id
      int4


  closed_at
      timestamp


  completed_by_id
      int4


  created_at
      timestamp


  instructions
      _text


  parent_id
      int4


  placed_on_hold_at
      timestamp


  started_at
      timestamp


  status
      varchar


  type
      varchar


  updated_at
      timestamp


Associations

depends on

  tasks
  n:1
  on 
 A.parent_id=B.id

  users
  n:1
  on 
 tasks.assigned_by_id=users.id

  users
  n:1
  on 
 tasks.cancelled_by_id=users.id

 
has dependent

  distributed_cases
  1:n
  on 
 distributed_cases.task_id=tasks.id

  docket_switches
  1:n
  on 
 docket_switches.task_id=tasks.id

  hearing_task_associations
  1:n
  on 
 hearing_task_associations.hearing_task_id=tasks.id

  post_decision_motions
  1:n
  on 
 post_decision_motions.task_id=tasks.id

  task_timers
  1:n
  on 
 task_timers.task_id=tasks.id

  tasks
  1:n
  on 
 B.parent_id=A.id

 
is associated with

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

  legacy_appeals
  1:n
  on 
 tasks.appeal_id=legacy_appeals.id AND tasks.appeal_type='LegacyAppeal'

  organizations
  1:n
  on 
 tasks.assigned_to_id=organizations.id AND tasks.assigned_to_type='Organization'

  users
  1:n
  on 
 tasks.assigned_to_id=users.id AND tasks.assigned_to_type='User'

Closure

  distance 0

 
 tasks

  distance 1

 
 appeals, distributed_cases, docket_switches, hearing_task_associations, legacy_appeals, organizations, post_decision_motions, task_timers, users

  distance 2

 
 advance_on_docket_motions, annotations, appeal_series, 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, document_views, end_product_establishments, end_product_updates, hearing_appeal_stream_snapshots, hearing_days, hearing_email_recipients, hearing_views, hearings, ihp_drafts, intakes, job_notes, judge_case_reviews, legacy_hearings, membership_requests, messages, metrics, nod_date_updates, organizations_users, ramp_election_rollbacks, ramp_issues, record_synced_by_jobs, request_issues, request_issues_updates, schedule_periods, sent_hearing_email_events, special_issue_lists, split_correlation_tables, supplemental_claims, system_admin_events, unrecognized_appellants, user_quotas, vbms_communication_packages, vbms_distribution_destinations, vbms_distributions, vbms_uploaded_documents, virtual_hearings, vso_configs, work_modes, worksheet_issues

  distance 3

 
 allocations, cavc_decision_reasons, cavc_selection_bases, certification_cancellations, claim_establishments, end_product_code_updates, hearing_issue_notes, hearing_locations, higher_level_reviews, legacy_issue_optins, legacy_issues, non_availabilities, people, priority_end_product_sync_queue, ramp_elections, ramp_refilings, remand_reasons, request_decision_issues, sent_hearing_admin_email_events, team_quotas, transcriptions, unrecognized_party_details, veterans, virtual_hearing_establishments

  distance 4

 
 batch_processes, caseflow_stuck_records, ramp_closed_appeals