| 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 |
Calculated by dividing Scheduled Billable Amount by the estimated number of hours or days, depending on whether the Bill Rate is Daily Rate field is selected on the assignment. If Scheduled Billable Amount is blank, this is the bill rate from the assignment.
Formula:
IF( ISBLANK(Scheduled_Billable_Amount__c), BLANKVALUE(pse__Assignment__r.pse__Bill_Rate__c, 0.0), IF( IF(Scheduled_Bill_Rate_is_Daily_Rate__c == 'true', Estimated_Days__c == 0, Estimated_Hours__c == 0), 0, Scheduled_Billable_Amount__c / IF(Scheduled_Bill_Rate_is_Daily_Rate__c == 'true', Estimated_Days__c, Estimated_Hours__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 |
|
| Scheduled_Billable_Amount__c |
(Beta) Scheduled Billable Amount |
Spring 2025 |
Calculated using the assignment's bill rate, or bill rate card if dated rates are used. Depending on whether Bill Rate is Daily Rate is selected on the assignment, the relevant rates are applied to the hours or days set out on the assignment's schedule.
|
Currency(18,2) |
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 |
|
