WorkersFromWorkOrder
Retrieve multiple workers using the Worker from Work Order Download connector.
Columns
| Name | Type | Description |
| Job Seeker ID | String | Tied to the work order. A worker can have many Job Seeker ID's. |
| Worker ID | String | Will be blank if the record is downloaded from the work order. Tied to the work order. A worker can have many worker IDs. |
| Person ID | String | Will be blank if the record is downloaded from the work order. 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 | Pending - Work order created or accepted or activated. Closed - Work order rejected, declined, closed, or worker closed. Active - Worker confirmed or work order revised. |
| First Name | String | Worker First Name. Populated from Worker once registered; populated from Job Seeker prior to registration. |
| Last Name | String | Worker Last Name. Populated from Worker once registered; populated from Job Seeker prior to registration. |
| Worker Email | String | Worker's Email Address. |
| Job Posting Title | String | Job Posting Title for Temporary or Direct Hire Workers. SOW Name for SOW Workers. |
| Work Order ID | String | Work Order ID. *Will be blank for Profile Workers. |
| Work Order/WorkOrder RevisionOwner | String | Work Order Owner Name. |
| Work Order/WorkOrder RevisionOwner Employee ID | String | Work Order Owner 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 | Fieldglass Buyer Company Code. |
| Remit To Address Code | String | Code as assigned to the Remit To Address by the Supplier. |
| Worker Pay Type Code | String | Indicates any worker pay types.Company configuration 'Use Worker Type' must be enabled. |
| Cost Center Name | String | Cost Center Name. |
| Cost Center Code | String | Cost Center Code. |
| Task_Name | String | Task Name. If Worker has flag set to allow access to all Task Codes, this field will be blank. |
| Task_Code | String | Task Code If Worker has flag set to allow access to all Task Codes, this field will be blank. |
| Billable Per Diem | Int | Billable Per Diem Amount. |
| Start Date | Date | Start Date of latest Confirmed Work Order Revision. |
| End Date | Date | End Date of the latest Confirmed Work Order Revision. |
| Currency | String | Three-character ISO currency designation. |
| Site Code | String | Site Code. |
| Site Name | String | Site Name. |
| Rate Category/UOM | String | Rate category and rate unit (e.g. ST/Hr, OT/Day, ST/MTH). |
| Bill Rate | Int | Bill Rate for the Rate Category. |
| Pay Rate | Int | Pay Rate for the Rate Category. Populated for buyer downloads when buyer has access to supplier pay rate data, otherwise this field will default to 0. |
| 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. |
| Discount % | Decimal | Discount % from SOW Worker |
| 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. |
| 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. |
| 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. |
| 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. |