MAIN HCM SQL with 2 UDT columns (Nested JOINs)
SummaryMAIN HCM SQL with 2 UDT columns (Nested JOINs)
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)
replace(replace(pni.NATIONAL_IDENTIFIER_NUMBER,'-',''),' ','') SSN,
PAAF.EFFECTIVE_START_DATE "HCM Effective Date"
FROM ff_user_tables_tl futt,