Operation Details
Description: Retrieves a summary record for each employer. May return a very large amount of records.
Sterotype: nsmulti
SQL 
SELECT
  Employer.primaryAlternateID,
  Employer.concernRoleID,
  Employer.tradingName,
  Employer.registeredName,
  ConcernRole.sensitivity,
  city.elementValue,
  addressLine1.elementValue
INTO
  :primaryAlternateID,
  :concernRoleID,
  :tradingName,
  :registeredName,
  :sensitivity,
  :city,
  :addressLine1 
FROM
  ConcernRole,
  Employer,
  AddressElement city,
  AddressElement addressLine1 
WHERE Employer.concernRoleID = ConcernRole.concernRoleID 
  AND 
  (
    city.addressID = ConcernRole.primaryAddressID 
    AND city.elementType = :cityType 
  ) 
  AND 
  (
    addressLine1.addressID = ConcernRole.primaryAddressID 
    AND addressLine1.elementType = :addressLine1Type 
  )