Job Posting Upload

This integration uploads job postings. This upload allows customers that are currently using an applicant tracking application to maintain open position data in that system and then pass the pertinent data for job openings related to services within scope of SAP Fieldglass.

Connector Overview

Component

Detail

Company Type

Buyer

MSP Partner

Version Type

API-V1.0

API-A-V1.0

BULK-DELTA-V1.0

Format

CSV

Prerequisites

Company Details setting must be turned on for Integration – Job Posting Upload.

User role permission must be turned on for upload data and download data.

Predecessors

Job Posting Templates

Business Units

Cost Centers

Sites

User

Related Connectors

Job Posting Template Upload

Job Seeker Upload

Job Posting Close Upload

Job Posting Coordinator Distributor Change 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.

Job Posting 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 is True.

Only applicable to the API version.

Approval Required

No

Determines if approval rules will be followed.

The valid values are:

  • True: Approval rules will be followed.

  • False: Job postings will be submitted without any approvals.

If header is missing or blank, default value will be True.

Send Notification?

No

Determines whether normal messaging workflow should be followed.

This flag is used to control sending notifications to users. If value set to True email will be sent. If value is set to False, then email will not be sent.

The valid values are:

  • True

  • False

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 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)

Number Format

No

Determines the number format to be used in the file.

This is an optional header value. Determines the number format used in the company.

The valid number format 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".

Date Format

No

Determines the date format to be used in the file.

The valid date format 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.

Submit

No

Determines the status in which the job postings will be saved.

The valid values are:

  • True: Job postings are considered completed and submitted to the next step in the job posting workflow configured in SAP Fieldglass.

  • False: Job postings are saved in draft status.

If this header is missing or blank, it defaults to True.

MSP

Conditional

Determines if the Custom Field present in the file is associated to the respective MSP for a multiple MSP buyer

Valid MSP code

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

Column Header Name

Data Type

Length

Required?

Value(s)/Format

Description/Use/Field Rules

External Job Posting ID

Text

100

Yes

An external job posting identifier used by the client for tracking purposes.

Creator Username

Text

100

Yes

Valid SAP Fieldglass Username

The valid SAP Fieldglass username of the individual who creates this specific job posting. The creator of the job posting can be different from the owner of the job posting. This user must be loaded into SAP Fieldglass prior to this file upload.

If the 'Enhanced Legal Entity Validation' configuration is enabled for the company and if the Creator Username is not the same as the Owner Username, then system must validate if the creator and owner both have visibility to the job posting legal entity, business unit, cost center and site codes. If even one of them is not associated to either the creator or the owner, the system displays an error message.

Template ID

Text

16

Yes, if Template Name is not entered.

Example:

  • ABCDJT00001234

System generated template identifier.

If the Enhanced Legal Entity Validation configuration is enabled for the company, the creator and owner must have the legal entity and business unit visibility to the template, otherwise the system displays an error message.

Template Name

Text

100

Yes, if Template ID is not entered.

Job Posting Template names are defined in the SAP Fieldglass application.

The name of the job posting template upon which this job posting is based. Job posting template names are defined in the SAP Fieldglass application.

If the Enhanced Legal Entity Validation configuration is enabled for the company, the creator and owner must have the legal entity and business unit visibility to the template, otherwise the system displays an error message.

Buyer reference

Text

100

No

Used to set buyer reference value on the job posting.

Title

Text

100

Yes

Example:

  • Administrative Assistant

The title of the position requested for this job posting.

SAP Fieldglass recommends that the value of the Title field be the same as the template name. This allows for easy tracking and reporting purposes.

Number of Positions

Number

Conditional

Example:

  • 1

The number of positions requested for this job posting.

If this field is left blank and Is Named Job Posting? is Yes or True, this field defaults to 1.

Job Description

Text

10000

No

A description of the position requested on this job posting.

If this field is left null/blank, the job description from the job posting template becomes the default description for this job posting.

Use the following HTML tags to format text in supported fields:

<strong>Your text</strong>
<em>Your text</em>
<span style="text-decoration: underline;">Your text</span>
<ul>
  <li>Bullet Item 1</li>
  <li>Bullet Item 2</li>
</ul>

These will render as bold text, italics, underlined text, and bullets, respectively.

