UFN_EVENT_GETNONPROGRAMEVENTREGISTRANTS

            CREATE function dbo.UFN_EVENT_GETNONPROGRAMEVENTREGISTRANTS
            (
                @CONSTITUENTID uniqueidentifier = null
            )
            returns table
            as
            return(

                select
                    REGISTRANT.ID REGISTRANTID,
                    EVENT.STARTDATE EVENTSTARTDATE,
                    EVENT.NAME EVENTNAME,
                    CONSTITUENTID CONSTITUENTID,
                    EVENTID EVENTID
                from dbo.REGISTRANT                
                inner join
                    dbo.EVENT on REGISTRANT.EVENTID = EVENT.ID
                where 
                      REGISTRANT.CONSTITUENTID = @CONSTITUENTID
                      and
                      EVENT.PROGRAMID is null
                      and
                      REGISTRANT.ISCANCELLED = 0
            )