Operation Details
Description: Returns planned item id, name, expected start date, expected end date, actual start date, actual end date, and sensitivity code from baseline plan item for a specified baseline sub-goal identifier.
Sterotype: nsmulti
SQL
SELECT
  BaselinePlanItem.plannedItemID,
  BaselinePlanItem.name,
  BaselinePlanItem.expectedStartDate,
  BaselinePlanItem.expectedEndDate,
  BaselinePlanItem.actualStartDate,
  BaselinePlanItem.actualEndDate,
  BaselinePlanItem.sensitivityCode,
  BaselinePlanItem.baselinePlanItemID
INTO
  :plannedItemID,
  :name,
  :expectedStartDate,
  :expectedEndDate,
  :actualStartDate,
  :actualEndDate,
  :sensitivityCode,
  :baselinePlanItemID 
FROM
  BaselinePlanItem 
WHERE BaselinePlanItem.baselineSubGoalID = :baselineSubGoalID