Remember:

  • Tags must be opened and closed (for example., <strong> ... </strong>)

  • Tags can be combined: <strong><em>Bold and italic</em></strong>

  • Plain text fields do not render HTML — only use in fields that support rich text

Are workers project-based?

Text

3

No

Valid values are:

  • Yes

  • No

Indicates if workers are project based.

If this field is left blank, it uses the value from the Contingent Type.

Currency

Text

100

Yes

Valid SAP Currency Code.

Examples are:

  • USD

  • CAD

  • GBP

Valid three-character currency code associated with the Cost Center listed in the Cost Center Code field. Only one currency code can be given.

Currency must be associated with the buyer prior to using in this upload.

Business Unit Code

Text

100

No

Valid SAP Fieldglass Business Unit Codes

The business unit in which this job posting belongs. Business unit codes must be defined in the SAP Fieldglass application, and the job posting owner must have access to this business unit code.

When the buyer is using the Users have access to all Business Unit/Cost Centers and Sites configuration, the business unit is automatically associated to the job posting owner and all those users who can act as a coordinator on upload.

If the Enhanced Legal Entity Validation configuration is enabled for the company, the creator and owner must have visibility access to the business unit code, and the business unit code must have visibility to the job posting legal entity.

If the entered business unit code is not associated with either the creator or the owner, the system displays an error message.

If the entered business unit code does not have visibility to the job posting legal entity, the system displays an error message.

If field is left blank, the value is defaulted to the job posting owner's business unit.

Site Code

Text

100

Yes

Valid SAP Fieldglass Site Code

The code of the site in which this job posting is located. The site code aids suppliers in knowing where the work occurs, so that appropriate candidates within that locale are submitted. This field also assists suppliers in determining which supplier account manager fulfills the job posting.

The job posting owner must have access to this site in order to create the job posting.

Site codes must be defined in the SAP Fieldglass application.

When the buyer is using the Users have access to all Business Unit/Cost Centers and Sites configuration, the site is automatically associated to the job posting owner and all those users who can act as a coordinator on upload.

If 'Enhanced Legal Entity Validation' configuration is enabled for the Company, the creator and owner must have visibility access to the site code and the site code must have visibility to the job posting legal entity.

If the site code is not associated with either the creator or the owner, the system displays an error message.

If the site code does not have visibility to the job posting legal entity, the system displays an error message.

Purchase Unit

Text

100

Conditional

Valid Purchase Unit Code

Purchase Unit associated to the Job Posting.

Location Code

Text

100

Yes

Valid SAP Fieldglass Location Code(s)

Example:

  • loc1~loc2~loc3

The code of the location in which this job posting is located. The location code aids suppliers in knowing where the work occurs, so that appropriate candidates within that locale are submitted.

Location codes must be defined in the SAP Fieldglass application.

Multiple codes are separated by a tilde (~) when at least one sub-configuration for company configuration Use multiple locations is enabled.

Primary Location Code

Text

100

Conditional

Valid SAP Fieldglass location code

Indicates primary location code

Enable at least one sub-configuration for the company configuration Use multiple locations.

If the selected primary location isn't listed in the 'Location Code' column, the application displays an error message.

If the 'Primary Location Code' column is blank for records with multiple locations or even a single location, the application displays an error message.

Start Date

Date

Yes

Example:

  • 01/01/2013

Date on which the contract begins.

End Date

Date

Yes

Example:

  • 01/31/2013

Date on which the contract ends.

Owner Username

Text

100

Yes

Valid SAP Fieldglass Username

The SAP Fieldglass username of the individual who owns this specific job posting. The owner receives notifications and work items about the job posting. This username must be defined in the SAP Fieldglass application.

If the Enhanced Legal Entity Validation configuration is enabled for the company, the system validates if the owner has visibility to the job posting legal entity, business unit, cost center, and site codes. If even one of these is not associated to the owner, the system displays an error message.

Coordinator Username

Text

100

Conditional

This is only a required value for buyers utilizing MSP services within SAP Fieldglass

Valid SAP Fieldglass Coordinator Username

The SAP Fieldglass username of the individual who coordinates this specific job posting. The coordinator can be responsible for defining and reviewing a job posting, as well as on-boarding activities, such as setting up security badges for new employees. Typically, the coordinator is assigned to the buyer’s MSP.

