Resource Fields

Here is a description of the PSA fields that you can add to the standard Salesforce Contact page layouts. Some of these fields may not be visible or editable at all times, or in all package combinations.

Contact Information

Here is a description of the fields in the Contact Information section.

Key: * – Mandatory field; R – Read-only

Field     Description
Account Name     Lookup to the account to which the contact is to be associated with.
Contact Currency *   The currency that the resource is to claim expenses in.
Contact Owner R   User to which the contact belongs.
Last Date     The last day of employment for the resource.
Licensed Features     Licensed features to that the contact is to use.
Reports To     The project manager or contact to which the contact reports to.
Start Date     The date that the resource commenced employment.

Resource Information

Field   Description
Allow Timecards Without Assignment   Indicates whether the resource is to be treated as a global resource and as such can enter time on any project even when the project normally requires assignments for time entry.
Default Cost Rate   Default cost of this resource, used in cost calculations on projects.
Default Cost Rate is Daily Rate   Indicates the default cost rate is a daily rate. If deselected, the default cost rate is an hourly rate.
Exclude From Missing Timecards   Indicates whether the resource is to be excluded from missing timecard generation.
Exclude from Resource Planner   Indicates whether the resource is to be excluded from the resource planner.
Exclude From Time Calculations   Indicates whether the resource is to be excluded from timecard calculations.
External Resource   Indicates that this is a PSA external resource.
Is Resource   Indicates that this contact is a PSA resource that can be assigned to projects.
Is Resource Active   Indicates that this is an active resource that can be assigned to projects.
Licensed Features   Enables additional licensed features where implemented.
Region/Practice/Group   Lookups to the related region, practice or group.
Resource Role   Role for this resource, used when creating resource requests to identify needs. This picklist on the Contact object must match the corresponding picklist on the Resource Request object.

Salesforce User

  Salesforce user for this resource used to associate this contact with the resource's Salesforce login name. You must enter this if the resource will enter their own timecards and expenses. You can leave it blank for external resources that enter timecards and expenses via a proxy.
Note
Only one resource can be associated with a Salesforce user. When you enter a value for this field, you must ensure that no other resource has the same value set in this field.
Work Calendar   Work calendar for this resource.

Selected Time Period

Actual values at a given point in time, based on selected time period, for the resource.

Field   Description
Action: Update Current Time Period   Indicates that you want the system to update the time period when the resource contact record is saved.
Current Time Period * Lookup to related time periodCollapsed.
Current Time Period End Date   Last day of the selected time period for which actuals are calculated.

Resource Actuals

These fields are automatically calculated by FinancialForce Professional Services Automation.

Revenue Actuals

Field   Description
Billed R Sum of Billed amounts. Timecards; Expenses, if billable, contribute to Billed revenue after they are billed/invoiced; Milestones contribute to Billed and Invoiced revenue after they are billed/invoiced.
Billings R Sum of Ready-to-Bill Revenue from Timecards and Milestones.
Bookings R Booked revenue for the resource. Budgets of type Customer PO and Customer PO Change Order contribute to Bookings.
Expense Budget R Sum of expense budgets for the resource. The Expense Amount field of a budget contributes to this field if the budget is of type: Customer PO, Customer PO Change Order, Internal Budget or Internal Budget Change Request.
Internal Budget R Sum of internal budgets for the resource. The Amount field of a budget contributes to this field if the budget is of type: Internal Budget or Internal Budget Change Request.
Invoiced R Sum of Invoiced amounts. Expenses, if billable, contribute to Invoiced after they are billed/invoiced; Milestones contribute to Invoiced after they are billed/invoiced.
Pass-Through Billings R Sum of Pass-Through billings. Expenses, if billable, contribute to Pass-Through Billings when they are billable.
Pre-Billed   Amount billed earlier.
Revenue R Revenue is not calculated or rolled up. You can enter a miscellaneous adjustment of type "ready to bill revenue" to show revenue on the resource actuals.

Cost Actuals

Field   Description
Expense Costs R Sum of Expenses. Expenses always contribute to Expense Cost, whether they are billable or not.
External Costs R The sum of external costs for the resource if external. The external resource cost is multiplied by timecard hours, whether billable or not. Milestones may contribute to a flat external cost if the External Cost field is filled in on the milestone and the Log Cost as External checkbox is selected. For instance, when you count subcontractor fees as a flat cost amount that helped you reach the milestone and achieve the billings.
Internal Costs R Internal costs for the resource. Internal resource cost multiplied by timecard hours, whether billable or not.
Other Costs R Any other RPG costs from Projects. From Miscellaneous Adjustments of transaction category "Other Cost," e.g., material costs. The Amount field of a budget also contributes to this field if the budget is of type Work Order or Work Order Change Request.
Total Costs R The total costs from for the resource. This includes internal costs, external costs, expenses and other costs from all projects in the RPGCollapsed hierarchy.

Margin

