ActiveWorkers
Retrieve all active workers using the Active Worker Download connector.
Columns
| Name | Type | Description |
| Worker ID | 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. |
| 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 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 Remit To Address by supplier. |
| Cost Center Name | String | Cost Center Name in SAP Fieldglass. |
| Cost Center Code | String | Cost Center Code in SAP Fieldglass. |
| Billable Per Diem | Decimal | Billable Per Diem |
| Start Date | Date | Work order start date. |
| End Date | Date | Work order end date. |
| Currency | String | ISO currency designation (ex. USD). |
| Site Code | String | Site Code. |
| Site Name | String | Site Name. |
| Rate Category / UOM | String | Worker's Rate Category/Unit Of Measure 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. |
| Bill Rate | Decimal | Worker's Bill Rate that is associated to the Rate Category/UOM listed in the previous field. |
| Pay Rate | Decimal | Worker's Pay Rate that is associated to the Rate Category/UOM listed in the previous field. If Supplier did not enter a Pay Rate, 0.00 will be displayed. |
| Sequence | Int | Work Order Revision Number. |
| Segmented Object Detail | String | Segmented Object Detail string. Segments will be separated by delimiter on the Segmented Object. Valid delimiters are colon (:), semi-colon (;), pipe (|), and dash (-). Required if 'Enable Segmented Object Detail' configuration is set. This field is mutually exclusive with GL Account fields. More than one string can appear for a cost center. |
| 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. |
| 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 of the hours against the Rate/Rate Category for that day.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. |
| Work Location Name | String | The location name of the hours against the Rate/Rate Category for that day.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. |
| 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. |