Where are Enterprise Project Outline Codes stored?

D

Doug

*Second post - first post didn't seem to appear*

I need to know where the Enterprise Project Outline Codes are stored? I
have read PJDB.HTM and found the fields where that document says they are
stored, but I don't seem to find any such data, or a reference to the data I
expected.

As always, thanks in advance!

Doug
 
G

Gary L. Chefetz [MVP]

Doug:

The document you're reading covers the Project client side of the database.
The web tables and Project Server tables are covered in svrdb.htm which you
can also find in the help directory on your Project Server.
 
K

Kevin W Flanagan

The codes are stored in the following tables in the ProjectServer database:

MSP_CUBE_ASSIGNMENTS_OUTLINE# where the # is the number of the code you
used. There are also PROJECT and RESOURCE tables in the place of "PROJECT"
in the above string. If you are wanting to extract the data as it is
assigned within the specific project, you will need to use the
MSP_CONVERSIONS table to find the CONV_VLAUE for the specific outline code
you want and refer to that value where your project ID is equal to the
project you want to get data for.

Hope this helps.
 
Top