| pse__Billable_External_Hours__c |
Billable Hours (External) |
Pre-Spring 2018 |
Billable timecard hours from external resources.
|
Number(18,2) |
false |
0.00 |
| pse__Billable_Internal_Hours__c |
Billable Hours (Internal) |
Pre-Spring 2018 |
Billable timecard hours from internal resources.
|
Number(18,2) |
false |
0.00 |
| pse__Billed__c |
Billed |
Pre-Spring 2018 |
Sum of the amounts marked as billed.
|
Currency(18,2) |
false |
0.00 |
| pse__Billings__c |
Billings |
Pre-Spring 2018 |
Sum of of ready-to-bill revenue from business records.
|
Currency(18,2) |
false |
0.00 |
| pse__Bookings__c |
Bookings |
Pre-Spring 2018 |
Sum of amount from Customer POs and Customer PO Change budgets.
|
Currency(18,2) |
false |
0.00 |
| pse__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 |
| pse__End_Date__c |
End Date |
Pre-Spring 2018 |
Formula:
pse__Time_Period__r.pse__End_Date__c
|
Date |
false |
|
| pse__Excluded_Hours__c |
Excluded Hours |
Pre-Spring 2018 |
Excluded Non-Billable timecard hours from internal resource.
|
Number(18,2) |
false |
0.00 |
| pse__Expense_Budget__c |
Expense Budget |
Pre-Spring 2018 |
Sum of expense amount from budgets.
|
Currency(18,2) |
false |
0.00 |
| pse__Expense_Costs__c |
Expense Costs |
Pre-Spring 2018 |
Sum of costs associated with expenses.
|
Currency(18,2) |
false |
0.00 |
| pse__External_Costs__c |
External Costs |
Pre-Spring 2018 |
Sum of costs from external resources.
|
Currency(18,2) |
false |
0.00 |
| pse__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 |
|
| pse__Internal_Budget__c |
Internal Budget |
Pre-Spring 2018 |
Sum of Internal Budget and Internal Budget Change Request amounts.
|
Currency(18,2) |
false |
0.00 |
| pse__Internal_Costs__c |
Internal Costs |
Pre-Spring 2018 |
Sum of costs from internal resources.
|
Currency(18,2) |
false |
0.00 |
| pse__Invoiced__c |
Invoiced |
Pre-Spring 2018 |
Sum of the invoiced amounts.
|
Currency(18,2) |
false |
0.00 |
| pse__Is_Verification__c |
Is Verification |
Pre-Spring 2018 |
Contains true if this record serves to verify the contents of another record
|
Checkbox |
|
false |
| pse__Margin__c |
Margin |
Pre-Spring 2018 |
Sum of Billings and Pass-Through Billings minus Total Costs.
Formula:
pse__Billings__c + pse__Pass_Through_Billings__c - pse__Internal_Costs__c - pse__External_Costs__c - pse__Expense_Costs__c - pse__Other_Costs__c
|
Currency(18,2) |
false |
|
| pse__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 |
| pse__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 |
| pse__Other_Costs__c |
Other Costs |
Pre-Spring 2018 |
Sum of miscellaneous adjustment other cost amounts.
|
Currency(18,2) |
false |
0.00 |
| pse__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 |
| pse__Pre_Billed__c |
Pre-Billed |
Pre-Spring 2018 |
Sum of pre-billed amounts from budgets or miscellaneous adjustments.
|
Currency(18,2) |
false |
0.00 |
| pse__Resource__c |
Resource |
Pre-Spring 2018 |
Looks up to: Contact
|
MasterDetail |
|
|
| pse__Revenue__c |
Revenue |
Pre-Spring 2018 |
Sum of revenue amount from miscellaneous adjustments.
|
Currency(18,2) |
false |
0.00 |
| pse__Start_Date__c |
Start Date |
Pre-Spring 2018 |
Formula:
pse__Time_Period__r.pse__Start_Date__c
|
Date |
false |
|
| pse__Time_Period__c |
Time Period |
Pre-Spring 2018 |
Looks up to: pse__Time_Period__c
|
MasterDetail |
|
|
| pse__Total_Costs__c |
Total Costs |
Pre-Spring 2018 |
Sum of internal, external, expense and other costs.
Formula:
pse__Internal_Costs__c + pse__External_Costs__c + pse__Expense_Costs__c + pse__Other_Costs__c
|
Currency(18,2) |
false |
|
| pse__Total_Time_Period_Hours__c |
Total Time Period Hours |
Pre-Spring 2018 |
|
Number(18,2) |
false |
|
| pse__Unique_Name__c |
Unique Name |
Pre-Spring 2018 |
|
Text(80) |
true |
|
| pse__Utilization_Calculation_Date__c |
Utilization: Last Calculation Date |
Pre-Spring 2018 |
|
Date |
false |
|
| pse__Utilization_Elapsed_Hours__c |
Utilization: Elapsed Hours |
Pre-Spring 2018 |
|
Number(18,2) |
false |
|
| pse__Utilization_Over_Full_Time_Period__c |
Utilization: Over Full Time Period |
Pre-Spring 2018 |
Formula:
IF((pse__Total_Time_Period_Hours__c>pse__Excluded_Hours__c),IF(AND(NOT(ISNULL(pse__Billable_Internal_Hours__c)),NOT(ISNULL(pse__Credited_Non_Billable_Internal_Hours__c)),NOT(ISNULL(pse__Total_Time_Period_Hours__c)),NOT(ISNULL(pse__Excluded_Hours__c))),(pse__Billable_Internal_Hours__c + pse__Credited_Non_Billable_Internal_Hours__c)/(pse__Total_Time_Period_Hours__c - pse__Excluded_Hours__c),0.00),0.00)
|
Percent(18,2) |
false |
|
| pse__Utilization__c |
Utilization |
Pre-Spring 2018 |
Formula:
IF((pse__Utilization_Elapsed_Hours__c>pse__Excluded_Hours__c),IF(AND(NOT(ISNULL(pse__Billable_Internal_Hours__c)),NOT(ISNULL(pse__Credited_Non_Billable_Internal_Hours__c)),NOT(ISNULL(pse__Utilization_Elapsed_Hours__c)),NOT(ISNULL(pse__Excluded_Hours__c))),(pse__Billable_Internal_Hours__c + pse__Credited_Non_Billable_Internal_Hours__c)/(pse__Utilization_Elapsed_Hours__c - pse__Excluded_Hours__c),0.00),0.00)
|
Percent(18,2) |
false |
|
| pse__Verified_By__c |
Verified By |
Pre-Spring 2018 |
Self-join to store a temporary recalculation of the actuals for verification purposes
Looks up to: pse__Resource_Actuals__c
|
Lookup |
false |
|
