Multiple choice technology packaged enterprise solutions

When you create a join to a party table, the destination column must reference the _____column in the joined table.

  1. ROW_ID

  2. PARTY_ID

  3. BU_ID

  4. PAR_ROW_ID
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When joining to party tables in Siebel, the destination column must reference PAR_ROW_ID, which is the standard foreign key column pointing to party-related records. ROW_ID is the generic primary key, PARTY_ID and BU_ID are not the standard join columns for party table relationships.

AI explanation

When joining to a party-related table (S_PARTY and its subtype tables like S_ORG_EXT, S_CONTACT) in Siebel, the destination column on the joined table that the source business component's foreign key must reference is PAR_ROW_ID — a special column present on party-type tables specifically to support polymorphic joins across different party subtypes. ROW_ID is the generic primary key (used for normal, non-party joins), PARTY_ID and BU_ID aren't the standard destination columns for this pattern. This is Siebel-specific data-model trivia around the 'party model' design.

Keep practicing — related questions