Back to Table list

Table certifications

Columns

	id		serial
	already_certified		bool
	bgs_rep_address_line_1		varchar
	bgs_rep_address_line_2		varchar
	bgs_rep_address_line_3		varchar
	bgs_rep_city		varchar
	bgs_rep_country		varchar
	bgs_rep_state		varchar
	bgs_rep_zip		varchar
	bgs_representative_name		varchar
	bgs_representative_type		varchar
	certification_date		varchar
	certifying_office		varchar
	certifying_official_name		varchar
	certifying_official_title		varchar
	certifying_username		varchar
	completed_at		timestamp
	created_at		timestamp
	form8_started_at		timestamp
	form9_matching_at		timestamp
	form9_type		varchar
	hearing_change_doc_found_in_vbms		bool
	hearing_preference		varchar
	loading_data		bool
	loading_data_failed		bool
	nod_matching_at		timestamp
	poa_correct_in_bgs		bool
	poa_correct_in_vacols		bool
	poa_matches		bool
	representative_name		varchar
	representative_type		varchar
	soc_matching_at		timestamp
	ssocs_matching_at		timestamp
	ssocs_required		bool
	updated_at		timestamp
	user_id		int4
	v2		bool
	vacols_data_missing		bool
	vacols_hearing_preference		varchar
	vacols_id		varchar
	vacols_representative_name		varchar
	vacols_representative_type		varchar

Associations

	depends on
	users		n:1	on	certifications.user_id=users.id
	has dependent
	certification_cancellations		1:n	on	certification_cancellations.certification_id=certifications.id

Closure

	distance 0				certifications
	distance 1				certification_cancellations, users
	distance 2				advance_on_docket_motions, annotations, appeal_states, appeal_views, appellant_substitutions, attorney_case_reviews, cavc_dashboard_dispositions, cavc_dashboard_issues, cavc_dashboards, cavc_dispositions_to_reasons, cavc_reasons_to_bases, cavc_remands, cavc_remands_appellant_substitutions, 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 3				allocations, appeals, board_grant_effectuations, cavc_decision_reasons, cavc_selection_bases, 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 4				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 5				remand_reasons