| 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 |
|
| Actuals_Last_Updated_By__c |
Actuals: Last Updated By |
Pre-Spring 2018 |
Looks up to: User
|
Lookup |
|
| Backlog_Last_Update_Date__c |
Backlog: Last Update Date |
Pre-Spring 2018 |
|
DateTime |
|
| Backlog_Last_Updated_By__c |
Backlog: Last Updated By |
Pre-Spring 2018 |
Looks up to: User
|
Lookup |
|
| 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 |
| Current_Time_Period_End_Date__c |
Current Time Period End Date |
Pre-Spring 2018 |
|
Date |
TODAY() |
| Current_Time_Period__c |
Current Time Period |
Pre-Spring 2018 |
Looks up to: Time_Period__c
|
Lookup |
|
| Default_Work_Calendar__c |
Default Work Calendar |
Pre-Spring 2018 |
Looks up to: Work_Calendar__c
|
Lookup |
|
| 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) |
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 |
| Headquarters_Region__c |
Headquarters Region |
Pre-Spring 2018 |
Looks up to: Region__c
|
Lookup |
|
| Hierarchy_Depth__c |
Hierarchy Depth |
Pre-Spring 2018 |
|
Number(2,0) |
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) |
|
| 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) |
|
| 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) |
|
| Hist_Sch_Utilization_Held_Hours__c |
Hist Sch Utilization Held Hours |
Pre-Spring 2018 |
|
Number(18,2) |
|
| 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) |
|
| 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) |
|
| 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) |
|
| 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) |
|
| 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) |
|
| 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) |
|
| 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) |
|
| Historical_Utilization_Target_Hours__c |
Historical Utilization Target Hours |
Pre-Spring 2018 |
|
Number(18,2) |
|
| 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) |
|
| 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) |
|
| 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) |
|
| 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) |
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 |
| 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) |
|
| 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 |
| Parent_Region__c |
Parent Region |
Pre-Spring 2018 |
Looks up to: Region__c
|
Lookup |
|
| Pass_Through_Billings__c |
Pass-Through Billings |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
| Plan_Last_Update_Date__c |
Plan: Last Update Date |
Pre-Spring 2018 |
|
DateTime |
|
| Plan_Last_Updated_By__c |
Plan: Last Updated By |
Pre-Spring 2018 |
Looks up to: User
|
Lookup |
|
| Planned_Billings__c |
Planned Billings |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
| Planned_Bookings__c |
Planned Bookings |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
| Planned_External_Costs__c |
Planned External Costs |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
| Planned_Internal_Costs__c |
Planned Internal Costs |
Pre-Spring 2018 |
|
Currency(18,2) |
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) |
|
| Planned_Revenue__c |
Planned Revenue |
Pre-Spring 2018 |
|
Currency(18,2) |
0.0 |
| Planned_Utilization__c |
Planned Utilization |
Pre-Spring 2018 |
|
Percent(5,2) |
0.00 |
| Pre_Billed__c |
Pre-Billed |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
| Region_Head__c |
Region Owner |
Pre-Spring 2018 |
Looks up to: Contact
|
Lookup |
|
| Region_ID_Chain__c |
Region ID Chain |
Pre-Spring 2018 |
|
Text(255) |
|
| Region_Name_Chain__c |
Region Name Chain |
Pre-Spring 2018 |
|
Text(255) |
|
| Revenue__c |
Revenue |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
| Reversed_ID_Chain__c |
Reversed Region ID Chain |
Fall 2020 |
System-generated reversed chain for linking to the region.
|
Text(255) |
|
| Scheduled_Backlog_Calculated_Date__c |
Scheduled Backlog Calculated Date |
Pre-Spring 2018 |
|
Date |
Today() |
| Scheduled_Backlog_End_Date__c |
Scheduled Backlog End Date |
Pre-Spring 2018 |
|
Date |
|
| Scheduled_Milestone__c |
Scheduled Milestone |
Pre-Spring 2018 |
|
Currency(18,2) |
|
| Scheduled_Time__c |
Scheduled Time |
Pre-Spring 2018 |
|
Currency(18,2) |
|
| 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) |
|
| 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) |
|
| 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) |
|
| 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) |
|
| Scheduled_Utilization_Held_Hours__c |
Scheduled Utilization Held Hours |
Pre-Spring 2018 |
|
Number(18,2) |
|
| 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) |
|
| 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) |
|
| Scheduled_Utilization_Target_Hours__c |
Scheduled Utilization Target Hours |
Pre-Spring 2018 |
|
Number(18,2) |
|
| 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) |
|
| 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) |
|
| Total_Costs__c |
Total Costs |
Pre-Spring 2018 |
Formula:
Internal_Costs__c + External_Costs__c + Expense_Costs__c + Other_Costs__c
|
Currency(18,2) |
|
| Total_Time_Period_Hours__c |
Total Time Period Hours |
Pre-Spring 2018 |
[DEPRECATED, no longer used]
|
Number(18,2) |
|
| 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) |
|
| Unscheduled_Backlog__c |
Unscheduled Backlog |
Pre-Spring 2018 |
|
Currency(18,2) |
|
| Utilization_Calculation_Date__c |
Utilization Calculation Date |
Pre-Spring 2018 |
The date that the utilization fields were last updated
|
Date |
Today() |
| Utilization_Elapsed_Hours__c |
Utilization: Elapsed Hours |
Pre-Spring 2018 |
[DEPRECATED, no longer used]
|
Number(18,2) |
|
| Utilization_Last_Calculation_Date__c |
Utilization: Last Calculation Date |
Pre-Spring 2018 |
|
Date |
|
| Utilization_Last_Update_Date__c |
Utilization: Last Update Date |
Pre-Spring 2018 |
|
DateTime |
|
| Utilization_Last_Updated_By__c |
Utilization: Last Updated By |
Pre-Spring 2018 |
Looks up to: User
|
Lookup |
|
| Utilization_Over_Full_Time_Period__c |
Utilization: Over Full Time Period |
Pre-Spring 2018 |
[DEPRECATED, no longer used]
|
Percent(18,2) |
|
| Utilization_Period_End_Date__c |
Utilization Period End Date |
Pre-Spring 2018 |
|
Date |
|
| Utilization_Period_Start_Date__c |
Utilization Period Start Date |
Pre-Spring 2018 |
|
Date |
|
| 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) |
|
| Utilization_Target_Hours__c |
Utilization Target Hours |
Pre-Spring 2018 |
|
Number(18,2) |
|
| 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) |
|
| Utilization__c |
Utilization |
Pre-Spring 2018 |
[DEPRECATED, no longer used]
|
Percent(18,2) |
0.00 |
