v_FACT_INTERACTIONPARTICIPANT
Contains information about additional participants on an interaction.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| INTERACTIONPARTICIPANTFACTID | int | BBDW.[FACT_INTERACTIONPARTICIPANT].[INTERACTIONPARTICIPANTFACTID] | |
| INTERACTIONPARTICIPANTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_INTERACTIONPARTICIPANT].[INTERACTIONPARTICIPANTSYSTEMID] |
| INTERACTIONFACTID | int | yes | BBDW.[FACT_INTERACTIONPARTICIPANT].[INTERACTIONFACTID] |
| INTERACTIONSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_INTERACTIONPARTICIPANT].[INTERACTIONSYSTEMID] |
| PARTICIPANTCONSTITUENTDIMID | int | yes | BBDW.[FACT_INTERACTIONPARTICIPANT].[PARTICIPANTCONSTITUENTDIMID] |
| PARTICIPANTCONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_INTERACTIONPARTICIPANT].[PARTICIPANTCONSTITUENTSYSTEMID] |
| INTERACTIONCONSTITUENTDIMID | int | yes | BBDW.[FACT_INTERACTIONPARTICIPANT].[INTERACTIONCONSTITUENTDIMID] |
| INTERACTIONCONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_INTERACTIONPARTICIPANT].[INTERACTIONCONSTITUENTSYSTEMID] |
| FUNDRAISERDIMID | int | yes | BBDW.[FACT_INTERACTIONPARTICIPANT].[FUNDRAISERDIMID] |
| FUNDRAISERSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_INTERACTIONPARTICIPANT].[FUNDRAISERSYSTEMID] |
| INTERACTIONDATEDIMID | int | yes | BBDW.[FACT_INTERACTIONPARTICIPANT].[INTERACTIONDATEDIMID] |
| INTERACTIONDATE | datetime | yes | BBDW.[FACT_INTERACTIONPARTICIPANT].[INTERACTIONDATE] |
| INTERACTIONDIMID | int | yes | BBDW.[FACT_INTERACTIONPARTICIPANT].[INTERACTIONDIMID] |
| EVENTDIMID | int | yes | BBDW.[FACT_INTERACTIONPARTICIPANT].[EVENTDIMID] |
| PROSPECTPLANDIMID | int | yes | BBDW.[FACT_INTERACTIONPARTICIPANT].[PROSPECTPLANDIMID] |
| PLANOUTLINESTEPDIMID | int | yes | BBDW.[FACT_INTERACTIONPARTICIPANT].[PLANOUTLINESTEPDIMID] |
| PROSPECTPLANSTATUSDIMID | int | yes | BBDW.[FACT_INTERACTIONPARTICIPANT].[PROSPECTPLANSTATUSDIMID] |
| FUNDINGREQUESTDIMID | int | yes | BBDW.[FACT_INTERACTIONPARTICIPANT].[FUNDINGREQUESTDIMID] |
| FUNDINGREQUESTOUTLINESTEPDIMID | int | yes | BBDW.[FACT_INTERACTIONPARTICIPANT].[FUNDINGREQUESTOUTLINESTEPDIMID] |
| FUNDRAISERCONSTITUENTDIMID | int | yes | BBDW.[FACT_INTERACTIONPARTICIPANT].[FUNDRAISERCONSTITUENTDIMID] |
Definition
Copy
create view [BBDW].[v_FACT_INTERACTIONPARTICIPANT] as
select
[INTERACTIONPARTICIPANTFACTID],
[INTERACTIONPARTICIPANTSYSTEMID],
[INTERACTIONFACTID],
[INTERACTIONSYSTEMID],
[PARTICIPANTCONSTITUENTDIMID],
[PARTICIPANTCONSTITUENTSYSTEMID],
[INTERACTIONCONSTITUENTDIMID],
[INTERACTIONCONSTITUENTSYSTEMID],
[FUNDRAISERDIMID],
[FUNDRAISERSYSTEMID],
[INTERACTIONDATEDIMID],
[INTERACTIONDATE],
[INTERACTIONDIMID],
[EVENTDIMID],
[PROSPECTPLANDIMID],
[PLANOUTLINESTEPDIMID],
[PROSPECTPLANSTATUSDIMID],
[FUNDINGREQUESTDIMID],
[FUNDINGREQUESTOUTLINESTEPDIMID],
[FUNDRAISERCONSTITUENTDIMID]
from [BBDW].[FACT_INTERACTIONPARTICIPANT];