V_QUERY_MEMBERSHIPBATCHEXCEPTIONREPORT

View used for output for the Membership Batch Exception Report.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
MEMBERSHIPPROGRAMNAME	nvarchar(100)		Membership program name
MEMBERS	nvarchar(max)	yes	Members

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  3/19/2013 1:31:44 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_MEMBERSHIPBATCHEXCEPTIONREPORT AS



            select distinct
                [BATCHMEMBERSHIP].[ID],
                [MEMBERSHIPPROGRAM].[NAME] as [MEMBERSHIPPROGRAMNAME],
                dbo.[UDA_BUILDLIST]([CONSTITUENT].[NAME]) as [MEMBERS]
            from
                dbo.[BATCHMEMBERSHIP]
                inner join dbo.[MEMBERSHIPPROGRAM] on [MEMBERSHIPPROGRAM].[ID] = [BATCHMEMBERSHIP].[MEMBERSHIPPROGRAMID]
                inner join dbo.[BATCHMEMBERSHIPMEMBER] on [BATCHMEMBERSHIPMEMBER].[BATCHMEMBERSHIPID] = [BATCHMEMBERSHIP].[ID]
                inner join dbo.[CONSTITUENT] on [CONSTITUENT].[ID] = [BATCHMEMBERSHIPMEMBER].[CONSTITUENTID]
            group by 
                [BATCHMEMBERSHIP].[ID],
                [MEMBERSHIPPROGRAM].[NAME]