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.

Connector Overview

Component

Detail

Company Type

Buyer

Supplier

MSP Partner

Version Type

1.0

Format

CSV

Prerequisites

Company Details Setting must be turned on for Integration – Active Worker Delta Single Line Download.

User role permission must be turned on for Upload Data and Download Data.

Predecessors

Worker(s)

Related Connectors

Active Worker Single Line Download

Active Worker Download

Worker from Work Order Download

Worker from Work Order XML Download

Worker from Work Order HRXML Download

Supplier Worker Download

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

Detail

Column Header Name

Data Type

Length

Enabled by Default?

Value(s)/Format

Description/Use/Field Rules

Job Seeker ID Text 16 Yes   SAP Fieldglass Job Seeker ID.
Worker ID Text 16 Yes   SAP Fieldglass Worker ID.
Person ID Text 24 Yes   Unique identifier for the worker as a person.
Security ID Text 20 No   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 Text 100 Yes  

Status of the worker

Active or closed or withdrawn

First Name Text 100 Yes   First name of the Worker as defined in SAP Fieldglass.
Last Name Text 100 Yes   Last name of the Worker as defined in SAP Fieldglass.
Worker Email Text 100 Yes   Worker’s e-mail address.
Job Posting Title Text 100 Yes   Job Posting’s Title or SOW Name (if an SOW Worker).
Work Order ID Text 16 Yes   Work Order ID.
Work Order/Work Order Revision Owner Text 100 Yes   Work Order Owner’s name.
Work Order/Work Order Revision Owner Employee ID Text 50 No   Work Order Owner Employee ID.
Business Unit Code Text 100 Yes   Business Unit Code.
Business Unit Name Text 100 Yes   Business Unit Name.
Vendor Number Text 6 Yes   Fieldglass Supplier code.
Vendor Name Text 100 Yes   Supplier name.
Buyer Code Text 6 Yes   Buyer Company Code.
Remit To Address Code Text 100 No   Code as assigned to the RTA by supplier.
Billable Per Diem Decimal 9 No

Example:

22.50

Amount that is billable.
Start Date Date Yes   Work Order Start date.
End Date Date Yes   Work Order End Date.
Currency Text 3 Yes

Valid ISO Currency Code.

Example:

USD

GBP

Currency designation (USD).
Site Code Text 100 Yes   Site Code.
Site Name Text 100 Yes   Site Name.

Vendor ID

Text

50

No

Native field for the buyer company’s external ID.

Worker Country of Origin

Text

3

Conditional

Valid SAP Fieldglass country codes

Examples:

GER

USA

Indicates worker's country of origin.

Company configurations 'Security ID format by worker country of origin' and 'Security Information' must be enabled.

Time Zone

Text

100

No

Examples:

GMT-06:00 Central Time (US & Canada)

or

GMT-05:00 Eastern Time (US & Canada)

or

GMT Greenwich Mean Time.

Time zone for worker.

If not entered, it is defaulted to the default setting of buyer's time zone.

Discount %

Decimal

No

Valid values are 0-100, up to 3 decimal places

Discount % from SOW Worker.

Primary Location

Text

100

No

Indicates primary location name when at least one sub-configuration for the company configuration Use multiple locations is enabled.

Client must configure the download to include this field via the Enabled Fields +Add Native Fields hyperlink.

Primary Location Code

Text

100

No

Valid SAP Fieldglass location code.

Indicates primary location code when at least one sub-configuration for the company configuration Use 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

No

This field returns the Start Date from the original work order regardless of what revision the work order is currently on.

[c]{module}_{custom field(s)} Dependent on Custom Field Dependent on Custom Field.  

Custom fields may be included in download per the request of the company.

Custom fields from the following Modules may be included in the download:

Business Unit

Buyer

Consolidated Worker

Cost Center

Job Posting

Profile Worker

Security Information

SOW Worker

Supplier

Work Order

Work Order Revision

Worker

Worker User Person

If there are many custom fields, there will be many columns.

Column header format will be:

"[c] modulename_custom field name" (i.e. [c] followed by module custom text lowercase with no spaces, followed by underscore, followed by the custom field name text as defined by users in the SAP Fieldglass® application.)

Unique Identifier

  • Job Seeker ID field

  • Worker ID field

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.