To help us with this I documented the common tables we use for reporting and how they join together with other tables in the system.
I thought I would attach it here in case it is helpful.
The attached document is filtered but also contains information on 4Cast, FIS and ProAchieve.
Hope it is useful
