rogramParticipation (programID,personID,startDate,districtID)
SELECT P.programID, CS.personID, CAST(CS.date AS DATE) AS startDate,D.districtID
FROM CustomStudent CS
JOIN CampusAttribute CA O... am WHERE code = 'FIELDTRIP') P
CROSS JOIN (SELECT districtID FROM District WHERE NUMBER = 066105) D
WHERE PP.participationID IS NULL
--End Date Flags Where Opted In