V_QUERY_BBDW_PROSPECTPLAN
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PROSPECTPLANSYSTEMID | uniqueidentifier | yes | |
| PROSPECTPLANDIMID | int | ||
| CONSTITUENTDIMID | int | yes | |
| PROSPECTPLANNAME | nvarchar(100) | yes | |
| PROSPECTPLANSTATUS | nvarchar(100) | yes | |
| PROSPECTPLANTYPE | nvarchar(100) | yes | |
| NARRATIVE | nvarchar(1000) | yes | |
| HISTORICAL | int | ||
| PRIMARYFUNDRAISERDIMID | int | yes | |
| PRIMARYFUNDRAISERSTARTDATEDIMID | int | yes | |
| PRIMARYFUNDRAISERSTARTDATE | datetime | yes | |
| PRIMARYFUNDRAISERENDDATEDIMID | int | yes | |
| PRIMARYFUNDRAISERENDDATE | datetime | yes | |
| SECONDARYFUNDRAISERDIMID | int | yes | |
| SECONDARYFUNDRAISERSTARTDATEDIMID | int | yes | |
| SECONDARYFUNDRAISERSTARTDATE | datetime | yes | |
| SECONDARYFUNDRAISERENDDATEDIMID | int | yes | |
| SECONDARYFUNDRAISERENDDATE | datetime | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_PROSPECTPLAN] as
select
pp.[PROSPECTPLANSYSTEMID],
pp.[PROSPECTPLANDIMID],
pp.[CONSTITUENTDIMID],
pp.[PROSPECTPLANNAME],
pp.[PROSPECTPLANSTATUS],
pp.[PROSPECTPLANTYPE],
pp.[NARRATIVE],
case pp.[PROSPECTPLANISACTIVE] when 1 then 0 else 1 end [HISTORICAL],
pp.[PRIMARYFUNDRAISERDIMID],
pp.[PRIMARYFUNDRAISERSTARTDATEDIMID],
pp.[PRIMARYFUNDRAISERSTARTDATE],
pp.[PRIMARYFUNDRAISERENDDATEDIMID],
pp.[PRIMARYFUNDRAISERENDDATE],
pp.[SECONDARYFUNDRAISERDIMID],
pp.[SECONDARYFUNDRAISERSTARTDATEDIMID],
pp.[SECONDARYFUNDRAISERSTARTDATE],
pp.[SECONDARYFUNDRAISERENDDATEDIMID],
pp.[SECONDARYFUNDRAISERENDDATE]
from BBDW.[DIM_PROSPECTPLAN] pp
where [PROSPECTPLANDIMID] > 0