We realized this necessity for data consistency in reports so we use an authoritative list of projects. We load the data every month as an ad hoc (as often as you need), effectively overwriting any previous version with the most recent version. Then we created lookups against that table for parameters like Project Name, so there is only one value provided for any data source (GL, Purchase Orders, CMDB, etc) that might contain the project name. This ensures that reports only display the most recent version for the project name. This method works for any meta data coming from list of Cost Centers, or Applications too.