Trying to get fund name into output set element

Good morning! Our development coordinator is using an output set to pull information from a Fund Activity Report saved as a List. We have almost everything we need, but ideally I need to get the name of the fund that pledge payments went to in there. Currently, the pledge payment information is coming from LVS_ELEMENTS_PLEDGE_PAYMENTS, which only includes the campaign number. I'm guessing a new view is necessary, but I'm not sure which tables need to be linked together to get the correct information. And while I've set up Output Set elements in the past, I'm not sure how the set up for something like this would go. Has anyone set up an element like this already? (My consulting budget has been cut thanks to the shutdown, so I'm asking here.)

Thanks for any suggestions.

Anne Robichaux
The Historic New Orleans Collection