V_QUERY_BBNCMEMBERSHIPBATCHEXCEPTIONREPORT

View used for output by the Blackbaud Internet Solutions Membership Transaction Batch Exception Report.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
MEMBERSHIPPROGRAM	nvarchar(100)	yes	Membership program
MEMBERSHIPLEVEL	nvarchar(100)	yes	Membership level
PRIMARYMEMBER	nvarchar(154)	yes	Primary member

Definition

Copy

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



            select
                BATCHBBNCMEMBERSHIP.ID,
                MEMBERSHIPPROGRAM.NAME as [MEMBERSHIPPROGRAM],
                MEMBERSHIPLEVEL.NAME as [MEMBERSHIPLEVEL],
                (
                    select top 1 dbo.UFN_CONSTITUENT_BUILDNAME(MEMBERCONSTITUENTID)
                    from dbo.BATCHBBNCMEMBERSHIPMEMBER where BATCHBBNCMEMBERSHIPMEMBER.BATCHBBNCMEMBERSHIPID = BATCHBBNCMEMBERSHIP.ID
                    order by SEQUENCE asc
                ) as [PRIMARYMEMBER]
            from dbo.BATCHBBNCMEMBERSHIP
            left join dbo.MEMBERSHIPPROGRAM on MEMBERSHIPPROGRAM.ID = BATCHBBNCMEMBERSHIP.MEMBERSHIPPROGRAMID
            left join MEMBERSHIPLEVEL on MEMBERSHIPLEVEL.ID = BATCHBBNCMEMBERSHIP.MEMBERSHIPLEVELID