Rate table in interface doesn't match MSP_RESOURCE_RATES

[BananaQuaalude]

Hello,

I'm trying to reconcile what I see in the client with the numbers in
MSP_RESOURCE_RATES for any specific resource. The numbers do not match.
Nor can I find any logic in the difference between the two.

For instance, for A (Default) client has

Thu 1/1/09 103.13/h

MSP_RESOURCE_RATES value 0 for RR_RATE_TABLE has

2009-01-01 08:00:00.000 141.160000

I've consulted the PJDB reference, which states that "This table
contains resource rate data." I haven't found another rate table. The
resource is at 100% units. It doesn't matter if I'm in the global or a
specific project, they don't match.

I'm trying to find a way to update resource rates via direct SQL to the
DB, since I couldn't find a PDS call to do it. But before I attempt
that, I need to understand how the client relates to this table. Has
anyone else tried to do this?

Any help is greatly appreciated!

 

[BananaQuaalude]

Forgot to mention--I'm using MS Project Server 2003

 

[Rod Gill]

Hi,

Enterprise resource rates are stored in other tables and should not be
updated directly. If there isn't a PDS call already for this, then you need
to write a PDS extension. Note that PDS has gone for 2007 and is replaced by
PSI, so don't waste too much time on it!. Resource rates do not change
often, so a simple VBA macro for Project to open the Enterprise Resource
Pool with all resources, then update the rates form a database or
spreadsheet then save and close would be the simplest solution and the
quickest and cheapest to write.

--

Rod Gill
Project MVP

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

 

[BananaQuaalude]

Thanks Rod!

I don't mind going the VBA route at all. I'll look, but I'm assuming
there are methods, properties directly tied to changing the rate
tables?

I have your book, do you explain any of this in it?

 

[Rod Gill]

Hi,

Module 21 and the Cost Margin report macro uses different Cost Rates to
calculate the difference between what's charged and internal rates.

--

Rod Gill
Project MVP

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