Variance Report - Row Fields

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.

Based on the number of Client levels defined in your installation you will have available fields under the Client Fields for each named level. For example, if your installation has two Client levels, Division and Department, you will have Division Name and Department Name as available fields.

Field

Field Category

Description

Actuals Cutoff DateTransaction FieldsReturns the Use Actuals Through Date specified on the parameters tab

Booked End Date

Role Fields

The last date on which there are booked hours for this role

Booked Start Date

Role Fields

The first date on which there are booked hours for this role

Client

Client Fields

 

Cost Card Chargeable (Y/N)

Cost Fields

Yes if the cost card's client amount is greater than zero.

Cost Contract Amount

Engagement Fields

Engagement cost contract amount

Cost Contract Terms

Engagement Fields

Engagement cost contract terms: T&M, Fixed Price, or Not to Exceed

Day

Time Fields

Date

Engagement

Engagement Fields

 

Engagement Billable (Yes/No)

Engagement Fields

Yes if the engagement is a billable type

Engagement Billing Address Attention

Engagement Fields

 

Engagement Billing Address City

Engagement Fields

 

Engagement Billing Address Company Name

Engagement Fields

 

Engagement Billing Address Country

Engagement Fields

 

Engagement Billing Address Line 1

Engagement Fields

 

Engagement Billing Address Line 2

Engagement Fields

 

Engagement Billing Address State/Province

Engagement Fields

 

Engagement Billing Address Zip/PostalCode

Engagement Fields

 

Engagement Code

Engagement Fields

 

Engagement Company

Engagement Fields

The name of the company associated with the engagement's cost center

Engagement Currency

Engagement Fields

Billing currency of the engagement

Engagement Manager

Engagement Fields

 

Engagement Manager Display Name

Engagement Fields

 

Engagement Manager Email Address

Engagement Fields

 

Engagement Name

Engagement Fields

 

Engagement Productive (Yes/No)

Engagement Fields

Yes if the engagement is a productive type

Engagement Stage

Engagement Fields

Name of the engagement stage

Engagement Type

Engagement Fields

 

Expense Type

Cost Fields

 

Half-Month

Time Fields

Date of first day in half-month

Hours Type

Hours Fields

Indicates if hours are associated with a project, holiday, or time off.

Month

Time Fields

Date of first day in month

Operational Period

Time Fields

Date of first day in operational period

Project

Project Fields

 

Project Code

Project Fields

 

Project End Date

Project Fields

The latest date for which time or cost can be incurred for this project

Project Location

Project Fields

 

Project Manager

Project Fields

 

Project Manager Display Name

Project Fields

 

Project Manager Email Address

Project Fields

 

Project Name

Project Fields

 

Project Stage

Project Fields

Name of the project stage

Project Start Date

Project Fields

The earliest date for which time or cost can be incurred for this project

Quarter

Time Fields

Date of first day in quarter

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 Department

Resource Fields

 

Resource Display Name

Resource Fields

 

Resource Email Address

Resource Fields

 

Resource Employee ID

Resource Fields

 

Resource First Name

Resource Fields

 

Resource Last Name

Resource Fields

 

Resource Location

Resource Fields

 

Resource Middle Name

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 Temporary Worker (Yes/No)

Resource Fields

Yes = contractor

Resource Title

Resource Fields

 

Resource Type

Resource Fields

The type of resource, such as "Salaried" or "Hourly"

Resource Type Code

Resource Fields

 

Revenue Recognition Method

Engagement Fields

Percent Complete or Revenue Schedule. Applies only to fixed price engagements.

Role

Role Fields

 

Role End Date

Role Fields

End date of role

Role Start Date

Role Fields

Start date of role

Time Card Chargeable (Y/N)

Time Fields

Yes if the time card's billing adjusted revenue is greater than zero.

Time Contract Amount

Engagement Fields

Engagement time contract amount

Time Contract Amount Less Holdback

Engagement Fields

Time contract amount minus the time holdback amount

Time Contract Terms

Engagement Fields

Engagement time contract terms: T&M, Fixed Price, or Not to Exceed

Time Holdback Amount

Engagement Fields

Engagement time holdback amount

Time Holdback Percent

Engagement Fields

Time holdback as a percentage of the time contract amount

Time Off ReasonTime Off FieldsAvailable reasons are specified on the Time Off Reason Editor

Week

Time Fields

Date of first day in week

Year

Time Fields

Date of first day in year