USP_MEMBERSHIPPROGRAMCONTRIBUTION_GETPROGRAMCRITERIA

Parameters

Parameter	Parameter Type	Mode
@MEMBERSHIPPROGRAMID	uniqueidentifier	IN
@CRITERIADEFINITIONTYPECODE	tinyint	INOUT
@ISPAYMENTCOUNTED	bit	INOUT
@ISPLEDGECOUNTED	bit	INOUT
@ISRECURRINGGIFTCOUNTED	bit	INOUT
@INCLUDEPAYMENTACTIVITYTYPECODE	tinyint	INOUT
@DESIGNATIONID	uniqueidentifier	INOUT
@IDSETREGISTERID	uniqueidentifier	INOUT
@ISEVENTREGISTRATIONCOUNTED	bit	INOUT
@INCLUDEEVENTTYPECODE	tinyint	INOUT
@EVENTCATEGORYCODEID	uniqueidentifier	INOUT
@ISMEMBERSHIPDUECOUNTED	bit	INOUT
@INCLUDEMEMBERSHIPTYPECODE	tinyint	INOUT
@CONTRIBUTIONMEMBERSHIPPROGRAMID	uniqueidentifier	INOUT
@APPLICATIONSELECTIONID	uniqueidentifier	INOUT
@ISMULTIPLEREVENUETRANSACTIONSCOUNTED	bit	INOUT
@WHATDATETOCALCULATEEXPIRATIONDATECODE	tinyint	INOUT
@WHATHAPPENSIFTHEYGIVEMORECODE	tinyint	INOUT

Definition

Copy



create procedure dbo.USP_MEMBERSHIPPROGRAMCONTRIBUTION_GETPROGRAMCRITERIA (
    @MEMBERSHIPPROGRAMID uniqueidentifier = null,

    --Criteria type

    @CRITERIADEFINITIONTYPECODE tinyint = null output,

    --System-defined application filter options

    @ISPAYMENTCOUNTED bit = null output,
    @ISPLEDGECOUNTED bit = null output,
    @ISRECURRINGGIFTCOUNTED bit = null output,

    @INCLUDEPAYMENTACTIVITYTYPECODE tinyint = null output,
    @DESIGNATIONID uniqueidentifier = null output,
    @IDSETREGISTERID uniqueidentifier = null output,

    @ISEVENTREGISTRATIONCOUNTED bit = null output,
    @INCLUDEEVENTTYPECODE tinyint = null output,
    @EVENTCATEGORYCODEID uniqueidentifier = null output,

    @ISMEMBERSHIPDUECOUNTED bit = null output,
    @INCLUDEMEMBERSHIPTYPECODE tinyint = null output,
    @CONTRIBUTIONMEMBERSHIPPROGRAMID uniqueidentifier = null output,

    --Application selection

    @APPLICATIONSELECTIONID uniqueidentifier = null output,

    @ISMULTIPLEREVENUETRANSACTIONSCOUNTED bit = null output,
    @WHATDATETOCALCULATEEXPIRATIONDATECODE tinyint = null output,
    @WHATHAPPENSIFTHEYGIVEMORECODE tinyint = null output
)
as
begin
    -- Pull all useful information about the membership program

    select 
        @CRITERIADEFINITIONTYPECODE = MEMBERSHIPPROGRAMCONTRIBUTION.CRITERIADEFINITIONTYPECODE,

        @ISPAYMENTCOUNTED = MEMBERSHIPPROGRAMCONTRIBUTION.ISPAYMENTCOUNTED,
        @ISPLEDGECOUNTED = MEMBERSHIPPROGRAMCONTRIBUTION.ISPLEDGECOUNTED,
        @ISRECURRINGGIFTCOUNTED = MEMBERSHIPPROGRAMCONTRIBUTION.ISRECURRINGGIFTCOUNTED,

        @INCLUDEPAYMENTACTIVITYTYPECODE = MEMBERSHIPPROGRAMCONTRIBUTION.INCLUDEPAYMENTACTIVITYTYPECODE,
        @DESIGNATIONID = MEMBERSHIPPROGRAMCONTRIBUTION.DESIGNATIONID,
        @IDSETREGISTERID = MEMBERSHIPPROGRAMCONTRIBUTION.IDSETREGISTERID,

        @ISEVENTREGISTRATIONCOUNTED = MEMBERSHIPPROGRAMCONTRIBUTION.ISEVENTREGISTRATIONCOUNTED,
        @INCLUDEEVENTTYPECODE = MEMBERSHIPPROGRAMCONTRIBUTION.INCLUDEEVENTTYPECODE,
        @EVENTCATEGORYCODEID = MEMBERSHIPPROGRAMCONTRIBUTION.EVENTCATEGORYCODEID,

        @ISMEMBERSHIPDUECOUNTED = MEMBERSHIPPROGRAMCONTRIBUTION.ISMEMBERSHIPDUECOUNTED,
        @INCLUDEMEMBERSHIPTYPECODE = MEMBERSHIPPROGRAMCONTRIBUTION.INCLUDEMEMBERSHIPTYPECODE,
        @CONTRIBUTIONMEMBERSHIPPROGRAMID = MEMBERSHIPPROGRAMCONTRIBUTION.MEMBERSHIPPROGRAMID,

        @APPLICATIONSELECTIONID = MEMBERSHIPPROGRAMCONTRIBUTION.APPLICATIONSELECTIONID,

        @ISMULTIPLEREVENUETRANSACTIONSCOUNTED  = MEMBERSHIPPROGRAMCONTRIBUTION.ISMULTIPLEREVENUETRANSACTIONSCOUNTED,
        @WHATHAPPENSIFTHEYGIVEMORECODE = MEMBERSHIPPROGRAMCONTRIBUTION.WHATHAPPENSIFTHEYGIVEMORECODE,
        @WHATDATETOCALCULATEEXPIRATIONDATECODE = MEMBERSHIPPROGRAMCONTRIBUTION.WHATDATETOCALCULATEEXPIRATIONDATECODE
    from dbo.MEMBERSHIPPROGRAMCONTRIBUTION
    where MEMBERSHIPPROGRAMCONTRIBUTION.ID = @MEMBERSHIPPROGRAMID
end