CA PPM: Query to get the pending actuals against a project

Document ID : KB000100927
Last Modified Date : 10/08/2018
Show Technical Document Details
Question:
Do you have a query to get the pending actuals against a project?
Answer:
Query to get the pending actuals against a project. Ex: PRJ00873

SELECT 
prtask.prname AS task_name, 
srm_resources.first_name, 
srm_resources.last_name, 
prassignment.prpendactsum / 3600 pend_act, 
prtimesheet.prid AS ts_id, 
prtimeperiod.prstart AS ts_start, 
prtimesheet.prstatus AS ts_status 
FROM 
prassignment 
INNER JOIN prtask ON prassignment.prtaskid = prtask.prid 
INNER JOIN inv_investments ON prtask.prprojectid = inv_investments.id 
INNER JOIN srm_resources ON prassignment.prresourceid = srm_resources.id 
INNER JOIN prtimeentry ON prtimeentry.prassignmentid = prassignment.prid 
INNER JOIN prtimesheet ON prtimesheet.prid = prtimeentry.prtimesheetid 
INNER JOIN prtimeperiod ON prtimeperiod.prid = prtimesheet.prtimeperiodid 
WHERE 
prtimesheet.prstatus <> 4 
AND prassignment.prpendactsum > 0 
AND inv_investments.code = 'PRJ00873'