The Coordinator Username must be defined in the SAP Fieldglass application. Leave the Coordinator Username blank if no coordinator exists.

If the Enhanced Legal Entity Validation configuration is enabled for the company, the system validates if the coordinator username has access to the job posting business unit and legal entity and has the 'Coordinator' user profile flag enabled. If not, the system displays an error message.

Distributor Username

Text

100

No

Valid job posting distributor username.

Sets distributor on the job posting if Distribution Type is 'Distributor selects Suppliers before any approvals or Distributor selects Suppliers after final approval'.

If the Enhanced Legal Entity Validation configuration is enabled for the company, the system validates if the distributor username has access to the job posting business unit and the legal entity and has the 'Distributor' user profile flag enabled. If not, the system displays an error message.

Cost Center Code

Text

200

Yes

Valid Cost Center Code

The code of the cost center to which this job posting is assigned. The cost center code typically identifies to what cost center (or total estimated budget) this job posting applies, and is used for accounting purposes.

Cost center codes must be defined in the SAP Fieldglass application. The job posting owner must have access to this cost center in order to create the job posting.

The cost center code is not directly related to the business unit or the site.

When buyer is using the Users have access to all Business Unit/Cost Centers and Sites configuration, the cost center is automatically associated to job posting owner and all those users who can act as coordinator on upload.

If the Enhanced Legal Entity Validation configuration is enabled for the company, the creator and owner must have visibility access to the cost center code and the cost center code must have visibility to the job posting legal entity.

If the cost center code is not associated with either the creator or the owner, the system displays an error message.

If entered cost center code does not have visibility to the job posting legal entity, the system displays an error message.

If entered cost center code is inactive, the system displays an error message.

General Ledger Account Name

Text

100

This is dependent upon the company configuration and is required if the company has General Ledger account functionality enabled.

General Ledger Account Name

General Ledger (G/L) accounts created in the SAP Fieldglass system. 

This field is mutually exclusive with Segmented Object Detail field.

When the Allows Unknown Cost Center Validation and GLA allocation on Job Postings and Statements of Work is required company configurations are enabled, the software supports unknown cost center functionality. It also suppresses SOD or GLA allocation for unknown cost centers.

Segmented Object Detail

Text

2000

Conditional

Examples:

  • IS|Admin|12001

  • IS-Admin-12001

  • IS;Admin;12001

  • IS:Admin:12001

Multiple accounting strings that can be assigned to a worker.

Segments are separated by delimiter on the segmented object. Valid delimiters are colon (:), semi-colon (;), pipe (|) and dash (-).

Required if 'Segmented object detail' set.

If the buyer company has Segmented object detail based allocation is required company configuration enabled, then the field must be associated to a Pick List which has the first segment as Active Legal Entity.

This field is mutually exclusive with GL Account fields.

When the Allows Unknown Cost Center Validation and Segmented object detail based allocation is required company configurations are enabled for Contingent cost centers, the software supports unknown cost center functionality. It also suppresses SOD or GLA allocation for unknown cost centers.

Estimated Expense %

Decimal

No

Example:

  • 1.25

The estimated expense percentage of the total estimated cost for this job posting. Example: 1.25% should be entered as 1.25, not .0125.

Estimated Additional Spend %

Decimal

No

Example:

  • 1.25

Percentage of the total number of hours per week. This is used by SAP Fieldglass to calculate the total estimated cost for this job posting. Example: 1.25% should be entered as 1.25 not .0125.

Job Seeker Rate can be increased

Text

3

Yes

Valid values are:

  • Yes

  • No

This field indicates whether the bill rate can be increased in the work order.

If this field is set to No, the bill rate that is presented in the job seeker must be less than or equal to the bill rate presented in the job. The Job Seeker Bill Rate cannot be greater than the Job Posting Bill Rate.

If this field is set to Yes, then the bill rate that is presented in the job seeker can be greater than the bill rate presented in the job posting.

If company configuration Enable Rates 2.0 is enabled, this rule no longer controls whether the user can enter zero because that is now controlled by the job posting template rule 'Creator can edit Rate values on Job Posting'.

Allow Job Seeker Submissions Below Minimum Requested Pay Rate

Text

3

No

Valid values are:

  • Yes

  • No

You can view this column only if Enable Rates 2.0 is on and Service Type is Temp.

When enabled, this rule allows suppliers to submit job seekers below the minimum requested pay rate. This rule applies only to rates that use a pay-rate based rate component group.

If left blank, this field borrows the value set on this rule on your job posting template.

If you have locked or hidden the rule Allow Job Seeker Submissions Below Minimum Requested Pay Rate on the contingent type, then any value you enter here will be ignored.

Allow Deductions to be Submitted on Time Sheet

Text

3

Conditional

Valid values are:

  • Yes

  • No

Determines whether the workers can submit deductions on their time sheets

Company configuration Deduction must be enabled.

This field defaults to the value from the job posting template if company configuration Deduction is locked or in case of company configuration is not locked and this field is left blank.

Respond by Date

Date

No

Example:

  • 01/15/2013

The respond by date identifies the time in which the suppliers must respond to the job posting with job seekers.

If this field is null/blank, the Job Posting Start Date is taken as the Respond by Date.

Hours per Week

Decimal

Yes, if Hours per Week value is not defined for the site or in the buyer’s company configuration.

Example:

  • 40

The standard number of hours per week for this position on this job posting.

This is required if the Hours per Week value is not defined for the site or in the buyer’s company configuration.

Days for Estimated Spend

Decimal

Conditional, if Job Posting Template rule Hours/Days for Committed Spend is set to ‘Creator enters’ AND committed spend rate UOM is set to ‘Days’

Example:

  • 8

Indicates days per estimated spend.

Hours for Estimated Spend

Decimal

Conditional, if Job Posting Template rule Hours/Days for Committed Spend is set to ‘Creator enters’ AND committed spend rate UOM is set to ‘Days’.

Example:

  • 8

Indicates hours per estimated spend.

Is Named Job Posting?

Text

5

No

Valid values are:

  • Yes

  • True

  • No

  • False

Indicates if job posting has a named worker associated with it.

If field is left blank, it defaults to No.

Workforce ID

Text

16

Conditional

Valid SAP Fieldglass Worker ID

Example:

  • xxxxWF00000012

Indicates worker named to job posting.

Required if Is Named Job Posting? is set to Yes or True.

Hours per Day

Decimal

Yes

Example:

  • 8

The standard number of hours per day for this position on this job posting.

Travel Time

Decimal

No

Example:

1.25% should be entered as 1.25, not .0125.

The percentage of travel required for this position on this job posting.

Maximum Submission

Number

No

Example:

  • 10

The number of job seekers a supplier can submit against this particular job posting.

If left blank, each supplier may submit an unlimited number of job seekers in response to the job posting.

Flat Adjustment

Number

No

Example:

  • 99

  • -99

Flat adjustment amount applied to the job posting estimated spend.

Flat adjustment value can be positive or negative. Users can enter the value for flat adjustment from -99999999 to 999999999.

Comments

Text

2000

No

Any comments added to this job posting.

Address 1

Text

600

No

Example:

  • 123 West St

Address of work location.

Address 2

Text

600

No

Example:

  • Suite 2400

Address of work location.

City

Text

50

No

Example:

  • Chicago

City of work location.

State/ Province

Text

50

No

Example:

  • IL

State/province of work location.

Country/Region

Text

3

No

Example:

  • USA

  • CAN

Country/region of work location.

ZIP/Postal Code

Text

20

No

Example:

  • 60062

Postal code of work location.

Site Tax

Decimal

No

Example:

  • 1.25

Percentage of site tax for work location. Example: 1.25% should be entered as 1.25, not .0125.

Suppliers

Text

10000

No

Valid Supplier Code or Codes

 

Examples:

  • ABC~A124~SUP1

  • [ALL]

Use this field to control supplier distribution of job postings. Only valid supplier codes from the template distribution list can be used. If code is specified as [ALL], then all suppliers in the template distribution list receive the job posting. Codes should be delimited by “~”.

The field values are dependent upon the distribution rule on the job posting template.

Time Sheet Type

Text

16

No

Valid values are:

  • Standard (or Hourly)

  • Time-In/Time-Out

  • No Time Sheets

This flag indicates how time and expenses should be recorded for workers.  

Enable CATS Time Sheet

Text

3

Conditional

Valid values are:

  • Yes

  • No

Indicates if CATS time sheets are used.

Applicable only for Time sheet type ‘Standard’ / ‘Hourly’.

Company configuration ‘Rate schedule’ must be enabled.

If locked on Job Posting Template, entry is ignored.

Time Sheet Frequency

Text

16

Yes, for Adds only

Valid values are:

  • Weekly

  • Biweekly or Bi-Weekly

  • Semimonthly

  • Monthly

  • 8 Day Time Sheet

Indicates how often time sheets are generated.

Allowed values for time sheet frequency depends on the company configuration and locked value if any.

Start Day of Week

Text

9

No

Valid values are:

  • Sunday

  • Monday

  • Tuesday

  • Wednesday

  • Thursday

  • Friday

  • Saturday

Start day of the time sheet if Time Sheet Frequency is Biweekly, Bi-Weekly, or Monthly.

These can be entered if the Start Day value is not locked.

Adjustment Group

Text

100

Conditional

Valid SAP Fieldglass Adjustment Group Code

or

Blank

Sets an adjustment group for a job posting.

If job posting template flag Creator can change adjustment group = Yes, changes can be made to the adjustment group via this upload.

Company configuration Adjustment groups must be enabled.

When Job Posting is distributed to Suppliers, use Rate values from

Text

100

Conditional

Valid values are:

  • Supplier Distribution Lookups

  • Rates Lookup

  • Job Posting

Identifies the rate value when job postings are distributed to suppliers.

Company configuration Rates 2.0 must be enabled.

In order to choose anything but Supplier Distribution Lookups, the user must have these Job Posting permissions:

Financial

View Rates During Creation

AND

Job Posting Template must have enabled 'Creator can edit Rate values on Job Posting' in order for the 'Job Posting' value to be accepted.

If this field is left blank and if Contingent Type is not locked, this field defaults to:

  • Supplier Distribution Lookups when 'On Job Posting, calculate Estimated Spend using' configuration is set to 'Estimated Spend values from lookups'.

  • Rates Lookup when 'On Job Posting, calculate Estimated Spend using' configuration is NOT set to 'Estimated Spend values from lookups'.

If Contingent Type has locked the field, it sets to the selection from the Contingent Type.

Job Posting is a valid entry when the Job Posting Template has enabled 'Creator can edit Rate values on Job Posting'.

Refresh rate components from lookup

Text

100

No

Valid values are
  • Yes

  • No

If left blank, the value from the Contingent Type is picked.

Company configuration Enable Rates 2.0 must be enabled in order to view/use this.

You must have the following Job Posting permissions:
  • Financial: View Rates During Creation

  • When Job Posting is distributed to Suppliers, use Rate values from is set to Job Posting

Rate Schedule Code

Text

100

Conditional

Valid Rate Schedule Code

Sets the rate schedule on the job posting.

Company configuration 'Rate schedule' must be enabled and 'Can Change Rate' rule is enabled on the job posting.

Legal Entity

Text

100

Conditional

Valid SAP Fieldglass Legal Entity

Legal Entity code associated to job posting.

Company configuration Use legal entity must be turned on for Contingent.

If the Enhanced Legal Entity Validation configuration is enabled for the company, the creator and owner must have visibility access to the Legal Entity Code. If the entered Legal Entity code is not associated with either the creator or the owner, the system displays an error message.

If the legal entity entered in the Legal Entity field is not associated to the job posting template, the system displays an error message.

Default Shift Schedule

Text

100

Conditional

Valid SAP Fieldglass Shift Codes

Indicates default shift schedule. Company configuration Enable Shift Manager must be enabled.

Disallow Approval of Time Sheet/Expense Sheet/Invoice when Job Posting Estimated Spend is exceeded

Text

3

Conditional

Valid values are:

  • Yes

  • No

This field indicates whether the approval of time sheet, expense sheets, and invoices are disallowed when the job posting estimated spend is exceeded when Shift Manager is enabled.

The value in this column is ignored and defaults to what is on the template if the field was locked during creation on the job posting template ID.

Company configuration Enable Shift Manager must be enabled.

Is this a Rebillable Resource?

Text

3

No

Valid values are:

  • Yes

  • No

Allows job posting to be flagged to enable the rebillable resource.

Rebillable Margin

Decimal

Conditional

Example:

  • 20

  • 1.25

This field reflects the numerical value of the re-billable markup percentage.

All values entered are in percentage. For example, 1.25% should be entered as 1.25, not .0125.

If the field Is this a Rebillable Resource? is Yes, the percent value is accepted.

Project code

Text

100

No

Valid project code created in SAP Fieldglass that is active.

Project code associated to the job posting. Used to set the currency conversion factor on the job posting while creating a job posting from a project.

Comparator Rate

Decimal

Conditional

Example:

  • 20

  • 1.25

Comparator rate indicates what a permanent worker's equivalent rate would be. All values are in percentage. For example, 1.25% should be entered as 1.25, not .0125.

Company configuration 'Germany Rate Automation' must be enabled. The Collective Bargaining Agreement (CBA) rate change flag must also be enabled on the business unit of the job posting.

If company configuration 'Rates 2.0' is enabled, this field is ignored.

Parity Management Type

Text

100

Dependent on site configuration.

Valid Parity Management Type

United Kingdom (UK) pay parity type.

If parent and all children configurations are enabled, the Parity Management Type is taken from user selection.

If parent and only one child configuration is enabled, the child configuration value defaults as Job Posting Parity Management Type.

Company configuration Manage Pay Parity must be enabled. This is the only configuration necessary for the parent company. For a child company, configurations Manage Parity via Automated Milestones and Manage Parity via Automated Status Change can be enabled.

If company configuration Rates 2.0 is enabled, this field is ignored.

Allow Suppliers and Workers to Edit CATS Time Information?

Text

3

Conditional

Valid values are:

  • Yes

  • No

Indicates if suppliers or workers can edit other workers' CATS time sheet information.

The time sheet must be in draft or rejected status to be edited.

Job Posting Template rule 'Enable SAP CATS Time Sheet' must = Yes. If rule locked on Job Posting Template, this field can not be changed.

If this field is blank or missing, the default value is No.

[c] Job Posting Custom Field 1

Dependent on custom field configuration

No

Dependent on Custom Field type.

Any custom field associated with a job posting. The custom field name should be prefixed with ‘[c]’.

For example, custom field name: ‘Job Posting Custom Field 1’ will be ‘[c] Job Posting Custom Field 1’.

Valid values of the custom field are configured during the setup of the SAP Fieldglass application.

When Custom Field Type = Segmented Pick List and the 'Autopopulate Segment' rule on the Pick List = Yes, if a segment value is left blank on the upload, the value is auto populated on the document if there is only one possible value based on the previous segment values. If there is more than one possible value, an error message displays.

Do not include this field if not in use.

[Min] Rate Category/ Rate UOM

Decimal

No

Example:

[Min] OT/Hr

11.25

Minimum requested rate for the job posting.

If the rate is a factor, enter the factor in this field. (For example, if 1.25%, then enter 1.25.). This is not applicable for Rates 2.0.

If the rate is a calculated rate, enter the word Calculated.

If field left blank, rate is taken from job posting template.

If company configuration Rates 2.0 is enabled, the system runs the rate lookups then the system validates the entry in the upload against the default value to determine whether the entered value is acceptable. If the entered value does not pass validations, the system creates an error. Also see Assumption section for additional Rates 2.0 information.

[Max] Rate Category/ Rate UOM

Decimal

No

Example:

[Max] OT/Hr

15.25

Maximum requested rate for the Job Posting.

If the rate is a factor, enter the factor in this field. (For example, if 1.25%, enter 1.25.)

If the rate is a calculated rate, enter the word Calculated.

If this field left blank, rate is taken from job posting template.

If company configuration Rates 2.0 is enabled, the system runs the rate lookups then the system validates the entry in the upload against the default value to determine whether the entered value is acceptable. If the entered value does not pass validations, the system creates an error. Also see Assumption section for additional Rates 2.0 information.

[RC] Rate Category/UOM

Text

100

No

Valid SAP Fieldglass Rate Code

Example:

[RC] ST/Hr

B1

To change a rate code or to add a new rate, this header must be manually added.

If a new rate code is provided for an existing rate category and UOM combination, then the existing rate code is replaced with this new value.

[Committed Spend Flag] RateCategory/UOM

Text

3

No

Valid values are:

  • Yes

  • No

Sets ‘Use in committed spend calculation’ flag value on the newly added rates or can be used to change the value on rates carried from the job template.

If company configuration Rates 2.0 is enabled, the system ignores this field if the rate that it applies to is a Calculated Rate with Calculation Type = Rate Rule, and the rate is not flagged to be included in spend.

[min] [pr] Rate Category/Interval

Decimal

No

Example:

  • 1.25

Time Sheet Allotment Min Pay Rate.

If company configuration Rates 2.0 is enabled, this field is ignored.

[max] [pr] Rate Category/Interval

Decimal

No

Example:

  • 2.25

Time Sheet Allotment Max Pay Rate.

If company configuration Rates 2.0 is enabled, this field is ignored.

[min] [br] Rate Category/Interval

Decimal

No

Example:

  • 1.25

Time Sheet Allotment Min Bill Rate.

If company configuration Rates 2.0 is enabled, this field is ignored.

[max] [br] Rate Category/Interval

Decimal No

Example:

  • 2.25

Time Sheet Allotment Max Bill Rate.

If company configuration Rates 2.0 is enabled, this field is ignored.

[drc] Rate Category/ Rate UOM

Decimal

No

Example:

[drc] OT2/Hr

Weekend_factor

Removes an existing rate code on the job posting.

[factor] Rate Category/ Rate UOM

Decimal

Conditional

Example:

[factor] OT/HR

1.125

Rate factor. Minimum Value = 0.001, Maximum Value = 1000.

Company configuration Rates 2.0 must be enabled.

If the rate does not use a factor, the system ignores any value you enter in this column for that row. If the rate uses a factor and you customize the column with a specific rate category or rate unit of measure, make sure the column name matches a valid factor-based calculated rate on the job posting template. If the column name does not match a valid rate or is not valid for the rate code you are adding, the system displays an error.

Unique Identifier

  • External Job Posting ID field

Configuration Considerations

#

Item

Notes

1

External Job Posting ID

A consistent format should be used for the values populated in the External Job Posting ID field. As the actual Job Posting ID is generated by SAP Fieldglass, the External Job Posting ID is referenced in related uploads of job seekers and work orders related to this Job Posting. As such, it is often a good idea to apply a counter to the end of the ID and increment it by some constant number for each new row.

By applying this consistent counter, you should be able to upload job seekers and worker orders through their respective connectors in the same order, at a later time and with greater ease.

2

Approval Required?

If marked as False, job postings are created without any approvals. If marked as True, the appropriate approval group is triggered for approval of the job postings.

3

Send Notifications?

If False, normal notifications related to the creation, submission, and distribution of job postings do not occur.

4

Business Unit Code

Site Code

Cost Center Code

If legal entity functionality is enabled and utilized by a client, then specific validations are performed against these core values on the upload, and if these values do not match the required validation, then this can cause an error in the upload. Buyers using legal entity need to ensure that their specific validation setups are reflected in their upload values.

