Rate Group Upload

This integration uploads rate groups.

Rates 2.0 does not support Rate Grids.

Connector Overview

Component

Detail

Company Type

Buyer

Version Type

API-V1.0

API-A-V1.0

Format

CSV

Prerequisites

Company plug-ins must be turned on for Integration – Rate Group Upload.

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

Predecessors

N/A

Related Connectors

Rate Code Upload

Rate Group Detail Upload

Rate Grid Upload

Rate Grid Detail 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.

Rate Group Upload

Transaction

No

Only applicable for the API-V1.0 version.

Transaction Type

Transaction Type. The valid type names are:

  • True If any record errors, the entire upload fails.

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

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)

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

Modification Type

Char

1

Yes

Valid values:

  • A

  • U

  • D

Determines whether record is an Add, Update, or Delete modification.

A = Add

U = Update

D = Delete

Rate Group Code

Text

100

Yes

Unique Code for the Rate Group.

Name

Text 

100

Yes

Name of the Rate Group.

Description

Text 

1000

No

Optional Description of the Rate Group.

Rate Type

Text

15

Yes, for Adds only.

Valid values are:

  • Pay Rate

  • Unit Pay Rate

  • Rate

  • Markup

  • Unit Bill Rate

  • Bill Rate Based

  • Pay Rate Based

  • Parity Based

This field reflects the appropriate Rate Group Type.

Bill Rate and Pay Rate Based are only available as options if Rate Component functionality is enabled for the buyer within their company configuration.

Enter 'Pay Rate' if want Rate Type in UI to be Pay Rate and Coefficient.

Unique Identifier

  • Rate Group Code field

Configuration Considerations

#

Item

Notes

1

Rate Group Names

It is important to create a meaningful naming convention for Rate Groups. Although they may rarely be used by the standard user population, they will need to be associated to different objects by SAP Fieldglass Administrators. Consistent and descriptive naming will assist in these tasks.