Worker Activity Item Download

Connector Overview

Component	Detail
Company Type	Buyer MSP Partner Supplier
Version Type	1.0
Format	CSV

Component

Detail

Company Type

Buyer

MSP Partner

Supplier

Version Type

1.0

Format

CSV

File Formatting

Detail

Field Header Name	Data Type	Length	Required?	Value(s)/Format	Description/Use/Field Rules
Object ID	Text	16	Yes	Valid SAP Fieldglass: Worker ID Work Order ID Profile Worker ID Resource ID
Job Seeker ID	Text	16	Yes	Example: ABCJS00000001	Tied to the work order. A worker can have many Job Seeker ID's.
First Name	Text	100	Yes	Example: John	Worker’s First Name
Last Name	Text	100	Yes	Example: Smith	Worker’s Last Name
Action	Text	100	Yes
Code	Text	100	Yes	Valid Activity/Offboarding Activity	The code for the onboarding or offboarding item that is to be marked as completed.
Status	Text		Yes	Canceled Completed Pending
Site Code	Text	100	Yes	site1	Site code of worker.
Business Unit Code	Text	100	Yes	BU1	Business unit code of worker
Activity Item Type	Text		Yes	Examples: Evaluate Manage Worker etc.	See full list in Appendix section below.
Actor	Text	100	Yes	Example: Administrator Supplier Account Worker	Role who needs to act upon the item.
Main Document ID	Text	16	No	Valid SAP Fieldglass JP, SOW ID, or Assignment ID. ABCTQ000000125 ABCJP000000125	SOW, JP IDs
Description	Text	100	No		Description of the activity item.
Due Date	Date		No		Date to mark pending recurring items for activity item of due on type 'specific calendar date'.
Completion Date	Date		No	Company default date format. Example: MM/DD/YYYY	Completion date of checklist item.
Completion Type	Text	100	Yes	Valid values are: Activity Offboarding Activity	Valid SAP Fieldglass Completion Type
Frequency	Text		Yes	Once Recurring
Buyer Code	Text	100	No		Buyer Code
Supplier Code	Text	100	No		Supplier Code
Supplier Name	Text	100	No		Supplier Name
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.
Website URL	Text	100	No	website address
Prerequisite item action	Text	100	No		The title for the Activity Item the represents the action. For example, “Sign NDA document”. This is the text that is sent in the work item. Two activity items may have same action.
Prerequisite item code	Text	100	No	Valid Activity/Offboarding Activity code of the prerequisite activity item code	Code of the onboarding or offboarding Item that needs to be completed before this item.
Completed by Username	Text	100	No	Valid SAP Fieldglass Username. Examples: djones tsmith	Indicates who completed the checklist item.
Document Start Date	Date		No	Company default date format. Example: MM/DD/YYYY	Activity item start time.
Document Expiration Date	Date		No	Company default date format. Example: MM/DD/YYYY	Activity item end time.
Revision Time	Date		No	Company default date format. Example: MM/DD/YYYY	Checklist item revision time.
Revision Number	Text	16	No
Usage	Text		No	Valid values are: Optional Mandatory
[c]{module}_{custom field(s)}	Dependent on custom field configuration.		No		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: Activity Offboarding Activity Business Unit Buyer Consolidated Worker Cost Center Job Posting Job Seeker SOW Worker Supplier Work Order Work Order Revision Worker Worker User Person

Unique Identifier

Code

Custom Fields

The download file will include custom fields from various modules in SAP Fieldglass. For the specific modules, consult your SAP Fieldglass representative

The client can specify the custom fields that they wish to include in the file and the order in which they want 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.

Inclusion Criteria

The download will include any status Worker Activity Items that has been revised or actioned since the last run date and current run date of the connector for that buyer/supplier/MSP in SAP Fieldglass.

Appendix - Activity Item Type

The following is a list of valid Activity Item Type that may be provided in the Activity Item Type field in this download.

Manage Worker
Manage Consolidated Worker
Add Attachment
Manage Contract/eSignature
Evaluate
Other
Manage Assignment

Appendix - Completion Type

The following is a list of valid Completion Types that may be provided in the Completion Type field in this download.

Add Attachment to Worker
Complete Onboarding Task
Complete Offboarding Task
Edit Worker
Manage Contingent Worker End Date
Revise Worker
Worker Closed
Add Attachment to Contingent Work Order
Add Attachment to Statement of Work
Add Attachment to Worker
Add Attachment with Expiration Date
Add Form Attachment
Add Attachment to Contingent Work Order
Add Attachment to Statement of Work
Attach Contingent Worker
Contract Initiate eSignature Process
Sign a Document Manually
Validate a Document
Evaluate Supplier
Evaluate Worker
Complete Custom Fields
View Website
Questionnaire
Review SOW Bid