Operation Details
Description: Reads all facilities that are NOT provided at the specified location.
Sterotype: nsmulti
SQL 
SELECT
  code
INTO
  :typeCode 
FROM
  codetableitem 
WHERE tableName = :tablename 
  AND code NOT in 
  ( 
  SELECT
    typeCode 
  FROM
    LocationFacilities 
  WHERE providerLocationID = :providerLocationID 
  )