Thanks John (and Yusra), this is a great ticket, bringing all of the schema tables in under one roof. It should certainly help with catalogue consistency between surveys going forward.
I've ran through my test DECam data from the Merian survey using the pipe_tasks and obs_decam branches of this ticket (tickets/
DM-28862), and all seems to work well. I attach the step 1 (single-frame), step 2 (post-single-frame), step 3 (coadd) and step 7 (post-run) processing logs to this ticket, for reference.
I haven't had the chance to test this on any HSC or ImSim data - I can't imagine anything would break, but it might be worth pushing through some (e.g.) HSC data for a few visits to double check that nothing there breaks either?
Other than that, I've left some comments on the GH PR for pipe_tasks regarding doc strings and a few typos. Some of these I likely propagated on my prior obs_decam ticket, so thanks for looking at this! I saw that the MacOS Jenkins run passed successfully, but not the CentOS run. Was this due to the unrelated Jenkins issues we were having on or around mid-December? If so, all seems well here, and this looks good to merge to me - thanks!