SAP Knowledge Base Article - Public

3200298 - Employee Delta Export: 'Always Show' field for person Id

Symptom

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

You wish to understand why, when using the 'Always Show Value' functionality in Column option, person Id or user ID are not being displayed

Environment

SAP SuccessFactors Employee Delta Export Add-In for Microsoft Excel

Reproducing the Issue

Sample replication steps:
- Using the Wizard, select the user_id from Employment Information

Cause

Expected behavior. The Employee Delta Export Add-In for Microsoft Excel is on maintenance mode only. No development of new features is planned.

Resolution

The feature 'Always Show Value' will generate a column that always shows the current value of a field, even if the value has not changed since the last extraction. 

Additionally, the "Person ID" in the Personal Sheet is available for all the rows, but only the first row person id value will be visible and the other rows value will be hidden.

This is because, the first row person id acts like a header to indicate the start of all changes happened for this person id.

It is a standard feature to differentiate between changes happened for different person ids, this is the intended design which cannot be modified via any settings.

The following example illustrates how the person id is in the first line and also hidden until the next person id brings in additional changes (this sample employee was hired in 2017 and the employment was created in 2021)

See Also

Guide: Using the Employee Delta Export Add-In for Microsoft Excel
2659455 - explanation of SFAPI CompoundEmployee query with changedSegmentsOnly and delta parameters - SAP SuccessFactors
2616251 - Compound Employee Delta excel shows the value "#NA" where a value should be present
712942 - Employee Delta Export - Multiple Changes to Employee Data in One Day Period
2992163 - First and last name fields are blank in the 'Leavers' tab from the employee delta export excel sheet - SAP SuccessFactors HXM Suite

Keywords

employee delta export, add a column, column, wizard, option to click ’Always show’, always show value, no change, person id, and userid (new), userid (old), userid, user id, personid, database, person id and userid is the same, person id is matching, employment details. , KBA , LOD-SF-INT-CE , Compound Employee API , LOD-SF-INT , Integrations , How To

Product

SAP SuccessFactors HCM Suite all versions