SAP Knowledge Base Article - Public

3546611 - Inactive and Terminated employees are not reportable in Person and Employment (as of Date) Reports for annualized salary or pay component group sum

Symptom

  • Person and Employment (as of Date) Reports Does not pull annualized salary or pay component group sum record for Inactive and Terminated employees
  • Inactive and Terminated employees are not reportable in Person and Employment (as of Date) Reports for annualized salary or pay component group sum

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors Employee Central - Compensation Information
  • SAP SuccessFactors Employee Central - Reporting

Reproducing the Issue

Run Person and Employment Info (as of Date)

  1. Go to Report Center Or Ad-hoc report
  2. Select Sub-Domain Person and Employment Info (as of Date)
  3. Select columns: Employee Pay Group Sums
  4. Click on Component Group ID, in this case: AnnualizedSalary
  5. Save and Run
  6. Check result: Inactive and Terminated employees are not reportable in Person and Employment (as of Date) Reports for annualized salary or pay component group sum

Cause

This is working as designed - Inactive and Terminated employees are not reportable 

Resolution

Since the data displayed in the Compensation Information is transient (calculated when the page loads), the displayed value is not stored in the database, and therefore not directly available in ad hoc reports. To display this information in the Person and Employment (as of Date) report, you must have the HRIS PayComponentGroup Sums Sync job scheduled in your instance.

When the job runs for the first time, it will likely take some time to complete. However, once completed, all subsequent jobs that run (advised as once daily) will be much faster. Once the job is completed, the Person and Employment (as of Date) report displays the calculated values when the selected column set is Employee Pay Group Sums and a pay component group, such as AnnualizedSalary.

The pay component group sum is calculated only for active users with these statuses:

  • VALID_INTERNAL_USER (active, paid leave, unpaid leave, dormant, suspended)

  • VALID_EXTERNAL_USER

  • VALID_EXTERNAL_USER_NON_MTR

Note: 3375924 - How To check User Status Via Data inspector

How to run Job HRIS PayComponentGroup Sums Sync.

Note: starting with B2305 Release, customers have also the possibility to directly run this job from the Admin Center.

  1. On Admin Center, go to Scheduled Job Manager // Guide- chapter -Managing Scheduled Jobs
  2. Click on the tab Job Scheduler
  3. On Job Type, select Job HRIS PayComponentGroup Sums Sync.
  4. On Actions, you can click on Run it Now or
  5. You can Create new job request and schedule it in future.

The maximum times that the job can run each day in the Admin Center:

  • 1 time a day.
  • 1 time for a recurring job.

NOTE: If the employee is active when the HRIS PayComponentGroup Sums Sync job runs for the first time, and they are then made inactive / terminated, the system should retain the value from when they were active. If the employee is inactive / terminated before the HRIS PayComponentGroup Sums Sync job runs for the first time and you would like them to have a value, they would need to be made active for the value to sync, after which they can be made inactive again.

FAQ - Additional Information

Q) Where can I get information on this from the Guide?

 A) EC Core Guide:Implementing Employee Central Core  and Scheduled Job Manager Guide: HRIS PayComponentGroup Sums Sync

See Also

  1. 3375924 - How To check User Status Via Data inspector 
  2. 2796879 - How To Run An Adhoc Report for Pay Component Group Name or Pay Component Group ID
  3. 2336732 - Pay Component Groups or Annualized Salary Missing Data in Ad Hoc Reports
  4. 2324356 - Annualized Salary in Report Table / Detailed reporting is blank or incorrect - Report Table / Detailed Reporting
  5. 2868162 - HRIS Pay Component Group Sums Sync Job is Failing
  6. 2231503 - Synchronize Business Configuration Job Configuration via Scheduled Job Manager

Keywords

active, paid leave, unpaid leave, dormant, suspended, inactive, Report center,  Person and Employment (as of Date), HRIS PayComponentGroup Sums Sync, AnnualizedSalary, status, valid, INC10301708 , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , Problem

Product

SAP SuccessFactors HCM Core 2411