| Billable_External_Hours__c |
Billable Hours (External) |
Pre-Spring 2018 |
Billable timecard hours from external resources.
|
Number(18,2) |
false |
0.00 |
| Billable_Internal_Hours__c |
Billable Hours (Internal) |
Pre-Spring 2018 |
Billable timecard hours from internal resources.
|
Number(18,2) |
false |
0.00 |
| Billed__c |
Billed |
Pre-Spring 2018 |
Sum of the amounts marked as billed.
|
Currency(18,2) |
false |
0.00 |
| Billings__c |
Billings |
Pre-Spring 2018 |
Sum of of ready-to-bill revenue from business records.
|
Currency(18,2) |
false |
0.00 |
| Bookings__c |
Bookings |
Pre-Spring 2018 |
Sum of amount from Customer POs and Customer PO Change budgets.
|
Currency(18,2) |
false |
0.00 |
| Credited_Non_Billable_Internal_Hours__c |
Credited Hours |
Pre-Spring 2018 |
Credited Non-Billable timecard hours from internal resource.
|
Number(18,2) |
false |
0.00 |
| End_Date__c |
End Date |
Pre-Spring 2018 |
Formula:
Time_Period__r.End_Date__c
|
Date |
false |
|
| Excluded_Hours__c |
Excluded Hours |
Pre-Spring 2018 |
Excluded Non-Billable timecard hours from internal resource.
|
Number(18,2) |
false |
0.00 |
| Expense_Budget__c |
Expense Budget |
Pre-Spring 2018 |
Sum of expense amount from budgets.
|
Currency(18,2) |
false |
0.00 |
| Expense_Costs__c |
Expense Costs |
Pre-Spring 2018 |
Sum of costs associated with expenses.
|
Currency(18,2) |
false |
0.00 |
| External_Costs__c |
External Costs |
Pre-Spring 2018 |
Sum of costs from external resources.
|
Currency(18,2) |
false |
0.00 |
| Has_Difference_In_Verification__c |
Has Difference in Verification |
Fall 2021 |
Formula to identify the differences between actuals and verification actuals.
Formula:
AND( NOT(ISBLANK(pse__Verified_By__c)), OR( (ROUND(pse__Bookings__c, 2) != ROUND(pse__Verified_By__r.pse__Bookings__c, 2)), (ROUND(pse__Pre_Billed__c, 2) != ROUND(pse__Verified_By__r.pse__Pre_Billed__c, 2)), (ROUND(pse__Billings__c, 2) != ROUND(pse__Verified_By__r.pse__Billings__c, 2)), (ROUND(pse__Billings__c, 2) != ROUND(pse__Verified_By__r.pse__Billings__c, 2)), (ROUND(pse__Billable_External_Hours__c, 2) != ROUND(pse__Verified_By__r.pse__Billable_External_Hours__c, 2)), (ROUND(pse__Billable_Internal_Hours__c, 2) != ROUND(pse__Verified_By__r.pse__Billable_Internal_Hours__c, 2)), (ROUND(pse__Billed__c, 2) != ROUND(pse__Verified_By__r.pse__Billed__c, 2)), (ROUND(pse__Credited_Non_Billable_Internal_Hours__c, 2) != ROUND(pse__Verified_By__r.pse__Credited_Non_Billable_Internal_Hours__c, 2)), (ROUND(pse__Excluded_Hours__c, 2) != ROUND(pse__Verified_By__r.pse__Excluded_Hours__c, 2)), (ROUND(pse__Internal_Budget__c, 2) != ROUND(pse__Verified_By__r.pse__Internal_Budget__c, 2)), (ROUND(pse__Expense_Budget__c, 2) != ROUND(pse__Verified_By__r.pse__Expense_Budget__c, 2)), (ROUND(pse__Expense_Costs__c, 2) != ROUND(pse__Verified_By__r.pse__Expense_Costs__c, 2)), (ROUND(pse__External_Costs__c, 2) != ROUND(pse__Verified_By__r.pse__External_Costs__c, 2)), (ROUND(pse__Internal_Costs__c, 2) != ROUND(pse__Verified_By__r.pse__Internal_Costs__c, 2)), (ROUND(pse__Invoiced__c, 2) != ROUND(pse__Verified_By__r.pse__Invoiced__c, 2)), (ROUND(pse__Non_Billable_External_Hours__c, 2) != ROUND(pse__Verified_By__r.pse__Non_Billable_External_Hours__c, 2)), (ROUND(pse__Non_Billable_Internal_Hours__c, 2) != ROUND(pse__Verified_By__r.pse__Non_Billable_Internal_Hours__c, 2)), (ROUND(pse__Other_Costs__c, 2) != ROUND(pse__Verified_By__r.pse__Other_Costs__c, 2)), (ROUND(pse__Pass_Through_Billings__c, 2) != ROUND(pse__Verified_By__r.pse__Pass_Through_Billings__c, 2)), (ROUND(pse__Revenue__c, 2) != ROUND(pse__Verified_By__r.pse__Revenue__c, 2)), (ROUND(pse__Total_Costs__c, 2) != ROUND(pse__Verified_By__r.pse__Total_Costs__c, 2)) ) )
|
Checkbox |
false |
|
| Internal_Budget__c |
Internal Budget |
Pre-Spring 2018 |
Sum of Internal Budget and Internal Budget Change Request amounts.
|
Currency(18,2) |
false |
0.00 |
| Internal_Costs__c |
Internal Costs |
Pre-Spring 2018 |
Sum of costs from internal resources.
|
Currency(18,2) |
false |
0.00 |
| Invoiced__c |
Invoiced |
Pre-Spring 2018 |
Sum of the invoiced amounts.
|
Currency(18,2) |
false |
0.00 |
| Is_Verification__c |
Is Verification |
Pre-Spring 2018 |
Contains true if this record serves to verify the contents of another record
|
Checkbox |
|
false |
| Margin__c |
Margin |
Pre-Spring 2018 |
Sum of Billings and Pass-Through Billings minus Total Costs.
Formula:
Billings__c + Pass_Through_Billings__c - Internal_Costs__c - External_Costs__c - Expense_Costs__c - Other_Costs__c
|
Currency(18,2) |
false |
|
| Non_Billable_External_Hours__c |
Non-Billable Hours (External) |
Pre-Spring 2018 |
Non-Billable timecard hours from external resources.
|
Number(18,2) |
false |
0.00 |
| Non_Billable_Internal_Hours__c |
Non-Billable Hours (Internal) |
Pre-Spring 2018 |
Non-Billable timecard hours from internal resources.
|
Number(18,2) |
false |
0.00 |
| Other_Costs__c |
Other Costs |
Pre-Spring 2018 |
Sum of miscellaneous adjustment other cost amounts.
|
Currency(18,2) |
false |
0.00 |
| Pass_Through_Billings__c |
Pass-Through Billings |
Pre-Spring 2018 |
Sum of Billable expense and miscellaneous adjustment pass-through-ready-to-bill revenue amounts.
|
Currency(18,2) |
false |
0.00 |
| Pre_Billed__c |
Pre-Billed |
Pre-Spring 2018 |
Sum of pre-billed amounts from budgets or miscellaneous adjustments.
|
Currency(18,2) |
false |
0.00 |
| Resource__c |
Resource |
Pre-Spring 2018 |
Looks up to: Contact
|
MasterDetail |
|
|
| Revenue__c |
Revenue |
Pre-Spring 2018 |
Sum of revenue amount from miscellaneous adjustments.
|
Currency(18,2) |
false |
0.00 |
| Start_Date__c |
Start Date |
Pre-Spring 2018 |
Formula:
Time_Period__r.Start_Date__c
|
Date |
false |
|
| Time_Period__c |
Time Period |
Pre-Spring 2018 |
Looks up to: Time_Period__c
|
MasterDetail |
|
|
| Total_Costs__c |
Total Costs |
Pre-Spring 2018 |
Sum of internal, external, expense and other costs.
Formula:
Internal_Costs__c + External_Costs__c + Expense_Costs__c + Other_Costs__c
|
Currency(18,2) |
false |
|
| Total_Time_Period_Hours__c |
Total Time Period Hours |
Pre-Spring 2018 |
|
Number(18,2) |
false |
|
| Unique_Name__c |
Unique Name |
Pre-Spring 2018 |
|
Text(80) |
true |
|
| Utilization_Calculation_Date__c |
Utilization: Last Calculation Date |
Pre-Spring 2018 |
|
Date |
false |
|
| Utilization_Elapsed_Hours__c |
Utilization: Elapsed Hours |
Pre-Spring 2018 |
|
Number(18,2) |
false |
|
| Utilization_Over_Full_Time_Period__c |
Utilization: Over Full Time Period |
Pre-Spring 2018 |
Formula:
IF((Total_Time_Period_Hours__c>Excluded_Hours__c),IF(AND(NOT(ISNULL(Billable_Internal_Hours__c)),NOT(ISNULL(Credited_Non_Billable_Internal_Hours__c)),NOT(ISNULL(Total_Time_Period_Hours__c)),NOT(ISNULL(Excluded_Hours__c))),(Billable_Internal_Hours__c + Credited_Non_Billable_Internal_Hours__c)/(Total_Time_Period_Hours__c - Excluded_Hours__c),0.00),0.00)
|
Percent(18,2) |
false |
|
| Utilization__c |
Utilization |
Pre-Spring 2018 |
Formula:
IF((Utilization_Elapsed_Hours__c>Excluded_Hours__c),IF(AND(NOT(ISNULL(Billable_Internal_Hours__c)),NOT(ISNULL(Credited_Non_Billable_Internal_Hours__c)),NOT(ISNULL(Utilization_Elapsed_Hours__c)),NOT(ISNULL(Excluded_Hours__c))),(Billable_Internal_Hours__c + Credited_Non_Billable_Internal_Hours__c)/(Utilization_Elapsed_Hours__c - Excluded_Hours__c),0.00),0.00)
|
Percent(18,2) |
false |
|
| Verified_By__c |
Verified By |
Pre-Spring 2018 |
Self-join to store a temporary recalculation of the actuals for verification purposes
Looks up to: Resource_Actuals__c
|
Lookup |
false |
|
