| INTERACTIONPARTICIPANTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[INTERACTIONPARTICIPANT].[ID] |
| INTERACTIONFACTID |
int |
yes |
|
Foreign Key to FACT_INTERACTION |
| INTERACTIONSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[INTERACTIONPARTICIPANT].[INTERACTIONID] |
| PARTICIPANTCONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived from dbo.[INTERACTIONPARTICIPANT].[CONSTITUENTID] |
| PARTICIPANTCONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[INTERACTIONPARTICIPANT].[CONSTITUENTID] |
| INTERACTIONCONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived from dbo.[INTERACTION].[CONSTITUENTID] |
| INTERACTIONCONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[INTERACTION].[CONSTITUENTID] |
| FUNDRAISERDIMID |
int |
yes |
|
Reference key to the fundraiser dimension, derived from dbo.[INTERACTION].[FUNDRAISERID] |
| FUNDRAISERSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[INTERACTION].[FUNDRAISERID] |
| INTERACTIONDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[INTERACTION].[DATE] |
| INTERACTIONDATE |
datetime |
yes |
|
dbo.[INTERACTION].[DATE] |
| INTERACTIONDIMID |
int |
yes |
|
Reference key to the interaction dimension, derived from dbo.[INTERACTION].[INTERACTIONTYPECODEID], dbo.[INTERACTION].[INTERACTIONSUBCATEGORYID], dbo.[INTERACTION].[STATUSCODE], dbo.[INTERACTION].[ISALLDAYEVENT], dbo.[INTERACTION].[ISINTERACTION], dbo.[INTERACTION].[COMPLETED], and dbo.[INTERACTION].[ISCONTACTREPORT] |
| EVENTDIMID |
int |
yes |
|
Reference key to the event dimension, derived from dbo.[INTERACTION].[EVENTID] |
| PROSPECTPLANDIMID |
int |
yes |
|
Reference key to the prospect plan dimension, derived from dbo.[INTERACTION].[PROSPECTPLANID] |
| PLANOUTLINESTEPDIMID |
int |
yes |
|
Reference key to the plan outline step dimension, derived from dbo.[INTERACTION].[PLANOUTLINESTEPID] |
| PROSPECTPLANSTATUSDIMID |
int |
yes |
|
Reference key to the prospect plan status dimension, derived from dbo.[INTERACTION].[PROSPECTPLANSTATUSCODEID] |
| FUNDINGREQUESTDIMID |
int |
yes |
|
Reference key to the funding request dimension, derived from dbo.[INTERACTION].[FUNDINGREQUESTID] |
| FUNDINGREQUESTOUTLINESTEPDIMID |
int |
yes |
|
Reference key to the funding request outline step dimension, derived from dbo.[INTERACTION].[FUNDINGREQUESTOUTLINESTEPID] |
| ISINCLUDED |
bit |
yes |
|
Flag indicating when data should be included in results. |
| ETLCONTROLID |
int |
yes |
|
ID generated through the ETL process |
| SOURCEDIMID |
int |
yes |
|
Source system used |
| FUNDRAISERCONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived using [dbo].[INTERACTION].[FUNDRAISERID] |