Resource Report - Data Fields

In Projector a data field represents the information that you are interested in. For Excel Pivot Tables this information can be cross-referenced by the row and column fields to compile the data. In this image you see project profit organized by project name and month. Project Profit is the data field. Project Name is the row field. Month is the column field. If this sounds confusing, read our introductory article on pivot tables.

If your Projector installation is making use of User Defined Fields those data elements will be available for use in this report type. Client, Engagement, Project and Resource level based user defined fields will be found in each corresponding Field Category. For example, if you have defined a resource-level user defined field called Utilization Target you will find it in the Resource Fields called Resource Utilization Target.

Most of these data elements are defined on the Resource Editor. Some data points are historical in nature. These can be viewed from the History Tab of the resource editor.

Field	Field Category	Description
Resource	Resource Fields
Resource Billable (Yes/No)	Resource Fields	Yes = resource is usually billable
Resource Company	Resource Fields	The name of the company associated with the resource's cost center
Resource Cost Center Mapping Override	Resource Fields
Resource Department	Resource Fields
Resource Direct Rate Actual	Cost Fields	The per-hour cost to the organization of the resource, including the effect of any overrides
Resource Direct Rate Actual Currency Code	Cost Fields	The currency of the Resource Direct Rate Actual.
Resource Direct Rate Default	Cost Fields	The per-hour cost to the organization of the resource based on the resource title and cost center. This may not be the cost used in calculations as it may be overridden.
Resource Direct Rate Default Currency Code	Cost Fields	The currency of the Resource Direct Rate Default.
Resource Direct Rate Overridden (Y/N)	Cost Fields	Yes if the resource's cost rate is overriden
Resource Display Name	Resource Fields
Resource Email Address	Resource Fields
Resource Employee ID	Resource Fields
Resource Expense Approver	Resource Fields
Resource First Name	Resource Fields
Resource History Begin Date	Resource Fields
Resource History End Date	Resource Fields
Resource Inactive (Yes/No)	Resource Fields	This field does nothing. The report only ever returns history rows where the resource was active. So by definition every row = Yes. Although even that doesn't work.
Resource Initials	Resource Fields
Resource Last Name	Resource Fields
Resource Location	Resource Fields
Resource Middle Name	Resource Fields
Resource Missing Time Email (Yes/No)	Resource Fields
Resource Mobile Phone	Resource Fields
Resource Office Phone	Resource Fields
Resource Other Contact Information	Resource Fields
Resource Pay Category	Resource Fields	Salaried without overtime, salaried with overtime, or hourly.
Resource Skill	Resource Fields
Resource Skill Group	Resource Fields
Resource Start Date	Resource Fields	The begin date for the first history row on a resource's profile
Resource Temporary Worker (Yes/No)	Resource Fields	Yes = contractor. Temporary Worker flag has been deprecated in favor of User Types.
Resource Termination Date	Resource Fields
Resource Time Approval Required (Yes/No)	Resource Fields
Resource Time Approver	Resource Fields
Resource Time Off Approver	Resource Fields
Resource Title	Resource Fields
Resource Track Missing Time (Yes/No)	Resource Fields
Resource Type	Resource Fields
Resource Vendor ID	Resource Fields
Resource Resume Last Modified Date	Resource Fields	Looks at all the resume files associated with a resource and returns the most recent last modified date.