Clarity

  • Private Community

  • 1.  Team Role Rate x hours

    Posted Oct 10, 2016 11:46 AM

    Hello,

     

    I am working on a report where we have to show sum of Role Rate x Hours for the whole team at project level. Before attempting to write a function, I would like to know if this info is already available. 

     

    Please advice.

     

    Thank you,

    Rajani.



  • 2.  Re: Team Role Rate x hours

    Broadcom Employee
    Posted Oct 10, 2016 07:23 PM

    Hi Rajani,

    I dont think we have a column in DB which has the details of Rate X hours - usually we do the math in the query. You can use NBI_PROJ_RES_RATES_AND_COSTS or ppa_matrix for the rate and the hours from ppa_wip or from the slice tables. 

    Let me know how it goes. 

     

    Thanks,

    Jerin