Assumptions/Tips

  • SAP Fieldglass automatically assigns each job posting with an application-generated identifier. Example: xxxxJP00000001. Further access to the Job Posting can be done via this application-generated identifier or the External Job Posting ID (if supplied).

  • For Rate schedules, if Capture Time Worked on Time Sheet is not enabled and Time Sheet Type = Time In/Time Out, an error is created.

  • Estimated spend and total per worker are automatically rounded to whole numbers but displayed to two decimal points if currency is Yen.

  • Named Job posting defaults the distribution type to 'Auto' (Irrespective of Job Posting Template distribution type). A Named Job Posting’s Distribution List should be 'NA' and the distributed supplier should be the workforce supplier. Otherwise an error is displayed.

  • If the Time Sheet Allotment is Mandatory, and the upload file does not contain [pr] or [br] values, the system pulls these values from the Job Posting Template. If the Job Posting Template allows removal of Time Sheet Allotments, blank values in the upload file do not remove Mandatory Time Sheet Allotments.

  • For user entered amounts, a validation has to happen on the upload to ensure that the amount entered is a whole number for those currencies where precision is supposed to be zero decimals.

  • When the company configuration Distribution selected by distributor before approval is enabled along with the sub-configuration Submit JP to Suppliers before any approvals (Editor selects Suppliers in Program Office Assisted Workflow), the distribution logic sends job postings to Level 1 suppliers at job posting submit, then sends to remaining distribution levels based on the distribution times specified in their job posting distribution list (job posting no longer needs to be approved to send to remaining distribution levels).

  • If Currency is specified as blank and the site provided has a single currency, then that site currency is used, else if site has multiple currencies, an error is displayed.

  • If the company uses multiple MSPs and a general buyer user is uploading the file, all mandatory custom fields for all MSPs must be in the file.

  • This connector considers the Corporate Calendar for spend calculation when the company configuration Spend calculation is based on corporate calendar is turned on.

  • Buyers are not allowed to create a named Job Posting for a Workforce record that has been removed by them.

  • If the Job Posting Template flag 'Use Spend Matrix to determine Cost Allocation structure and budget validation' is enabled, Adjustment groups added in this upload are ignored.

  • 8 day time sheets cannot be selected as a Time Sheet Frequency when the Enable SAP CATS time sheets job posting template flag is enabled.

  • For Rates 2.0

    • If a user wants to add or replace a rate from the job posting template, user must add the '[rc] Rate Category/UOM' column for the rate and enter the desired Rate Code. If the user decides not to enter values for [Min] and [Max], the system relies on the lookups to derive these values.

    • If a user wants to add Factor rate and specify a value, the user must add both the '[rc] Rate Category/UOM' column for the rate AND the '[factor] Rate Category/ Rate UOM' column. If a user wants to add Factor rate but pull Factor value from lookups, the user only needs to add the '[rc] Rate Category/UOM' column to add the rate's code.

    • The [factor] field can be edited when the Rate field 'Allow Rate Factor edits by' has 'Supplier' enabled AND either the 'Auto Engage Job Seeker' is disabled OR the 'Auto Engage Job Seeker' is enabled + 'Allow Supplier to Edit Rate' is enabled. OTHERWISE the [factor] field cannot be edited.

    • The system runs rate lookups if there is no [factor] field for a rate that uses a factor.

    • Values for supplier distribution are determined as follows:

      • If 'When Job Posting is distributed to Suppliers, use Rate values from = Job Posting', all suppliers receive the job posting's rates.

      • If 'When Job Posting is distributed to Suppliers, use Rate values from = Supplier Distribution Lookups', suppliers receive rates according to what was brought back from the Supplier Distribution Lookups.

    • For Calculated Rates with Calculated Type = Rate Rule:

      • The user no longer needs to enter 'Calculated' in both of these columns for the rate:

        • [min] <Rate Category>/<UOM or Unit Type>

        • [max] <Rate Category>/<UOM or Unit Type>

      • Instead, the system looks at the job posting template to determine whether any of these Calculated Rates need to be picked up when the job posting is uploaded.

        • If the user has used the '[rc] Rate Category/UOM' column to replace a Rate Code from the job posting template, that new Rate Code is used.

        • The user can also use the '[rc] Rate Category/UOM' column to add a new Rate Code of this rate type.

      • When the uploaded job posting is submitted (header flag Submit = True),

        • The rate's Rate Rule processes when 'Use Rule to Calculate Rate At' = 'Job Posting' or 'Job Posting through Work Order Revision'

        • Rate values are calculated using the same logic as the UI. Any applicable errors from the UI apply here too

        • The rate's Rate Rule is not calculated when 'Use Rule to Calculate Rate At' is set to another setting. (In this situation, rates of this type display as 'Calculated' in the UI once the job posting is uploaded.)

      • When the uploaded job posting is not submitted (header flag Submit = False), no Rate Rules process, since the job posting is saved as a Draft. (Thus, all rates of this type display as 'Calculated' in the UI once the job posting is uploaded.)

  • Regarding leading and dependent custom fields:

    • When leading and dependent custom fields have been set up and a buyer downloads a blank upload template for this connector from the user interface, leading and dependent custom fields are automatically added as individual columns.

    • The system reads the value of the leading custom field and validates the first dependent custom field. This process continues for all dependent custom fields in the defined sequence until it is completed.