V_QUERY_TEAMFUNDRAISINGTEAMMEMBER

Provides the ability to query for members of team fundraising teams.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
TEAMFUNDRAISERID	uniqueidentifier		Team fundraiser record ID
CONSTITUENTID	uniqueidentifier		Constituent record ID
NAME	nvarchar(154)	yes	Name
ISTEAMCAPTAIN	bit	yes	Is team captain
TEAMFUNDRAISINGTEAMID	uniqueidentifier	yes	Team fundraising team record ID
DATEADDED	datetime		Date added
DATECHANGED	datetime		Date changed
TSLONG	bigint	yes	Timestamp value
ADDEDBYAPPLICATION	nvarchar(200)	yes	Added by application
ADDEDBYUSERNAME	nvarchar(128)	yes	Added by user name
CHANGEDBYAPPLICATION	nvarchar(200)	yes	Changed by application
CHANGEDBYUSERNAME	nvarchar(128)	yes	Changed by user name

Definition

Copy

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



                select
                    TEAMFUNDRAISINGTEAMMEMBER.ID,
                    TEAMFUNDRAISINGTEAMMEMBER.TEAMFUNDRAISERID,
                    TEAMFUNDRAISER.CONSTITUENTID,
                    dbo.UFN_CONSTITUENT_BUILDNAME(TEAMFUNDRAISER.CONSTITUENTID) [NAME],
                    cast((case when TEAMFUNDRAISINGTEAMCAPTAIN.ID is null then 0 else 1 end) as bit) [ISTEAMCAPTAIN],
                    TEAMFUNDRAISINGTEAMMEMBER.TEAMFUNDRAISINGTEAMID,
                    TEAMFUNDRAISINGTEAMMEMBER.DATEADDED,
                    TEAMFUNDRAISINGTEAMMEMBER.DATECHANGED,
                    TEAMFUNDRAISINGTEAMMEMBER.TSLONG,
                    ADDEDBY.APPLICATIONNAME as ADDEDBYAPPLICATION,
                    ADDEDBY.USERNAME as ADDEDBYUSERNAME,
                    CHANGEDBY.APPLICATIONNAME as CHANGEDBYAPPLICATION,
                    CHANGEDBY.USERNAME as CHANGEDBYUSERNAME
                    /*#EXTENSION*/ 
                from
                    dbo.TEAMFUNDRAISINGTEAMMEMBER
                    left join dbo.CHANGEAGENT as ADDEDBY on ADDEDBY.ID = TEAMFUNDRAISINGTEAMMEMBER.ADDEDBYID
                    left join dbo.CHANGEAGENT as CHANGEDBY on CHANGEDBY.ID = TEAMFUNDRAISINGTEAMMEMBER.CHANGEDBYID
                    inner join dbo.TEAMFUNDRAISER on TEAMFUNDRAISINGTEAMMEMBER.TEAMFUNDRAISERID = TEAMFUNDRAISER.ID
                    left join dbo.TEAMFUNDRAISINGTEAMCAPTAIN on
                        TEAMFUNDRAISINGTEAMMEMBER.TEAMFUNDRAISINGTEAMID = TEAMFUNDRAISINGTEAMCAPTAIN.TEAMFUNDRAISINGTEAMID
                        and TEAMFUNDRAISER.CONSTITUENTID = TEAMFUNDRAISINGTEAMCAPTAIN.CONSTITUENTID