| FUNDRAISERINTERACTIONADDITIONALSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[INTERACTIONADDITIONALFUNDRAISER].[ID] |
| INTERACTIONFACTID |
int |
yes |
|
Foreign Key to FACT_INTERACTION |
| INTERACTIONSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[INTERACTIONADDITIONALFUNDRAISER].[INTERACTIONID] |
| ADDITIONALFUNDRAISERDIMID |
int |
yes |
|
Reference key to the fundraiser dimension, derived from dbo.[FUNDRAISERINTERACTIONADDITIONAL].[FUNDRAISERID] |
| ADDITIONALFUNDRAISERSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[INTERACTIONADDITIONALFUNDRAISER].[FUNDRAISERID] |
| CONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived from dbo.[INTERACTION].[CONSTITUENTID] |
| CONSTITUENTSYSTEMID |
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 |