What's new in Customer Journeys?

Connect and learn more! ×
Direct join between Benefit and Element tables issue — 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

Direct join between Benefit and Element tables issue

Received Response
22
Views
3
Comments

Summary:

Hi,

I am building a report where I need to show the CONTRIBUTION_PERCENTAGE (BEN_PRTT_RT_VAL.ANN_RT_VAL) from Benefit and CONTRIBUTION_AMOUNT (pay_element_entry_values_f.screen_entry_value) from Element.

I am joining Benefit table to Element table via per_assignment_secured_list_v.But the Assignment ID and Person ID is creating a cross join and I am getting unwanted records.Is there a way, I can directly join BENEFIT with ELEMENT table and pull ANN_RT_VAL,screen_entry_value ?


Below is the join conditions.

BEN_BENEFIT_RELATIONS_F.REL_PRMRY_ASG_ID = per_assignment_secured_list_v.ASSIGNMENT_ID 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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