As I thought about this, using a STRING_AGG for JobNum would help with troubleshooting, so you could see the collection of jobs that were being checked and could verify the data with job tracker and timephase.
I thought I knew what I was doing, but I guess it’s not clear to me after all where I need to make the changes to move the grouping up to part/revision instead of job. I can’t removing groupings in the sub-query without aggregating the results somehow, and I can’t remove tables at the top level (for instance to only let the subquery run to experiment with it) because I get errors about missing fields in the table I just removed.
I’ll make a copy tonight and see if I can update the groupings.