Time Sheet Rejection Upload

This integration rejects time sheets in bulk.

Connector Overview

Component

Detail

Company Type

Buyer

Version Type

API-A-V1.0

Format

CSV

Prerequisites

Company plug-ins must be turned on for Integration – Time Sheet Rejection Upload.

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

Predecessors

Time Sheet Upload

Related Connectors

Time Sheet 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.

Time Sheet Rejection Upload

Number Format

No

Determines the number format to be used in the file.

The valid values are:

  • “#,##9.99" (Example: "1,234,567.99”)

  • “#.##9,99" (Example: "1.234.567,99”)

  • “#'##9.99" (Example: "1'234'567.99”)

  • “# ##9,99" (Example: "1 234 567,99”)

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:

  • MM/DD/YYYY

  • DD/MM/YYYY

  • YYYY-MM-DD

If this field is not included in the header, the default value will be MM/DD/YYYY.

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)

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

Timesheet _ID

Yes

Unique Identifier.

Example:

XXXXTS00000001

Unique identifier for the time sheet.

Reject Reason

Text

100

Yes

Valid SAP Fieldglass Reason

Valid SAP Fieldglass Reason. Any reason of the Rejectedreason type, configured by buyers for the time sheet module.

If the field is left blank and no close reason is provided, a missing reason error is thrown in the upload process.

Comments

Text

2000

No

Any comments to be recorded along with the timesheet rejection.

Unique Identifier

  • Timesheet ID field

Assumptions/Tips

  • Time sheets should be in Pending Approval/Approval Paused/Approved Status/Invoiced Status.

  • If users are not at the approval level, the upload adds them as ad-hoc approvers and rejects the timesheet. However, if an existing ad-hoc approver has already approved the timesheet, the new ad-hoc approvers do not have approval permissions, and the timesheet cannot be rejected.

  • A time sheet with an invoiced status deletes the invoice and invoice-related items of the time sheet after rejecting it.

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

  • Upload cannot affect time sheets in 'Revoked' status.

Frequently Asked Questions

Question:

Do I have to provide a 0 for a day not worked?

Answer:

No, but it is best practice to do so. Entering a 0 in for the hours worked in a day shows all using the system that a value was deliberately entered in a time sheet to show no work was done. This eliminates the question of whether or not it was not entered. In many cases, it is a good idea to enter a Zero Hour Time Sheet when Workers are off for a period of time. This shows that the time sheet was submitted and is not a “missing” time sheet that may still be submitted with hours.