ActiveWorkersSingleLine
Retrieve all active workers using the Active Worker Single Line Download connector.
Columns
| Name | Type | Description |
| Worker ID [KEY] | 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 (100 characters). |
| 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 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 | 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. Primary Cost Center only. |
| Cost Center Code | String | Cost Center Code in SAP Fieldglass. Primary Cost Center Only. |
| Billable Per Diem | Decimal | Amount that is billable. |
| Start Date | Date | Work Order Start date. |
| End Date | Date | Work Order End Date. |
| Currency | String | Currency designation (USD). |
| Site Code | String | Site Code. |
| 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. |
| 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 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. |
| Project-Based Worker | String | Indicates if project-based workers are allowed.If this field is left blank, it uses the value from the Contingent Type. |