Clarity

  • 1.  Find Rate Matrix Use

    Posted Jan 30, 2018 06:58 AM

    Hi, 

     

    I want to know where all (list of all Projects, Ideas or Resources) a particular Rate Matrix is used (amongst say a couple of rate matrices is used. How can I check the same (from DB say)

     

    Regards,

    Uruj



  • 2.  Re: Find Rate Matrix Use
    Best Answer

    Broadcom Employee
    Posted Jan 30, 2018 07:16 AM

    Hi Uruj,

    Project financial data is stored at PAC_MNT_PROJECTS, resources at PAC_MNT_RESOURCES

    On this table you will find details of rate matrices associated.

    Regards



  • 3.  Re: Find Rate Matrix Use

    Posted Jan 30, 2018 07:17 AM

    Hi Jose,

     

    Thanks, I tried the same, but could not find the column names. There are so many columns and I am confused.

     

    Regards,

    Uruj



  • 4.  Re: Find Rate Matrix Use

    Posted Jan 30, 2018 07:45 AM

    I don't think that info is available - however, you can create a portlet like the below:

     

    http://www.regoxchange.com/files/2414/4926/1051/Investment_Resource_Rates_v01.png

     

    NJ



  • 5.  Re: Find Rate Matrix Use

    Broadcom Employee
    Posted Jan 30, 2018 07:36 AM
    transratesourcematerials
    transcostsourcematerials
    transratesourceexpenses
    transcostsourceexpenses
    transcostsourceequipment
    transratesourceequipment
    transcostsourcelabor
    transratesourcelabor
    This refers to the ID of the associated matrix


  • 6.  Re: Find Rate Matrix Use

    Posted Jan 30, 2018 07:46 AM

    Aah - there you go

     

    Thank you

     

    NJ