Operation Details
Description: Returns all sub-columns for a parent column by index and returns full rate column details.
Sterotype: nsmulti
SQL
SELECT
  rateColumnID,
  rateHeaderID,
  parentColumnID,
  rateColumnKeyMin,
  rateColumnKeyMax,
  rateColumnKeyValue,
  rateColumnType,
  rateColumnIndex,
  anyMaximumInd,
  anyMinimumInd
INTO
  :rateColumnID,
  :rateHeaderID,
  :parentColumnID,
  :rateColumnKeyMin,
  :rateColumnKeyMax,
  :rateColumnKeyValue,
  :rateColumnType,
  :rateColumnIndex,
  :anyMaximumInd,
  :anyMinimumInd 
FROM
  RateColumn 
WHERE parentColumnID = :rateColumnID 
  AND 
  (
    rateColumnIndex >= :index 
  ) 
ORDER BY rateColumnType, rateColumnIndex ASC