Operation Details
Description: Reads top level columns by header ID, column type and column index. Sub-columns are not included in the read.
Sterotype: nsmulti
SQL 
SELECT
  rateColumnID,
  rateHeaderID,
  parentColumnID,
  rateColumnKeyMin,
  rateColumnKeyMax,
  rateColumnKeyValue,
  rateColumnType,
  rateColumnIndex,
  anyMinimumInd,
  anyMaximumInd
INTO
  :rateColumnID,
  :rateHeaderID,
  :parentColumnID,
  :rateColumnKeyMin,
  :rateColumnKeyMax,
  :rateColumnKeyValue,
  :rateColumnType,
  :rateColumnIndex,
  :anyMinimumInd,
  :anyMaximumInd 
FROM
  RateColumn 
WHERE 
  (
    
    (
      :rateHeaderIDIsNull <> '0' 
    ) 
    OR rateHeaderID = :rateHeaderID 
  ) 
  AND 
  (
    
    (
      :rateColumnType IS NULL 
    ) 
    OR rateColumnType = :rateColumnType 
  ) 
  AND 
  (
    
    (
      :rateColumnIndex IS NULL 
    ) 
    OR rateColumnIndex = :rateColumnIndex 
  ) 
  AND 
  (
    parentColumnID IS NULL 
  )