Caseflow Schema CSV
Caseflow Schema CSV # Source: http://department-of-veterans-affairs.github.io/caseflow/schema/make_docs/caseflow.csv Tables advance_on_docket_motions allocations annotations api_keys api_views appeals appeal_series appeal_states hearing_appeal_stream_snapshots appeal_views appellant_substitutions appellant_substitution_histories attorney_case_reviews available_hearing_locations batch_processes bgs_attorneys bgs_power_of_attorneys board_grant_effectuations cached_appeal_attributes cached_user_attributes caseflow_stuck_records cavc_dashboards cavc_dashboard_dispositions cavc_dashboard_issues cavc_decision_reasons cavc_dispositions_to_reasons cavc_reasons_to_bases cavc_remands cavc_remands_appellant_substitutions cavc_selection_bases certifications certification_cancellations claim_establishments claimants claims_folder_searches conference_links decision_documents decision_issues dispatch_tasks distributed_cases distributions docket_snapshots docket_switches docket_tracers documents document_views documents_tags end_product_code_updates end_product_establishments end_product_updates form8s global_admin_logins hearings hearing_days hearing_email_recipients hearing_issue_notes hearing_locations hearing_task_associations hearing_views higher_level_reviews ihp_drafts intakes job_notes judge_case_reviews legacy_appeals legacy_hearings legacy_issues legacy_issue_optins membership_requests messages metrics mpi_update_person_events nod_date_updates non_availabilities notifications notification_events organizations organizations_users people post_decision_motions priority_end_product_sync_queue ramp_closed_appeals ramp_elections ramp_election_rollbacks ramp_issues ramp_refilings record_synced_by_jobs remand_reasons request_decision_issues request_issues request_issues_updates schedule_periods sent_hearing_admin_email_events sent_hearing_email_events special_issue_lists split_correlation_tables supplemental_claims system_admin_events tags tasks task_timers team_quotas transcriptions unrecognized_appellants unrecognized_party_details users user_quotas vbms_communication_packages vbms_distributions vbms_distribution_destinations vbms_uploaded_documents veterans virtual_hearings virtual_hearing_establishments vso_configs work_modes worksheet_issues 'advance_on_docket_motions' table Column Type Required Unique Index Description appeal_id integer FK x The ID of the appeal this motion is associated with appeal_type string x The type of appeal this motion is associated with created_at datetime ∗ x granted boolean x Whether VLJ has determined that there is sufficient cause to fast-track an appeal, i. ...