ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
DWH_INV_SUMMARY_FACTS fields calculation
Article ID: 125025
Clarity PPM On Premise
Clarity PPM SaaS
Where the Data Warehouse fields in DWH_INV_SUMMARY_FACTS come from:
Release: Any Supported Release
- EAC_TOTAL_COST Total estimate at completion cost from assignments.
- It will take and add data from the combined assignments on the investment.
- ACTUAL_TOTAL_COST Total actual cost from financial transactions.
- ACTUAL_LABOR_COST Actual cost from financial transactions where the transaction type is Labor.
- ACTUAL_LABOR_HOURS Actual labor hours from assignments.
- The data gets collected from Assignments, and then summarized to Investment level.