Nikhil's typical debugging steps:
1. start with the
S&V completion latest dataset - filter to enterprise id (1 row per enterprise id in this dataset) and then find the column for the respective screener of interest
2. if the closure is incorrect, look at the upstream datasets - I typically start with this
S&V history dataset, this is basically an aggregation of all screeners of interested and dates of completion etc., use this to confirm if test is showing up. (multiple rows for same e_id - it's a history dataset).
3. Then cross-reference with athena, find it in the chart or where they show it and determine if it should be getting captured. If it should be getting captured, you should then look into the logic of the S&V history dataset above to see why it's not there. That S&V history dataset is the main source that drives all downstream completion datasets.
Lastly, this is the
S&V playbook - gives context on how each screener is determined to be closed