'foreign legal entity'.'number of employees' is mandatory when
there exists a counterparty role for which the following is true:
(( 'foreign legal entity'.'reporting agent identifier' = 'counterparty role'.'reporting agent identifier'
and 'foreign legal entity'.'counterparty identifier' = 'counterparty role'.'counterparty identifier'
and 'foreign legal entity'.'reporting reference date' = 'counterparty role'.'reporting reference date'
and 'counterparty role'.'counterparty role' in ("debtor", "originator"))
or
( 'foreign legal entity'.'reporting agent identifier' = 'counterparty'.'reporting agent identifier'
and 'foreign legal entity'.'counterparty identifier' = 'counterparty'.'counterparty identifier'
and 'foreign legal entity'.'reporting reference date' = 'counterparty'.'reporting reference date'
and 'counterparty'.'protection provider indicator' = "protection provider")
or
( 'foreign legal entity'.'reporting agent identifier' = 'debtor'.'reporting agent identifier'
and 'foreign legal entity'.'counterparty identifier' = 'debtor'.'immediate parent undertaking identifier'
and 'foreign legal entity'.'reporting reference date' = 'debtor'.'reporting reference date')
or
( 'foreign legal entity'.'reporting agent identifier' = 'debtor'.'reporting agent identifier'
and 'foreign legal entity'.'counterparty identifier' = 'debtor'.'ultimate parent undertaking identifier'
and 'foreign legal entity'.'reporting reference date' = 'debtor'.'reporting reference date')
or
( 'foreign legal entity'.'reporting agent identifier' = 'protection provider'.'reporting agent identifier'
and 'foreign legal entity'.'counterparty identifier' = 'protection provider'.'immediate parent undertaking identifier'
and 'foreign legal entity'.'reporting reference date' = 'protection provider'.'reporting reference date')
or
( 'foreign legal entity'.'reporting agent identifier' = 'protection provider'.'reporting agent identifier'
and 'foreign legal entity'.'counterparty identifier' = 'protection provider'.'ultimate parent undertaking identifier'
and 'foreign legal entity'.'reporting reference date' = 'protection provider'.'reporting reference date'))
|