If 'contract'.'syndicated contract indicator' = "single participation contract"
Then
'contract'.'reporting agent identifier' = 'single participation contract'.'reporting agent identifier' and
'contract'.'observed agent identifier' = 'single participation contract'.'observed agent identifier' and
'contract'.'reporting reference date' = 'single participation contract'.'reporting reference date' and
'contract'.'contract identifier' = 'single participation contract'.'contract identifier'
If 'contract'.'syndicated contract indicator' = "syndicated contract member"
Then
'contract'.'reporting agent identifier' = 'syndicated contract member'.'reporting agent identifier' and
'contract'.'observed agent identifier' = 'syndicated contract member'.'observed agent identifier' and
'contract'.'reporting reference date' = 'syndicated contract member'.'reporting reference date' and
'contract'.'contract identifier' = 'syndicated contract member'.'contract identifier'
|