Parent Company Historical Worker Upload
This integration uploads parent company historical worker changes.
There is a Historical Worker Upload connector that can be used to upload historical workers for child companies.
Connector Overview
|
Component |
Detail |
|---|---|
|
Company Type |
Buyer |
|
Version Type |
BULK FULL-V1.0 |
|
Format |
CSV |
|
Prerequisites |
Company Details Setting must be turned on for Integration – Parent Company Historical Worker Upload User role permission must be turned on for Upload Data and Download Data. |
|
Predecessors |
Historical Workers |
|
Related Connectors |
Worker Upload Worker Edit Upload Historical Worker Upload |
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. |
Parent Company Historical Worker Upload |
|
Transaction |
No |
Transaction Type |
Transaction Type. The valid type names are:
If this field is not included in the header, the default value will be True. |
|
|
Language |
No |
Determines the language to be used for values in the file, such as drop-down lists and radio buttons. Column headers will always default to the upload user's preferred language. |
The valid language values are: Arabic (Standard Arabic) |
|
|
Number Format |
No |
Determines the number format to be used in the file. |
The valid values are:
The quotes are required even if the value does not have a comma in it. If this field is not included in the header, the default value will be “#,##9.99” (Example: ”1,234,567.99”) |
|
|
Date Format |
No |
Determines the date format to be used in the file. |
The valid values are:
If this field is not included in the header, the default value will be MM/DD/YYYY. |
|
|
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 |
|---|---|---|---|---|---|
|
Worker ID |
Text |
100 |
Yes |
Worker identifier from buyer’s historical system Examples:
|
Identifier of the worker to be uploaded. |
|
Security ID |
Text |
100 |
No |
This is the Security ID of worker that is to be uploaded. Company configuration Security Information must be enabled to use this field. If the Worker Country of Origin value has a configured Auto-generate Security ID format (which is available for configuration when the Auto-generate Security ID company configuration is enabled), the Security ID will be auto-generated and any value entered here will be ignored. |
|
|
Unique ID |
Text |
100 |
No |
This is the Unique ID of Consolidated Worker that is to be uploaded. Company configuration Consolidated Worker must be enabled to use this field. |
|
|
Buyer Ref |
Text |
100 |
No |
Unique identifier for buyer |
Buyer reference of the worker to be uploaded. |
|
First Name |
Text |
200 |
No |
Example:
|
First name of the historical worker. |
|
Last Name |
Text |
200 |
No |
Example:
|
Last name of the historical worker. |
|
Start Date |
Date |
Yes |
Worker’s start date |
||
|
End Date |
Date |
Yes |
Worker’s end date |
||
|
Country |
Text |
3 |
No |
Valid Fieldglass list of country codes |
Country of the historical worker. |
|
Worker Type |
Text |
100 |
No |
Valid values are:
|
This is the valid type of worker. |
|
Job Title |
Text |
100 |
No |
Job posting title for temporary or direct hire workers. SOW name for SOW workers |
|
|
Supplier Code |
Text |
6 |
No |
Valid Fieldglass supplier code |
Supplier code associated with the historical worker |
|
Supplier Name |
Text |
100 |
No |
Supplier name associated with the historical worker |
|
|
Cost Center Name |
Text |
200 |
No |
Any cost center names |
Cost center name |
|
Business Unit Name |
Text |
200 |
No |
Any business unit names |
Business unit name |
|
Site Name |
Text |
200 |
No |
Any site names |
Worker site name |
|
Work Location Name |
Text |
200 |
No |
Any location names |
Worker location name |
|
Manager Name |
Text |
100 |
No |
Name of historical worker’s manager. |
|
|
Closed Reason |
Text |
100 |
No |
Any close reason |
Reason historical worker’s assignment ended. |
|
Do Not hire Flag |
Text |
No |
Valid values are:
|
Indicates if the historical worker should be flagged as DO NOT HIRE. If field left blank, defaults to No. |
|
|
Worker Country of Origin |
Text |
3 |
Conditional |
Valid SAP Fieldglass country code Examples:
|
Indicates worker's country of origin. Company configurations Security ID format by worker country of origin' and Security Information must be enabled. |
|
[c] historical worker CF1 |
Dependent on custom field configuration |
Dependent on custom field configuration |
Dependent on custom field configuration |
Custom field on historical worker module. |
Unique Identifier
-
Worker ID field
Assumptions/Tips
-
The combination of the Historical Worker Ref ID (Worker ID) and their Name (First Name and Last Name) should be a valid combination.
-
If you want Consolidated Worker match logic, Matches on Security ID only and Buyer Ref only are not considered Strong must be enabled in company configuration. When this configuration is enabled, if the only attribute that matches between a document and the Consolidated Worker is the Security ID or the Buyer Ref, the match is not considered Strong. Strong matches require one of the following combinations: Identical Name (First Name and Last Name) + Security ID + Buyer Ref, Identical Security ID + Buyer Ref, Identical Name (First Name and Last Name) + Security ID when the document has no Buyer Ref, or Identical Name + Buyer Ref when the document has no Security ID.
-
Company configuration Security ID format by worker country of origin cannot be enabled for companies using Manage Pay Parity.