V_NFG_SUMMARYINFO
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | yes | |
| NAME | nvarchar(100) | ||
| CONTACTID | uniqueidentifier | yes | |
| NFGTYPECODEID | uniqueidentifier | yes | |
| CAMPAIGNID | uniqueidentifier | ||
| TOTALRAISED | money | ||
| DONORCNT | int | ||
| GIFTCOUNT | int | ||
| TOTALGROUP | int | ||
| COMMSENT | int | ||
| TOTALPARTICIPANTS | int | ||
| TOTALGROUPRETAINED | int | ||
| GROUPRETENTIONRATE | decimal(11, 4) | yes | |
| TOTALPARTICIPANTRETAINED | int | ||
| PARTICIPANTRETENTIONRATE | decimal(11, 4) | yes |
Definition
Copy
CREATE view dbo.V_NFG_SUMMARYINFO as
select
NLS.NFGID as ID,
C.NAME,
C.CONTACTID,
C.NFGTYPECODEID,
C.CAMPAIGNID,
NLS.TOTALRAISED,
NLS.TOTALDONOR as DONORCNT,
NLS.TOTALGIFT as GIFTCOUNT,
NLS.TOTALGROUP,
NLS.TOTALCOMMUNICATIONSENT AS COMMSENT,
NLS.TOTALPARTICIPANT AS TOTALPARTICIPANTS,
NLS.TOTALGROUPRETAINED,
NLS.GROUPRETENTIONRATE * 100 as GROUPRETENTIONRATE,
NLS.TOTALPARTICIPANTRETAINED,
NLS.PARTICIPANTRETENTIONRATE * 100 as PARTICIPANTRETENTIONRATE
from dbo.FAFNFGLEVELSUMMARY NLS (nolock)
join dbo.FAFNFGCAMPAIGN C (nolock) on NLS.NFGID = C.ID
where NLS.ISROOT = 1