Est_Vs_Actuals__c

Label: Est Vs Actuals

Compares the estimated and actual hours worked by a resource on an assignment, derived from scheduled hours and entered timecard hours respectively. FinancialForce PSA generates Est Vs Actuals when you create or update assignments and schedules, and when timecard hours are entered for an assignment.

Field Name	Field Label	Created in Version	Description	Type	Default Value
Actual_Average_Bill_Rate__c	Actual Average Bill Rate	Pre-Spring 2018	Actual Billable Amount divided by Actual Hours or Actual Days as appropriate Formula: IF(OR(Actual_Days__c = 0, Actual_Hours__c = 0), 0, IF ( Assignment__r.Daily_Bill_Rate__c, (Actual_Billable_Amount__c / Actual_Days__c), (Actual_Billable_Amount__c / Actual_Hours__c)))	Currency(18,4)
Actual_Billable_Amount__c	Actual Billable Amount	Pre-Spring 2018	The billable amount of timecard hours	Currency(18,2)	0
Actual_Days_Aggregated__c	Actual Days (Aggregated)	Pre-Spring 2018	Actual number of days worked in the time period based on aggregated timecards by week.	Number(18,6)
Actual_Days__c	Actual Days	Pre-Spring 2018		Number(18,6)
Actual_Hours__c	Actual Hours	Pre-Spring 2018		Number(12,2)
Assignment__c	Assignment	Pre-Spring 2018	Looks up to: Assignment__c	Lookup
Days_Percent_Variance__c	Days Percent Variance	Pre-Spring 2018	Formula: IF(Estimated_Days__c=0,0,(Actual_Days__c - Estimated_Days__c) / Estimated_Days__c)	Percent(18,2)
Days_Variance__c	Days Variance	Pre-Spring 2018	Formula: Actual_Days__c - Estimated_Days__c	Number(18,6)
End_Date__c	End Date	Pre-Spring 2018	End date of the time period for this record. This should not be confused with the end date of the associated assignment or timecards.	Date
Estimated_Days__c	Estimated Days	Pre-Spring 2018		Number(18,6)
Estimated_Hours__c	Estimated Hours	Pre-Spring 2018		Number(12,2)
Percent_Variance__c	Hours Percent Variance	Pre-Spring 2018	Formula: IF(Estimated_Hours__c != 0,(Actual_Hours__c - Estimated_Hours__c) / Estimated_Hours__c,0)	Percent(18,2)
Project_Currency_Exchange_Rate__c	Project Currency Exchange Rate	Fall 2019	Project (bill rate) exchange rate, relative to corporate currency, calculated on the end date of the schedule.	Number(18,6)
Project_Manager__c	Project Manager	Pre-Spring 2018	Linked to the project manager for the project. This allows for easier workflow alerts to be sent Looks up to: Contact	Lookup
Project__c	Project	Pre-Spring 2018	Looks up to: Proj__c	Lookup
Resource_Request_Bill_Rate__c	Resource Request Bill Rate	Fall 2019	The bill rate amount for the requested resource.	Currency(18,2)	0
Resource_Request_Days__c	Resource Request Days	Fall 2019	The number of requested days scheduled for the work on the held resource request during the time period.	Number(18,6)
Resource_Request_Hours__c	Resource Request Hours	Fall 2019	The number of requested hours scheduled on the held resource request.	Number(12,2)
Resource_Request__c	Resource Request	Fall 2019	Lookup to the held resource request relating to this Estimates Versus Actuals record. Looks up to: Resource_Request__c	Lookup
Resource__c	Resource	Pre-Spring 2018	Linked to the resource record for the assignment. This allows for easier workflow alerts to be sent Looks up to: Contact	Lookup
Scheduled_Bill_Rate__c	Scheduled Bill Rate	Pre-Spring 2018	Formula: Assignment__r.Bill_Rate__c	Currency(18,4)
Scheduled_Bill_Rate_is_Daily_Rate__c	Scheduled Bill Rate is Daily Rate	Pre-Spring 2018	Formula: IF(Assignment__r.Daily_Bill_Rate__c, 'true', 'false')	Text
Start_Date__c	Start Date	Pre-Spring 2018	Start date of the time period for this record. This should not be confused with the start date of the associated assignment or timecards.	Date
Time_Period_Type__c	Time Period Type	Pre-Spring 2018	The type of time period this time span represents	Picklist: Month Quarter Week
Time_Period__c	Time Period	Pre-Spring 2018	The associated time period Looks up to: Time_Period__c	Lookup
Timecards_Submitted__c	Timecards Submitted	Pre-Spring 2018		Checkbox	false
Variance__c	Hours Variance	Pre-Spring 2018	Formula: Actual_Hours__c - Estimated_Hours__c	Number(18,2)