USP_DATALIST_PRINTMEMBERSHIPCARDSPROCESSRESULT

Returns cards that were printed by the print membership cards business process.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@PRINTMEMBERSHIPCARDSPROCESSSTATUSID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_PRINTMEMBERSHIPCARDSPROCESSRESULT
                (
                    @CURRENTAPPUSERID uniqueidentifier = null,
                    @PRINTMEMBERSHIPCARDSPROCESSSTATUSID uniqueidentifier = null
                )
                as
                    set nocount on;

                    declare @LOWERBOUND datetime;
                    set @LOWERBOUND = dbo.UFN_DATE_GETEARLIESTTIME(getdate());

                    select
                        MC.ID,
                        MC.STATUSCODE,
                        dbo.UFN_CONSTITUENT_BUILDNAME(M.CONSTITUENTID) MEMBER,
                        case
                            when MC.STATUSCODE <> 2 and @LOWERBOUND > MC.EXPIRATIONDATE then
                                'Expired'
                            else
                                MC.STATUS
                        end [STATUS],
                        case 
                            when MC.STATUSCODE = 0 then ''
                            else MC.CARDNUMBER
                        end [CARDNUMBER],
                        MC.NAMEONCARD,
                        MC.DATEADDED,
                        MC.EXPIRATIONDATE,
                        MC.COMMENTS,
                        dbo.UFN_CHANGEAGENT_GETUSERNAME(MC.ADDEDBYID) ISSUEDBY
                    from
                        dbo.MEMBERSHIPCARD MC
                    inner join
                        dbo.MEMBER M
                            on MC.MEMBERID = M.ID
                    where
                        MC.PRINTMEMBERSHIPCARDSPROCESSSTATUSID = @PRINTMEMBERSHIPCARDSPROCESSSTATUSID
                    order by
                        MEMBER,
                        MC.DATEADDED