Query to extract Job Information

 Below query can be used to extract loaded Jobs from Fusion.

select 
TO_CHAR(pjf.effective_start_date,'DD/MM/YYYY') Effective_Start_Date,
TO_CHAR(pjf.Effective_End_Date,'DD/MM/YYYY') Effective_End_Date,
fs.set_code Job_Set_Id,
pjft.NAME job_name,
pjf.JOB_CODE,
pjf.ACTIVE_STATUS STATUS,
pjf.FULL_PART_TIME,
pjf.REGULAR_TEMPORARY,
pjff.job_family_code,
pjfft.job_family_name,
pjf.MANAGER_LEVEL,
pjf.approval_authority "Level",
pjf.JOB_FUNCTION_CODE Job_Function,
hrc.object_name, 
hrc.source_system_id, 
hrc.source_system_owner
 from hrc_integration_key_map hrc,
        per_jobs_f pjf,
        per_jobs_f_tl pjft,
        fnd_setid_sets_vl fs,
        PER_JOB_FAMILY_F pjff,
        PER_JOB_FAMILY_F_TL pjfft
where hrc.object_name like 'Job'
     and hrc.surrogate_id = pjf.job_id
     and pjf.job_id = pjft.job_id
     and pjf.set_id = fs.set_id
     and pjf.job_family_id = pjff.job_family_id
     and pjfft.job_family_id = pjff.job_family_id