Using several ratings from Performance forms in Compensation

[xavierlegarrec]

Introduction

In Compensation templates there is only one standard column called "pmRating" that can automatically retrieve a rating from Performance forms or Employee Profile or custom objects to use it in standard guideline tables.

 

We can feed this one and only Rating column from different performance forms (in case there are different performance review templates for different group of employees for example) but it always results in one and only rating value.

 

We can also use up to 3 custom columns from our Compensation template as attributes of standard guidelines.

 

How to use 2+ performance ratings in standard Compensation guidelines (or simply display 2+ ratings on Compensation worksheets).

In the 20 minutes recording below we solution the complex requirement of using the objcomp matrix placement from Performance forms in Compensation guidelines with the following design:

1. Two different scheduled Integration center (API) jobs send Objective and Competency ratings from the sysOverall standard portlets of Employee Profile (which are natively integrated with Performance forms to store ratings) to an effective dated MDF custom object.

1. The ratings are then mapped to 2 custom columns of the Compensation template and as a consequence become available to be used in Guidelines.

The design in the recording actually goes even further than just retrieving two ratings into a custom object: it also has on Save business rule with a built-in formula to merge both ratings into only one (in a third field) to help bring down the number of records in the Compensation guideline table.

Things to keep in mind when building a design like this.

• There is a 50 million records limit for all custom MDF objects together in any SuccessFactors environment which means that in some cases for large customers wanting to retrieve more than 2 ratings into the Compensation template (for example 2 ratings in each Performance form and multiple performance forms per employee each year) it is better to build this design using a non-effective dated object as per the screenshot here.

• In the recording below I mention it is not possible to build this design without having completed performance forms but this is actually not correct as we found out later after additional research. There is a checkbox in Provisioning > Company settings called "Show in-progress form ratings in live profile" that needs to be checked for Performance ratings to flow to the sysOverall portlets even though forms aren't completed yet.

• It is also possible to query Performance Ratings from Performance Forms through Odata API but it requires advanced skills (not your basic Integration Center API) as explained in this blog : https://community.sap.com/t5/human-capital-management-blogs-by-sap/performance-management-and-api-ho...

 

This recording was made for a customer (name not mentioned) using my demo environment data.

https://youtu.be/MuCQNP9nP-U

 

Additional links in connection with this topic (either functionally or technically with demos of MDF or Integration Center for other business cases) :

• How to use Performance Ratings in Compensation Eligibility Rules

• Integration Center demo for the Compensation module

• Off Cycle Increases through MDF objects in Employee Central

• Managing employees rehired during the same fiscal year than Termination in Variable Pay

• How to filter on several Line Manager or HR Manager names in Compensation Executive Review

 

All the best,

Xavier

 

 

[swagatikapanda]

Great post @xavierlegarrec .

I am current working on a similar scenario and need your guidance. Below is the case:

I am publishing a custom rating field from Comp worksheet to a string field (let us call as LTI rating) in custom MDF object - This is all fine.

Post publish, I want the rating to flow from MDF to the standard SysOverallCompetency background element. Below is the IC job screenshot.

Issues:

1. I can't see the Label field in SysOverallCompetency API within IC, which actually holds the rating value. What could be the reason? I see label on Employee Profile UI.

2. I mapped the LTI rating field from MDF to Name field from SysOverallCompetency, after running the job error is thrown that Data type mismatch for rating field. 

Any idea how to fix it?

Many thanks,

Swagatika

[swagatikapanda]

Hi @xavierlegarrec 

Any thoughts on the above topic?

Thanks,

Swagatika