v_DIM_PROSPECTPLAN
Contains information about prospect plans.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PROSPECTPLANDIMID | int | BBDW.[DIM_PROSPECTPLAN].[PROSPECTPLANDIMID] | |
| PROSPECTPLANSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PROSPECTPLAN].[PROSPECTPLANSYSTEMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PROSPECTPLAN].[CONSTITUENTSYSTEMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[DIM_PROSPECTPLAN].[CONSTITUENTDIMID] |
| PROSPECTSTATUS | nvarchar(100) | yes | BBDW.[DIM_PROSPECTPLAN].[PROSPECTSTATUS] |
| RESEARCHSTATUSCONFIRMED | bit | yes | BBDW.[DIM_PROSPECTPLAN].[RESEARCHSTATUSCONFIRMED] |
| PROSPECTPLANNAME | nvarchar(100) | yes | BBDW.[DIM_PROSPECTPLAN].[PROSPECTPLANNAME] |
| PROSPECTPLANSTATUS | nvarchar(100) | yes | BBDW.[DIM_PROSPECTPLAN].[PROSPECTPLANSTATUS] |
| PROSPECTPLANTYPE | nvarchar(100) | yes | BBDW.[DIM_PROSPECTPLAN].[PROSPECTPLANTYPE] |
| PROSPECTMANAGERFUNDRAISERDIMID | int | yes | BBDW.[DIM_PROSPECTPLAN].[PROSPECTMANAGERFUNDRAISERDIMID] |
| PRIMARYFUNDRAISERDIMID | int | yes | BBDW.[DIM_PROSPECTPLAN].[PRIMARYFUNDRAISERDIMID] |
| SECONDARYFUNDRAISERDIMID | int | yes | BBDW.[DIM_PROSPECTPLAN].[SECONDARYFUNDRAISERDIMID] |
| PRIMARYFUNDRAISERSTARTDATE | datetime | yes | BBDW.[DIM_PROSPECTPLAN].[PRIMARYFUNDRAISERSTARTDATE] |
| PRIMARYFUNDRAISERSTARTDATEDIMID | int | yes | BBDW.[DIM_PROSPECTPLAN].[PRIMARYFUNDRAISERSTARTDATEDIMID] |
| PRIMARYFUNDRAISERENDDATE | datetime | yes | BBDW.[DIM_PROSPECTPLAN].[PRIMARYFUNDRAISERENDDATE] |
| PRIMARYFUNDRAISERENDDATEDIMID | int | yes | BBDW.[DIM_PROSPECTPLAN].[PRIMARYFUNDRAISERENDDATEDIMID] |
| SECONDARYFUNDRAISERSTARTDATE | datetime | yes | BBDW.[DIM_PROSPECTPLAN].[SECONDARYFUNDRAISERSTARTDATE] |
| SECONDARYFUNDRAISERSTARTDATEDIMID | int | yes | BBDW.[DIM_PROSPECTPLAN].[SECONDARYFUNDRAISERSTARTDATEDIMID] |
| SECONDARYFUNDRAISERENDDATE | datetime | yes | BBDW.[DIM_PROSPECTPLAN].[SECONDARYFUNDRAISERENDDATE] |
| SECONDARYFUNDRAISERENDDATEDIMID | int | yes | BBDW.[DIM_PROSPECTPLAN].[SECONDARYFUNDRAISERENDDATEDIMID] |
| NARRATIVE | nvarchar(1000) | yes | BBDW.[DIM_PROSPECTPLAN].[NARRATIVE] |
| PROSPECTPLANISACTIVE | bit | yes | BBDW.[DIM_PROSPECTPLAN].[PROSPECTPLANISACTIVE] |
Definition
Copy
create view [BBDW].[v_DIM_PROSPECTPLAN] as
select
[PROSPECTPLANDIMID],
[PROSPECTPLANSYSTEMID],
[CONSTITUENTSYSTEMID],
[CONSTITUENTDIMID],
[PROSPECTSTATUS],
[RESEARCHSTATUSCONFIRMED],
[PROSPECTPLANNAME],
[PROSPECTPLANSTATUS],
[PROSPECTPLANTYPE],
[PROSPECTMANAGERFUNDRAISERDIMID],
[PRIMARYFUNDRAISERDIMID],
[SECONDARYFUNDRAISERDIMID],
[PRIMARYFUNDRAISERSTARTDATE],
[PRIMARYFUNDRAISERSTARTDATEDIMID],
[PRIMARYFUNDRAISERENDDATE],
[PRIMARYFUNDRAISERENDDATEDIMID],
[SECONDARYFUNDRAISERSTARTDATE],
[SECONDARYFUNDRAISERSTARTDATEDIMID],
[SECONDARYFUNDRAISERENDDATE],
[SECONDARYFUNDRAISERENDDATEDIMID],
[NARRATIVE],
[PROSPECTPLANISACTIVE]
from [BBDW].[DIM_PROSPECTPLAN];