We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

MAIN HCM SQL with 2 UDT columns (Nested JOINs)

Received Response
16
Views
1
Comments
edited Oct 19, 2020 9:43PM in HCM Integrations 1 comment

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!