Clarity

  • Private Community

  • 1.  Need help with Calculation of Total Labor Effort

    Posted Sep 17, 2015 03:13 PM

    Can some one please let me know where i can find total labor effort field in DB?

     

    If this field can not be found in DB can some one let me know how to calculate this field?



  • 2.  Re: Need help with Calculation of Total Labor Effort

    Broadcom Employee
    Posted Sep 17, 2015 05:54 PM

    If you want total labor actual hours at the investment level, it is in the INV_INVESTMENTS table

     

    SELECT i.name, i.code, (labor_actsum/3600) labor_hours FROM INV_INVESTMENTS i