Investigate AOD cases in Case Storage that have not been distributed

[alisan16]

We have a request from John Gosnell to investigate 500+ AOD appeals that are in VACOLS case storage and have not been distributed with the Caseflow automatic case distribution algorithm. Based on Mike Sanford's initial manual investigation, some of these cases are tied to AVLJs and are not distributed because AVLJs cannot order cases. The goal of this ticket is to classify why these appeals are not being distributed.

The team may be asked to come up with a Caseflow solution for distributing these cases, but that solution is out of scope of this ticket

• [ ] Ping Alisa to get the spreadsheet of cases (it uses the appeal ID which may have PII)
• [ ] Verify that the appeals are in case storage and ready to be distributed in VACOLS
• [ ] Figure out why the appeals are not being distributed (reasons could be - they are tied to an AVLJ, there are open tasks, they are in a different VACOLS location, etc.)

Acceptance criteria

• [ ] Spreadsheet or Metabase table with the cases and reasons for why they're not being distributed

[ajspotts]

what is this chart?

1 | 
2 | 
3 | |||
5 | |||||||
8 | ||

Why 1?

Why 2?

Why 3?

• Very set rules as to why cases are ready and why they cannot be distributed.

Why 5?

Why 8?

• 500+ cases

[hschallhorn]

Noticed a discrepancy between counts_by_priority_and_readiness and the number of appeals actually ready to distribute

VACOLS::CaseDocket.counts_by_priority_and_readiness
=> [..., {"n"=>766, "priority"=>1, "ready"=>1},...]

One thing this method does not take account of are blocking mail tasks and diary entries. A case is classified as "ready" if the case is in case storage.

If we filter out these instances, we get down to 661

SELECT_PRIORITY_APPEALS = "
    select BFKEY, BFDLOOUT, VLJ
      from (
        select BFKEY, BFDLOOUT,
          case when BFHINES is null or BFHINES <> 'GP' then nvl(VLJ_HEARINGS.VLJ, VLJ_PRIORDEC.VLJ) end VLJ
        from (
          #{VACOLS::CaseDocket::SELECT_READY_APPEALS}
            and (BFAC = '7' or AOD = '1')
          order by BFDLOOUT
        ) BRIEFF
        #{VACOLS::CaseDocket::JOIN_ASSOCIATED_VLJS_BY_HEARINGS}
        #{VACOLS::CaseDocket::JOIN_ASSOCIATED_VLJS_BY_PRIOR_DECISIONS}
      )
  "

VACOLS::CaseDocket.connection.exec_query(SELECT_PRIORITY_APPEALS).count
=> 661

This function is used to count legacy appeals when calculating our priority count (total number of priority cases available to distribute) and calculate our docket proportions

Found by looking at priority_count and the counts of each docket's ready appeal ids

DocketCoordinator.new.dockets.map { |docket_type, docket| docket_type == :legacy ? 661 : docket.appeals(priority: true, ready: true).pluck(:uuid).count }
=> 858
DocketCoordinator.new.priority_count
=> 963