Database Schema

[MSPNewbie]

Does anyone know where I can find information about the MS
Project Server 2002 database?

I can't for the life of me figure out how to obtain the
Enterprise Outline Codes for a given project.

 

[Jack D.]

Does anyone know where I can find information about the MS
Project Server 2002 database?

I can't for the life of me figure out how to obtain the
Enterprise Outline Codes for a given project.

look at the file called svrdb.htm on the cd or the computer that project
server is installed on.

--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP
email: J -at- eM Vee Pee S dot COM


+++++++++++++++++++

 

[MSPNewbie]

Thanks but I already looked there.
I saw no references to obtaining the Enterprise Outline
Codes.

Enterprise Cost, Flag, Number, Date and Text fields are
easy to get as they're in MSP_VIEW_PROJ_TASKS_ENT but I
need to join somewhere to get the Enterprise Outline Codes.

Can you (or anyone else) help me out here?

Thanks!

 

[Lars Hammarberg]

Here's a view for you - if you want the definitions too, they're put away in
the MSP_ATTRIBUTE_STRINGS and MSP_FIELD_ATTRIBUTES tables.

SELECT oc.PROJ_ID, oc.CODE_UID, oc.OC_FIELD_ID, oc.OC_PARENT,
oc.OC_NAME, oc.OC_CACHED_FULL_NAME
FROM dbo.MSP_OUTLINE_CODES oc INNER JOIN
dbo.MSP_FIELD_ATTRIBUTES fa ON oc.PROJ_ID = fa.PROJ_ID
AND oc.OC_FIELD_ID = fa.ATTRIB_FIELD_ID AND fa.ATTRIB_ID = 209
WHERE (oc.CODE_UID > 0) AND ((fa.ATTRIB_VALUE & 32) > 0)

/Lars Hammarberg
www.camako.se