V_QUERY_MEMBERSHIPBATCHCONTROLREPORT
View used for output for Membership Batch Control 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_MEMBERSHIPBATCHCONTROLREPORT AS
select distinct
[MEMBERSHIP].[ID],
[MEMBERSHIPPROGRAM].[NAME] as [MEMBERSHIPPROGRAMNAME],
dbo.[UDA_BUILDLIST]([CONSTITUENT].[NAME]) as [MEMBERS]
from
dbo.[MEMBERSHIP]
inner join dbo.[MEMBERSHIPPROGRAM] on [MEMBERSHIPPROGRAM].[ID] = [MEMBERSHIP].[MEMBERSHIPPROGRAMID]
inner join dbo.[MEMBER] on [MEMBER].[MEMBERSHIPID] = [MEMBERSHIP].[ID]
inner join dbo.[CONSTITUENT] on [CONSTITUENT].[ID] = [MEMBER].[CONSTITUENTID]
group by
[MEMBERSHIP].[ID],
[MEMBERSHIPPROGRAM].[NAME]