API_Resource_Correlation_Id__c |
API Resource Correlation ID |
Pre-Spring 2018 |
|
Text(255) |
|
Action_Calculate_Utilization__c |
Action: Calculate Utilization |
Pre-Spring 2018 |
|
Checkbox |
true |
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 |
|
Allow_Timecards_Without_Assignment__c |
Allow Timecards Without Assignment |
Pre-Spring 2018 |
Check this if resource should be treated as 'Global' Resources. 'Global' Resources can enter time for any Project, even if that Project normally requires Assignments for Time Entry.
|
Checkbox |
false |
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 |
|
Daily_Default_Cost_Rate__c |
Default Cost Rate is Daily Rate |
Pre-Spring 2018 |
|
Checkbox |
false |
Default_Cost_Rate__c |
Default Cost Rate |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
ERP_Worker_Correlation_Id__c |
Foundations Worker Correlation |
Pre-Spring 2018 |
This records the worker correlation key used within the Foundations system.
|
Text(255) |
|
Employment_Status_Effective_Date__c |
Employment Status Effective Date |
Pre-Spring 2018 |
|
Date |
|
Employment_Status__c |
Employment Status |
Pre-Spring 2018 |
|
Picklist: Active Terminated |
|
Exclude_From_Missing_Timecards__c |
Exclude From Missing Timecards |
Pre-Spring 2018 |
Whether to exclude this resource from missing timecard reports
|
Checkbox |
false |
Exclude_From_Time_Calculations__c |
Exclude from Time Calculations |
Pre-Spring 2018 |
|
Checkbox |
false |
Exclude_From_Time_Variance__c |
Exclude From Time Variance Calculations |
Pre-Spring 2018 |
If true, the resource is excluded from Time Variance calculations.
|
Checkbox |
false |
Exclude_from_Resource_Planner__c |
Exclude from Resource Planner |
Pre-Spring 2018 |
|
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 |
External_Resource__c |
External Resource |
Pre-Spring 2018 |
|
Checkbox |
false |
Group__c |
Group |
Pre-Spring 2018 |
Looks up to: Grp__c
|
Lookup |
|
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) |
|
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_Resource_Active__c |
Is Resource Active |
Pre-Spring 2018 |
|
Checkbox |
false |
Is_Resource__c |
Is Resource |
Pre-Spring 2018 |
|
Checkbox |
false |
Jira_Correlation_Username__c |
Jira Correlation ID |
Fall 2019 |
Unique ID of the related user in Jira. Used for synchronization.
|
Text(255) |
|
Last_Date__c |
Last Date |
Pre-Spring 2018 |
A Resource's last day of employment.
|
Date |
|
Latitude_PSA__c |
Latitude (PSA) |
Pre-Spring 2018 |
|
Number(10,8) |
|
Longitude_PSA__c |
Longitude (PSA) |
Pre-Spring 2018 |
|
Number(11,8) |
|
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 |
Practice__c |
Practice |
Pre-Spring 2018 |
Looks up to: Practice__c
|
Lookup |
|
Pre_Billed__c |
Pre-Billed |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
Region__c |
Region |
Pre-Spring 2018 |
Looks up to: Region__c
|
Lookup |
|
Resource_Role__c |
Resource Role |
Pre-Spring 2018 |
|
Picklist: Architect Business Analyst Client Manager Consultant Contractor Executive Project Manager Senior Consultant Trainer |
|
Revenue__c |
Revenue |
Pre-Spring 2018 |
|
Currency(18,2) |
0.00 |
Salesforce_User__c |
Salesforce User |
Pre-Spring 2018 |
Looks up to: User
|
Lookup |
|
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(18,2) |
|
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) |
|
Send_to_Third_Party_Expenses_Application__c |
Send to Third-Party Expenses Application |
Spring 2019 |
Controls whether or not the resource is sent to a third-party expenses application.
Formula: AND(Is_Resource__c , Is_Resource_Active__c)
|
Checkbox |
|
Start_Date__c |
Start Date |
Pre-Spring 2018 |
A Resource's first date of employment.
|
Date |
|
Sync_with_Jira__c |
Sync with Jira |
Fall 2019 |
Controls whether the resource is synchronized with Jira.
|
Checkbox |
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) |
|
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) |
|
Utilization_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_Target_Attainment__c |
Utilization Target Attainment |
Pre-Spring 2018 |
Formula: IF(Utilization_Target_Average__c = 0, IF(Total_Utilization__c <= 0,0,1), Total_Utilization__c / Utilization_Target_Average__c )
|
Percent(18,2) |
|
Utilization_Target_Average__c |
Utilization Target Average |
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_Target_Hours__c |
Utilization Target Hours |
Pre-Spring 2018 |
|
Number(18,2) |
|
Utilization_Target__c |
Utilization Target |
Pre-Spring 2018 |
A target percentage of utilization for this resource. For example, a target of 50% for an 8 hour per day work calendar, results in a 4 hour per day target that the resource should be utilized for.
|
Percent(5,2) |
|
Work_Calendar__c |
Work Calendar |
Pre-Spring 2018 |
Looks up to: Work_Calendar__c
|
Lookup |
|