Going back to System Data Providers https://communities.ca.com/message/109017861#109017861
Is there any more information currently available? Other than that they are now listed also in the Wiki.
The query in https://communities.ca.com/message/100992399#100992399 is looking at the Team allocations, but the field Approved Flag is not there. Could have been that it was not displayed when the trace was taken.
Is Approved Flag in Team Allocations coming from INVESTEMENTS where Approved Flag a virtual boolean field for Approved Flag for Status which status may have values Approved, Nonapproved and Rejected?