Professional Services Automation Data Dictionary

Region__c

Label: Region

An entity that represents a geographic area in which you do business. Regions are organized as an independent hierarchy determined by the Parent Region field, with parent and child records of the same type. Every region 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
Action_Update_Current_Time_Period__c Action: Update Current Time Period Pre-Spring 2018 Checkbox true
Actuals_Last_Update_Date__c Actuals: Last Update Date Pre-Spring 2018 DateTime false
Actuals_Last_Updated_By__c Actuals: Last Updated By Pre-Spring 2018 Looks up to: User

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

 Lookup false
Billable_External_Hours__c Billable Hours (External) Pre-Spring 2018 Number(18,2) false 0.00
Billable_Internal_Hours__c Billable Hours (Internal) Pre-Spring 2018 Number(18,2) false 0.00
Billed__c Billed Pre-Spring 2018 Currency(18,2) false 0.00
Billings__c Billings Pre-Spring 2018 Currency(18,2) false 0.00
Bookings__c Bookings Pre-Spring 2018 Currency(18,2) false 0.00
Credited_Non_Billable_Internal_Hours__c Credited Hours Pre-Spring 2018 Number(18,2) false 0.00
Current_Time_Period_End_Date__c Current Time Period End Date Pre-Spring 2018 Date false TODAY()
Current_Time_Period__c Current Time Period Pre-Spring 2018 Looks up to: Time_Period__c
 Lookup false
Default_Work_Calendar__c Default Work Calendar Pre-Spring 2018 Looks up to: Work_Calendar__c
 Lookup false
Exclude_From_Utilization__c Exclude from Utilization Spring 2020 When selected, data in this region and any sub-regions are excluded from Utilization calculations when a calculation is run on a parent of this region.

 Checkbox false
Excluded_Hours__c Excluded Hours Pre-Spring 2018 Number(18,2) false 0.00
Expense_Budget__c Expense Budget Pre-Spring 2018 Currency(18,2) false 0.00
Expense_Costs__c Expense Costs Pre-Spring 2018 Currency(18,2) false 0.00
External_Costs__c External Costs Pre-Spring 2018 Currency(18,2) false 0.00
Headquarters_Region__c Headquarters Region Pre-Spring 2018 Looks up to: Region__c
 Lookup false
Hierarchy_Depth__c Hierarchy Depth Pre-Spring 2018 Number(2,0) false 0
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
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
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
Hist_Sch_Utilization_Held_Hours__c Hist Sch Utilization Held Hours Pre-Spring 2018 Number(18,2) false
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
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
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
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
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
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
Historical_Utilization_Target_Attainment__c Historical Utilization Target Attainment Pre-Spring 2018 Formula:
IF(Historical_Utilization_Target__c = 0, IF(Historical_Utilization__c <= 0,0,1), Historical_Utilization__c / Historical_Utilization_Target__c )
 Percent(18,2) false
Historical_Utilization_Target_Hours__c Historical Utilization Target Hours Pre-Spring 2018 Number(18,2) false
Historical_Utilization_Target__c Historical Utilization Target Pre-Spring 2018 Formula:
IF(Historical_Utilization_Calendar_Hours__c = 0, 0, Historical_Utilization_Target_Hours__c / Historical_Utilization_Calendar_Hours__c )
Percent(18,2) false
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
Inactive_Project_Backlog__c Inactive Project Backlog Pre-Spring 2018 The amount of backlog (bookings - billings) that was made inactive when a contained project (including projects from sub-regions) became inactive. For parent regions, this is a cumulative value. NOTE: this field is only intended to be updated by PSE.

 Currency(18,2) false
Include_In_Forecasting__c Include In Forecasting Pre-Spring 2018 Does this region participate in forecasting?

 Checkbox true
Internal_Budget__c Internal Budget Pre-Spring 2018 Currency(18,2) false 0.00
Internal_Costs__c Internal Costs Pre-Spring 2018 Currency(18,2) false 0.00
Invoiced__c Invoiced Pre-Spring 2018 Currency(18,2) false 0.00
Margin__c Margin Pre-Spring 2018 Formula:
Billings__c + Pass_Through_Billings__c - External_Costs__c - Internal_Costs__c - Expense_Costs__c - Other_Costs__c
 Currency(18,2) false
Non_Billable_External_Hours__c Non-Billable Hours (External) Pre-Spring 2018 Number(18,2) false 0.00
Non_Billable_Internal_Hours__c Non-Billable Hours (Internal) Pre-Spring 2018 Number(18,2) false 0.00
Other_Costs__c Other Costs Pre-Spring 2018 Currency(18,2) false 0.00
Parent_Region__c Parent Region Pre-Spring 2018 Looks up to: Region__c
 Lookup false
