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 |