SecurityWorkersSingleLine
Retrieve all data on workers with Security IDs using the Worker Security Single Line 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 | Primary Cost Center Name in SAP Fieldglass. |
Cost Center Code | String | Primary Cost Center 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. |
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. 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. |