vwFundRaiserSolicitorSummaries
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| RootFundraiserId | int | yes | |
| FirstName | nvarchar(50) | yes | |
| LastName | nvarchar(50) | yes | |
| Fundraiser | nvarchar(256) | yes | |
| FrsId | int | ||
| TeamName | nvarchar(100) | yes | |
| TeamId | int | yes | |
| Goal | money | yes | |
| AmountRaised | money | yes |
Definition
Copy
CREATE view [dbo].[vwFundRaiserSolicitorSummaries]
as
select
frs.RootFundraiserId,
usr.FirstName,
usr.LastName,
scnt.title Fundraiser,
frs.id FrsId,
frt.Name TeamName,
frt.id TeamId,
frs.goal Goal,
dbo.fnFundraiserSolicitorDonationTotal(frs.id) AmountRaised
from
dbo.fundraiserSolicitors frs
inner join dbo.fundraisers fr on fr.id = frs.rootFundraiserId
inner join dbo.sitecontent scnt on scnt.id = fr.siteContentId
inner join dbo.clientusers usr on frs.ClientUsersId=usr.id and usr.Deleted = 0
left join dbo.fundraiserTeams frt on frs.teamid = frt.id