locked
resource rate table RRS feed

  • Question

  • Hi:

    When a resource is assigned, you can up to 5 rate tables for a particular resource.  Where can I find this information in the database?  I would like to retrieve the rate table for a particular resource and effective date.  I know A is the default table.  I know how to retreive that rate.  But if the resource is set to B and so on.   

    I need this information to create a flat file from project server 2007. 

    Thanks,

    kkmick

     

     

    Thursday, September 16, 2010 6:47 PM

Answers

  • Hi kkmick,

    The resource rate tables are stored as a binary blob in the database and cannot be retrieved using a SQL query.

    You can access cost rate tables programmatically using PSI (enterprise resources only) or VBA in Project.

    I hope this helps,
    Hans


    My EPM blog: Projectopolis
    • Marked as answer by kkmick Thursday, September 16, 2010 9:27 PM
    Thursday, September 16, 2010 8:58 PM

All replies

  • Hi kkmick,

    The resource rate tables are stored as a binary blob in the database and cannot be retrieved using a SQL query.

    You can access cost rate tables programmatically using PSI (enterprise resources only) or VBA in Project.

    I hope this helps,
    Hans


    My EPM blog: Projectopolis
    • Marked as answer by kkmick Thursday, September 16, 2010 9:27 PM
    Thursday, September 16, 2010 8:58 PM
  • Thank you Hans.
    Thursday, September 16, 2010 9:28 PM