Field   Description
Margin R The RPG margin. This is the billings minus total costs including internal costs, external costs, expenses and other costs from all projects in the RPG hierarchy.

Resource Time Actuals

Key: * – Mandatory; R – Read-only

Field     Description
Action: Calculate Utilization   R Indicates whether the resource's utilization figures are to be re-calculated when you click Save.
Billable Hours (External)   R Hours from Timecards marked Billable for external Resources (e.g., contractor doing billable customer work); not included in Utilization calculation.
Billable Hours (Internal)   R Hours from Timecards marked Billable for internal Resources; counted towards numerator of Utilization calculation.
Credited Hours   R Hours taken from timecards for the resource where the project has Time Credited checkbox selected. This value counts towards the numerator of the utilization calculation.
Excluded Hours   R Hours taken from timecards for the resource where the project has Time Excluded checkbox selected.
Non-Billable Hours (External)   R Hours from project Timecards marked Non-Billable for external Resources, e.g., contractor working on internal budget project; not included in Utilization calculation.
Non-Billable Hours (Internal)   R Hours from project Timecards marked Non-Billable for internal Resources; not included in Utilization calculation.

Resource Utilization

Field     Description
Historical Utilization     Historical utilization calculated from the resource timecards and assignment schedule information. The formula for this field is: (Billable Historical Timecard Hours + Credited Historical Timecard Hours) / (Historical Calendar Hours - Excluded Historical Timecard Hours).
Historical Utilization Billable Hours     Billable hours calculated from the resource's timecards.
Historical Utilization Calendar Hours     The number of working hours for the resource for the historical utilization period calculated. For instance, if you calculate the historical utilization for the month of December on 2nd December, the Historical Utilization Calendar Hours will be 24 if the time period starts on the last day of November and the working calendar for the resource is 8 hours per day.
Historical Utilization Target     Percentage utilization target for the resource during the selected time period. The formula for this field is: Historical Utilization Target Hours / Historical Utilization Calendar Hours * 100.
Historical Utilization Target Attainment     Percentage indicating how much of their historical utilization target, the resource actually achieved during the time period selected. The formula for this field is: Historical Utilization / Historical Utilization Target.
Historical Utilization Target Hours     Target hours to be worked by the resource during the time period. This does not include hours in the future.
Scheduled Utilization     The scheduled utilization percentage for the current time period. The formula for this field is: (Scheduled Billable Hours + Scheduled Credited Hours) / (Scheduled Calendar Hours - Scheduled Excluded Hours).
Scheduled Utilization Billable Hours     The scheduled utilization billable hours total for the current time period.
Scheduled Utilization Calendar Hours     The scheduled utilization calendar hours total for the current time period.
Scheduled Utilization Target     Percentage scheduled utilization target for the resource during the selected time period. The formula for this field is: Scheduled Utilization Target Hours / Scheduled Utilization Calendar Hours.
Scheduled Utilization Target Attainment     Percentage indicating how much of their scheduled utilization target, the resource will achieve during the time period selected. The formula for this field is: Scheduled Utilization / Scheduled Utilization Target.
Scheduled Utilization Target Hours     Target hours to be worked by the resource during the time period. This does not include hours in the past.
Utilization     Percentage indicating the overall utilization including scheduled and historical utilization. The formula for this field is: (Scheduled Billable Hours + Historical Billable Hours + Scheduled Credited Hours + Historical Credited Hours) / (Scheduled Calendar Hours + Historical Calendar Hours - Scheduled Excluded Hours - Historical Excluded Hours).
Utilization Target     A target percentage of utilization for this resource. The formula for this field is: Utilization Target Hours / ( Historical Calendar Hours + Scheduled Calendar Hours.
Utilization Target Attainment     Overall historical and scheduled utilization percentage for the current time period divided by Utilization Target. The formula for this field is:
Utilization / Utilization Target Average.
Utilization Target Average     Percentage Utilization Target Average. The formula for this field is: Utilization Target Hours / ( Historical Utilization Calendar Hours + Scheduled Utilization Calendar Hours)
Utilization Target Hours     The scheduled and historical target utilization hours.
Utilization: Last Calculation Date     Date when last Utilization calculation was run.
Utilization: Elapsed Hours     Elapsed working hours from the start of the calculation to present day.
Utilization: Over Full Time Period     Utilization over the whole time period regardless of the current date. The formula for this field is: (Billable_Internal_Hours__c + Credited_Non_Billable_Internal_Hours__c)/(Total_Time_Period_Hours__c - Excluded_Hours__c)

Related Information

Contacts and Resources

About Scheduling Strategies

Resources

Resource Requests

About the Resource Planner

About Staffer

Assignments and Schedules

Related Tasks

Adding a Resource

Setting up Resources

Creating Resource Requests

Using the Resource Planner

Using the Staffer

Reference Materials

Resource Change Fields

© Copyright 2009-2012 FinancialForce.com, inc. All rights reserved.
Various trademarks held by their respective owners.