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 |