Professional Services Automation Data Dictionary

pse__Grp__c

Label: Group

An entity that usually represents a functional business area or business vertical. Groups are organized as an independent hierarchy determined by the Parent Group field, with parent and child records of the same type. Every group in the hierarchy may contain projects, resources (contacts), and other objects. The hierarchy allows roll-ups of revenue, cost, and time totals.

Field NameField LabelCreated in VersionDescriptionTypeRequiredDefault Value
pse__Action_Update_Current_Time_Period__c Action: Update Current Time Period Pre-Spring 2018 Checkbox true
pse__Actuals_Last_Update_Date__c Actuals: Last Update Date Pre-Spring 2018 DateTime false
pse__Actuals_Last_Updated_By__c Actuals: Last Updated By Pre-Spring 2018 Looks up to: User

Lookup false
pse__Backlog_Last_Update_Date__c Backlog: Last Update Date Pre-Spring 2018 DateTime false
pse__Backlog_Last_Updated_By__c Backlog: Last Updated By Pre-Spring 2018 Looks up to: User

Lookup false
pse__Billable_External_Hours__c Billable Hours (External) Pre-Spring 2018 Number(18,2) false 0.00
pse__Billable_Internal_Hours__c Billable Hours (Internal) Pre-Spring 2018 Number(18,2) false 0.00
pse__Billed__c Billed Pre-Spring 2018 Currency(18,2) false 0.00
pse__Billings__c Billings Pre-Spring 2018 Currency(18,2) false 0.00
pse__Bookings__c Bookings Pre-Spring 2018 Currency(18,2) false 0.00
pse__Credited_Non_Billable_Internal_Hours__c Credited Hours Pre-Spring 2018 Number(18,2) false 0.00
pse__Current_Time_Period_End_Date__c Current Time Period End Date Pre-Spring 2018 Date false TODAY()
pse__Current_Time_Period__c Current Time Period Pre-Spring 2018 Looks up to: pse__Time_Period__c
Lookup false
pse__Default_Work_Calendar__c Default Work Calendar Pre-Spring 2018 Looks up to: pse__Work_Calendar__c
Lookup false
pse__Exclude_From_Utilization__c Exclude from Utilization Spring 2020 When selected, data in this group and any sub-groups are excluded from Utilization calculations when a calculation is run on a parent of this group.

Checkbox false
pse__Excluded_Hours__c Excluded Hours Pre-Spring 2018 Number(18,2) false 0.00
pse__Expense_Budget__c Expense Budget Pre-Spring 2018 Currency(18,2) false 0.00
pse__Expense_Costs__c Expense Costs Pre-Spring 2018 Currency(18,2) false 0.00
pse__External_Costs__c External Costs Pre-Spring 2018 Currency(18,2) false 0.00
pse__Group_Head__c Group Owner Pre-Spring 2018 Looks up to: Contact

Lookup false
pse__Group_ID_Chain__c Group ID Chain Pre-Spring 2018 Text(255) false
pse__Group_Name_Chain__c Group Name Chain Pre-Spring 2018 Text(255) false
pse__Hierarchy_Depth__c Hierarchy Depth Pre-Spring 2018 Number(2,0) false 0
pse__Hist_Sch_Utilization_Billable_Hours__c Hist Sch Utilization Billable Hours Pre-Spring 2018 The historical scheduled utilization billable hours total for the current time period. This value has been copied from the associated Utilization Detail object for this time period.

Number(18,2) false
pse__Hist_Sch_Utilization_Credited_Hours__c Hist Sch Utilization Credited Hours Pre-Spring 2018 The historical scheduled utilization credited hours total for the current time period. This value has been copied from the associated Utilization Detail object for this time period.

Number(18,2) false
pse__Hist_Sch_Utilization_Excluded_Hours__c Hist Sch Utilization Excluded Hours Pre-Spring 2018 The historical scheduled utilization excluded hours total for the current time period. This value has been copied from the associated Utilization Detail object for this time period.

Number(18,2) false
pse__Hist_Sch_Utilization_Held_Hours__c Hist Sch Utilization Held Hours Pre-Spring 2018 Number(18,2) false
pse__Hist_Sch_Utilization_Non_Billable_Hrs__c Hist Sch Utilization Non Billable Hrs Pre-Spring 2018 The historical scheduled utilization non-billable hours total for the current time period. This value has been copied from the associated Utilization Detail object for this time period.

Number(18,2) false
pse__Historical_Utilization_Billable_Hours__c Historical Utilization Billable Hours Pre-Spring 2018 The historical utilization billable hours total for the current time period. This value has been copied from the associated Utilization Detail object for this time period.

Number(18,2) false
pse__Historical_Utilization_Calendar_Hours__c Historical Utilization Calendar Hours Pre-Spring 2018 The historical utilization calendar hours for the current time period. This value has been copied from the associated Utilization Detail object for this time period.

Number(18,2) false
pse__Historical_Utilization_Credited_Hours__c Historical Utilization Credited Hours Pre-Spring 2018 The historical utilization credited hours total for the current time period. This value has been copied from the associated Utilization Detail object for this time period.

