Enterprise Resource Pool Database Schema

[dpark29]

Can someone point me to where Project Server 2003 stores its Enterprise
Resource Pool data and where I can get a copy of the database schema
(client tables) for the Enterprise Resource Pool?

 

[Guidho]

Resource information is stored in many tables.
You need to tell u which data exactly you need before we can tell you
were it is stored in the database.

The database scheme can be downloaded for free from the Microsoft
website. It is also available on the projectserver machine. In the
install folder, there is a help folder somewhere which contains the DB
scheme (I forgot the exact path).

Guidho

 

[Rod Gill]

Try searching for pjsrvrdb.htm

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

 

[dpark29]

I'm trying to identify what table(s) Server uses to store the data
about a resource--name, calendar, active/inactive status, rates, etc.
I found the "Microsoft Office Project Server 2003 Data Reference"
(...Microsoft Office Project Server 2003\HELP\1033\PJSVRDB.HTM), which
provides an overview of the project tables. Also, there is a Visio
form (Projerd.vsd) that provides a database diagram of the tables
referred to in pjsvrdb.htm; however, these tables appear to define data
about projects, only. The resource table that is included in the data
reference, MSP_RESOURCES, appears to track resources as they are
associated to projects. Is there a separate table or tables that
support the Enterprise Resource Pool; data about the resource itself
rather than the resource as it is assigned to a project? Does Server
store Enterprise Resource Pool data in a separate table or tables from
MSP_RESOURCES? If so, what is/are those tables? If Server uses
MSP_RESOURCES to hold all information about resources--individually
referring to the properties of the resource itself and as the resource
is related to projects--how can I locate the information that is
specific to the individual resource? For example, where is the Boolean
field that indicates whether a resource is "Inactive" located?

Thanks,
David