| 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) |
|