Number(18,2) false
pse__Historical_Utilization_Excluded_Hours__c Historical Utilization Excluded Hours Pre-Spring 2018 The historical utilization excluded hours total for the current time period. This value has been copied from the associated Utilization Detail object for this time period.

Number(18,2) false
pse__Historical_Utilization_Non_Billable_Hrs__c Historical Utilization Non Billable Hrs Pre-Spring 2018 The historical utilization non-billable hours total for the current time period. This value has been copied from the associated Utilization Detail object for this time period.

Number(18,2) false
pse__Historical_Utilization_Target_Attainment__c Historical Utilization Target Attainment Pre-Spring 2018 Formula:
IF(pse__Historical_Utilization_Target__c = 0, IF(pse__Historical_Utilization__c <= 0,0,1), pse__Historical_Utilization__c / pse__Historical_Utilization_Target__c )
Percent(18,2) false
pse__Historical_Utilization_Target_Hours__c Historical Utilization Target Hours Pre-Spring 2018 Number(18,2) false
pse__Historical_Utilization_Target__c Historical Utilization Target Pre-Spring 2018 Formula:
IF(pse__Historical_Utilization_Calendar_Hours__c = 0, 0, pse__Historical_Utilization_Target_Hours__c / pse__Historical_Utilization_Calendar_Hours__c )
Percent(18,2) false
pse__Historical_Utilization__c Historical Utilization Pre-Spring 2018 The historical utilization percentage for the current time period. This value has been copied from the associated Utilization Detail object for this time period.

Percent(10,2) false
pse__Inactive_Project_Backlog__c Inactive Project Backlog Pre-Spring 2018 Currency(18,2) false
pse__Include_In_Forecasting__c Include In Forecasting Pre-Spring 2018 Does this group participate in forecasting?

Checkbox false
pse__Internal_Budget__c Internal Budget Pre-Spring 2018 Currency(18,2) false 0.00
pse__Internal_Costs__c Internal Costs Pre-Spring 2018 Currency(18,2) false 0.00
pse__Invoiced__c Invoiced Pre-Spring 2018 Currency(18,2) false 0.00
pse__Margin__c Margin Pre-Spring 2018 Formula:
pse__Billings__c + pse__Pass_Through_Billings__c - pse__External_Costs__c - pse__Internal_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 Number(18,2) false 0.00
pse__Non_Billable_Internal_Hours__c Non-Billable Hours (Internal) Pre-Spring 2018 Number(18,2) false 0.00
pse__Other_Costs__c Other Costs Pre-Spring 2018 Currency(18,2) false 0.00
pse__Parent_Group__c Parent Group Pre-Spring 2018 Looks up to: pse__Grp__c
Lookup false
pse__Pass_Through_Billings__c Pass-Through Billings Pre-Spring 2018 Currency(18,2) false 0.00
pse__Plan_Last_Update_Date__c Plan: Last Update Date Pre-Spring 2018 DateTime false
pse__Plan_Last_Updated_By__c Plan: Last Updated By Pre-Spring 2018 Looks up to: User

Lookup false
pse__Planned_Billings__c Planned Billings Pre-Spring 2018 Currency(18,2) false 0.00
pse__Planned_Bookings__c Planned Bookings Pre-Spring 2018 Currency(18,2) false 0.00
pse__Planned_External_Costs__c Planned External Costs Pre-Spring 2018 Currency(18,2) false 0.00
pse__Planned_Internal_Costs__c Planned Internal Costs Pre-Spring 2018 Currency(18,2) false 0.00
pse__Planned_Margin__c Planned Margin Pre-Spring 2018 Formula:
pse__Planned_Billings__c - pse__Planned_External_Costs__c - pse__Planned_Internal_Costs__c
Currency(18,2) false
pse__Planned_Revenue__c Planned Revenue Pre-Spring 2018 Currency(18,2) false 0.0
pse__Planned_Utilization__c Planned Utilization Pre-Spring 2018 Percent(5,2) false 0.00
pse__Pre_Billed__c Pre-Billed Pre-Spring 2018 Currency(18,2) false 0.00
pse__Revenue__c Revenue Pre-Spring 2018 Currency(18,2) false 0.00
pse__Reversed_ID_Chain__c Reversed Group ID Chain Fall 2020 System-generated reversed chain for linking to the group.

Text(255) false
pse__Scheduled_Backlog_Calculated_Date__c Scheduled Backlog Calculated Date Pre-Spring 2018 Date false Today()
pse__Scheduled_Backlog_End_Date__c Scheduled Backlog End Date Pre-Spring 2018 Date false
pse__Scheduled_Milestone__c Scheduled Milestone Pre-Spring 2018 Currency(18,2) false
pse__Scheduled_Time__c Scheduled Time Pre-Spring 2018 Currency(18,2) false
pse__Scheduled_Utilization_Billable_Hours__c Scheduled Utilization Billable Hours Pre-Spring 2018 The scheduled utilization billable hours total for the current time period. This value has been copied from the associated Utilization Detail object for this time period.

