SQL Query to get the profile id or profile code for an employee

select                  "PER_ALL_PEOPLE_F"."PERSON_NUMBER" as "PERSON_NUMBER",
               "HRT_PROFILES_B"."PROFILE_CODE" as "PROFILE_CODE"
 from    "FUSION"."PER_ALL_PEOPLE_F" "PER_ALL_PEOPLE_F",
              "FUSION"."HRT_PROFILES_B" "HRT_PROFILES_B"
 where   "HRT_PROFILES_B"."PERSON_ID"="PER_ALL_PEOPLE_F"."PERSON_ID"
  --and    "PER_ALL_PEOPLE_F"."PERSON_NUMBER" ='12345'

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

Technical Contents - SQL Query
Posted by : Mohammad
Follow on Linkedin