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
- Navigate to Admin Centre and search for Data Subject Information.
- Generate a report.
- 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