SAP Knowledge Base Article - Public

3538044 - Incorrect Country Values Displayed for "Status Id" Field in Data Subject Information Report

Symptom

In the Data Subject Information Report, the "Status Id" field in the Recruiting data for both external and internal candidates displays country values such as "Afghanistan".

Environment

  • SAP SuccessFactors Recruiting
  • Reporting & Analytics
  • Data Imports & Exports

Reproducing the Issue

  1. Navigate to Admin Centre and search for Data Subject Information.
  2. Generate a report.
  3. In the generated report, the "statusID" field displays a country value instead of an application status.

Cause

The issue arises because the "Status Id" field is mapped to the "STATUS" column of the Job Application table, which stores values from 0 to 6 (including application statuses such as "Open," "Disqualified," etc.). When any standard application field is mapped to a picklist during the API query building process for report generation, the option id for that picklist is pulled out. In this case, 1 is an option Id for ISOCountryPicklist, so in the report, the "Status Id" field is resolved to a country value "Afghanistan".

Resolution

To resolve this issue, it is recommended to use the "System Status" field instead of the "Status Id" field in the Data Subject Information report.

See Also

For further guidance, refer to the following Knowledge Base Articles and SAP Notes:

  • [2665203](https://me.sap.com/notes/2665203)
  • [2648036 - Data Subject Information Report Configuration for Recruiting](https://me.sap.com/notes/2648036)

Keywords

Albania; Algeria; Andorra; Angola; Antigua and Barbuda , KBA , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , Problem

Product

SAP SuccessFactors Recruiting all versions