How To Find Rates Used For Auditing/Historic Purposes

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The NBI_PROJ_RES_RATES_AND_COSTS  table get details only from active projects.
Are there a recommended tables we can use to get the cost and rate details for inactive projects?

 

Environment

All Clarity Versions

Resolution

In order to obtain the rates used for past transactions and/or inactive investments,
the PPA_WIP_VALUES table has the rate associated with the transaction.

Here is a query that can be used:

SELECT 
a.transno,a.sourcemodule,
a.entrydate, a.EXTERNALBATCHID timesheettt, a.EXTERNAL_ID,
a.transdate, a.quantity, d.actualcost ac_rate, d.totalcost,
c.is_active, a.investment_id, a.project_code, a.TASK_ID,
b.prname,c.name,a.RESOURCE_CODE
FROM ppa_wip a, prtask b, inv_investments c,
ppa_wip_values d
WHERE a.task_id = b.prid
AND c.id = b.PRPROJECTID 
AND a.transno = d.transno
AND d.CURRENCY_type = 'HOME'
AND c.IS_ACTIVE = 0
ORDER BY a.transno 

Use filters as needed.