If 'debtor-instrument data'.'household type-instrument data indicator' = "natural person-instrument data"
Then
'debtor-instrument data'.'reporting agent identifier' = 'natural person-instrument data'.'reporting agent identifier' and
'debtor-instrument data'.'observed agent identifier' = 'natural person-instrument data'.'observed agent identifier' and
'debtor-instrument data'.'counterparty role' = 'natural person-instrument data'.'counterparty role' and
'debtor-instrument data'.'counterparty identifier' = 'natural person-instrument data'.'counterparty identifier' and
'debtor-instrument data'.'instrument identifier' = 'natural person-instrument data'.'instrument identifier' and
'debtor-instrument data'.'reporting reference date' = 'natural person-instrument data'.'reporting reference date'
If 'debtor-instrument data'.'household type-instrument data indicator' = "partnership-instrument data"
Then
'debtor-instrument data'.'reporting agent identifier' = 'partnership-instrument data'.'reporting agent identifier' and
'debtor-instrument data'.'observed agent identifier' = 'partnership-instrument data'.'observed agent identifier' and
'debtor-instrument data'.'counterparty role' = 'partnership-instrument data'.'counterparty role' and
'debtor-instrument data'.'counterparty identifier' = 'partnership-instrument data'.'counterparty identifier' and
'debtor-instrument data'.'instrument identifier' = 'partnership-instrument data'.'instrument identifier' and
'debtor-instrument data'.'reporting reference date' = 'partnership-instrument data'.'reporting reference date'
|