Consolidated Worker Merge Upload

This integration merges existing worker records into new consolidated worker records. This helps companies remove duplicate consolidated worker records.

Connector Overview

Component

Detail

Company Type

Buyer

MSP

Version Type

API-A-V1.0

Format

CSV

Prerequisites

Company Details Setting must be turned on for Integration – Consolidated Worker Merge Upload.

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

Predecessors

N/A

Related Connectors

N/A

File Formatting

Header

Component

Required?

Definition/Use

Notes

Value

Type

Yes

Upload File Type

If you have a custom connector name for a standard connector, you may use the exact same custom name for the Type header; otherwise, you must use the standard name shown in the Value field.

Consolidated Worker Merge Upload

Send Notification?

No

Determines whether the normal messaging workflow should be followed.

This flag is used to control sending notifications to users. If the value is set to True, an email is sent. If the value is set to False, then an email will not be sent.

The valid values are:

  • True

  • False

If this field is not included in the header, the default value will be True.

Comments

No

Upload Comments

This is a comment field containing notes about the upload file.

Immediately following the Header section of the upload is one blank line.

Detail

Field Header Name

Data Type

Length

Required?

Value(s)/Format

Description/Use/Field Rules

Consolidated Worker ID

Text

16

Yes

Example:

  • ABCDWM00001234

  • NEW_MASTER_WORKER

The Consolidated Worker record to which additional workers are being added.

Only when the Object ID is a Profile Worker in pending approval status and a new Consolidated Worker ID needs to be associated, upload the value NEW_MASTER_WORKER.

Object ID

Text

1000

Yes

Example:

  • ABCDWK00001111

  • ABCDWO00001456

  • ABCDPW00001332

  • ABCDWK00001111~ABCDPW00001332~ABCDWO00001456

The Worker, Profile Worker, Work Order, and/or Historical worker records that will be associated to the Consolidated Worker.

Multiple records must be provided as tilde-separated values.

Any associations not included are removed.

Unique Identifier

  • Consolidated Worker ID field

  • Object ID field

Configuration Considerations

  • The company configuration Consolidated Worker must be enabled to use this connector.

Assumptions/Tips

  • When a Worker or Work Order is associated to a Consolidated Worker record, its association to its previous Consolidated Worker record is removed automatically. It is not possible to remove a WO/WK/PW record from all Consolidated Workers once it is associated to one. If Transaction Type is included, it is ignored.

  • Users can associate multiple WKs/WOs/PWs to a single Consolidated Worker in two ways:

    • A single row using a tilde (~) delimiter, or

    • Multiple rows for the same Consolidated Worker

  • To associate a new consolidated worker to a Profile Worker in 'Pending Approval' status, in the upload file, give the Consolidated Worker ID as a constant NEW_MASTER_WORKER. With this value, the file can be processed and create a new consolidated worker after the profile worker is approved.

    To associate any existing consolidated worker to a profile worker in 'Pending Approval' status, in the upload file, give a valid Consolidated Worker ID in its column (all the Consolidated Worker IDs that are visible on the user interface during the edit can be taken). The entered Consolidated Worker IDs are associated after profile worker is approved.

    If a valid Consolidated Worker ID is given with the combination of pending approval Profile Worker and other approved Profile Worker / Work Order / and Worker, the system takes pending approval Profile Worker and associate the Consolidated Worker ID . The other modules are ignored.

    If NEW_MASTER_WORKER is taken in the Consolidated Worker ID and a combination of pending approval Profile Worker and other approved Profile Worker / Work Order / and Worker in Object ID, then the system displays the error 'Invalid values for Consolidated Worker ID'.