When trying to find the Job Application Status Audit Trail - Time In Status field in Integration Center or using OData API, the field is not available but it's possible to find it in Adhoc Reporting.
SAP SuccessFactors Recruiting Management
Reproducing the Issue
- Open Reporting, and create a new Recruiting V2 table report;
- Select App Status Audit Trail column and search for "Time In Status";
- Now go to Integration Center, and create a new Integration;
- Select the JobApplicationStatusAuditTrail Entity, and look for the Time In Status field;
- Not able to find it.
This happens because the Time In Status is not an exposed field through API. The field Time In Status is not stored directly into a Database table/column, and that is the reason why we can't find it in Integration Center, nor OData API.
How come that we see the field in Adhoc then? - Adhoc has some additional columns that are not found in the Integration Center. That is because IC is pulling the data straight out from the database, the only information we have there is the information that is stored on the database. Now, on the Adhoc side, we have native calculated columns, which are hardcoded into the product functionality accordingly to the necessity of the customers.
On Adhoc, when we see the Time In Status column, we are actually seeing a calculation that the system is doing, getting information from the Audit and displaying to us on the field value.
Time, In, Status, IC, Integration Center, OData, Missing, Not, Audit, App, Application , KBA , LOD-SF-RCM-APP , Applicants and Job Applications , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , Problem