Base Package Reports - FACT Tables

FACT Hiring Needs

Project Code

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

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

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

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

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

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

ExpenseDocumentNumber
ExpenseDocumentName
ExpenseDocumentType
ResourceDisplayName
ProjectCode
ExpenseType
CompanyPaidFlag
DisbursedAmountEngagementCurrency
ClientAmountEngagementCurrency
ApprovalWorkflowStatus
PaymentWorkflowStatus
InvoicingWorkflowStatus
SubmittedBy
SubmittedTime
ApprovedBy
ApprovedTime
BillingStatus
CostCardApproverDisplayName