, case when tbl_CRM_MarketingActivities.enrollmentRuleCode = 'CLOSED' then 'LOCKED'
       else case when tbl_CRM_MarketingActivities.enrollmentEndDate < {fn now()} then 'LOCKED'
                 else 'UNLOCKED'
             end
   end enrollmentState



, case when tbl_CRM_MarketingActivities.ready <> 'Y' then 'NOT READY'
	   when tbl_CRM_MarketingActivities.unpublishDate < {fn now()} then 'UNPUBLISHED'
       when tbl_CRM_MarketingActivities.endDate < {fn now()} then 'FINISHED'
       when tbl_CRM_MarketingActivities.startDate < {fn now()} and tbl_CRM_MarketingActivities.enrollmentRuleCode = 'CLOSED' then 'RUNNING'
       when tbl_CRM_MarketingActivities.enrollmentStartDate <= {fn now()} and tbl_CRM_MarketingActivities.enrollmentEndDate >= {fn now()} then 'ENROLLMENT'
       when tbl_CRM_MarketingActivities.startDate <= {fn now()} and tbl_CRM_MarketingActivities.endDate >= {fn now()} then 'RUNNING'
       when tbl_CRM_MarketingActivities.publishDate < {fn now()} then 'PUBLISHED'
       else 'PLANNING'
   end lifecycleState
   
   
   

   -- just a comment to quite down the editor errors due to less than signs above >