As an attorney, it is hard to distinguish the difference between different appeals of the same Veteran at a glance on the welcome gate page.
We will be adding the Issues as a new column.
h2 Work assignments to Cases checked inh1 (Reader allows attorneys and judges review and annotate a Veteran鈥檚 case file. Reader allows attorneys and judges review and annotate a Veteran鈥檚 case file.)
https://github.com/department-of-veterans-affairs/appeals-design-research/issues/288
@cmgiven can you clarify which column in VACOLS we should look at here for program? Is it BFCASEV?
It's ISSUES.ISSPROG, which need to be joined on ISSREF.PROG_CODE in order to get the label (ISSREF.PROG_DESC). Alternatively, we could hardcode our preferred labels and skip the join, which may be preferable anyway, as some of the program names are quite long.
(Also note that we'll need to allow for the possibility of multiple program areas, probably comma separated? Two program areas is a reasonably common edge case. Three is possible but rare.)
Thanks!
@abbyraskin
How about stacking instead of commas? The some of the programs are kind of long and stacking might look cleaner.

I don't think this really effects other views:


definitely agree @gnakm!
note to figure out what our preferred hardcoded labels are for all of these - i think that's a better route
@cmgiven how many program areas are there? could you paste them here when you have a chance? (or direct us to them? tried finding them myself and failed!)
COUNT(*) PROG_DESC
1 9 Loan Guaranty
2 3 Insurance
3 28 BVA Original Jurisdiction
4 164 Medical
5 437 Pension
6 7 NCA Burial benefits (38 CFR Part 38)
7 37 VBA Burial benefits (38 CFR Part 3)
8 26 Other programs
9 62876 Compensation
10 19 VR&E
11 122 Education
select count(*), PROG_DESC from ISSUES join (select distinct PROG_CODE, PROG_DESC from ISSREF) on ISSPROG = PROG_CODE where ISSDCLS > date '2017-01-01' and ISSDC in ('1', '3', '4') group by PROG_DESC
@abbyraskin I wonder if we should make a separate issue for cleaning up program data and check-in with Lara since it effects hearings stuff as well.
Closing because this has been combined with #2511
Most helpful comment
@abbyraskin
How about stacking instead of commas? The some of the programs are kind of long and stacking might look cleaner.
I don't think this really effects other views:
