Database Query Registry - department-of-veterans-affairs/caseflow GitHub Wiki

This page lists database queries used to address data and metric requests.

To facilitate search, cross-referencing, and reuse, items on this page should have:

• description
• link to related GitHub tickets or PRs
• link to Gist containing SQL or query code
• link to dashboards

BVA Annual Report Metrics

Metrics from BVA's FY19 Annual Report

• Metabase collection 24
• 1.1 Dispatched AMA Appeals
  • calculation: BvaDispatchTask completion date grouped by month
  • Metabase dashboard 13
  • queries
• 1.2 Appeals worked Overtime vs. Regular
  • Metabase dashboard 13
• 1.3 Scheduled hearings
  • Metabase dashboard 13

OIT Metrics

• Reader Adoption - #12556
  • percentage of unique users who have used Reader during the calendar year
  • A user is considered to have "used Reader" if that user opened at least 5 different documents during the month.
  • count of unique users (and their role: VLJ vs attorney) using Reader per month
  • Metabase dashboard 14
  • queries
  • Jupyter Dashboard

Feature work

AOD Motions

• Metabase collection 27

Case Distribution

• Metabase collection 26
• Metabase dashboard 15
• Metabase dashboard 7
• Querying for case distribution numbers #149
  • Distributed priority cases: queries

Hearings

• Metabase collection 30
• Metabase dashboard 5

Motions to Vacate

• Metabase collection 26
• Metabase dashboard 7

New Contentions Tracking

• Metabase collection 29
• Metabase dashboard 9

Regional Offices

• Metabase collection 31

Time spent on ...

Time spent on AMA appeals

• Days to dispatch AMA appeals

Time spent on IHP tasks

• Metabase collection 25

Stuck Appeals

Tasks assigned to/by inactive users

• Task types and counts
• Tasks and inactive users

Attorneys and VLJs using Caseflow

• Metabase dashboard 15
• JudgeTeam user count and appeal_views count of Caseflow usage
• Infrequent Caseflow non-users among JudgeTeam