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

book

Article ID: 125025

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Where the Data Warehouse fields in DWH_INV_SUMMARY_FACTS come from:
EAC_TOTAL_COST
ACTUAL_COST
 

Environment

Release: Any Supported Release

Resolution

DWH_INV_SUMMARY_FACTS table:

  • 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.