| INTERACTIONSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[INTERACTION].[ID] |
| 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] |
| INTERACTIONLOOKUPID |
nvarchar(100) |
yes |
|
dbo.[INTERACTION].[LOOKUPID] |
| INTERACTIONOBJECTIVE |
nvarchar(100) |
yes |
|
dbo.[INTERACTION].[OBJECTIVE] |
| 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] |
| ISFIRSTINTERACTION |
bit |
yes |
|
First interaction for the constituent order by bbdw.[FACT_INTERACTION].[INTERACTIONDATE] and bbdw.[FACT_INTERACTION].[INTERACTIONSEQUENCE] |
| ISLASTINTERACTION |
bit |
yes |
|
First interaction for the constituent order by bbdw.[FACT_INTERACTION].[INTERACTIONDATE] and bbdw.[FACT_INTERACTION].[INTERACTIONSEQUENCE] |
| INTERACTIONCOMMENT |
nvarchar(4000) |
yes |
|
First 4000 characters for dbo.[INTERACTION].[COMMENT] |
| INTERACTIONSEQUENCE |
int |
yes |
|
dbo.[INTERACTION].[SEQUENCEID] |
| ACTUALDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[INTERACTION].[ACTUALDATE] |
| ACTUALDATE |
datetime |
yes |
|
dbo.[INTERACTION].[ACTUALDATE] |
| EXPECTEDDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[INTERACTION].[EXPECTEDDATE] |
| EXPECTEDDATE |
datetime |
yes |
|
dbo.[INTERACTION].[EXPECTEDDATE] |
| ADDEDDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[INTERACTION].[DATEADDED] |
| ADDEDDATE |
datetime |
yes |
|
dbo.[INTERACTION].[DATEADDED] |
| CHANGEDDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[INTERACTION].[DATECHANGED] |
| CHANGEDDATE |
datetime |
yes |
|
dbo.[INTERACTION].[DATECHANGED] |
| ACTUALSTARTTIMEDIMID |
int |
yes |
|
Reference key to the time dimension, derived from dbo.[INTERACTION].[ACTUALSTARTTIME] |
| ACTUALSTARTTIME |
UDT_HOURMINUTE |
yes |
|
dbo.[INTERACTION].[ACTUALSTARTTIME] |
| ACTUALENDTIMEDIMID |
int |
yes |
|
Reference key to the time dimension, derived from dbo.[INTERACTION].[ACTUALENDTIME] |
| ACTUALENDTIME |
UDT_HOURMINUTE |
yes |
|
dbo.[INTERACTION].[ACTUALENDTIME] |
| EXPECTEDSTARTTIMEDIMID |
int |
yes |
|
Reference key to the time dimension, derived from dbo.[INTERACTION].[EXPECTEDSTARTTIME] |
| EXPECTEDSTARTTIME |
UDT_HOURMINUTE |
yes |
|
dbo.[INTERACTION].[EXPECTEDSTARTTIME] |
| EXPECTEDENDTIMEDIMID |
int |
yes |
|
Reference key to the time dimension, derived from dbo.[INTERACTION].[EXPECTEDENDTIME] |
| EXPECTEDENDTIME |
UDT_HOURMINUTE |
yes |
|
dbo.[INTERACTION].[EXPECTEDENDTIME] |
| INTERACTIONSTARTTIMEDIMID |
int |
yes |
|
Reference key to the time dimension, derived from dbo.[INTERACTION].[STARTTIME] |
| INTERACTIONSTARTTIME |
UDT_HOURMINUTE |
yes |
|
dbo.[INTERACTION].[STARTTIME] |
| INTERACTIONENDTIMEDIMID |
int |
yes |
|
Reference key to the time dimension, derived from dbo.[INTERACTION].[ENDTIME] |
| INTERACTIONENDTIME |
UDT_HOURMINUTE |
yes |
|
dbo.[INTERACTION].[ENDTIME] |
| TIMEZONEDIMID |
int |
yes |
|
Reference key to the time zone dimension, derived from dbo.[INTERACTION].[TIMEZONEENTRYID] |