TITO Details for Rate Schedule Time Sheet Upload

This integration uploads Time In/Time Out (TITO) details for worker time sheets. This upload also eliminates the need to use the Time Sheet Upload to enter and allocate the hours worked, as rate rules will determine hours.

Connector Overview

Component

Detail

Company Type

Buyer

MSP Partner

Supplier

Version Type

API-V1.0

API-A-V1.0

Format

CSV

Prerequisites

Company plug-ins must be turned on for Integration – TITO Details for Rate Schedule Time Sheet Upload.

Time In/Time Out Time Sheet Type must be enabled in Company Configuration.

Company Configuration must enable Rate Schedules.

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

Predecessors

Worker

Time Sheet

Rate Schedules

Related Connectors

Standard Time Sheet Upload

Standard TITO Details Upload

Standard Rate Schedule Revised Timesheet 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.

Upload TITO Details for Rate Schedules

Transaction

No

Only applicable for the API-V1.0 version.

Transaction Type

Transaction Type.

The valid type names are:

  • True: If any record errors, entire upload fails

  • False: Only records in error fail. Remaining records are committed successfully.

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

Submit

Yes

Determines the status in which the time sheets will be saved

The valid values are:

  • True: Time sheets will be considered completed and submitted to the next step in the Time Sheet Workflow configured in SAP Fieldglass.

  • False: The time sheets will be saved in Draft status.

Approval Required

No

Determines if the time sheets will be required to go through an approval process.

The valid values are:

  • True: Time sheets will route through the appropriate approval process if one is assigned per the current configuration of SAP Fieldglass

  • False: Time sheets will not route through an approval process and will move to the next status per the configuration.

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)
Chinese (Simplified)
Chinese (Traditional)
Dutch (Netherlands)
English (United Kingdom)
English (United States)
French (Canada)
French (France)
German (Germany)
Hebrew (Israel)
Hungarian (Hungary)
Italian (Italy)
Japanese (Japan)
Korean (Korea)
Mongolian (Mongolia)
Polish (Poland)
Portuguese (Brazil)
Portuguese (European)
Russian (Russia)
Spanish (Mexico)
Swedish (Sweden)

Date Format

No

Date format for date fields in the file.

The valid values are:

  • MM/DD/YYYY

  • DD/MM/YYYY

  • YYYY-MM-DD

If this field is not included in the header, the default value will be the format determined by the Locale value.

Buyer

Yes if supplier upload

Company Code of the buyer company to which the timesheets are to be uploaded.

If unknown, code can be found under

Start of the navigation pathAdmin  Next navigation step  Company Structure  Next navigation step  CompanyEnd of the navigation path. Details on the buyer side of the application or it is also the characters prefacing the letters “TS” in the timesheet IDs of the timesheets being uploaded.

Associate Unassigned Cost Centers to Workers

or

Associate Unassigned Cost Centres to Workers

No

