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.
File Formatting
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.
-
Errors
The following errors can occur when processing this upload file:
|
Error Message |
Resolution |
|---|---|
|
Business Unit is not associated to the specified Job Template. |
The Business Unit Code value does not belong to the selected Job Posting Template. Verify the Business Unit Code column value matches a business unit associated with the template. |
|
Cost Center Code missing |
Cost Center Code is required. Enter a valid cost center code in the Cost Center Code column. |
|
Cost Center Code invalid |
The cost center code entered does not exist or is not active. Verify the Cost Center Code column value matches an active cost center record. |
|
Creator Username invalid |
The provided user does not exist in the system or belongs to a different company. Verify that the Creator Username column value is a valid, active user login. |
|
Creator Username missing |
Creator Username is required. Enter the username of the person responsible for creating the job posting in the Creator Username column. |
|
Currency invalid |
The currency value does not match any currency supported by the selected site. Enter a currency code in the Currency column that is configured for the site. |
|
Date Format invalid |
The date format in the file header is not a recognized format. Correct the Date Format header value to a valid format (for example, MM/DD/YYYY). |
|
Days for Estimated Spend invalid |
The value entered in the Days for Estimated Spend column is not a valid number. Enter a numeric value greater than zero in the Days for Estimated Spend column. |
|
Days for Estimated Spend missing |
Days for Estimated Spend is required when the Job Posting Template rate unit is Daily. Enter a positive numeric value in the Days for Estimated Spend column. |
|
Days for Estimated Spend - rate UOM not compatible |
The rate's UOM for the Job Posting is not compatible with the Days for Estimated Spend field. Remove the Days for Estimated Spend value or change the rate unit to match the template configuration. |
|
End Date invalid |
The End Date value cannot be parsed using the date format specified in the file header. Correct the End Date column value to match the required format. |
|
End Date missing |
End Date is required for non-hire job postings. Enter a valid end date in the End Date column. |
|
External Job Posting ID missing |
External Job Posting ID is required. Insert the external identifier code in the External Job Posting ID column, or populate the Ignore External ID column to bypass this requirement. |
|
External Job Posting ID - already in use |
The external ID provided belongs to a job posting that has already been submitted (non-draft). Use a different External Job Posting ID or update the existing draft posting instead. |
|
General Ledger Account Name invalid |
The GL account name entered does not match an active GL account. Verify the General Ledger Account Name column value matches a GL account configured for the cost center. |
|
General Ledger Account Name missing |
General Ledger Account Name is required when GL allocation is enabled. Enter a valid GL account name in the General Ledger Account Name column. |
|
Hours for Estimated Spend invalid |
The value entered in the Hours for Estimated Spend column is not a valid number. Enter a numeric value greater than zero in the Hours for Estimated Spend column. |
|
Hours for Estimated Spend missing |
Hours for Estimated Spend is required when the Job Posting Template rate unit is Hourly. Enter a positive numeric value in the Hours for Estimated Spend column. |
|
Hours for Estimated Spend - rate UOM not compatible |
The rate's UOM for the Job Posting is not compatible with the Hours for Estimated Spend field. Remove the Hours for Estimated Spend value or change the rate unit to match the template configuration. |
|
Job Posting can not be created from selected Job Posting Template as it is not associated to any MSP Company. |
The selected Template Name does not have an MSP company assigned. Select a job posting template that is associated with an MSP company, or contact your administrator. |
|
Job Posting has Site with different currencies. |
The currency entered is not supported by the selected site. Verify the Currency column value matches a currency configured for the site in the Site Code column. |
|
Job Posting Owner is not associated with the Business Unit specified in this file. |
The owner does not have visibility to the business unit. Verify that the Owner Username has access to the business unit entered in the Business Unit Code column, or select a different owner or business unit. |
|
Job Posting Owner is not associated with the Cost Center specified in this file. |
The owner does not have visibility to the cost center. Verify that the Owner Username has access to the cost center entered in the Cost Center Code column, or select a different owner or cost center. |
|
Job Posting Site has multiple currencies. Please select currency. |
The selected site supports more than one currency and no currency was specified. Enter a valid currency code in the Currency column. |
|
Location Code invalid |
The work location code entered does not exist or does not belong to the selected site. Verify the Location Code column value matches an active work location associated with the site. |
|
Location Code missing |
Location Code is required when multiple work locations exist for the selected site. Enter a valid location code in the Location Code column. |
|
Location specified in the file is invalid. |
The work location entered is not associated with the site selected for this job posting. Verify the Location Code column value matches a work location configured for the site. |
|
Invalid MSP for {0}. MSP of {0} does not match the MSP of the template. |
The Owner Username or Creator Username belongs to an MSP user whose MSP code does not match the job posting template's MSP code. Use an owner or creator associated with the correct MSP company. |
|
Multiple Cost Centers found. |
The cost center code in the Cost Center Code column matches more than one record. Use a more specific cost center code that uniquely identifies a single cost center. |
|
New Rate Code cannot be added because the rule 'Creator can add and remove Rate Codes or Rate Schedules' is not enabled on the Job Template. |
The [RC] rate code column value was populated, but the Job Posting Template does not allow adding rate codes. Remove the [RC] columns from the file, or ask an administrator to enable the allow rate code change rule on the template. |
|
Owner Username invalid |
The owner's username does not exist in the system or is not active. Verify that the Owner Username column value is a valid, active user login in the same company. |
|
Owner Username missing |
Owner Username is required. Enter the username of the job posting owner in the Owner Username column. |
|
Please enter a positive value for {0}. |
The committed spend value entered is zero or negative. Enter a positive number in the Hours for Estimated Spend or Days for Estimated Spend column. |
|
Rate Code cannot be deleted since the rule 'Creator can add and remove Rate Codes or Rate Schedules' is not enabled on Job Template. |
The [DRC] rate code column value was populated, but the Job Posting Template does not allow removing rate codes. Remove the [DRC] columns from the file, or ask an administrator to enable the allow rate code change rule on the template. |
|
Selected Cost Center {0} is Inactive. Please select another Cost Center. |
The cost center entered is inactive. Replace the value in the Cost Center Code column with an active cost center code. |
|
Site Code invalid |
The site code entered does not exist or is not active. Verify the Site Code column value matches an active site record. |
|
Site Code missing |
Site Code is required. Enter a valid site code in the Site Code column. |
|
Site {0} is not selectable. |
The site entered is configured as non-selectable. Select a site that has the Selectable flag enabled, or contact your administrator. |
|
Template ID missing |
Template Name or Template ID is required. Enter a valid template name in the Template Name column or a valid template ID in the Template ID column. |
|
Template Name invalid |
The specified template does not exist or cannot be used with the selected cost center. Verify the Template Name column value matches a selectable job posting template available for the cost center. |
|
The Job Posting Template has CATS Time Sheet flag enabled. However, the Site does not use Time Sheet Type: Standard. Select a new Site or contact your System Administrator for assistance. |
The site selected does not support CATS time sheets, which are required by the Job Posting Template. Enter a site that has Time Sheet Type: Standard enabled in the Site Code column, or contact your System Administrator. |
|
Users with the Configuration Manager role cannot be selected. |
The username entered in the Creator Username or Owner Username column belongs to a user with the Configuration Manager role. Enter a username for a user with a different role. |
|
An 8 day Time Sheet frequency is not permitted with rate Schedules. |
The Job Posting Template has 8 Day Time Sheet frequency selected, but Rate Schedules are also enabled on the template. These two settings are incompatible. Remove the Rate Schedule from the Job Posting Template, or change the Time Sheet Frequency to a value compatible with Rate Schedules before uploading. |