SSIS Components for SAP Fieldglass

Build 24.0.9060

SecurityWorkersWithTransactionTypeSingleLine

Retrieve worker records based on transaction type filtering logic using the Worker Security with Transaction Type Single Line Download connector.

Columns

Name Type Description
Security ID String Unique identifier for a candidate when the supplier submits the candidate against a WO.
Job Seeker ID String Internal SAP Fieldglass ID for Job Seeker. Tied to the work order. A worker can have many Job Seeker IDs.
Worker ID String Tied to the work order. A worker can have many Worker IDs. Will be blank if the record is downloaded from the work order Populated when the worker registers.
Person ID String Unique identifier for the worker as a person Will be blank if the record is downloaded from the work order Populated when the worker registers.
Status String The status is set based on the following: pending: wo created pending: wo accepted closed: wo rejected closed: wo declined activated: wo activated active: worker confirmed active: worker revised active: wo revised closed: wo closed closed: worker closed Rule: Filter out Pending and Activated statuses
First Name String First name
Last Name String Last name
Worker Email String Workers e-mail address
Job Posting Title String Job Posting title for worker
Work Order ID String Work Order ID
Work Order/Work Order Revision Owner String Work Order owner 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 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
Primary Cost Center Name String Primary Cost Center Name
Primary Cost Center Code String Primary Cost Center Code
Billable Per Diem Decimal Billable Per Diem
Start Date Date Format: mm/dd/yyyy
End Date Date Format: mm/dd/yyyy
Currency String Currency designation (USD)
Site Code String Site code of worker
Site Name String Site name
Buyer Reference String Unique id for buyer side
Transaction Type String Indicates if hire, rehire, update, or termination
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 Work Location Name
Location Code String Valid SAP Fieldglass location code
Primary Location String Primary Location
Primary Location Code String Valid SAP Fieldglass location code
Original Revision Start Date Date Original Revision Start Date

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