Labor Rate Table

[RandyK]

As you know, each resource profile can store up to 5 labor rates. I am
trying to locate within the MSPS database tables the location of the labor
rates associated with tabs B, C, D, & E. In the Enterprise Resoruce Pool,
Tab "A" (Standard Rate) is readily available - but I am in need of the other
four for reporting purposes.

Can any of you SQL guru's point me to the table & column name for these
other rates?

 

[Pam Earls]

Hi Randy,

There's a file included on the MS Project Installation CD called PJDB.htm
under the DOCS folder. This file has all the tables and their fields listed.

With that said, back to your question .... The table is MSP_RESOURCE_RATES.
The field that determines which rate table is represented in the record is
RR_RATE_TABLE (0 -> A (default), 1 -> B, 2->C, etc). Each resource will have
a separate record for each rate table for which they have values defined.
You can look at the other fields for whatever values you're looking for ...

Hope it helps ...
Pam

Bye the bye, there is a similar document for the Project Server tables, as
well, called PJSVRDB.HTM. That one comes with the SDK. I don't remember if
it's included on the Project Server CD or not ...

 

[RandyK]

Thanks Pam - sure does help!