How I Can Get Custom Outline Code Name Using SQL

[boni]

hi,
I need the Project Server 2003 database Table name in which it saves the
name of Enterprise Custom Outline Code for Project. For example if I define
'Group' as Enterprise Custom Outline Code for Project using Microsoft Office
Project 2003 then in which database table it will save the name 'Group'?

 

[Jonathan Yong]

-- Assuming you want to extract the field name for Enterprise Custom
Outline Code 1

SELECT A.ATTRIB_FIELD_ID,B.AS_VALUE
FROM MSP_FIELD_ATTRIBUTES A,MSP_ATTRIBUTE_STRINGS B
WHERE A.PROJ_ID = B.PROJ_ID AND A.AS_ID = B.AS_ID
AND A.ATTRIB_FIELD_ID = 188744589
AND (A.ATTRIB_ID = 206)
AND A.PROJ_ID = (select proj_id from msp_projects where proj_type=2)