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. 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	Required	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)	false
Actual_Billable_Amount__c	Actual Billable Amount	Pre-Spring 2018	The billable amount of timecard hours	Currency(18,2)	false	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)	false
Actual_Days__c	Actual Days	Pre-Spring 2018		Number(18,6)	false
Actual_Hours__c	Actual Hours	Pre-Spring 2018		Number(12,2)	true
Assignment__c	Assignment	Pre-Spring 2018	Looks up to: Assignment__c	Lookup	false
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)	false
Days_Variance__c	Days Variance	Pre-Spring 2018	Formula: Actual_Days__c - Estimated_Days__c	Number(18,6)	false
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	true
Estimated_Days__c	Estimated Days	Pre-Spring 2018		Number(18,6)	false
Estimated_Hours__c	Estimated Hours	Pre-Spring 2018		Number(12,2)	true
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)	false
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)	false
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	false
Project__c	Project	Pre-Spring 2018	Looks up to: Proj__c	Lookup	false
Resource_Request_Bill_Rate__c	Resource Request Bill Rate	Fall 2019	The bill rate amount for the requested resource.	Currency(18,2)	false	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)	false
Resource_Request_Hours__c	Resource Request Hours	Fall 2019	The number of requested hours scheduled on the held resource request.	Number(12,2)	false
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	false
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	false
Scheduled_Bill_Rate__c	Scheduled Bill Rate	Pre-Spring 2018	Formula: Assignment__r.Bill_Rate__c	Currency(18,4)	false
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	false
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	true
Time_Period_Type__c	Time Period Type	Pre-Spring 2018	The type of time period this time span represents	Picklist: Month Quarter Week	false
Time_Period__c	Time Period	Pre-Spring 2018	The associated time period Looks up to: Time_Period__c	Lookup	false
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)	false