Hi
I normally do these things using SQL queries, but it depends on what
you want to do, you could also look at PDS approach.
Rates are stored in the MSP_RESOURCE_RATES table, in some fields
(RR_STD_RATE and RR_OVT_RATE), the only problem is to reach the right
one among the five different rate tables (A,B,C,D, E). This information
is stored in the same table, field RR-RATE_TABLE. so if a resource has
five rated, for that resource ID you'll find five records in this
table, with RR_RATE_TABLE values to 0, 1, 2, 3, 4 respectively for
table A, B.......
Now you have to join the PROJ_ID and RES_UID keys with the other tables
or with your project ID and resource ID and with assignments records. I
don't know if your're practiced with Project and project server
database tables. So depending if you want web-related tables or not,
you'll find some of these references in the MSP_WEB_PROJECT/MSP_PROJECT
and MSP_WEB_RESOURCES/MSP_RESOURCES tables. Don't forget of course
that rates are related with assignments, and in the table
MSP_ASSIGNMENTS you'll find the ASS_COST_RATE_TABLE with the code of
the rate table of the assignment for that resource.
Hope this helps....
Andrea
