Query to find Ownership type of candidate pool(Private, Shared, Global)
I need to show ownership type(Private, Shared, Global) of Candidate Pool in BI report. I am unable to find any table that stores this information. However, there is a lookup 'ORA_IRC_POOL_STATUS' which has these 3 values in lookup meaning. But, I cant find any column in candidate pool related tables or views like hrt_pools_b, irc_pools_v etc so that I can join that column with this lookup to get the actual values.
Please let me know if there is any table which I can use.
Thanks and Regards
Content (please ensure you mask any confidential information):