HCM Extract - User Entity BEN_EXT_ENRT_DPNT_UE provides incorrect value for Person ID — Cloud Customer Connect
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 Extract - User Entity BEN_EXT_ENRT_DPNT_UE provides incorrect value for Person ID

edited Oct 11, 2024 10:48PM in Benefits 2 comments

I am working on an HCM extract process to provide it to the insurance provider. I am trying to obtain the Life AD&D information for employee, spouse and child(ren).

I have used PER_EXT_SEC_PERSON_UE (employee root) followed by BEN_EXT_ENRT_DPNT_UE (level 1 - matched on parent.Extract Person ID = Person ID) and then BEN_EXT_ENRT_RTCVG_UE (level 2 - matched on parent.Person ID = Person ID).

The user entities should match based on employee's person ID. I believe BEN_EXT_DPNT_PERSON_ID should provide the employee person ID and BEN_EXT_DPNT_DPNT_PERSON_ID should yield dependent (in this case spouse) person id.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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