Operation Details
Description: Reads details required for baseline plan item for all planned items assigned to a sub goal.
Sterotype: nsmulti
SQL 
SELECT
  PlannedItem.name,
  PlannedItem.plannedItemID,
  PlannedItem.sensitivityCode,
  PlannedItem.expectedStartDate,
  PlannedItem.expectedEndDate,
  PlannedItem.actualStartDate,
  PlannedItem.actualEndDate,
  PlanItem.typeCode,
  PlannedItem.expectedOutcomeID,
  PlannedItem.outcomeAchieved,
  PlannedItem.goodCauseID,
  PlannedItem.responsibilityID,
  PlannedItem.responsibilityType,
  PlannedItem.respUserName,
  PlannedItem.ownerUserName,
  PlannedItem.estimatedCost,
  PlannedItem.actualCost,
  PlannedItem.comments
INTO
  :name,
  :plannedItemID,
  :sensitivityCode,
  :expectedStartDate,
  :expectedEndDate,
  :actualStartDate,
  :actualEndDate,
  :typeCode,
  :expectedOutcomeID,
  :outcomeAchieved,
  :goodCauseID,
  :responsibilityID,
  :responsibilityType,
  :respUserName,
  :ownerUserName,
  :estimatedCost,
  :actualCost,
  :comments 
FROM
  PlannedItem,
  PlanItem 
WHERE PlannedItem.plannedSubGoalID = :plannedSubGoalID 
  AND PlanItem.planItemID = PlannedItem.planItemID