Project 2003 SQL tables & attributes

[Nock]

Hi all, I am using Project Server 2003 and am in the process of building some
reports for our exec's.

Is there an explanation of the Project 2003 SQL tables and attributes
somewhere on the web? For example, if I wanted to know what the difference
between the
PROJ_PROP_AUTHOR and PROJ_PROP_MANAGER fields was.

I can create a view to see the values but the information isn't that
descriptive in some cases and to build reports requires some fairly explicit
information on each table\attribute.

Many thanks!

Nock (Australia)

 

[Rayan]

It's located in your machine
In Microsoft Office Project Server 2003 folder (C:\Program Files\Microsoft
Office Project Server 2003\HELP\1033) , Check PJDB.HTM and there is some
other help files.

for example :
PROJ_PROP_AUTHOR varchar(255) The name of the author of the project; used to
group similar projects together.
PROJ_PROP_MANAGER varchar(255) The manager of the project; used to group
similar projects together.

Regards,
Rayan (Saudi Arabia)

 

[Nock]

Was this post helpful? Yes, yes it was!

Thanks Ryan, much appreciated.

Nock (Newb, Australia)