If 'counterparty'.'national identifier type_type' contains ("_OTHER_CD")
Then
'foreign counterparty'.'reporting agent identifier' = 'foreign counterparty with other national identifier'.'reporting agent identifier' and
'foreign counterparty'.'counterparty identifier' = 'foreign counterparty with other national identifier'.'counterparty identifier' and
'foreign counterparty'.'reporting reference date' = 'foreign counterparty with other national identifier'.'reporting reference date'
If 'counterparty'.'national identifier type_type' does not contain ("_OTHER_CD")
Then
'foreign counterparty'.'reporting agent identifier' = 'foreign counterparty with regular national identifier'.'reporting agent identifier' and
'foreign counterparty'.'counterparty identifier' = 'foreign counterparty with regular national identifier'.'counterparty identifier' and
'foreign counterparty'.'reporting reference date' = 'foreign counterparty with regular national identifier'.'reporting reference date'
|