project db tables

[Aubrey]

We are currently using sql reporting services to report on risks and issues
in the project server. We would like to sort this report by location. I have
a location field and outline code but cannot find these values in any of the
tables in the database. Does anyone know what tables enterprise text fields
and outline codes are stored in?

 

[Brian]

Aubrey,

I believe that the information regarding the enterprise text fields that you
are looking for is housed in the MSP_WEB_WORKGROUP_FIELDS table. The
CUSTFIELD_TYPE field indicates the type of custom field. A value of 21 in
this fields indicates a string. For string values, the actual value is
stored in the VARCHAR_VAL field. You may want to query this table where the
CUSTFIELD_TYPE equals 21 to see if the data that you need is there.

Regarding the outline codes, these are stored in the MSP_OUTLINE_CODES
table. The OC_CACHED_FULL_NAME field contains the values of these outline
codes.

You may already know this, but data dictionaries are available in the help
directory on the server. They are named svrdb.htm and prjdb.htm.

Hope this helps,
Brian

 

[Cvila]

Hello Aubrey,

if you need tu understand Project Server Data Base, you can review this web
page:

For Project Server DataBase:
http://www.microsoft.com/downloads/details.aspx?FamilyID=ac5cc775-1367-4b66-
870d-f280c054efe2&displaylang=en#top

For Project Professional DataBase
http://www.microsoft.com/downloads/...FC8-8E67-D908CDB9FAF2&displaylang=en#Overview

It is important that you know that both Project Server and Project
Professional are stored in the same data base in SQL, and you can learn both.