SQL Query to Identify Employees Without a Profile Code

Explanation:

• PER_ALL_PEOPLE_F provides person-level data.

• HRT_PROFILES_B stores profile records.

• The profile_code IS NULL condition filters those entries that are missing the actual profile assignment.

SELECT DISTINCT
    papf.person_number,
    hpb.profile_code
FROM
    per_all_people_f papf,
    hrt_profiles_b hpb
WHERE
    papf.person_id = hpb.person_id
    AND hpb.profile_code IS NULL;

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.