v_FACT_FUNDRAISERINTERACTIONADDITIONAL
Contains information about additional participants on an interaction.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| FUNDRAISERINTERACTIONADDITIONALFACTID | int | BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL].[FUNDRAISERINTERACTIONADDITIONALSYSTEMID] | |
| FUNDRAISERINTERACTIONADDITIONALSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL].[FUNDRAISERINTERACTIONADDITIONALSYSTEMID] |
| INTERACTIONFACTID | int | yes | BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL].[INTERACTIONFACTID] |
| INTERACTIONSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL].[INTERACTIONSYSTEMID] |
| ADDITIONALFUNDRAISERDIMID | int | yes | BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL].[ADDITIONALFUNDRAISERDIMID] |
| ADDITIONALFUNDRAISERSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL].[ADDITIONALFUNDRAISERSYSTEMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL].[CONSTITUENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL].[CONSTITUENTSYSTEMID] |
| FUNDRAISERDIMID | int | yes | BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL].[FUNDRAISERDIMID] |
| FUNDRAISERSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL].[FUNDRAISERSYSTEMID] |
| INTERACTIONDATEDIMID | int | yes | BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL].[INTERACTIONDATEDIMID] |
| INTERACTIONDATE | datetime | yes | BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL].[INTERACTIONDATE] |
| INTERACTIONDIMID | int | yes | BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL].[INTERACTIONDIMID] |
| EVENTDIMID | int | yes | BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL].[EVENTDIMID] |
| PROSPECTPLANDIMID | int | yes | BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL].[PROSPECTPLANDIMID] |
| PLANOUTLINESTEPDIMID | int | yes | BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL].[PLANOUTLINESTEPDIMID] |
| PROSPECTPLANSTATUSDIMID | int | yes | BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL].[PROSPECTPLANSTATUSDIMID] |
| FUNDINGREQUESTDIMID | int | yes | BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL].[FUNDINGREQUESTDIMID] |
| FUNDINGREQUESTOUTLINESTEPDIMID | int | yes | BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL].[FUNDINGREQUESTOUTLINESTEPDIMID] |
Definition
Copy
CREATE view [BBDW].[v_FACT_FUNDRAISERINTERACTIONADDITIONAL] as
select
[FACT_FUNDRAISERINTERACTIONADDITIONAL].[FUNDRAISERINTERACTIONADDITIONALFACTID],
[FACT_FUNDRAISERINTERACTIONADDITIONAL].[FUNDRAISERINTERACTIONADDITIONALSYSTEMID],
[FACT_FUNDRAISERINTERACTIONADDITIONAL].[INTERACTIONFACTID],
[FACT_FUNDRAISERINTERACTIONADDITIONAL].[INTERACTIONSYSTEMID],
[FACT_FUNDRAISERINTERACTIONADDITIONAL].[ADDITIONALFUNDRAISERDIMID],
[FACT_FUNDRAISERINTERACTIONADDITIONAL].[ADDITIONALFUNDRAISERSYSTEMID],
[FACT_FUNDRAISERINTERACTIONADDITIONAL].[CONSTITUENTDIMID],
[FACT_FUNDRAISERINTERACTIONADDITIONAL].[CONSTITUENTSYSTEMID],
[FACT_FUNDRAISERINTERACTIONADDITIONAL].[FUNDRAISERDIMID],
[FACT_FUNDRAISERINTERACTIONADDITIONAL].[FUNDRAISERSYSTEMID],
[FACT_FUNDRAISERINTERACTIONADDITIONAL].[INTERACTIONDATEDIMID],
[FACT_FUNDRAISERINTERACTIONADDITIONAL].[INTERACTIONDATE],
[FACT_FUNDRAISERINTERACTIONADDITIONAL].[INTERACTIONDIMID],
[FACT_FUNDRAISERINTERACTIONADDITIONAL].[EVENTDIMID],
[FACT_FUNDRAISERINTERACTIONADDITIONAL].[PROSPECTPLANDIMID],
[FACT_FUNDRAISERINTERACTIONADDITIONAL].[PLANOUTLINESTEPDIMID],
[FACT_FUNDRAISERINTERACTIONADDITIONAL].[PROSPECTPLANSTATUSDIMID],
[FACT_FUNDRAISERINTERACTIONADDITIONAL].[FUNDINGREQUESTDIMID],
[FACT_FUNDRAISERINTERACTIONADDITIONAL].[FUNDINGREQUESTOUTLINESTEPDIMID]
from BBDW.[FACT_FUNDRAISERINTERACTIONADDITIONAL];