You are currently viewing SQL Query to fetch Recruiting Location Hierarchy
SQL Query to fetch Recruiting Location Hierarchy

In this article, we will look into fetching the Recruiting Location Hierarchy for ORC.

Recruiting Locations are different from the Core HR Locations and we need to configure the Recruiting Locations and then add them to Recruiting Tree Geography Hierarchy.

SQL Query:

SELECT
hg_parent.geography_element1 parent_geography_element1
,hg_parent.geography_element2 parent_geography_element2
,hg_parent.geography_element3 parent_geography_element3
,hg_parent.geography_element4 parent_geography_element4
,hg.geography_element1
,hg.geography_element2
,hg.geography_element3
,hg.geography_element4
FROM IRC_GEO_HIER_NODES ighn,
HZ_GEOGRAPHIES hg,
IRC_GEO_HIER_NODES ighn_parent,
HZ_GEOGRAPHIES hg_parent
WHERE hg.geography_id = ighn.geography_id
AND ighn.parent_geo_node_id = ighn_parent.geography_node_id
AND hg_parent.geography_id = ighn_parent.geography_id
GROUP BY hg_parent.geography_element1
,hg_parent.geography_element2
,hg_parent.geography_element3
,hg_parent.geography_element4
,hg.geography_element1
,hg.geography_element2
,hg.geography_element3
,hg.geography_element4

Output will look like:

image 8 1024x551 - SQL Query to fetch Recruiting Location Hierarchy
If you like the content, please follow us on LinkedInFacebook, and Twitter to get updated with the latest content.