Query for Acknowledgement / Approve section for Overall Performance Evaluation — 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

Query for Acknowledgement / Approve section for Overall Performance Evaluation

in HCM Extract

Hello!

I would like to build a query which will receive the approval/acknowledgment of a specific section. Unfortunatelly in the ratings or section tables we cant corelate any field.



select
per.display_name,
per.person_id,
hev.evaluation_id,
hev.evaluation_date,
hev.start_date,
hev.end_date,
sec.section_type_code,
sec.comment_text,
rat.COMMENTS
from per_person_names_f per
join HRA_EVALUATIONS hev on per.person_id = hev.worker_id
join HRA_EVAL_SECTIONS sec on sec.evaluation_id = hev.evaluation_id
join HRA_EVAL_RATINGS rat on rat.reference_id = sec.eval_section_id

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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