USP_CONSTITUENTMEMBERSHIPPROGRAM_GETMEMBERCARDSDATALIST

                CREATE procedure dbo.USP_CONSTITUENTMEMBERSHIPPROGRAM_GETMEMBERCARDSDATALIST
                (
                    @MEMBERSHIPID uniqueidentifier
                )
                as
                begin
                declare @MEMBERSHIPCARDVIEWFORMID uniqueidentifier = '92c7dac0-0015-42f0-9a24-191d16037d8e'

                select
                MC.ID,
                @MEMBERSHIPCARDVIEWFORMID as VIEWFORMID,
                1 as TYPECODE,
                'Membership card' as ITEMTYPE,
                MC.DATEADDED as DATE,
                NF.NAME,
                MC.NAMEONCARD,
                cast(MC.EXPIRATIONDATE as date) as EXPIRATIONDATE,
                MC.ID as CONTEXTID,
                MC.PRINTDATE,
                MC.STATUSCODE as CARDSTATUS,
                case when cast(getdate() as date) > cast(MC.EXPIRATIONDATE as date) then 1 else 0 end as ISEXPIRED
                from dbo.MEMBERSHIP MS
                inner join dbo.MEMBER M on MS.ID = M.MEMBERSHIPID
                inner join dbo.MEMBERSHIPCARD MC on M.ID = MC.MEMBERID
                outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(M.CONSTITUENTID) NF
                where MS.ID = @MEMBERSHIPID

                end