MAIN HCM SQL with 2 UDT columns (Nested JOINs)

Summary

MAIN HCM SQL with 2 UDT columns (Nested JOINs)

Content

Hello Forum friends:

My goal is to have one line per Person_number and am successful with a couple of records.

I believe this works, but am open to bullet-proofing tips?

(The real quarterly run will be in the several thousand persons)

Thank you,

John

 

 

SELECT DISTINCT

replace(replace(pni.NATIONAL_IDENTIFIER_NUMBER,'-',''),' ','') SSN,

papf.PERSON_NUMBER "Emplid",

ppnf.full_name "Name",

PAAF.EFFECTIVE_START_DATE "HCM Effective Date"

,(SELECT fuctl.VALUE

              FROM ff_user_tables_tl futt,

                   ff_user_rows_f fur,

                   ff_user_rows_tl furt,