V_NFGLEVEL_SUMMARYINFO
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| NAME | nvarchar(100) | ||
| CONTACTID | uniqueidentifier | yes | |
| NFGTYPECODEID | uniqueidentifier | yes | |
| CAMPAIGNID | uniqueidentifier | ||
| TOTALRAISED | money | ||
| TOTALDONOR | int | ||
| TOTALGIFT | int | ||
| TOTALGROUP | int | ||
| TOTALCOMMUNICATIONSENT | int | ||
| TOTALPARTICIPANT | int |
Definition
Copy
create view dbo.V_NFGLEVEL_SUMMARYINFO as
select
NLS.ID,
C.NAME,
C.CONTACTID,
C.NFGTYPECODEID,
C.CAMPAIGNID,
NLS.TOTALRAISED,
NLS.TOTALDONOR ,
NLS.TOTALGIFT ,
NLS.TOTALGROUP,
NLS.TOTALCOMMUNICATIONSENT ,
NLS.TOTALPARTICIPANT
from dbo.FAFNFGLEVELSUMMARY NLS (nolock)
join dbo.FAFNFGCAMPAIGN C (nolock) on NLS.NFGID = C.ID
where NLS.ISROOT = 0