I understand your points above…You need to be a business analyst or reach out to your business analyst to build a common canonical document or design spec to manage source - target mappings etc…some people use basee OAG BOD’s (OAGIS) and start using that as starting point.
HTH,
RMG