UFN_SELECTION_CONSTITUENT_MEMBERS

            CREATE function dbo.UFN_SELECTION_CONSTITUENT_MEMBERS()
            returns table
            as return
                select distinct
                    MEMBER.CONSTITUENTID as [ID]
                from
                    dbo.MEMBER
                    inner join dbo.MEMBERSHIP on MEMBER.MEMBERSHIPID = MEMBERSHIP.ID
                    inner join dbo.MEMBERSHIPLEVELTERM on MEMBERSHIP.MEMBERSHIPLEVELTERMID = MEMBERSHIPLEVELTERM.ID
                where
                    MEMBER.ISDROPPED = 0 
                    and
                    (
                        getdate() <= dbo.UFN_MEMBERSHIPLEVEL_CREATERENEWALAFTEREXPIRATIONDATE(MEMBERSHIP.MEMBERSHIPLEVELID,MEMBERSHIP.EXPIRATIONDATE)
                        or
                        MEMBERSHIPLEVELTERM.TERMCODE = 6
                    )
                    and MEMBERSHIP.STATUSCODE <> 1;