v_FACT_FUNDRAISERTEAMTOTAL
Contains aggregate and factual information about fundraising teams.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| FUNDRAISERTEAMTOTALFACTID | int | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[FUNDRAISERTEAMTOTALFACTID] | |
| FUNDRAISERTEAMSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[FUNDRAISERTEAMSYSTEMID] |
| FUNDRAISERTEAMDIMID | int | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[FUNDRAISERTEAMDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[CONSTITUENTSYSTEMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[CONSTITUENTDIMID] |
| EVENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[EVENTSYSTEMID] |
| EVENTDIMID | int | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[EVENTDIMID] |
| COUNTGROUPS | int | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[COUNTGROUPS] |
| COUNTPARTICIPANTS | int | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[COUNTPARTICIPANTS] |
| COUNTDONORS | int | yes | [BBDW].[FACT_FUNDRAISERTEAMTOTAL].[COUNTDONORS] |
| COUNTGIFTSRECEIVED | int | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[COUNTGIFTSRECEIVED] |
| COUNTGIFTSFROMEMAIL | int | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[COUNTGIFTSFROMEMAIL] |
| COUNTGIFTSFROMSOCIALMEDIA | int | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[COUNTGIFTSFROMSOCIALMEDIA] |
| COUNTONLINEGIFTS | int | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[COUNTONLINEGIFTS] |
| COUNTOFFLINEGIFTS | int | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[COUNTOFFLINEGIFTS] |
| COUNTGIFTSSELFDONATION | int | yes | [BBDW].[FACT_FUNDRAISERTEAMTOTAL].[COUNTGIFTSSELFDONATION] |
| COUNTCOMMUNICATIONSSENT | int | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[COUNTCOMMUNICATIONSSENT] |
| COUNTSOCIALMEDIAPOSTS | int | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[COUNTSOCIALMEDIAPOSTS] |
| COUNTREGISTEREDFOREVENTTYPE | int | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[COUNTREGISTEREDFOREVENTTYPE] |
| PCTGROUPSRETAINED | decimal(9, 2) | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[PCTGROUPSRETAINED] |
| PCTPARTICIPANTSRETAINED | decimal(9, 2) | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[PCTPARTICIPANTSRETAINED] |
| PCTDONORSRETAINED | decimal(9, 2) | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[PCTDONORSRETAINED] |
| PCTZERORAISEDPARTICIPANTS | decimal(9, 2) | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[PCTZERORAISEDPARTICIPANTS] |
| AMOUNTRAISED | money | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[AMOUNTRAISED] |
| AMOUNTFROMEMAIL | money | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[AMOUNTFROMEMAIL] |
| AMOUNTFROMSOCIALMEDIA | money | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[AMOUNTFROMSOCIALMEDIA] |
| AMOUNTONLINE | money | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[AMOUNTONLINE] |
| AMOUNTOFFLINE | money | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[AMOUNTOFFLINE] |
| AMOUNTRAISEDFOREVENTTYPE | money | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[AMOUNTRAISEDFOREVENTTYPE] |
| AMOUNTRAISEDBYPREVIOUSEVENT | money | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[AMOUNTRAISEDBYPREVIOUSEVENT] |
| AMOUNTSELFDONATION | money | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[AMOUNTSELFDONATION] |
| AMOUNTALLREGISTRATIONFEES | money | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[AMOUNTALLREGISTRATIONFEES] |
| AMOUNTRECEIVEDREGISTRATIONFEES | money | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[AMOUNTRECEIVEDREGISTRATIONFEES] |
| AMOUNTPENDING | money | yes | BBDW.[FACT_FUNDRAISERTEAMTOTAL].[AMOUNTPENDING] |
| COUNTGIFTSBYPARTICIPANTS | int | yes | [BBDW].[FACT_FUNDRAISERTEAMTOTAL].[COUNTGIFTSBYPARTICIPANTS] |
| AMOUNTBYPARTICIPANTS | money | yes | [BBDW].[FACT_FUNDRAISERTEAMTOTAL].[AMOUNTBYPARTICIPANTS] |
Definition
Copy
CREATE view [BBDW].[v_FACT_FUNDRAISERTEAMTOTAL] as
select
TT.[FUNDRAISERTEAMTOTALFACTID]
,TT.[FUNDRAISERTEAMSYSTEMID]
,TT.[FUNDRAISERTEAMDIMID]
,TT.[CONSTITUENTSYSTEMID]
,TT.[CONSTITUENTDIMID]
,TT.[EVENTSYSTEMID]
,TT.[EVENTDIMID]
,TT.[COUNTGROUPS]
,TT.[COUNTPARTICIPANTS]
,TT.[COUNTDONORS]
,TT.[COUNTGIFTSRECEIVED]
,TT.[COUNTGIFTSFROMEMAIL]
,TT.[COUNTGIFTSFROMSOCIALMEDIA]
,TT.[COUNTONLINEGIFTS]
,TT.[COUNTOFFLINEGIFTS]
,TT.[COUNTGIFTSSELFDONATION]
,TT.[COUNTCOMMUNICATIONSSENT]
,TT.[COUNTSOCIALMEDIAPOSTS]
,TT.[COUNTREGISTEREDFOREVENTTYPE]
,TT.[PCTGROUPSRETAINED]
,TT.[PCTPARTICIPANTSRETAINED]
,TT.[PCTDONORSRETAINED]
,TT.[PCTZERORAISEDPARTICIPANTS]
,TT.[AMOUNTRAISED]
,TT.[AMOUNTFROMEMAIL]
,TT.[AMOUNTFROMSOCIALMEDIA]
,TT.[AMOUNTONLINE]
,TT.[AMOUNTOFFLINE]
,TT.[AMOUNTRAISEDFOREVENTTYPE]
,TT.[AMOUNTRAISEDBYPREVIOUSEVENT]
,TT.[AMOUNTSELFDONATION]
,TT.[AMOUNTALLREGISTRATIONFEES]
,TT.[AMOUNTRECEIVEDREGISTRATIONFEES]
,TT.[AMOUNTPENDING]
,TT.[COUNTGIFTSBYPARTICIPANTS]
,TT.[AMOUNTBYPARTICIPANTS]
from [BBDW].[FACT_FUNDRAISERTEAMTOTAL] TT