Active Worker Download

This integration downloads worker data for currently active workers.

Connector Overview

Component

Detail

Company Type

Buyer

Supplier

MSP Partner

Version Type

1.0 – Returns latest revisions of work orders and profile workers.

1.1 – Returns latest revisions of work orders and profile workers. If the latest revision has not been fully approved, send previous revision instead.

Format

CSV

Prerequisites

Company Details Setting turned on for Integration – Active Worker Download

User role permission is turned on for Upload Data and Download Data.

Predecessors

Worker(s)

Related Connectors

Active Worker Single Line Download

Active Worker Delta Single Line Download

Worker from Work Order Download

Worker from Work Order XML Download

Worker from Work Order HRXML Download

Worker Download

Inclusion Criteria

Worker status should not be closed, and worker end date must be greater than parameter or run date.

Parameter

Parameter format is:

Date workers are active

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 Valid SAP Fieldglass Job Seeker ID SAP Fieldglass Job Seeker ID.
Worker ID Text 16 Yes Valid SAP Fieldglass Worker ID SAP Fieldglass Worker ID.
Person ID Text 24 Yes, for Temp and SOW workers. Optional for Profile workers.

Valid Person ID

Examples:

1002

1003

Unique identifier for the worker as a person.
Security ID Text 100 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 50 Yes

Valid values are:

Active

Closed

Created

Pending

Pending Approval

Approval Paused

Rejected

Status of the worker.
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 for SOW Workers.
Work Order ID Text 16 Yes Valid SAP Fieldglass Work Order ID 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’s Employee ID.
Business Unit Code Text 100 Yes Valid SAP Fieldglass Business Unit Code Business Unit Code.
Business Unit Name Text 100 Yes   Business Unit Name.
Vendor Number Text 6 Yes   SAP Fieldglass Supplier code for buyer.
Vendor Name Text 200 Yes   Supplier name.
Buyer Code Text 6 Yes   Buyer Company Code.
Remit To address Code Text 100 No   Code as assigned to the Remit To Address by supplier.
Cost Center Name Text 200 No Valid SAP Fieldglass Cost Center Code Cost Center Name in SAP Fieldglass.
Cost Center Code Text 200 Yes   Cost Center Code in SAP Fieldglass.
Billable Per Diem Decimal No

Amount that is billable.

Example:

75.00

 
Start Date Date Yes   Work order start date.
End Date Date Yes   Work order end date.
Currency Text 100 Yes   ISO currency designation (ex. USD).
Site Code Text 100 Yes Valid SAP Fieldglass Site Code Site Code.
Site Name Text 100 Yes   Site Name.

Rate Category/UOM

 

Text 100 Yes  

Worker’s Rate Category/Unit Of Measure for which the corresponding rate will be displayed.

More than one Rate Category/UOM may exist for a single Worker.  If this is the case a new line will appear for each associated Rate Category/UOM in this file.

Bill Rate Decimal Yes   Worker’s Bill Rate that is associated to the Rate Category/UOM listed in the previous field.
Pay Rate Decimal Yes  

Worker’s Pay Rate that is associated to the Rate Category/UOM listed in the previous field.

If Supplier did not enter a Pay Rate, 0.00 will be displayed.

Sequence Number Yes   Work Order Revision Number.

Segmented Object Detail

Text 2000

Conditional

Examples:

IS|Admin|12001

IS-Admin-12001

IS;Admin;12001

IS:Admin:12001

Segmented Object Detail string. Segments will be separated by delimiter on the Segmented Object.

Valid delimiters are colon (:), semi-colon (;), pipe (|), and dash (-).

Required if ‘Segmented object detail’ configuration is set.

This field is mutually exclusive with GL Account fields.

More than one string can appear for a cost center.

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.

Location Code

Text

100

Conditional

Valid SAP Fieldglass location code

The location code of the hours against the Rate/Rate Category for that day.

Enable at least one sub-configuration for the company configuration Use multiple locations. If the download’s parameters pull a document with multiple locations, the row is 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 on the time sheet.

Work Location Name

Text

100

Conditional

The location name of the hours against the Rate/Rate Category for that day.

Enable at least one sub-configuration for the company configuration Use multiple locations. If the download’s parameters pull a document with multiple locations, the row is 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 on the time sheet.

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] Work Order Custom Fields Text 4000 Depends on custom field configuration.  

Custom fields found on the work order/work order revision.

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.)

[c] Worker Custom Fields Text 4000 Depends on custom field configuration.  

Custom fields found on the worker.

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.)

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

Statement of Work

SOW Revision

SOW Worker

Worker

[c] Worker User Person Custom Fields Text 4000 Depends on custom field configuration.  

Custom fields found on the 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.)

[c] Buyer or Supplier custom fields Text 4000 Depends on custom field configuration.  

Custom fields found on the supplier. (For supplier side download, only those fields required by buyer for supplier to be entered and viewed are downloaded.)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 they wish to include in the file and the order that they wish to see in the file.

  • When 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.

  • Included custom fields will always appear at the end of the column layout after all of the native SAP Fieldglass fields have been output.

Assumptions/Tips

  • A future date may be used as a parameter when requesting the file. The data will be treated as today’s date and only those workers that are Active as of the current date will be returned.

  • 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 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 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.

  • For a SOD enabled company, the column of ‘Segmented Object Detail’ should be added as an enabled field. Otherwise there is a chance for clients to see duplicate records since a worker may have multiple SOD values for which the worker record will appear multiple times in the file.

  • Company configuration 'Security ID format by worker country of origin' cannot be enabled for companies using 'Manage Pay Parity'.

  • Active worker type 'Direct Hire' is downloaded, along with Temp and SOW workers.

  • For Rates 2.0, for Calculated Rates with Calculation Type = Rate Rule and if rule-based rate's value has not yet been calculated, the value is output as zero.

  • The system includes any inactive cost centers associated with the document.