none
Where the cost rate table is stored (for multiple values) ? RRS feed

  • Question

  • Hi,

    Our version of project pro and project server is 2013.

    Did someone know where is stored the rate in the cost rate table in project pro ?

    I know that the current rate is in the MSP_Resource table ... but the others are where ?

    We did'nt want to modifiy the data, we wanna find a solution to join a new entitie "contract" to a resource and a cost of this table.

    Thank you.

    Stephen C.


    • Edited by SittButt Monday, June 1, 2015 3:53 PM
    Monday, June 1, 2015 3:47 PM

Answers

  • HI Stephen,

    The data is saved in the binary format in the published database and can be accessed via PSI. If you want to used in the reports etc. an option would be to have an event handler (or a PowerShell script) and capture the information in a custom database that can be used then in your reports, etc.

    Hope this helps

    Paul

    • Marked as answer by SittButt Tuesday, June 2, 2015 11:53 AM
    Monday, June 1, 2015 6:06 PM

All replies

  • HI Stephen,

    The data is saved in the binary format in the published database and can be accessed via PSI. If you want to used in the reports etc. an option would be to have an event handler (or a PowerShell script) and capture the information in a custom database that can be used then in your reports, etc.

    Hope this helps

    Paul

    • Marked as answer by SittButt Tuesday, June 2, 2015 11:53 AM
    Monday, June 1, 2015 6:06 PM
  • Thank you.

    It's not really simple and complexify too much our process.

    But we got a alternate plan (it's always important to have a plan B).

    Tuesday, June 2, 2015 11:53 AM