Request Data Export

This report produces information in regards to requests created for a client organization.

The Billing Rate Type Detail Report supports BYOK encryption. If the client organization has enabled the encryption feature, only supported reports are available. For more information about the encryption feature, contract your Program Representative.

The report produces the following columns:

• General Info section
  • Request #
  • Engagement #
  • Type
  • Status
  • Client
  • OpUnit
  • Manager
  • Supplier
  • Worker
  • Worker Email
  • Worker Nickname
  • Start Date
  • Est. End Date
  • Actual End Date
  • Job Title
  • Job Code
  • Project Name
  • Bill Rate
  • OT Bill Rate
  • DT Bill Rate
  • Pay Rate
  • Piece Bill Rate
  • Piece Pay Rate
  • State/Province
  • City
  • Allocation Name
• Request Description section
• Position Location section
  • Onsite
  • Client Address
  • Client Postal Code
  • Client Country
  • Client Building Code
  • Offsite Address
  • Offsite City/Town
  • Offsite State/Province
  • Offsite Postal Code
  • Offsite Country
  • Work Address
  • Work City/Town
  • Work State/Province
  • Work Postal Code
  • Work Country
  • Work Building Code
• Position Schedule section
  • Duration in Workdays
  • Hours Per Week
  • Hours Per Day
  • Duration in weeks
  • Weeks to Date - Only displays for filled engagements.
  • Weeks Left - Only displays for filled engagements.
  • Confirmed Est. End Date
  • Total Hours - Applies to all request/engagement statuses.
  • Total Days - Applies to all request/engagement statuses.
  • Non-Billable Granted
  • Non-Billable Used
  • Schedule Notes
• Position Financials section
  • Submitted Bill Rate
  • Negotiated Bill Rate
  • Shift
  • Shift Type
  • Value
  • % BR
  • Job#
  • Req OT Mod
  • Req DT Mod
  • Req MSP Up
  • Req MSP Down
• Worker Info section
  • Worker #
  • Worker Status
  • Worker GUID
  • Worker External ID
  • Worker Original Start Date
  • Worker Custom Fields - One column for each Worker type custom field.
  • Previous Employee
  • FTE - From
  • FTE - To
  • FTE - Supervisor
  • Contractor - From
  • Contractor - To
  • Contractor - Supervisor
  • Family Member Works for Client
• Project Quote section
  • Milestone Name
  • Milestone Description
  • Milestone Due Date
  • Milestone Amount
  • Milestone Balance Amount
  • Material Name
  • Material Quantity
  • Material Price
  • Material Amount
  • Material Balance Amount
  • Position Name
  • Position Description
  • Position Worker Name
  • Position Bill Rate
  • Position Billable
  • Position Estimated Hour
  • Position Amount
  • Position Rate Application Type
  • Position Balance (Hours)
  • Position Balance Amount
  • Position Expense Description
  • Position Expense Amount
  • Position Expense Balance
• Project Worker section
  • Worker Phone
  • Worker Start Date
  • Worker End Date
  • Worker Onsite
  • Relationship to Supplier
  • Time Entry Interface
  • Time Source
  • Work Period
• Contact Info section
  • Original Supplier Acceptor
  • Original Acceptance Date
  • Acceptance Decision
• Timeline Info section
  • Date Created
  • Date Pending
  • Date Client Approved
  • Date Supplier Accepted
  • Date Filled
  • Date Closed
  • Date Cancelled
• Requisition Custom Fields section
  • One column per added custom field.
  • The naming convention for the data set is <opunit_name> - Requisition
  • The naming convention for the column is <custom_field_name>.<opunit_name>
• Billing Custom Fields section
  • One column per added custom field.
  • The naming convention for the data set is <opunit_name> - Billing
  • The naming convention for the column is <custom_field_name>.<opunit_name>
• Department Custom Fields section