3383354 - Report on Interview Rating and Feedback Using Integration Center - Recruiting Management

Is it possible to generate a report on interview rating and feedback using Integration Center?

SAP SuccessFactors Recruiting Management 

To query the data of interview ratings and feedbacks in Interview Central, the following OData API entities can be used:

• JobApplicationInterview - Use this entity to query the Job Application Id, Interview and Interviewer details.
• InterviewOverallAssessment - Use this entity to query Average Rating, Overall Rating and comments.
• InterviewIndividualAssessment - Use this entity to query the Rating and Comments on each competency.

Please note that these entities are not intended for reporting. To generate a report on Interview Central data, use the Story report (SAP Analytics Cloud). See the KBA 2082205 for more details.

Due to the navigation relationship between these entities, it may not be possible to consolidate all the information into a single table using Integration Center.

Entity Relationships:

• JobApplicationInterview entity to InterviewOverallAssessment entity is in a one-to-many relationship. 
• InterviewOverallAssessment entity to InterviewIndividualAssessment entity is also in a one-to-many relationship.
• The navigation direction is as follows: JobApplicationInterview --> InterviewOverallAssessment --> InterviewIndividualAssessment. Backward navigation is not supported. 

Understanding Entity Relationships:

• One-to-Many: if you choose the left side entity as the starting entity, only a random record from the dependent/many entity will be returned. For example, if InterviewOverallAssessment is the starting entity, only one random competency rating from the InterviewIndividualAssessment entity will be returned. For a detailed explanation, refer to the Integration Center Guide.
• Navigation Direction: As the navigation is in one direction, if you choose the right side entity as the starting entity, it is not possible to navigate to the left side entity to add fields in the same table. For example, if you choose InterviewIndividualAssessment as the starting entity, you cannot add Job Application details or Interviewer details from other entities.
  
  

This is the current design. If you would like to request an improvement, please submit it to our Customer Influence page. This platform enables users to vote for each other's ideas, post comments, and receive direct feedback from the Product Management team. Refer to the KBA 2090228 for more information.

• KBA 2082205 - Is it possible to report on Interview Central? - Recruiting Management
• KBA 2769165 - Change Audit Reports of Interview information - Recruiting Management
• KBA 2466107 - AdHoc report interview fields
• KBA 2954107 - Print Interview Result
• KBA 3115715 - How to provide Interview Feedback via oData API

SAP SuccessFactors API Reference Guide (OData V2):

• JobApplicationInterview
• InterviewOverallAssesment
• InterviewIndividualAssessment

RCM, IC, OData, API, Individual Interview rating, Interview rating, Interview Feedback, Report on Interview result, Interview Central, Competency , KBA , LOD-SF-RCM-IVW , Interview Central, Interviews, Scheduling etc , LOD-SF-RCM-INT , Integration Center & Intelligent Services , LOD-SF-RCM-REP , Reporting & Analytics, Data Imports & Exports , LOD-SF-RCM-API , Webservices & APIs , How To