Published Job Requisition and External Career Site SQL
I am looking for Table(s)/SQL that link the Job Requisition posted and External Career Site configured.
I am currently facing issue to create a report that links the job requisition posted and new active external career site.
I am using below tables :
While the default 'CX' career site is deactivated, IRC_PUBLISHED_JOBS still has only this site_id.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Code snippet used in the Query: