Professional Services Automation Data Dictionary

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 NameField LabelCreated in VersionDescriptionTypeDefault 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)


© Copyright 2009–2023 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.