SAP Knowledge Base Article - Public

2274679 - How To Delete/Delimit Dependents Data via Import - Employee Central

Symptom

It is possible to remove a Dependent of an Employee via the Dependents (personRelationshipInfo) portlet UI on the Personal Information page in Employee Central, but what if you want to do this on mass?

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

Cause

Removed  employee's dependent record from Dependents portlet. Performing this task via the UI can be next to impossible via the UI if hundreds of users are impacted, and performing a Full Purge import meant that you would have to reimport the Dependents data you wanted to keep (all of it) via Full Purge import. There was no way to Delimit/Delete a particular Dependent from an employees Dependents portlet outside of the UI.

Resolution

In B1602 support for the "operation" column has now been added to the Dependents import framework. Now you can delimit data by doing a single incremental import with a DELIMIT token in the operation column of the import template.

View- Mass change In Employee Central Chapter - Deleting Employee Data with a Single Entity

If you had done mass incorrect imports for dependents then easy way to remove the incorrect dependents from employees is to import personRelationship file with DELIMIT operation.

We just need to make sure that dependent person ID is correct and event dates are matching as per the employee's dependent records.

Step 1: Retrieve    Person ID External or Dependent Person Id Via Data Inspector or canvas Report 

  • View 3277779 - How to Find Dependent Person Id or Related Person Id External

Step 2: Export and fill Person Relationship template  with Person ID External employee ID, Related Person Id External, Dependent Person ID, event date , relationship-type and DELIMIT in Operaton column.

ttdenppp.png

Step 3: Import fie in incremental mode and verify that dependent is no more shown in employee's profile.

PS : this way of delimit will just dissociate the dependents data from employee and no dependents will be shown in employee's contact post this import. However, the dependents ID and their data will still remain in the database.

  • If you want dependent person ID and person data to be deleted completely then you will need to use the compound delete function. View: 
    • 2375294 - How to use the Compound Delete for Employee Central (Mass Delete Grid Portlet Data)

FAQ - Additional Information

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

A) Guide: Implementing Dependents   - Mass change In Employee Central - Deleting Employee Data with a Single Entity

  • 3277779 - How to Find Dependent Person Id or Related Person Id External
  • 2806252 - How To Retrieve Dependents Related Information via ORD
  • 2368375 - How to Set Up and Use Date Options in Advanced Reporting
  • 2776882 - EC Advanced Reporting Metadata Sync / Reload (View Based Metadata)

See Also

  • 2806252 - How To Retrieve Dependents Related Information via ORD
  • 3277779 - How to Find Dependent Person Id or Related Person Id External
  • 2375294 - How to use the Compound Delete for Employee Central (Mass Delete Grid Portlet Data)
  • 2092840 - Importing Dependent Information into Employee Central
  • 2368375 - How to Set Up and Use Date Options in Advanced Reporting,
  • 2470903 - How to use "Effective From" and "Effective To" filters to obtain historical/future records - Integration Center
  • 2186440 - Employee Central: Error Importing new Dependents via Compound Dependent import using Incremental mode
  • 2274679 - How to Delete/Delimit Dependents Data via Import
  • 2323484 - Error: Unable to import Consolidated Dependents data
  • 2280959 - Unable to generate an Ad Hoc Report for Dependents data
  • 2543169 - How to Save the Query in Report Center for future use 
  • 2776882 - EC Advanced Reporting Metadata Sync / Reload (View Based Metadata)
  • 2186440 - Error: Importing new Dependents via Compound Dependent import using Incremental mode
  • 2584658 - How to Check if a User is an EC User using the Integration Center - isECRecord Boolean

Keywords

Dependents, DELIMIT, operation, import, personRelationshipInfo, Related Person Id External, Dependent Person ID, Related Person Id External, Child, parent, spouse, Husband, Import, Employee Central, Related Person Id External, Report, Canvas, Advance reporting, ODS, Data inspector, Related Person ID is Invalid , KBA , LOD-SF-EC-EDP , Import Employee Data (EC Core only) , LOD-SF-EC , Employee Central , LOD-SF-EC-DPD , Dependents Management , How To

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HXM Suite all versions