Project Process

Modified on Mon, 15 Jul, 2024 at 12:40 PM

Overview

The FactProjectProcess table stores comprehensive data on the various processes within a project. It includes details about hours allocated and spent, financial metrics, dates, and other relevant project management information. This table helps track project processes' progress, financials, and resource allocation.


common.FactProjectProcess

Column NameDescriptionTypeIs Unique
IdThe unique identifier of the project processnumberYes
ProjectKeyThe Key for the project tablenumberNo
ProcessKeyThe Key for the master process tablenumberNo
ProjectManagerKeyThe Key for the Project Manager tablenumberNo
ProjectLeaderKeyThe Key for the project leadernumberNo
ActualDeliveryDateKeyThe Key to the actual delivery datenumberNo
CustomerKeyThe key for the customernumberNo
TargetStartDateThe target start datenumberNo
TargetFinishDateThe target finish datenumberNo
AllocatedHoursNumber of hours budgeted for the processdecimalNo
ActualHoursNumber of hours spent on the processdecimalNo
RemainingHoursNumber of hours remaining for the processdecimalNo
PercentOfAllocatedHoursToDatePercentage of allocated hours used to datedecimalNo
PercentOfAllocatedHoursProjectedProjected percentage of allocated hoursdecimalNo
ProjectedHoursTotalTotal projected hours (Actual + Remaining)decimalNo
ProjectedHoursBalanceBalance of projected hoursdecimalNo
LastUpdatedDate of last updatenumberNo
AllocatedHoursManYearsAllocated hours in man-yearsdecimalNo
AllocatedHoursManWeeksAllocated hours in man-weeksdecimalNo
RemainingHoursManYearsRemaining hours in man-yearsdecimalNo
RemainingHoursManWeeksRemaining hours in man-weeksdecimalNo
BudgetBalanceBalance of the budgetdecimalNo
EstimatedHoursToCompletionEstimated hours to completiondecimalNo
EtcLastUpdatedDate of last update for estimated hours to completionnumberNo
ProjectedHoursMarginMargin of projected hoursdecimalNo
ProjectNumberNumber of the projectnumberNo
ProposalNumberNumber of the proposalnumberNo
CustomerName of the customertextNo
ProjectedCostBalanceBalance of the projected costdecimalNo
ProjectedCostMarginMargin of the projected costdecimalNo
IsInternalIndicates if the project is internaltrue/falseNo
ActualDeliveryDateActual delivery datenumberNo
IcrHoursToDateICR hours to datedecimalNo


production.FactProjectProcess

Column NameDescriptionTypeIs Unique
IdThe unique identifier of the project processnumberYes
GrossProjectedRemainingLabourGross projected remaining labour costdecimalNo
RemainingCostProjectedProjected remaining costdecimalNo
ProjectedFinalCostProjected final costdecimalNo
BudgetBalanceDifference between the budget and the projected costdecimalNo


finance.FactProjectProcess

Column NameDescriptionTypeIs Unique
IdThe unique identifier of the project processnumberYes
SalesRphSales rate per hourdecimalNo
SalesPriceSales price based on allocated hoursdecimalNo
ProjectedProfitLossProjected profit or lossdecimalNo

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article