SQL TO GET EMPLOYER EXPERIENCE DETAILS FROM SKILLS AND QUALIFICATIONS (EXPERIENCE DETAILS)
Summary:
SQL TO GET EMPLOYER EXPERIENCE DETAILS FROM SKILLS AND QUALIFICATIONS (EXPERIENCE DETAILS)
Content (required):
SQL TO GET EMPLOYER EXPERIENCE DETAILS FROM SKILLS AND QUALIFICATIONS (EXPERIENCE DETAILS)
Version (include the version you are using, if applicable):
23C
Code Snippet (add any code snippets that support your topic, if applicable):
SELECT
PAPF.PERSON_NUMBER AS "PERSON_NUMBER"
,PPN.DISPLAY_NAME AS "PERSON_NAME"
,HPI.ITEM_TEXT240_1 as "EMPLOYER_NAME"
,SUBSTR(HPI.ITEM_DATE_1,1,10) as "Start Date from Experience"
,SUBSTR(HPI.ITEM_DATE_2,1,10) as "End Date from Experience"
FROM
PER_ALL_PEOPLE_F PAPF,
PER_PERSON_NAMES_F PPN,
HRT_PROFILES_B HPB,
Tagged:
0