vwFundraiserParticipants

Fields

Field	Field Type	Null
RootFundraiserId	int	yes
FrsId	int
FirstName	nvarchar(50)	yes
LastName	nvarchar(50)	yes
TeamName	nvarchar(100)	yes
BackofficeSolicitorId	int	yes
UserId	int
ParentId	int	yes
TeamId	int	yes
Goal	money	yes
AmountRaised	money	yes
RecruiterId	int	yes
Inactive	bit
IsDirty	bit
AthonUnits	int
AthonLocked	bit
Personalization	ntext	yes
BackofficeTeamId	int	yes

Definition

Copy



        create view [dbo].[vwFundraiserParticipants]
            as
            select
                frs.RootFundraiserId RootFundraiserId,
                frs.id FrsId,
                cu.FirstName FirstName, 
                cu.LastName LastName,
                frt.Name TeamName,
                frs.BackofficeId BackofficeSolicitorId,
                frs.ClientUsersId UserId,
                frs.FundraiserId ParentId,
                frs.TeamId TeamId,
                frs.Goal Goal,
                dbo.fnFundraiserSolicitorDonationTotal(frs.id) AmountRaised,
                frs.RecruiterId RecruiterId,
                frs.Inactive Inactive,
                frs.Dirty IsDirty,
                frs.AthonUnits AthonUnits,
                frs.AthonLocked AthonLocked,
                frs.Personalization Personalization,
                frt.BackOfficeId BackofficeTeamId
            from 
                FundraiserSolicitors frs left join FundraiserTeams frt on frs.teamid=frt.id
                inner join clientusers cu on cu.id=frs.clientusersid