Ginsu 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.

When reporting on stoplight UDFs (Project Health fields), we display a string of characters representing the health. For example,if you looked at the health for the six months, you would be returned a six character string. If there is no health status for a given time period, no character is returned. For example a four character string would be returned if the first two months had no data. Finally, the character returned is based on the first day of a time bucket. For month, it would be the first day of the month. For week, it would be the first day of the week. 'Today' represents the day the report was run. Use Actuals Through Date has no effect on stoplight UDF reporting.

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
Billing Status	Invoice Fields	On an issued invoice, on a draft invoice, or unbilled.
Booked Candidates	Role Fields	List of candidates on unnamed booked roles
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 Baseline Name	Budget Fields	Name of the current active cost baseline
Cost Card Chargeable (Y/N)	Cost Fields	Yes if the cost card's client amount is greater than zero.
Cost Card Description	Cost Fields
Cost Center Mapping (Expense)	Accounting Fields	The accounting system's cost center to which expense will be routed.
Cost Center Mapping (Revenue)	Accounting Fields	The accounting system's cost center to which revenue will be routed.
Cost Contract Amount in Engagement Currency	Contract Line Item Fields	Cost contract amount.
Cost Contract Amount in Reporting Currency	Contract Line Item Fields	Cost contract amount. FX'd to currency set on the parameters tab.
Cost Contract Terms	Engagement Fields	Engagement cost contract terms: T&M, Fixed Price, or Not to Exceed
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 Cost Center*	Engagement Fields	You will not find this exact line in your report. Instead, for each Cost Center Level defined in the Cost Center Editor you will have a choice. So for example if you have levels called Business Unit and Group then there will be one line called Engagement Business Unit and another called Engagement Group.
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	Engagement Fields
Engagement Stage	Engagement Fields	Name of the engagement stage
Engagement Type	Engagement Fields
Expense Document Name	Expense Document Fields	Name of the expense report or vendor invoice
Expense Document Number	Expense Document Fields	Identifying number associated with the expense report or vendor invoice
Expense Document Type	Expense Document Fields	Expense Report, Vendor Invoice, or Soft Cost
Expense Location	Cost Fields	Location in which the expense was incurred
Expense Type	Cost Fields
For Reporting Only (Y/N)	Other Fields	Yes only if the cost card was imported as a for reporting only cost card
Holdback Revenue (Y/N)	Engagement Fields	Yes if the revenue is from a holdback
Hours Status	Hours Fields	Approved, unapproved, booked, or requested change. This is a deprecated report field. It is only available in old, saved reports. It has been supplanted by Approval Workflow Status.
Hours Type	Hours Fields	Indicates if hours are associated with a project, holiday, or time off.
Invoice Date	Invoice Fields
Invoice Number	Invoice Fields	Invoice or credit memo number
Invoice Paid (Y/N)	Invoice Fields	Yes if the invoice has been marked as paid
Pass-through Cost Flag (Y/N)	Cost Fields	Yes if the cost is a pass-through cost.
Project	Project Fields
Project Code	Project Fields
Project Description	Project Fields	Limited to 255 characters to support Excel 2003. Please use the Report Web Services if you require the full description.
Project End Date	Project Fields	The latest date for which time or cost can be incurred for this project
Project Likelihood %	Project Fields
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
Project Task Code	Project Fields	This field has been deprecated. Please use Project Task Type instead.
Project Task Type	Project Fields
Purchase Order Number	Invoice Fields	Populated if time or costs reported on are presently on an invoice, unbilled time or cost will report a blank PO number.
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*	Resource Fields	You will not find this exact line in your report. Instead, for each Cost Center Level defined in the Cost Center Editor you will have a choice. So for example if you have levels called Business Unit and Group then there will be one line called Resource Business Unit and another called Resource Group.
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. This flag has been replaced by Resource Type. If you have not already you should thinking about migrating your installation to use this instead.
Resource Title	Resource Fields
Resource Type	Resource Fields	Resource Types are used for categorizing resources and also for determining their internal cost (RDC) based on the work they have done. For example, salaried workers don't cost more if they work overtime, but hourly workers do.
Revenue Recognition Method	Engagement Fields	Percent Complete or Revenue Schedule. Applies only to fixed price engagements.
Role	Role Fields
Role Billing Department	Role Fields	Department of the title used for setting the billing rate of this role
Role Billing Title	Role Fields	Title used for setting the billing rate of this role
Role End Date	Role Fields	End date of role
Role Start Date	Role Fields	Start date of role
Skill	Skill Fields	For each skill defined in the Skill Editor a corresponding Skill Field is available
Standard Rate Type	Project Fields
Standard Rate Type Code	Project Fields
Standard Task Type	Project Fields
Standard Task Type Code	Project Fields
Task Name	Task Fields	Name of the task
Time Baseline Name	Budget Fields	Name of the current active time baseline
Time Card Chargeable (Y/N)	Time Fields	Yes if the time card's billing adjusted revenue is greater than zero.
Time Card Marked Non-Chargeable (Y/N)	Time Fields	This field is deprecated. It will always return zero.
Time Contract Amount	Engagement Fields	Engagement time contract amount
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 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 Amount	Engagement Fields	Engagement time holdback amount
Time Holdback Percent	Engagement Fields	Time holdback as a percentage of the time contract amount
Timeoff Reason	Time Off Fields	Time off reason
Units Name	Unit Fields	The name of the unit of measure
Vendor Name	Vendor Fields
Vendor Number	Vendor Fields
WBS Code	Task Fields	Work breakdown structure code(e.g., 4.1.2)
Work Location	Hours Fields	Location where the work was performed