Operation Details
Description: Reads baseline details for comparison when baseline is not associated with a group.
Sterotype: nsmulti
SQL
SELECT
  BaselineSubGoal.baselineSubGoalID,
  BaselineSubGoal.plannedSubGoalID,
  BaselineSubGoal.name,
  BaselineSubGoal.typeCode,
  BaselineSubGoal.expectedStartDate,
  BaselineSubGoal.expectedEndDate,
  BaselineSubGoal.actualStartDate,
  BaselineSubGoal.actualEndDate,
  BaselineSubGoal.plannedGroupID
INTO
  :baselineSubGoalID,
  :plannedSubGoalID,
  :name,
  :typeCode,
  :expectedStartDate,
  :expectedEndDate,
  :actualStartDate,
  :actualEndDate,
  :plannedGroupID 
FROM
  BaselineSubGoal 
WHERE BaselineSubGoal.baseLineID = :baseLineID 
  AND BaselineSubGoal.sensitivityCode <= :sensitivityCode 
  AND BaselineSubGoal.plannedGroupID IS NULL