Enterprise Resource "Group" Attribute

[lambeth26.2]

I am writing some SQL reports using data contained in the Project
Server database. We are running Project Server 2003 on SQL Server
2000. I am having a tough time locating one piece of data.

On the reports we would like to break resources out by Group which is
plainly displayed in the desktop application when you open the
Enterprise Resource pool. The problem is, I can't seem to locate the
source table that contains that attribute as it relates to Enterprise
Resources.

Can someone point me to the table where this data attribute is
contained?

I have ruled out MSP_VIEW_PROJ_RES_STD and MSP_TEXT_FIELDS. I can't
seem to locate any other suitable locations.

Thanks in advance.

 

[lambeth26.2]

I think I I have found the answer to this problem. It seems that a
project with ID = 1 is where those default values will be stored.

The following query will list the enterprise resources with the Group
name that shows up in Project when you are working with the Enterprise
Resource Pool:

SELECT Proj_ID, Wres_ID, Res_EUID, Res_Name, Text_Value AS Group
FROM MSP_TEXT_FIELDS t, MSP_WEB_RESOURCES r
WHERE t.Text_ref_UID = r.Res_EUID
AND Text_Category = 1
AND Text_Field_id = 205520899
AND Proj_ID = 1
ORDER BY Res_Name