Back to Table list

Table special_issue_lists

Columns

	id		bigserial
	appeal_id		int8
	appeal_type		varchar
	blue_water		bool
	burn_pit		bool
	contaminated_water_at_camp_lejeune		bool
	created_at		timestamp
	dic_death_or_accrued_benefits_united_states		bool
	education_gi_bill_dependents_educational_assistance_scholars		bool
	foreign_claim_compensation_claims_dual_claims_appeals		bool
	foreign_pension_dic_all_other_foreign_countries		bool
	foreign_pension_dic_mexico_central_and_south_america_caribb		bool
	hearing_including_travel_board_video_conference		bool
	home_loan_guaranty		bool
	incarcerated_veterans		bool
	insurance		bool
	manlincon_compliance		bool
	military_sexual_trauma		bool
	mustard_gas		bool
	national_cemetery_administration		bool
	no_special_issues		bool
	nonrating_issue		bool
	pension_united_states		bool
	private_attorney_or_agent		bool
	radiation		bool
	rice_compliance		bool
	spina_bifida		bool
	updated_at		timestamp
	us_court_of_appeals_for_veterans_claims		bool
	us_territory_claim_american_samoa_guam_northern_mariana_isla		bool
	us_territory_claim_philippines		bool
	us_territory_claim_puerto_rico_and_virgin_islands		bool
	vamc		bool
	vocational_rehab		bool
	waiver_of_overpayment		bool

Associations

	is associated with
	appeals		1:1	on	special_issue_lists.appeal_id=appeals.id AND special_issue_lists.appeal_type='Appeal'
	legacy_appeals		1:1	on	special_issue_lists.appeal_id=legacy_appeals.id AND special_issue_lists.appeal_type='LegacyAppeal'

Closure

	distance 0				special_issue_lists
	distance 1				appeals, legacy_appeals
	distance 2				advance_on_docket_motions, appeal_series, appeal_states, appeal_views, appellant_substitutions, attorney_case_reviews, available_hearing_locations, board_grant_effectuations, cavc_remands, claimants, claims_folder_searches, decision_documents, decision_issues, dispatch_tasks, docket_switches, hearing_appeal_stream_snapshots, hearing_email_recipients, hearings, ihp_drafts, intakes, judge_case_reviews, legacy_hearings, nod_date_updates, post_decision_motions, ramp_issues, record_synced_by_jobs, request_issues, request_issues_updates, supplemental_claims, tasks, vbms_uploaded_documents, work_modes, worksheet_issues
	distance 3				cavc_dashboards, cavc_remands_appellant_substitutions, claim_establishments, distributed_cases, end_product_establishments, end_product_updates, hearing_days, hearing_issue_notes, hearing_locations, hearing_task_associations, hearing_views, higher_level_reviews, job_notes, legacy_issue_optins, legacy_issues, messages, organizations, people, ramp_elections, ramp_refilings, remand_reasons, request_decision_issues, sent_hearing_email_events, task_timers, transcriptions, unrecognized_appellants, users, vbms_communication_packages, veterans, virtual_hearings
	distance 4				annotations, cavc_dashboard_dispositions, cavc_dashboard_issues, cavc_dispositions_to_reasons, cavc_reasons_to_bases, certifications, conference_links, distributions, document_views, end_product_code_updates, membership_requests, metrics, organizations_users, priority_end_product_sync_queue, 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
	distance 5				allocations, batch_processes, caseflow_stuck_records, cavc_decision_reasons, cavc_selection_bases, certification_cancellations, non_availabilities, team_quotas