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

HCM Cloud - is it possible to extract the alternate_registered_name field via REST APIs ?

in HCM Integrations

Summary:

Hello,

Wondering if it's possible to extract details of an worker's reporting establishment (present at his assignment level) through REST APIs.

Extracting this data is achievable through BIP:

SELECT reg.alternate_registered_nameFROM per_all_assignments_m paam JOIN per_all_people_f papf ON paam.person_id = papf.person_id
LEFT JOIN HR_ORGANIZATION_INFORMATION_F eff ON paam.establishment_id = eff.organization_id AND eff.ORG_INFORMATION_CONTEXT = 'HRX_FR_TRU_CORPORATE_INFO'LEFT JOIN HR_ORG_UNIT_CLASSIFICATIONS_F cls ON paam.establishment_id = cls.organization_id AND cls.classification_code = 'HCM_TRU'LEFT JOIN HR_ALL_ORGANIZATION_UNITS_F haouf ON haouf.organization_id = cls.organization_idLEFT JOIN XLE_REGISTRATIONS reg ON haouf.establishment_id = reg.source_id AND reg.source_table = 'XLE_ETB_PROFILES'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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