Table request_issues

Columns

	id		bigserial
	benefit_type		varchar
	closed_at		timestamp
	closed_status		varchar
	contention_reference_id		int4
	contention_removed_at		timestamp
	contention_updated_at		timestamp
	contested_decision_issue_id		int4
	contested_issue_description		varchar
	contested_rating_decision_reference_id		varchar
	contested_rating_issue_diagnostic_code		varchar
	contested_rating_issue_profile_date		varchar
	contested_rating_issue_reference_id		varchar
	corrected_by_request_issue_id		int4
	correction_type		varchar
	covid_timeliness_exempt		bool
	created_at		timestamp
	decision_date		date
	decision_date_added_at		timestamp
	decision_review_id		int8
	decision_review_type		varchar
	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
	edited_description		varchar
	end_product_establishment_id		int4
	ineligible_due_to_id		int8
	ineligible_reason		varchar
	is_predocket_needed		bool
	is_unidentified		bool
	nonrating_issue_category		varchar
	nonrating_issue_description		varchar
	notes		text
	ramp_claim_id		varchar
	rating_issue_associated_at		timestamp
	split_issue_status		varchar
	type		varchar
	unidentified_issue_text		varchar
	untimely_exemption		bool
	untimely_exemption_notes		text
	updated_at		timestamp
	vacols_id		varchar
	vacols_sequence_id		int4
	verified_unidentified_issue		bool
	veteran_participant_id		varchar

Associations

depends on
decision_issues	n:1	on	request_issues.contested_decision_issue_id=decision_issues.id
end_product_establishments	n:1	on	request_issues.end_product_establishment_id=end_product_establishments.id
request_issues	n:1	on	A.corrected_by_request_issue_id=B.id
request_issues	n:1	on	A.ineligible_due_to_id=B.id
has dependent
hearing_issue_notes	1:n	on	hearing_issue_notes.request_issue_id=request_issues.id
legacy_issue_optins	1:n	on	legacy_issue_optins.request_issue_id=request_issues.id
legacy_issues	1:n	on	legacy_issues.request_issue_id=request_issues.id
request_decision_issues	1:n	on	request_decision_issues.request_issue_id=request_issues.id
request_issues	1:n	on	B.corrected_by_request_issue_id=A.id
request_issues	1:n	on	B.ineligible_due_to_id=A.id
is associated with
appeals	1:n	on	request_issues.decision_review_id=appeals.id AND request_issues.decision_review_type='Appeal'
higher_level_reviews	1:n	on	request_issues.decision_review_id=higher_level_reviews.id AND request_issues.decision_review_type='HigherLevelReview'
supplemental_claims	1:n	on	request_issues.decision_review_id=supplemental_claims.id AND request_issues.decision_review_type='SupplementalClaim'

Closure

	distance 0				request_issues
	distance 1				appeals, decision_issues, end_product_establishments, hearing_issue_notes, higher_level_reviews, legacy_issue_optins, legacy_issues, request_decision_issues, supplemental_claims
	distance 2				advance_on_docket_motions, appeal_states, appeal_views, appellant_substitutions, attorney_case_reviews, available_hearing_locations, board_grant_effectuations, cavc_remands, claimants, claims_folder_searches, decision_documents, docket_switches, end_product_code_updates, end_product_updates, hearing_email_recipients, hearings, ihp_drafts, intakes, job_notes, judge_case_reviews, messages, nod_date_updates, post_decision_motions, priority_end_product_sync_queue, ramp_elections, ramp_issues, ramp_refilings, record_synced_by_jobs, remand_reasons, request_issues_updates, special_issue_lists, tasks, users, vbms_uploaded_documents, work_modes
	distance 3				annotations, 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_days, hearing_locations, hearing_task_associations, hearing_views, legacy_appeals, legacy_hearings, membership_requests, 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_communication_packages, vbms_distribution_destinations, vbms_distributions, veterans, virtual_hearings
	distance 4				allocations, appeal_series, cavc_decision_reasons, cavc_selection_bases, certification_cancellations, claim_establishments, hearing_appeal_stream_snapshots, non_availabilities, sent_hearing_admin_email_events, team_quotas, unrecognized_party_details, virtual_hearing_establishments, vso_configs, worksheet_issues