JDBC Driver for SAP Fieldglass

Build 24.0.9062

SecurityWorkers

Retrieve all data on workers with Security IDs using the Worker Security Download connector.

Columns

Name Type Description
Security ID String Unique identifier for a candidate when the supplier submits the candidate against a work order (WO).
Job Seeker ID String SAP Fieldglass Job Seeker ID Tied to the work order (A worker can have many Job Seeker IDs.).
Worker ID String SAP Fieldglass Worker ID. Populated when the worker registers. Tied to the work order (A worker can have many worker IDs.).
Person ID String Unique identifier for the worker as a person. Populated when the worker registers.
Status String Status of the worker: Active or Closed
First Name String First name of the worker as defined in SAP Fieldglass.
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 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 owner's employee ID.
Business Unit Code String Business unit code.
Business Unit Name String Business Unit Name.
Vendor Number String SAP Fieldglass Supplier Code for buyer.
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.
Cost Center Code String Cost Center Code in SAP Fieldglass.
Task Name String Task Name in SAP Fieldglass.
Task Code String Task Code in SAP Fieldglass.
Billable Per Diem Decimal Per diem amount that is billable (if applicable).
Start Date Date Work order start date.
End Date Date Work order end date.
Currency String Currency designation.
Site Code String Site code.
Site Name String Site name.
Rate Category / UOM String Worker's Rate Category/UOM for which the corresponding rate will be displayed. More than one Rate Category/UOM may exist for a single worker. If this is the case, a new line will appear for each associated Rate Category/UOM in this file. Rates are pulled from current work order.
Bill Rate Decimal Worker's Bill Rate which is associated to the Rate Category/UOM listed in the previous field.
Pay Rate Decimal Worker's Pay Rate which is associated to the Rate Category/UOM listed in the previous field. If the supplier did not enter a Pay Rate, 0.00 will be displayed.
Vendor ID String Native field for the buyer company's external ID.
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 of worker.If not entered, it is defaulted to the default setting of buyer's time zone.
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 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.
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.

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