Automating Training Assignments Using Integer Custom Fields

Background

For years, customers requested enhancements to assign training dynamically after hire or after completing another item. Below are some key requests:

Enhancement Requests

• Allow training to be assigned X days after hire date
• Automatic assignment after X days of completing Item A
• Assign training via Assignment Profile X days after hire date

New Feature in 2H 2025

SAP introduced Integer and Decimal data types for custom fields in the User entity. This enables operators like Less Than or Equal To, Greater Than or Equal To, and Between for numeric criteria in Assignment Profiles.

Though this is not a perfect solution but we can utilize for our requirement.

Step-by-Step Implementation

We will walk through an example: Assign onboarding course 15 days after joining for hires after 1st Jan 2025.

Configuration in LMS

Creating References

• Create custom fields: Navigate to Learning Administration > System Administration > Custom Fields > User. Select data type as Integer and assign a unique field number (e.g., 170).
• Add new and you can select "data type" as Integer
• For field number you can put any number except standard custom field numbers(10,20...150)
• In this example I have used 170 ,you can enter any number you like.
  
  

nishadsthakur_0-1763101610251.png

Creating Integer Custom Field

Adding Configuration

• Once created, you need to add the reference in connector configuration file so that your user connector will pick it up
• To do that go to Learning Administration>System Administration>Configuration >System Configuration
  in this select Connector and add following line at bottom

Sample file

Sfuser.field.customcolumn.<your_column_number>=<your_column_name_in_connector_file>

For example I have created 2 columns below

#No of Years after hiring
Sfuser.field.customcolumn.160=YOE
#No of Day after hiring
Sfuser.field.customcolumn.170=DAH

If you do not want to touch your user data file or your user data file is coming from provisioning then you can use user extended data file
for that just modify the formula like this.

Sfuser.extendeduser.field.customcolumn.<your_column_number>=<your_column_name_in_connector_file>

Example -

Sfuser.extendeduser.field.customcolumn.160=YOE
Sfuser.extendeduser.field.customcolumn.170=DAH

Now the work in LMS is done for User connector part

Setting up Integration

If you do not have integration center job for user connector then you can go through following guide - SuccessFactors: Goodbye Provisioning Jobs Part 1 | Using Integration Center (IC) for synchronizing u...
I strongly recommend to move from Provisioning to IC job for User Connector for easy to access ,configure and debug.

Now you have Integration center job, you have to create new column for "Days After Hiring"
select Numeric value in Field Data Type
use following screenshot for reference

nishadsthakur_0-1763108043506.png
Days after hiring calculation

You can also add "Years after Hiring"

nishadsthakur_1-1763108124482.png
Years after hiring calculation

User the above settings for creating new Numeric columns and run/schedule your IC job

If you do not want to use user data file then you can use user extended data file
sample file you can see here(use the same blog listed above to create the file)
I have attached sample file for your reference

make sure you have used userid column as ^UserId
you can refer the IC job here

nishadsthakur_2-1763108175285.png

Years after hiring calculation

You are done with IC job, Sync this file using User Connector SF and head to Assignment Profile

creating Assignment Profiles

Due to new data type we have new operators specifically for Numerical values– "Less Than or Equal to", "Greater Than or Equal to" and "Between"

nishadsthakur_3-1763108312313.png

New operators for Assignment Profile

Your Requirement – any user joined after 1st Jan 2025 ,should get assigned onboarding course after 15th day from Joining.

In Assignment Profile you can create the rule as follows

nishadsthakur_4-1763108417012.png

days rule

Similarly if you want to Assign based on Years of Experience then you can use this

nishadsthakur_5-1763108431545.png

years rule

Also you can use this with JOB Grades where you can use between feature to segregate the grades

nishadsthakur_6-1763108449351.png

between rule

This will eliminate manually selecting each job grade to add into the criteria and give you dynamic option.
I highly encourage to transform your Grades to Numeric values using lookup table in IC so that you can use it as Numeric values (example M1 =1,M2 = 2 etc)

Future cases

Similar to this if you are feeling motivated and adventurous then you can create PRD report which has an user and item completion date and calculation from date of completion

send this data to EC using MDF and use it to extract back to User connector, you have to create this for multiple items and use it to assign courses After completion/assignment of Item A > automatic assignment after X days of Item B

sample report data
userid,itemid,completiondate,today-completiondate
10001,abc123,10-11-2025,5

you can comment on the blog, I can consult for the setting up any custom requirement for another item assignment after certain days of first item completion

References:

SuccessFactors: Goodbye Provisioning Jobs Part 1 | Using Integration Center (IC) for synchronizing u...

SuccessFactors: Goodbye Provisioning Jobs Part 2 | Using Integration Center (IC) to import User data...

Support for Integer and Decimal Custom Fields for User Entity

2571171 - How to create a year calculation field in Integration Center

2594749 - How to use Value Lookup Table in Integration Center