ODBC Driver for SAP Fieldglass

Build 24.0.9062

ActiveWorkersSingleLine

Retrieve all active workers using the Active Worker Single Line Download connector.

Columns

Name Type Description
Worker ID [KEY] String SAP Fieldglass Worker ID.
Job Seeker ID String SAP Fieldglass Job Seeker ID.
Person ID String Unique identifier for the worker as a person.
Security ID String This column will only appear in the file if the security ID field functionality is activated in SAP Fieldglass for the buyer. If the functionality is not activated, this column will not be in the file.
Status String Status of the worker.
First Name String First name of the worker as defined in SAP Fieldglass (100 characters).
Last Name String Last name of the worker as defined in SAP Fieldglass.
Worker Email String Worker's e-mail address.
Job Posting Title String Job Posting's Title or SOW Name for SOW Workers.
Work Order ID String Work Order ID.
Work Order/Work Order Revision Owner String Work Order Owner's name.
Work Order/Work Order Revision Owner Employee ID String Work Order Employee ID.
Business Unit Code String Business Unit Code.
Business Unit Name String Business Unit Name.
Vendor Number String Fieldglass Supplier code.
Vendor Name String Supplier name.
Buyer Code String Buyer Company Code.
Remit To Address Code String Code as assigned to the RTA by Supplier.
Cost Center Name String Cost Center Name in SAP Fieldglass. Primary Cost Center only.
Cost Center Code String Cost Center Code in SAP Fieldglass. Primary Cost Center Only.
Billable Per Diem Decimal Amount that is billable.
Start Date Date Work Order Start date.
End Date Date Work Order End Date.
Currency String Currency designation (USD).
Site Code String Site Code.
Worker Country of Origin String Indicates worker's country of origin.Company configurations 'Allow Security ID format by Worker Country of Origin' and 'Enable Security Information' must be enabled.
Time Zone String Time zone for worker.If not entered, it is defaulted to the default setting of buyer's time zone.
Discount % Decimal Discount % from SOW Worker
Primary Location String Indicates primary location name when Company Configuration 'Allow Multiple Locations' is enabled. Client must configure the download to include this field via the Enabled Fields +Add Native Fields hyperlink.
Work Location Name String The location name. Company configuration 'Allow Multiple Locations' must be enabled. Row will be repeated with the exact same information in all columns except the location columns. There will be as many duplicated rows as there are number of locations.
Location Code String The location code. Company configuration 'Allow Multiple Locations' must be enabled. Row will be repeated with the exact same information in all columns except the location columns. There will be as many duplicated rows as there are number of locations.
Primary Location Code String Indicates primary location code when Company Configuration 'Allow Multiple Locations' is enabled. Client must configure the download to include this field via the Enabled Fields +Add Native Fields hyperlink.
Original Revision Start Date Date This field returns the Start Date from the original work order regardless of what revision the work order is currently on.
Project-Based Worker String Indicates if project-based workers are allowed.If this field is left blank, it uses the value from the Contingent Type.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062