Cancer Screening History

[KELSEYDOWLING7]

Hey Jake, when you get a chance can you flatten the cancer screening history table in prod? The raw table has data now

[jacobmpeters]

Done!

[KELSEYDOWLING7]

Thanks! Looks good.

It looks like the survey flag is in the participants table but not the start/stop time stamp. Would you be able to add those/refresh that table as well? If needed, those variables are d_389890053,d_609630315

[jacobmpeters]

I ran it for the participants table as well in Dev, Stg, and Prod. Dev/Stg should be up-to-date. The query job is running in Prod and might take some time to complete. Can you check on it later this afternoon?

[KELSEYDOWLING7]

Absolutely, thanks