SAP Knowledge Base Article - Public

2962045 - Time In Status field of Job Application not Available in Integration Center or OData - Recruiting Management

Symptom

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.

Environment

SAP SuccessFactors Recruiting Management

Reproducing the Issue

  1. Open Reporting, and create a new Recruiting V2 table report;
  2. Select App Status Audit Trail column and search for "Time In Status";
  3. Now go to Integration Center, and create a new Integration;
  4. Select the JobApplicationStatusAuditTrail  Entity, and look for the Time In Status field;
  5. Not able to find it.

Cause

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.

Resolution

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.

See Also

Approved Date of Job Requisition not Available in Integration Center or OData - Recruiting Management

Application Date field not available in Integration Center or OData/SFAPI - Recruiting Management

Keywords

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

Product

SAP SuccessFactors Recruiting all versions