In which table do I find the name of school in Skills and Qualification > Education — 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

In which table do I find the name of school in Skills and Qualification > Education

edited Jul 22, 2025 1:22PM in Reporting and Analytics for HCM 11 comments

Summary: In this query hpi.item_number_9 returns the ID of the school field. But I do not know with which table the ID must be linked to display the description of the school field. Any ideas?

select papf.person_number
,hcit.name as QUALIFICATION
,hpi.item_number_9

from per_all_people_f papf
,per_person_names_f ppnf
,per_all_assignments_m paam
,per_periods_of_service ppos
,hrt_profiles_b hpb
,hrt_profile_items hpi
,hrt_content_types_tl hctt
,hrt_content_items_tl hcit
where 1=1
and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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