Does project store rates in binary?

[Mark E. Read]

When looking at the pjdb, there seems to be a table for rates that looks
right, but when storing rates in the table either via SQL or via the Project
Professional Client (VBA), this table is not used.

Can you tell me where the rates are stored? Are they documented somewhere
else?

Thanks!

 

[Ed Morrison]

Rates at a resource level are first stored in the infamous BLOB. In order
to see the rate information in the msp_resource_rate table, do the
following.
1. Assign a rate to an enterprise resource and save the resource pool. The
BLOB is updated, but not the table.
2. Assign the resource to a plan if it is not already.
3. Save the plan.
After saving the plan you will see the msp_resource_rates table populated
with resource rate info only for the plan that you just saved. If you
modify the rate again, the table is not updated until you open and save the
plan again.