Number(18,2) false
pse__Scheduled_Utilization_Calendar_Hours__c Scheduled Utilization Calendar Hours Pre-Spring 2018 The scheduled utilization calendar hours total for the current time period. This value has been copied from the associated Utilization Detail object for this time period.

Number(16,0) false
pse__Scheduled_Utilization_Credited_Hours__c Scheduled Utilization Credited Hours Pre-Spring 2018 The scheduled utilization credited hours total for the current time period. This value has been copied from the associated Utilization Detail object for this time period.

Number(18,2) false
pse__Scheduled_Utilization_Excluded_Hours__c Scheduled Utilization Excluded Hours Pre-Spring 2018 The scheduled utilization excluded hours total for the current time period. This value has been copied from the associated Utilization Detail object for this time period.

Number(18,2) false
pse__Scheduled_Utilization_Held_Hours__c Scheduled Utilization Held Hours Pre-Spring 2018 Number(18,2) false
pse__Scheduled_Utilization_Non_Billable_Hrs__c Scheduled Utilization Non Billable Hrs Pre-Spring 2018 The scheduled utilization non-billable hours total for the current time period. This value has been copied from the associated Utilization Detail object for this time period.

Number(18,2) false
pse__Scheduled_Utilization_Target_Attainment__c Scheduled Utilization Target Attainment Pre-Spring 2018 Formula:
IF(pse__Scheduled_Utilization_Target__c = 0, IF(pse__Scheduled_Utilization__c <= 0,0,1), pse__Scheduled_Utilization__c / pse__Scheduled_Utilization_Target__c )
Percent(18,2) false
pse__Scheduled_Utilization_Target_Hours__c Scheduled Utilization Target Hours Pre-Spring 2018 Number(18,2) false
pse__Scheduled_Utilization_Target__c Scheduled Utilization Target Pre-Spring 2018 Formula:
IF(pse__Scheduled_Utilization_Calendar_Hours__c = 0, 0, pse__Scheduled_Utilization_Target_Hours__c / pse__Scheduled_Utilization_Calendar_Hours__c )
Percent(18,2) false
pse__Scheduled_Utilization__c Scheduled Utilization Pre-Spring 2018 The scheduled utilization percentage for the current time period. This value has been copied from the associated Utilization Detail object for this time period.

Percent(10,2) false
pse__Top_Level_Group__c Top-Level Group Pre-Spring 2018 Looks up to: pse__Grp__c
Lookup false
pse__Total_Costs__c Total Costs Pre-Spring 2018 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 [DEPRECATED, no longer used]

Number(18,2) false
pse__Total_Utilization__c Utilization Pre-Spring 2018 The overall (historical + scheduled) utilization percentage for the current time period. This value has been copied from the associated Utilization Detail object for this time period.

Percent(10,2) false
pse__Unscheduled_Backlog__c Unscheduled Backlog Pre-Spring 2018 Currency(18,2) false
pse__Utilization_Calculation_Date__c Utilization Calculation Date Pre-Spring 2018 The date that the utilization fields were last updated

Date false Today()
pse__Utilization_Elapsed_Hours__c Utilization: Elapsed Hours Pre-Spring 2018 [DEPRECATED, no longer used]

Number(18,2) false
pse__Utilization_Last_Calculation_Date__c Utilization: Last Calculation Date Pre-Spring 2018 Date false
pse__Utilization_Last_Update_Date__c Utilization: Last Update Date Pre-Spring 2018 DateTime false
pse__Utilization_Last_Updated_By__c Utilization: Last Updated By Pre-Spring 2018 Looks up to: User

Lookup false
pse__Utilization_Over_Full_Time_Period__c Utilization: Over Full Time Period Pre-Spring 2018 [DEPRECATED, no longer used]

Percent(18,2) false
pse__Utilization_Period_End_Date__c Utilization Period End Date Pre-Spring 2018 Date false
pse__Utilization_Period_Start_Date__c Utilization Period Start Date Pre-Spring 2018 Date false
pse__Utilization_Target_Attainment__c Utilization Target Attainment Pre-Spring 2018 Formula:
IF(pse__Utilization_Target__c = 0, IF(pse__Total_Utilization__c <= 0,0,1), pse__Total_Utilization__c / pse__Utilization_Target__c )
Percent(18,2) false
pse__Utilization_Target_Hours__c Utilization Target Hours Pre-Spring 2018 Number(18,2) false
pse__Utilization_Target__c Utilization Target Pre-Spring 2018 Formula:
IF(pse__Historical_Utilization_Calendar_Hours__c + pse__Scheduled_Utilization_Calendar_Hours__c = 0, 0, pse__Utilization_Target_Hours__c / ( pse__Historical_Utilization_Calendar_Hours__c + pse__Scheduled_Utilization_Calendar_Hours__c ) )
Percent(18,2) false
pse__Utilization__c Utilization Pre-Spring 2018 [DEPRECATED, no longer used]

Percent(18,2) false 0.00


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