Determines if cost centers in upload file that are not currently associated to worker should be associated to worker.  (Also requires company config. Allow worker access to all Cost Centers and Task Codes, and submit Time Sheets through the UI (can be updated on worker only) to be enabled

Valid values are:

  • True

  • False

If not included in header, the value will default to False.

Different spelling of header based on upload user’s language

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

Or

Work Order ID

Or

Job Seeker ID

Or

Buyer_Ref

Text

14 or 100

Yes

Valid SAP Fieldglass ID format or Buyer Reference Tag

Examples:

  • XXXXWK00000001

  • XXXXWO00000001

  • XXXXJS00000001

  • jsmith22

Unique Identifier for the worker. Can be any of the four listed to the left but must be consistent throughout the file.

First Name

Text

200

No

Example:

John

Worker’s First Name

Last Name

Text

200

No

Example:

Smith

Worker’s Last Name

TIMESHEET ID

Text

16

No

Fieldglass Time Sheet ID

Example:

XXXXTS00000001

Valid SAP Fieldglass Time Sheet ID

Date

Date

Yes

Format should match that of the format configured for the company in the application.

Start Date of the Time Sheet Period for which TITO Details are being added.

For 8 day time sheets, this field will have the same value for the entire week's records.

Entry Date

Date

Yes

Format should match that of the format configured for the company in the application.

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

For 8 day time sheets, this field applies to the date on which the TITO details are being entered for time sheet Day 1 through time sheet Day 8.

Cost Center Code

Text

200

Yes

Valid SAP Fieldglass Cost Center Code

Cost Center Code that the Worker’s hours are to be assigned. Value must be from the list of currently active Cost Centers in SAP Fieldglass at the time of the upload and must be associated to the Worker.

Task Code

Text

100

Yes

Valid SAP Fieldglass Task Code

Task Code that the Worker’s hours are to be assigned. Value must be from the list of task codes.  The Task Code must also be active and assigned to the Worker booking time against it.

GL Account Code

Text

100

Conditional

Valid SAP Fieldglass GL Account Code

Must be from the list of current active GL Account Codes and must have an association to the Worker for which time is being booked.

This column is applicable only if ‘GLA allocation on job postings and statements of work is required’ plug-in is on.

This field is mutually exclusive with Segmented Object Detail field.

Segmented Object Detail Text 2000 Conditional.

Examples:

  • IS|Admin|12001

  • IS-Admin-12001

  • IS;Admin;12001

  • IS:Admin:12001

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

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

Required if company configuration Segmented object detail is set to Yes.

This field is mutually exclusive with GL Account Code field.

Shift Code

Text

100

Dependent on 'Rate Schedule Configuration'

Dependent on Rate Schedule Configuration

Indicates default Shift Code

Time In

hh:mm

Yes

24 Hour Time Value

hh:mm

Worker Time In at the beginning of the work day.

Meal Break 1 Out

hh:mm

No

24 Hour Time Value

hh:mm

'Meal Break 1 Out' Time

Meal Break 1 In

hh:mm

Yes, if value in Meal Break 1 Out

24 Hour Time Value

hh:mm

'Meal Break 1 In' Time

Meal Break 2 Out

hh:mm

No

24 Hour Time Value

hh:mm

'Meal Break 2 Out' Time

Meal Break 2 In

hh:mm

Yes, if value in Meal Break 2 Out

24 Hour Time Value

hh:mm

'Meal Break 2 In' Time
Meal Break 3 Out hh:mm No

24 Hour Time Value

hh:mm

'Meal Break 3 Out' Time

Meal Break 3 In

hh:mm

Yes, if value in Meal Break 3 Out

24 Hour Time Value

hh:mm

'Meal Break 3 In' Time

Time Out

hh:mm

Yes

24 Hour Time Value

hh:mm

Worker Time Out at the conclusion of the work day.

Unique Identifier

  • Job Seeker ID/Worker ID/Work Order ID/Buyer Ref field

  • Cost Center Code field

  • Task Code field

  • GL Account Code field

  • Date field

  • Entry Date field

Assumptions/Tips

  • Only one cost center/task code combination per date is supported by this connector. If multiple cost centers/task codes per date are required, the CATS TITO Rate Schedule Time Sheet Upload may be used.

  • Only one shift code per date is supported by this connector.

  • Only shift codes associated with the work order are supported.

  • This upload is Time In Time Out. The system will also calculate the hours of the time sheet and the timesheet ID (if not entered).

  • TITO entries can be uploaded only for time sheets which are in Draft or Rejected status.

  • No custom fields will be supported in this upload, even if there are mandatory custom fields defined in the application.

  • Upload will accept the time in 24-Hour Clock format (hh:mm).

  • Columns First Name and Last Name will not get uploaded. (These columns are included to make upload file format similar to the Standard TITO Download).

  • Upload will insert new TITO entries for the time sheet deleting all existing TITO entries of the time sheet.

  • If the time entry is entered without the colon (“:” [such as “Time In” as 30]), it will be treated as 00:30.

  • Creation of Ad Hoc time sheets are not supported by this connector.

  • If Rate Schedule does not support Time Worked, uploads will disregard entries in any Cost Center, Task Code, and General Ledger Account (GLA) columns and will allocate cost using Work Order Cost Center %s and Task Codes that are associated for the Cost Center on worker’s record.

  • If Auto Invoice is enabled and if the new Job Posting Template/SOW Template flag Allow Additional Invoice Adjustment Currency is enabled, the system will look back to the latest confirmed Work Order/Work Order Revision/SOW/SOW Revision for the additional adjustments.

  • When a Rate Schedule Time Sheet is submitted for approval and a Time Sheet Allotment has enabled No Time Sheet Entry and Time Sheet Allotment is valid for at least one date on the time sheet, the system will apply that Time Sheet Allotment once to the time sheet.

  • When a Time Sheet is submitted successfully via this upload, the system will update tenure information.

  • For those that need to have 0:00 time captured, please contact the SAP Fieldglass help desk.​​​​​

  • For a TITO Rate Schedule Time Sheet, Allow Time in Hundredths of Hours on Time Sheet is always = Yes.

  • With 8 day time sheets, for a day that spans across two time sheets, the details entered on the most recent time sheet will not override the time entered on the previous time sheet.

  • The headers Approval Required, Messaging Required, and Supplier Review do not appear in this file. By default, these headers are considered as 'False' for this upload. If a client wants to set any of these values to 'True', then the header must be manually added to the file.

  • When the approval enforcement setting is enabled, time sheets uploaded through this connector must be approved before they can proceed and will not bypass the approval workflow.

Configuration Considerations

#

Item

Notes

1

Associate Unassigned Cost Centers to Workers

or

Associate Unassigned Cost Centres to Workers

Prior to adding this header, company configuration ‘Allow worker access to all Cost Centers and Task Codes, and submit Time Sheets through the UI (can be updated on Worker only)’ must be enabled.

The first item is for upload users with language preference of English (United States). The second item is for those with preference of English (United Kingdom).

For Contingent Workers, the entered cost centers will be associated to the worker.

For SOW Workers, we will validate if the underlying SOW has the new SOW rule Give Workers Access to all Cost Centers belonging to the Legal Entity of the SOW enabled.  

If enabled, the entered Cost Centers will be associated to the SOW Worker, else the upload will fail for that worker.