FYI - my assumption that Total Labor Effort will always equal Total Allocation is incorrect. As a business process we do not track time to Ideas, therefore it may look 'in sync' in the UI but I see older ideas that do have time tracked to it, and others that just don't match.
SELECT
I.ID
, I.CODE
, I.NAME
, (I.LABOR_ETCSUM/3600) AS LABOR_ETC_SUM
, (I.LABOR_ACTSUM/3600) AS LABOR_ACT_SUM
, (I.LABOR_EACSUM/3600) AS LABOR_EAC_SUM
, CONVERT(DECIMAL(10,2),((I.LABOR_ETCSUM/3600)+(I.LABOR_ACTSUM/3600))) AS LABOR_TOTAL_EFFORT
, CONVERT(DECIMAL(10,2),T.LABOR_ALLOCATION_SUM) LABOR_ALLOCATION_SUM
FROM
INV_INVESTMENTS I
JOIN (SELECT SUM(T.PRALLOCSUM/3600) LABOR_ALLOCATION_SUM
, T.PRPROJECTID FROM PRTEAM T WHERE 1 = 1
GROUP BY T.PRPROJECTID) T ON I.ID = T.PRPROJECTID
WHERE ODF_OBJECT_CODE = 'idea'
For Total Allocation - Summing PRALLOCSUM per investment on PRTEAM appears to be the proper spot to pick this up from.