Issue in SQL script to get Overall Summary section comments — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Issue in SQL script to get Overall Summary section comments

edited Nov 19, 2017 1:31PM in Reporting and Analytics for HCM 4 comments

Content

Hi All,

I have written a script to get comments entered by both Manager and Worker in the Overall Summary Section (OS) in the Performance Document. (See my screen shot below, we have renamed the OS section as Training Requirement as per the business need)

For this purpose I have joined following tables as OS section comments were not available in one table;

   hra_evaluations 
   ,hra_eval_participants 
   ,hra_eval_ratings 
   ,hra_eval_sections 
 
But data model sample results shows me 10 rows other than two rows (one for manager and one for worker)
 
Please help me out to get this correctly;

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!