Skip to content

Database Query Registry

Yoom Lam edited this page Oct 20, 2020 · 11 revisions

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

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

Case Distribution

Hearings

Motions to Vacate

New Contentions Tracking

Regional Offices

Time spent on ...

Time spent on AMA appeals

Time spent on IHP tasks

Stuck Appeals

Tasks assigned to/by inactive users

Attorneys and VLJs using Caseflow

Clone this wiki locally