V_QUERY_MEMBERSHIPPROGRAMCAMPAIGN

Provides the ability to query membership program campaigns.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
MEMBERSHIPPROGRAMID	uniqueidentifier		Membership program ID
CAMPAIGNID	uniqueidentifier		Campaign ID
DATEFROM	datetime	yes	Date from
DATETO	datetime	yes	Date to
CAMPAIGNNAME	nvarchar(100)	yes	Campaign name
CAMPAIGNSUBPRIORITYNAMECODEID_TRANSLATION	nvarchar(100)	yes	Campaign subpriority name
CAMPAIGNSUBPRIORITYGOAL	money	yes	Campaign subpriority goal
ADDEDBY_APPLICATION	nvarchar(200)	yes	Added by application
ADDEDBY_USERNAME	nvarchar(128)	yes	Added by user name
CHANGEDBY_APPLICATION	nvarchar(200)	yes	Changed by application
CHANGEDBY_USERNAME	nvarchar(128)	yes	Changed by user name
DATEADDED	datetime		Date added
DATECHANGED	datetime		Date changed
TSLONG	bigint	yes	Timestamp value
CAMPAIGNBASECURRENCYID	uniqueidentifier	yes	Campaign base currency ID
CAMPAIGNSUBPRIORITYID	uniqueidentifier	yes	Campaign subpriority ID

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:36:22 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_MEMBERSHIPPROGRAMCAMPAIGN AS



                select
                    MPC.ID,
                    MPC.MEMBERSHIPPROGRAMID,
                    MPC.CAMPAIGNID,
                    MPC.DATEFROM,
                    MPC.DATETO,
                    C.NAME as CAMPAIGNNAME,
                    CSN.DESCRIPTION as [CAMPAIGNSUBPRIORITYNAMECODEID_TRANSLATION],
                    CS.GOAL as CAMPAIGNSUBPRIORITYGOAL,
                    [ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
                    [ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
                    [CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
                    [CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME],
                    MPC.DATEADDED,
                    MPC.DATECHANGED,
                    MPC.TSLONG,
                    C.BASECURRENCYID as CAMPAIGNBASECURRENCYID,
                    MPC.CAMPAIGNSUBPRIORITYID
                    /*#EXTENSION*/ 
                from
                    dbo.MEMBERSHIPPROGRAMCAMPAIGN MPC
                    left join dbo.CAMPAIGN C on MPC.CAMPAIGNID = C.ID
                    left join dbo.CAMPAIGNSUBPRIORITY CS on MPC.CAMPAIGNSUBPRIORITYID = CS.ID
                    left join dbo.CAMPAIGNSUBPRIORITYNAMECODE CSN on CSN.ID = CS.CAMPAIGNSUBPRIORITYNAMECODEID
                    left join dbo.CHANGEAGENT as [ADDEDBY] on ADDEDBY.ID = MPC.ADDEDBYID
                    left join dbo.CHANGEAGENT as [CHANGEDBY] on CHANGEDBY.ID = MPC.CHANGEDBYID