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. See Bring Your Own Key Encryption.

The report produces the following columns:

• General Info section
  • Request #
  • Engagement #
  • Type
  • Status
  • Client
  • OpUnit
  • Manager
  • Manager Email
  • Manager GUID
  • Manager External ID
  • Time&Expense Approver
  • T&E Approver Email
  • Department
  • Department Number
  • Supplier
  • Worker
  • Worker Email
  • Worker Nickname
  • Start Date
  • Est. End Date
  • Actual End Date
  • Job Category
  • Job Title
  • Job Code
  • Project Name
  • Bill Rate
  • OT Bill Rate
  • DT Bill Rate
  • Piece Bill Rate
  • State/Province
  • City
  • Allocation Name
  • Allocation Value Billing Auxiliary 1-5 - One column for each configured auxiliary billing value.
  • Parent Project Eng #
  • Supplier ID
• Request Description section
  • Reason Detail
• 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
  • Estimated Cost
  • Shift
  • Shift Type
  • Value
  • % BR
  • Spend to Date
  • Job#
  • Req OT Mod
  • Req DT Mod
  • Req MSP Up
  • MSP Up Fee Bill Rate
  • Bill Rate With Tax Inc
• 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
  • Payroll Worker Profile Status - For payroll worker types, displays 'Complete' or 'Incomplete' in regard to the profile status.
• Purchase Order section
  • Prim. PO Number
  • Prim. Currency
  • Prim. Initial Amount
  • Prim. Available Funds
  • Prim. Date Active
  • Prim. Status
  • Prim. Inactive
  • Prim. PO Line#
  • Prim. Description
  • Prim. Quantity
  • Prim. Unit of Measure
  • Prim. Amount
  • Prim. Valid Until
  • Aux. PO Number
  • Aux. Currency
  • Aux. Initial Amount
  • Aux. Available Funds
  • Aux. Date Active
  • Aux. Status
  • Aux. Inactive
  • Aux. PO Line #
  • Aux. Description
  • Aux. Quantity
  • Aux. Unit of Measure
  • Aux. Amount
  • Aux. Valid Until
  • PO Billing to Date
  • Average Weekly Billing
  • PO Est Weeks Remaining
  • PO % of Funds Used
  • Additional Fund Amount
  • PO Total Amount
  • Req PO Billing to Date
  • Req PO % of Funds Used
  • Primary PO Indicator
• 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
  • MSP Contact
  • MSP Phone
  • Manager Phone
  • HR Contact
  • Supplier Expense Contact Email
  • Additional Contact
  • Additional Phone
  • Additional Email
  • Supplier Phone
  • Original Supplier Acceptor
  • Original Acceptance Date
  • Acceptance Decision
• Professional Service Info section
  • Prof. Svcs .Customer
  • Prof. Svcs. Address1
  • Prof. Svcs. Address2
  • Prof. Svcs. City
  • Prof. Svcs. State
  • Prof. Svcs. Zip
  • Prof. Svcs. Country
  • Prof. Svcs. Contact
  • Prof. Svcs. Contact Phone
  • Prof. Svcs. Contact Fax
  • Prof. Svcs. Contact Email
• Timeline Info section
  • Date Created
  • Date Pending
  • Date Client Approved
  • Date Supplier Accepted
  • Date Filled
  • Date Closed
  • Date Cancelled
  • Parent Request Date Created
• Survey Dates section
  • Survey Type
  • Survey Sent Date
  • Survey Submitted Date
• Budget section
  • Fund Tracking Type
  • Budget Code
  • Allocated %
  • Allocated Amount
  • Expense Allotment
  • Total Budget - Does not display for Master Budgets.
  • Available Amount
  • Total Billed
  • Budget Owner
  • Budget Cost Center
  • Budget Actual Remaining
  • UnBilled Amount
  • Budget Approver 1-6 - One 'Budget Approver' column per record in the system.
  • Initial Budget Amount
  • Total Budget Amount
  • Available Amount
  • Expires On
  • Billing to Date
  • Average Weekly Billing
  • Est. Wks Remaining
  • % Of Funds Used
  • VAT to Date
  • Additional Fund Amount
• Daily Prorated Parameters section
  • Minimum Threshold
  • Maximum Threshold
  • Slope Modifier
  • Super Maximum
  • Hourly Rate
• 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