Operation Details
Description: Updates the status of actions to 'In Progress' where the action status is 'Not Started' and the start date is before the date supplied and there is either no end date or an end date that is after the date supplied.
Sterotype: ns
SQL 
UPDATE OutcomePlanAction
SET status = 'OPAS10002'
WHERE status = :status 
AND 
startDate <= :startDate
AND
(endDate IS NULL OR endDate >= :startDate)