Resource Rate for Resource Pool

[Anatess]

Hi,
I've googled all day long for an answer but all I found were similar
questions with no answers. I'm hoping you can answer my question or lead to
me to a site that may have the answer.
I'm trying to understand where the resource rates are found on the tables.
I found MSP_RESOURCE_RATES table, but it looks like this table only gets
populated when the resource is assigned to a project. But, when I open the
enterprise resource pool cost tab there are rates in there before I even
assign the resource to a project. So, what table are these rates stored?
By the way, I'm not in IT so I don't have access to a developers workbench.
All I can use is a query tool that has a read-only connection directly to the
project server tables. I've been able to structure basic adhoc queries even
figuring out outline codes. But this rate table is stumping me!
Thank you for your assistance.

 

[Jonathan Sofer]

Is this for PS 2003 or PS 2007? There is a big difference in data
structures.

Jonathan

 

[Anatess]

Hi Jonathan,

This is for PS 2003. Thank you for responding.

regards,
Anatess

 

[Jonathan Sofer]

After some research of my own, I have found that resource rates are not
exposed in the database until they are assigned to at least 1 project. The
resource does not have to actually be assigned to a task, you can create a
blank project and build the resource onto the team and that would be enough
to expose that data. It is not uncommon for certain data like resource
rates to not be exposed in the database directly.

Sorry for not having a better answer for you.

Jonathan

 

[Anatess]

By the way, I don't think I mentioned that we are using Project Server. So
that, when we pull the Enterprise Resource Pool, click on the resource, then
click on the Cost tab, that's where I see the rates (before the resource is
attached to the project).

regards,
Anatess.

 

[Jonathan Sofer]

Yes, I assumed you were on project server and that is how you were viewing
the rates. Unfortunately, without at the very least attaching the resource
to a schedule and saving it, it doesn't seem to be exposed for SQL
querying

Jonathan