Base Package Reports - FACT Tables
FACT Hiring Needs
| Project Code |
|---|
| Resource Display Name |
| Role |
| Role Type Name |
| Role Type Description |
| Role Billing Department |
| Role Billing Title |
| Billing Adjusted Rate |
| Projected Hours Start Date |
| Projected Hours End Date |
| Requested Hours |
| Booked Hours |
FACT Milestones
| EngagementCode |
|---|
| Project Code |
| Client Name |
| Project Name |
| Engagement Name |
| Engagement Manager |
| Milestone Name |
| Milestone Status |
| Milestone Forecast Date |
| Milestone Amount |
| Contract Line Item Uid |
| Milestone Achieved Date |
| Billing Milestone Description |
| Milestone Planned Date |
FACT Missing Time
| Row Fields | Page Fields | Data Fields |
|---|---|---|
| Resource Display Name | Resource Department | Missing Hours |
| ResourceTitle | Billable Type Hours | |
| Resource Primary Cost Center Name | Non Billable Type Hours | |
| Resource Location | Working Hours | |
| Resource Type | Time Off Hours V2 | |
| Resource Temporary Worker Flag | Holiday Hours | |
| Resource Pay Category | Normal Working Hours | |
| Resource Company | ||
FACT Ops Data by Wk
| Row Fields | Page Fields | Data Fields |
|---|---|---|
| ProjectCode | ResourceDisplayName | PersonHours |
| ResourceDepartment | ChargeableHours | |
| ResourceTitle | StandardRevenue | |
| ResourcePrimaryCostCenterName | ContractRevenue | |
| ResourceLocation | BillingAdjustedRevenue | |
| ResourceType | SystemRevenue | |
| ResourceTemporaryWorkerFlag | RecognizedRevenue | |
| ResourcePayCategory | OtherDirectCostsRevenue | |
| ResourceCompany | ResourceDirectCost | |
| StandardTaskType | OtherDirectCostsClient | |
| ProjectTaskType | OdcUnreimbursed | |
| FullWbsCode | TotalRevenue | |
| ProjectRateType | TotalRecognizedRevenue | |
| StandardRateType | PotentialStandardRevenue | |
| CostCode | Units | |
| ExpenseDocumentType | BudgetedHours | |
| UnitsName | BudgetedChargeableHours | |
| HoursType | BudgetedBillingAdjustedRevenue | |
| BillingStatus | BudgetedContractRevenue | |
| InvoiceNumber | BudgetedResourceDirectCost | |
| Role | BudgetedOtherDirectCostsClient | |
| RoleTypeName | NormalWorkingHours | |
| ACOD | WorkingHours | |
| TimeOffReasonV2 | UtilizationBasisHours | |
| BillableUtilizationMinTargetHours | ||
| BillableUtilizationMaxTargetHours | ||
| ChargeableUtilizationMinTargetHours | ||
| ChargeableUtilizationMaxTargetHours | ||
| ProductiveUtilizationMinTargetHours | ||
| ProductiveUtilizationMaxTargetHours | ||
| TotalUtilizationMinTargetHours | ||
| TotalUtilizationMaxTargetHours | ||
| Headcount | ||
| ResourceEquivalents | ||
| ProjectMargin | ||
| ResourceMargin | ||
| RevenueLossDueToDiscounting | ||
| RevenueLossDueToContractTerms | ||
| RevenueLossDueToWriteDowns |
FACT Fin Data by Month
| Row Fields | Data Fields |
|---|---|
| Project Code | PersonHours |
| ResourceDisplayName | ChargeableHours |
| ResourceDepartment | SystemRevenue |
| ResourceTitle | ResourceDirectCost |
| ResourcePrimaryCostCenterName | Total Revenue |
| ResourceLocation | Potential Standard Revenue |
| ResourceType | Resource Profit |
| ResourceTemporaryWorkerFlag | ProjectProfit |
| ResourcePayCategory | Headcount |
| ResourceCompany | |
| Actuals Cut Off Date (ACOD) |
FACT Portfolio Perf
| Row Fields | Page Fields | Data Fields |
|---|---|---|
| Project Code | RevenueLastRecognizedOnTime | ActualHoursToDate |
| Project Time Budget Metric | RevenueLastRecognizedThroughDate | ProjectedHoursToComplete |
| Project Cost Budget Metric | HoursBudgetAlertLevelAtCompletion | BudgetedHoursAtCompletion |
| HoursBudgetAlertLevelToDate | ActualChargeableHoursToDate | |
| ChargeableHoursBudgetAlertLevelAtCompletion | ProjectedChargeableHoursToComplete | |
| ChargeableHoursBudgetAlertLevelToDate | BudgetedChargeableHoursAtCompletion | |
| BillingAdjustedRevenueBudgetAlertLevelAtCompletion | ActualBillingAdjustedRevenueToDate | |
| BillingAdjustedRevenueBudgetAlertLevelToDate | ProjectedBillingAdjustedRevenueToComplete | |
| ResourceDirectCostBudgetAlertLevelAtCompletion | BudgetedBillingAdjustedRevenueAtCompletion | |
| ResourceDirectCostBudgetAlertLevelToDate | ActualContractRevenueToDate | |
| TaskHoursBudgetAlertLevelAtCompletion | ProjectedContractRevenueToComplete | |
| TaskHoursBudgetAlertLevelToDate | BudgetedContractRevenueAtCompletion | |
| ContractRevenueBudgetAlertLevelAtCompletion | BudgetedContractRevenueRemaining | |
| ContractRevenueBudgetAlertLevelToDate | ActualResourceDirectCostToDate | |
| ClientAmountBudgetAlertLevelAtCompletion | ProjectedResourceDirectCostToComplete | |
| ClientAmountBudgetAlertLevelToDate | BudgetedResourceDirectCostAtCompletion | |
| ACOD | ActualTaskHoursToDate | |
| ProjectStartDate | ProjectedTaskHoursToComplete | |
| ProjectEndDate | BudgetedTaskHoursAtCompletion | |
| ActualClientAmountToDate | ||
| ProjectedClientAmountToComplete | ||
| BudgetedClientAmountAtCompletion | ||
| ActualSystemRevenueToDate | ||
| ProjectedSystemRevenueToComplete | ||
| ActualSystemRevenueRecognizedToDate | ||
| SystemRevenueToBeRecognized | ||
| DeliveryMilestonesToDate | ||
| IncompleteDeliveryMilestonesToDate | ||
| LateDeliveryMilestonesToDate | ||
| DeliveryMilestonesAtCompletion | ||
| TasksToDate | ||
| IncompleteTasksToDate | ||
| LateTasksToDate | ||
| OverbudgetTasksToDate | ||
| TasksAtCompletion | ||
| TaskPlanStartDate | ||
| TaskPlanEndDate | ||
| ProjectedCostStartDate | ||
| ProjectedCostEndDate | ||
| ActualHoursStartDate | ||
| ActualHoursEndDate | ||
| UnbilledBillingAdjustedRevenue | ||
| UnbilledClientAmount | ||
| UnbilledMilestoneAmount | ||
| BilledBillingAdjustedRevenue | ||
| BilledClientAmount | ||
| BilledMilestoneAmount | ||
| AchievedMilestonesToDate | ||
| UnachievedMilestonesToDate | ||
| ForegoneMilestonesToDate | ||
| ActualCost(ACWP) | ||
| EarnedValue(BCWP) | ||
| PlannedValue(BCWS) | ||
| OpenIssues | ||
| TotalIssues | ||
| LateIssues | ||
| OpenHighPriorityIssues | ||
| HoursAtCompletion | ||
| ProjectedHoursStartDate | ||
| ProjectedHoursEndDate | ||
| SystemRevenueAtCompletion | ||
| SystemRevenueRecognized | ||
| ActualSystemRevenueToBeRecognizedToDate | ||
| ResourceProfitAtCompletion | ||
| ResourceDirectCostAtCompletion | ||
| RevenueLossDueToContractTermsAtCompletion | ||
| RevenueLossDueToDiscountingAtCompletion | ||
| RevenueLossDueToWriteDownsAtCompletion |
FACT Expense Exception
| ExpenseDocumentNumber |
|---|
| ExpenseDocumentName |
| ExpenseDocumentType |
| ResourceDisplayName |
| ProjectCode |
| ExpenseType |
| CompanyPaidFlag |
| DisbursedAmountEngagementCurrency |
| ClientAmountEngagementCurrency |
| ApprovalWorkflowStatus |
| PaymentWorkflowStatus |
| InvoicingWorkflowStatus |
| SubmittedBy |
| SubmittedTime |
| ApprovedBy |
| ApprovedTime |
| BillingStatus |
| CostCardApproverDisplayName |