Which table stores rate matrix related information.

[Legacy User]

Hi All,

I would like to know that table name which stores Rate Matrix Information.

Thanks.

[Deactivated User]

Go to the Tech Ref in Ca PPM documentation and start wit Matrix management

[Legacy User]

Hi ,

I want to get rates for the following resource class shown in the below screenshot, so tables i should use for join.

Please help me out in this.

 

Thanks.

[Suman Pramanik]

Here are the few tables 

 

 

PPA_MATRIX is the main table and then you can refer via technical ref as Martti mentioned 

 

Regards

Suman Pramanik 

[pjromano]

You'll obviously have to tweak this based on what your matrix columns are, but, here is a sample query that you can use that may be helpful:

 

select pmv.fromdate "From Date"
, pmv.todate"To Date"
, pmv.Value1 "Department"
, pmv.value2 "Role Code"
, (SELECT FULL_NAME FROM SRM_RESOURCES WHERE unique_name = pmv.value2) "Resource Role"
, pmv.value3 "Input Type Code"
, pmv.value4 "Resource Class"
, pmv.numval1 "Rate"
, pmv.numval2 "Standard Cost"
, pmv.numval3 "Actual Cost"
, pmv.strval1 "Cost Plus Code"
, pmv.matrix_currency_code "Currency Code"
, pmv.created_date "Created Date"
, (SELECT FULL_NAME FROM SRM_RESOURCES WHERE user_id = pmv.created_by) "Created By"
, pmv.last_updated_date "Last Updated Date"
, (SELECT FULL_NAME FROM SRM_RESOURCES WHERE user_id = pmv.last_updated_by) "Last Updated By"
from ppa_matrixvalues pmv
where pmv.matrixkey = '5000000'