Professional Services Automation Data Dictionary

Group_Actuals__c

Label: Group Actuals

Represents rolled-up revenues and costs expressed in the group currency for a particular time period, as well as total hours for the parent group. Groups and time periods have a master-detail relationship with group actuals.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Billable_External_Hours__c Billable Hours (External) Pre-Spring 2018 Number(18,2) 0.00
Billable_Internal_Hours__c Billable Hours (Internal) Pre-Spring 2018 Number(18,2) 0.00
Billed__c Billed Pre-Spring 2018 Currency(18,2) 0.00
Billings__c Billings Pre-Spring 2018 Currency(18,2) 0.00
Bookings__c Bookings Pre-Spring 2018 Currency(18,2) 0.00
Credited_Non_Billable_Internal_Hours__c Credited Hours Pre-Spring 2018 Number(18,2) 0.00
End_Date__c End Date Pre-Spring 2018 Formula:
Time_Period__r.End_Date__c
Date
Excluded_Hours__c Excluded Hours Pre-Spring 2018 Number(18,2) 0.00
Expense_Budget__c Expense Budget Pre-Spring 2018 Currency(18,2) 0.00
Expense_Costs__c Expense Costs Pre-Spring 2018 Currency(18,2) 0.00
External_Costs__c External Costs Pre-Spring 2018 Currency(18,2) 0.00
Group_Head__c Group Owner Pre-Spring 2018 Formula:
Group__r.Group_Head__r.FirstName & " " & Group__r.Group_Head__r.LastName
Text
Group__c Group Pre-Spring 2018 Looks up to: Grp__c
MasterDetail
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
Internal_Budget__c Internal Budget Pre-Spring 2018 Currency(18,2) 0.00
Internal_Costs__c Internal Costs Pre-Spring 2018 Currency(18,2) 0.00
Invoiced__c Invoiced Pre-Spring 2018 Currency(18,2) 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 Formula:
Billings__c + Pass_Through_Billings__c - Internal_Costs__c - External_Costs__c - Expense_Costs__c - Other_Costs__c
Currency(18,2)
Non_Billable_External_Hours__c Non-Billable Hours (External) Pre-Spring 2018 Number(18,2) 0.00
Non_Billable_Internal_Hours__c Non-Billable Hours (Internal) Pre-Spring 2018 Number(18,2) 0.00
Other_Costs__c Other Costs Pre-Spring 2018 Currency(18,2) 0.00
Pass_Through_Billings__c Pass-Through Billings Pre-Spring 2018 Currency(18,2) 0.00
Pre_Billed__c Pre-Billed Pre-Spring 2018 Currency(18,2) 0.00
Revenue__c Revenue Pre-Spring 2018 Currency(18,2) 0.00
Scheduled_Backlog_Calculated_Date__c Scheduled Backlog Calculated Date Pre-Spring 2018 Date Today()
Scheduled_Milestone__c Scheduled Milestone Pre-Spring 2018 Currency(18,2)
Scheduled_Time__c Scheduled Time Pre-Spring 2018 Currency(18,2)
Start_Date__c Start Date Pre-Spring 2018 Formula:
Time_Period__r.Start_Date__c
Date
Time_Period_Type__c Time Period Type Pre-Spring 2018 Formula:
TEXT(Time_Period__r.Type__c)
Text
Time_Period__c Time Period Pre-Spring 2018 Looks up to: Time_Period__c
MasterDetail
Total_Costs__c Total Costs Pre-Spring 2018 Formula:
Internal_Costs__c + External_Costs__c + Expense_Costs__c + Other_Costs__c
Currency(18,2)
Unique_Name__c Unique Name Pre-Spring 2018 Text(80)
Unscheduled_Backlog__c Unscheduled Backlog Pre-Spring 2018 Currency(18,2)
Verified_By__c Verified By Pre-Spring 2018 Self-join to store a temporary recalculation of the actuals for verification purposes

Looks up to: Group_Actuals__c
Lookup


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