TITO Time Sheet Status Parameter Download

This integration downloads worker time in/time out (TITO) details based off a parameter entered during run time. Worker time sheets will be in Draft, Pending Validation, or Pending Supplier Review status depending on the parameter value entered during run time. Refer to the Parameters section for more information.

Connector Overview

Component

Detail

Company Type

Buyer

Supplier

MSP Administrator

Version Type

1.0

Format

CSV

Prerequisites

Company plug-ins must be turned on for Integration – Download TITO Timesheet Status Parameter.

Time In/Time Out Timesheet Type must be enabled in Company Config.

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

Predecessors

Worker

Timesheet

Related Connectors

Standard Supplier Time Sheet Download

Triggering Events

The time sheet must be in Draft, Pending Validation, or Pending Supplier Review status.

Time sheets for the logged-in user’s company are pulled. For example, the supplier user will pull time sheets for that supplier; buyer user will pull time sheets for that buyer.

Parameter

A parameter must be given in order for this connector to run. The parameter is a numeric time sheet status.
  • 0 - Draft

  • 97 - Pending Validation

  • 101 - Pending Supplier Review

File Formatting

Detail

Field Header Name

Data Type

Length

Enabled by Default?

Value(s)/Format

Description/Use/Field Rules

Worker_Id

Text

16

Yes

Valid SAP Fieldglass Worker ID

Example:

xxxxWK00001234

Valid Worker ID.

Last Name

Text

100

No

 

Worker’s Last Name.

First Name

Text

100

No

 

Worker’s First Name.

Time_Sheet_Id

Text

16

No

Fieldglass Timesheet ID

Example:

xxxxTS00004567

Valid SAP Fieldglass Timesheet ID.

Date

Date

Yes

Date of the Timesheet Day for which TITO Details are being added.

Time In

Time

Yes

24 Hour Time Value

hh:mm

Worker Time In at the beginning of the work day.

Meal Break 1 Out

Time

No

24 Hour Time Value

hh:mm

Meal Break 1 Out Time.

Meal Break 1 In

Time

Yes, if there is a value in Meal Break 1 Out.

24 Hour Time Value

hh:mm

Meal Break 1 In Time.

Meal Break 2 Out

Time

No

24 Hour Time Value

hh:mm

Meal Break 2 Out Time.

Meal Break 2 In

Time

Yes, if there is a value in Meal Break 2 Out.

24 Hour Time Value

hh:mm

Meal Break 2 In Time.

Meal Break 3 Out

Time

No

24 Hour Time Value

hh:mm

Meal Break 3 Out Time

Meal Break 3 In

Time

Yes, if there is a value in Meal Break 3 Out.

24 Hour Time Value

hh:mm

Meal Break 3 In Time

Time Out

Time

Yes

24 Hour Time Value

hh:mm

Worker Time Out at the conclusion of the work day.

Unique Identifier

  • Time_Sheet_Id field

  • Date field