SecurityWorkersWithTransactionType
Retrieve worker records based on transaction type filtering logic using the Worker Security with Transaction Type 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 |
| 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 |
| Cost Center Name | String | Cost Center Name |
| Cost Center Code | String | Cost Center Code |
| Task_Name | String | Task Name |
| Task_Code | String | Task Code |
| Billable Per Diem | Decimal | Billable Per Diem |
| Start Date | Date | Work order start date. Valid format is: yyyy-mm-dd |
| End Date | Date | Work order end date. Valid format is: yyyy-mm-dd |
| Currency | String | Currency designation (ex. USD) |
| Site Code | String | Site code |
| Site Name | String | Site name |
| Rate Category/ UOM | String | Rate category and rate unit of measure |
| Bill Rate | Decimal | Bill rate for the Rate Category |
| Pay Rate | Decimal | Pay Rate for the Rate Category (Populated for buyer downloads when buyer has access to supplier pay rate data, otherwise this field will be defaulted to 0) |
| Worker Supervisor | String | Username of worker's supervisor |
| Closed Reason | String | Reason for closing worker |
| Buyer Reference | String | Native Buyer Reference on the Worker. Contains External Person ID. |
| Transaction Type | String | Send based on when the user took the action in SAP Fieldglass vs when it is effective. So, if a future close action is taken today we would send a TER trans type with the future end date. The following are possible values: HIR — Indicating brand new contingent worker. Rule: Status is Active and Buyer Reference is Blank UPD—Indicating a change to the existing contract of a contingent worker Rule: Status is Active and Buyer Reference is not Blank and is not a rehire. RHI – Indicating this is an existing worker on a new assignment Rule: Status is Active and Buyer Reference is not Blank and there is a previous Work Order in TRM status, and no other work orders are active during the same window. TER — Indicating a termination Rule: Send when the Action to Close is taken: User Closed in a future date Auto-Close after end date Please reference Transaction Type Process within this document for further details. |
| 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 the buyer's time zone. |
| 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 | Original Revision Start Date |