I would like to know that table name which stores Rate Matrix Information.Thanks.
Go to the Tech Ref in Ca PPM documentation and start wit Matrix management
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.
Here are the few tables
PPA_MATRIX is the main table and then you can refer via technical ref as Martti mentioned
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 pmvwhere pmv.matrixkey = '5000000'
Retrieving data ...