Pass_Through_Billings__c Pass-Through Billings Pre-Spring 2018 Currency(18,2) false 0.00
Plan_Last_Update_Date__c Plan: Last Update Date Pre-Spring 2018 DateTime false
Plan_Last_Updated_By__c Plan: Last Updated By Pre-Spring 2018 Looks up to: User

 Lookup false
Planned_Billings__c Planned Billings Pre-Spring 2018 Currency(18,2) false 0.00
Planned_Bookings__c Planned Bookings Pre-Spring 2018 Currency(18,2) false 0.00
Planned_External_Costs__c Planned External Costs Pre-Spring 2018 Currency(18,2) false 0.00
Planned_Internal_Costs__c Planned Internal Costs Pre-Spring 2018 Currency(18,2) false 0.00
Planned_Margin__c Planned Margin Pre-Spring 2018 Formula:
Planned_Billings__c - Planned_External_Costs__c - Planned_Internal_Costs__c
 Currency(18,2) false
Planned_Revenue__c Planned Revenue Pre-Spring 2018 Currency(18,2) false 0.0
Planned_Utilization__c Planned Utilization Pre-Spring 2018 Percent(5,2) false 0.00
Pre_Billed__c Pre-Billed Pre-Spring 2018 Currency(18,2) false 0.00
Region_Head__c Region Owner Pre-Spring 2018 Looks up to: Contact

 Lookup false
Region_ID_Chain__c Region ID Chain Pre-Spring 2018 Text(255) false
Region_Name_Chain__c Region Name Chain Pre-Spring 2018 Text(255) false
Revenue__c Revenue Pre-Spring 2018 Currency(18,2) false 0.00
Reversed_ID_Chain__c Reversed Region ID Chain Fall 2020 System-generated reversed chain for linking to the region.

 Text(255) false
Scheduled_Backlog_Calculated_Date__c Scheduled Backlog Calculated Date Pre-Spring 2018 Date false Today()
Scheduled_Backlog_End_Date__c Scheduled Backlog End Date Pre-Spring 2018 Date false
Scheduled_Milestone__c Scheduled Milestone Pre-Spring 2018 Currency(18,2) false
Scheduled_Time__c Scheduled Time Pre-Spring 2018 Currency(18,2) false
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
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
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
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
Scheduled_Utilization_Held_Hours__c Scheduled Utilization Held Hours Pre-Spring 2018 Number(18,2) false
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
Scheduled_Utilization_Target_Attainment__c Scheduled Utilization Target Attainment Pre-Spring 2018 Formula:
IF(Scheduled_Utilization_Target__c = 0, IF(Scheduled_Utilization__c <= 0,0,1), Scheduled_Utilization__c / Scheduled_Utilization_Target__c )
 Percent(18,2) false
Scheduled_Utilization_Target_Hours__c Scheduled Utilization Target Hours Pre-Spring 2018 Number(18,2) false
Scheduled_Utilization_Target__c Scheduled Utilization Target Pre-Spring 2018 Formula:
IF(Scheduled_Utilization_Calendar_Hours__c = 0, 0, Scheduled_Utilization_Target_Hours__c / Scheduled_Utilization_Calendar_Hours__c )
Percent(18,2) false
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
Total_Costs__c Total Costs Pre-Spring 2018 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 [DEPRECATED, no longer used]

 Number(18,2) false
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
Unscheduled_Backlog__c Unscheduled Backlog Pre-Spring 2018 Currency(18,2) false
Utilization_Calculation_Date__c Utilization Calculation Date Pre-Spring 2018 The date that the utilization fields were last updated

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

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

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

 Percent(18,2) false
Utilization_Period_End_Date__c Utilization Period End Date Pre-Spring 2018 Date false
Utilization_Period_Start_Date__c Utilization Period Start Date Pre-Spring 2018 Date false
Utilization_Target_Attainment__c Utilization Target Attainment Pre-Spring 2018 Formula:
IF(Utilization_Target__c = 0, IF(Total_Utilization__c <= 0,0,1), Total_Utilization__c / Utilization_Target__c )
 Percent(18,2) false
Utilization_Target_Hours__c Utilization Target Hours Pre-Spring 2018 Number(18,2) false
Utilization_Target__c Utilization Target Pre-Spring 2018 Formula:
IF(Historical_Utilization_Calendar_Hours__c + Scheduled_Utilization_Calendar_Hours__c = 0, 0, Utilization_Target_Hours__c / ( Historical_Utilization_Calendar_Hours__c + Scheduled_Utilization_Calendar_Hours__c ) )
Percent(18,2) false
Utilization__c Utilization Pre-Spring 2018 [DEPRECATED, no longer used]

 Percent(18,2) false 0.00


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