Flag start date does not match
INSERT INTO ProgramParticipation (programID,personID,startDate,districtID)
SELECT ... dTripRelease' AND CS.value = 'N'
LEFT JOIN ProgramParticipation PP ON PP.personID = CS.personID AND PP.startDate ... D FROM District WHERE NUMBER = 066105) D
WHERE PP.participationID IS NULL
--End Date Flags Where Opted In via O... 'fieldTripRelease' AND CS.value = 'Y'
JOIN ProgramParticipation PP ON PP.personID = CS.personID
JOIN Program P ON