Loading Candidates with Source/Source Medium - Job Aggregator/Indeed

Summary:

As part of migration we are loading candidates with source and source mediums, and finding difficulty in loading the candidates that specifically came from Indeed. As per the KM Doc: Oracle Fusion Recruiting Cloud: How to Find Values for the HDL Attribute: SOURCE (KB24160), the below query should return the list of values for source and source mediums. However, it doesnt have anything related to Source Medium: Job Aggregator, Source - Indeed.

SELECT DISTINCT

source_medium_url_value,

source_url_value

FROM

fusion.IRC_DIMENSION_DEF_B

ORDER BY

source_medium_url_value,source_url_value

However the Candidate Source Tracking