v_FACT_OPPORTUNITY
Contains information about prospect opportunities.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| OPPORTUNITYFACTID | int | BBDW.[FACT_OPPORTUNITY].[OPPORTUNITYFACTID] | |
| OPPORTUNITYSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_OPPORTUNITY].[OPPORTUNITYSYSTEMID] |
| PROSPECTPLANDIMID | int | yes | BBDW.[FACT_OPPORTUNITY].[PROSPECTPLANDIMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[FACT_OPPORTUNITY].[CONSTITUENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_OPPORTUNITY].[CONSTITUENTSYSTEMID] |
| PRIMARYFUNDRAISERDIMID | int | yes | BBDW.[FACT_OPPORTUNITY].[PRIMARYFUNDRAISERDIMID] |
| SECONDARYFUNDRAISERDIMID | int | yes | BBDW.[FACT_OPPORTUNITY].[SECONDARYFUNDRAISERDIMID] |
| OPPORTUNITYSTATUS | nvarchar(100) | yes | BBDW.[FACT_OPPORTUNITY].[OPPORTUNITYSTATUS] |
| OPPORTUNITYTYPE | nvarchar(100) | yes | BBDW.[FACT_OPPORTUNITY].[OPPORTUNITYTYPE] |
| OPPORTUNITYLIKELIHOODTYPE | nvarchar(100) | yes | BBDW.[FACT_OPPORTUNITY].[OPPORTUNITYLIKELIHOODTYPE] |
| EXPECTEDASKAMOUNT | money | yes | BBDW.[FACT_OPPORTUNITY].[EXPECTEDASKAMOUNT] |
| EXPECTEDASKDATE | datetime | yes | BBDW.[FACT_OPPORTUNITY].[EXPECTEDASKDATE] |
| EXPECTEDASKDATEDIMID | int | yes | BBDW.[FACT_OPPORTUNITY].[EXPECTEDASKDATEDIMID] |
| ASKAMOUNT | money | yes | BBDW.[FACT_OPPORTUNITY].[ASKAMOUNT] |
| ASKDATE | datetime | yes | BBDW.[FACT_OPPORTUNITY].[ASKDATE] |
| ASKDATEDIMID | int | yes | BBDW.[FACT_OPPORTUNITY].[ASKDATEDIMID] |
| OPPORTUNITYAMOUNT | money | yes | BBDW.[FACT_OPPORTUNITY].[OPPORTUNITYAMOUNT] |
| RESPONSEDATE | datetime | yes | BBDW.[FACT_OPPORTUNITY].[RESPONSEDATE] |
| RESPONSEDATEDIMID | int | yes | BBDW.[FACT_OPPORTUNITY].[RESPONSEDATEDIMID] |
Definition
Copy
create view [BBDW].[v_FACT_OPPORTUNITY] as
select
[FACT_OPPORTUNITY].[OPPORTUNITYFACTID],
[FACT_OPPORTUNITY].[OPPORTUNITYSYSTEMID],
[FACT_OPPORTUNITY].[PROSPECTPLANDIMID],
[FACT_OPPORTUNITY].[CONSTITUENTDIMID],
[FACT_OPPORTUNITY].[CONSTITUENTSYSTEMID],
[FACT_OPPORTUNITY].[PRIMARYFUNDRAISERDIMID],
[FACT_OPPORTUNITY].[SECONDARYFUNDRAISERDIMID],
[FACT_OPPORTUNITY].[OPPORTUNITYSTATUS],
[FACT_OPPORTUNITY].[OPPORTUNITYTYPE],
[FACT_OPPORTUNITY].[OPPORTUNITYLIKELIHOODTYPE],
[FACT_OPPORTUNITY].[EXPECTEDASKAMOUNT],
[FACT_OPPORTUNITY].[EXPECTEDASKDATE],
[FACT_OPPORTUNITY].[EXPECTEDASKDATEDIMID],
[FACT_OPPORTUNITY].[ASKAMOUNT],
[FACT_OPPORTUNITY].[ASKDATE],
[FACT_OPPORTUNITY].[ASKDATEDIMID],
[FACT_OPPORTUNITY].[OPPORTUNITYAMOUNT],
[FACT_OPPORTUNITY].[RESPONSEDATE],
[FACT_OPPORTUNITY].[RESPONSEDATEDIMID]
from [BBDW].[FACT_OPPORTUNITY];