Good Afternoon Folks,
I was working within the PS2010 RDB and wanted to get some additional information on the RDB. I was reminded that I was going to put the MSDN link that I reference often. Also wanted to share a query (provided by MSFT) – that you can run to find custom field data in the column pool tables.
SELECT CustomFieldName, ColumnPoolTableName, ColumnPoolColumnName FROM MFN_Epm_GetAllCustomFieldsInformation() WHERE EntityName = N'EntityType' -- Change EntityType to Project, Resource, Task, Assignment, or Timesheet.