Interesting. In the past I've used the values for 2"-4". Table 4E gives values for visually graded decking. Doing a spot check the Fb for decking is around twice what they give you for 2"-4".
Hilti has a free program, PROFIS, that does anchor bolt design. Playing with that can give you a feel for what needs to be checked and what bolts are applicable where
If the hole size voids the allowable dimensions I would give a repair. Depending on the actual hole size the plumber needs, you could look at TJI's TB-187 for a repair detail. If you reach out to Anthony they may have a recommendation.
I think what RWW0002 describes is what the author does. He gets the soil pressure with the thrust force in the "Proportion the Foundation" section then uses that to design the base.
This might be better served in the general discussion. I would try to go into the store below and look up through the ceiling at the joists to get a better idea of what is going on.
Version 15 of the AISC design examples has something relatively similar in the composite members section that might give you an idea of how to look at it.