Active Worker Delta Single Line Download
This integration downloads worker data for workers who have had revisions since the last successful connector run date. It returns a single line per worker (includes Temp Workers, SOW Workers, and Profile Workers).
This connector is most commonly used for new worker onboarding and provisioning as it only contains newly active or extended workers.
Inclusion Criteria
Workers and work orders in the following statuses are included if there have been any updates made to either the worker or work order record since the last run of the download.
|
Work Order Status |
Worker Registered |
Worker Record Included in Download |
Status in Download |
Person ID |
Work Order Status (Download) |
Work Order Display Status (UI) |
|---|---|---|---|---|---|---|
|
Pending Approval |
No |
Yes |
Pending |
Blank |
Pending Submission |
Pending Approval |
|
Created |
No |
Yes |
Pending |
Blank |
Submitted |
Created |
|
Rejected |
No |
Yes |
Closed |
Blank |
Rejected |
Rejected |
|
Declined |
No |
Yes |
Closed |
Blank |
Declined |
Declined |
|
Accepted |
No |
Yes |
Pending |
Blank |
Accepted |
Accepted |
|
Activated |
No |
Yes |
Pending |
Blank |
Activated |
Activated |
|
Confirmed |
Yes |
Yes |
Active |
Populated |
Confirmed |
Confirmed |
|
Pending Review |
No |
Yes |
Pending |
Blank |
Pending Submission |
Pending Review |
|
Pending Approval |
Yes |
Yes |
Active |
Populated |
Pending Submission |
Pending Approval |
|
Created |
Yes |
Yes |
Active |
Populated |
Submitted |
Created |
|
Confirmed |
Yes |
Yes |
Active |
Populated |
Confirmed |
Confirmed |
|
Rejected |
Yes |
Yes |
Active or Closed, depending on status of previous revision |
Populated |
Confirmed or Closed, depending on status of previous revision |
Rejected |
|
Declined |
Yes |
Yes |
Active or Closed, depending on status of previous revision |
Populated |
Confirmed or Closed, depending on status of previous revision |
Declined |
|
Confirmed |
Yes |
Yes |
Active |
Populated |
Confirmed |
Confirmed |
|
Closed |
No |
Yes |
Closed |
Blank |
Closed |
Closed |
|
Confirmed (Worker Closed) (End date after the download date) ) |
Yes |
Yes |
Active |
Populated |
Confirmed |
Worker Closed |
|
Confirmed (Worker Closed) (End date on or before the download date) |
Yes |
Yes |
Closed |
Populated |
Confirmed |
Worker Closed |
File Formatting
Custom Fields
-
The download file will include custom fields from various modules in SAP Fieldglass. The specific modules are explained in the file format above.
-
The client can specify the custom fields that they wish to include in the file and the order that they wish to see in the file.
-
At the time the connector is activated for the client, the client will be required to supply a list of the custom fields and their order. This list will be stored in SAP Fieldglass against the setup of the connector. If no custom fields are supplied, the download will not include any custom field values.
-
Custom fields that are included will always appear at the end of the column layout after all of the native, either default, or optional SAP Fieldglass fields have been output.
General Conventions
-
The download will include all the active worker records since the last successful run date of the connector for that buyer/MSP in SAP Fieldglass.
-
The worker file will download a worker record when the worker is registered or updated.
-
The download will also include any worker records that are closed in the future as that record is active on the day the download is executed.
Configuration Considerations
|
# |
Item |
Notes |
|---|---|---|
|
1 |
Enable Delta Compare Configuration Option |
If the ‘Enable Delta Compare’ field on the connector setup page is set to Yes, you can define the fields you want to monitor for changes. Two menu items become available under More Actions: ‘Define Delta Compare Fields’ and ‘Truncate Delta History’. If you select ‘Define Delta Compare Fields’, it allows you to choose what fields you want to select for comparison. If no fields are chosen, all enabled fields will be used for comparison. Any changes made between the downloads may impact the download results. If you select ‘Truncate Delta History’, this will truncate the back-end history table that is used to hold both the data string and key that is formed from the compare fields that were chosen. Any changes made between the downloads may impact the download results. |
Assumptions/Tips
-
Workers, whose End Dates have past but have not been officially “closed”, are included in the download.
-
For Worker User Person Custom fields:
-
If “Store Encrypted Data” is set to “Yes”, buyer users with and without the “View and Report on Sensitive Data” flag enabled in their user profile will be able to see the unencrypted value.
-
If “Visible to Supplier” is checked and “Store Encrypted Data” is set to “Yes”, supplier users with and without the “View and Report on Sensitive Data” flag enabled in their user profile will be able to see the unencrypted value. If “Visible to Supplier” is not enabled, suppliers will not see the field. The field will be suppressed for suppliers in this case.
-
-
Both Buyer and Supplier entered Custom Fields will display and can be updated by both parties regardless of who created the Custom Field first.
-
If the buyer company has multiple MSPs, when the MSP supplier user downloads records, they will see only records for their MSP.
-
Company configuration 'Security ID format by worker country of origin' cannot be enabled for companies with using 'Manage Pay Parity'.
-
Active worker type 'Direct Hire' is downloaded, along with Temp and SOW workers.
-
Work orders/work order revisions in Withdrawn status do not appear in supplier downloads.
-
Any connector configuration changes made between the downloads may impact the download results, in particular changing the delimiter.
-
The system includes any inactive cost centers associated with the document.