v_DIM_PROSPECT
Contains information about prospects.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTDIMID | int | yes | BBDW.[DIM_PROSPECT].[CONSTITUENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PROSPECT].[CONSTITUENTSYSTEMID] |
| FUNDRAISERDIMID | int | yes | BBDW.[DIM_PROSPECT].[FUNDRAISERDIMID] |
| ISRESEARCHSTATUSCONFIRMED | bit | yes | BBDW.[DIM_PROSPECT].[ISRESEARCHSTATUSCONFIRMED] |
| PROSPECTSTATUS | nvarchar(100) | yes | BBDW.[DIM_PROSPECT].[PROSPECTSTATUS] |
| PROSPECTMANAGERSTARTDATE | datetime | yes | BBDW.[DIM_PROSPECT].[PROSPECTMANAGERSTARTDATE] |
| PROSPECTMANAGERENDDATE | datetime | yes | BBDW.[DIM_PROSPECT].[PROSPECTMANAGERENDDATE] |
| PROSPECTMANAGERSTARTDATEDIMID | int | yes | BBDW.[DIM_PROSPECT].[PROSPECTMANAGERSTARTDATEDIMID] |
| PROSPECTMANAGERENDDATEDIMID | int | yes | BBDW.[DIM_PROSPECT].[PROSPECTMANAGERENDDATEDIMID] |
| FUNDRAISERSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PROSPECT].[FUNDRAISERSYSTEMID] |
| PROSPECTDIMID | int | BBDW.[DIM_PROSPECT].[PROSPECTDIMID] | |
| PROSPECTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_PROSPECT].[PROSPECTSYSTEMID] |
Definition
Copy
create view [BBDW].[v_DIM_PROSPECT] as
select
[CONSTITUENTDIMID],
[CONSTITUENTSYSTEMID],
[FUNDRAISERDIMID],
[ISRESEARCHSTATUSCONFIRMED],
[PROSPECTSTATUS],
[PROSPECTMANAGERSTARTDATE],
[PROSPECTMANAGERENDDATE],
[PROSPECTMANAGERSTARTDATEDIMID],
[PROSPECTMANAGERENDDATEDIMID],
[FUNDRAISERSYSTEMID],
[PROSPECTDIMID],
[PROSPECTSYSTEMID]
from [BBDW].[DIM_PROSPECT];