FACT_INTERACTION_STAGE
The Interaction fact relates information to constituent interactions.
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| INTERACTIONSYSTEMID | uniqueidentifier | yes | dbo.[INTERACTION].[ID] | |
| 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 | |
| INTERACTIONSUBCATEGORYSYSTEMID | uniqueidentifier | yes | dbo.[INTERACTIONSUBCATEGORY].[ID] | |
| INTERACTIONSUBCATEGORY | nvarchar(100) | yes | dbo.[INTERACTIONTYPECODE].[DESCRIPTION] | |
| INTERACTIONCATEGORY | nvarchar(100) | yes | dbo.[INTERACTIONCATEGORY].[NAME] | |
| INTERACTIONTYPECODESYSTEMID | uniqueidentifier | yes | dbo.[INTERACTIONTYPECODE].[ID] | |
| INTERACTIONTYPE | nvarchar(100) | yes | dbo.[INTERACTIONTYPECODE].[DESCRIPTION] | |
| INTERACTIONSTATUSCODE | tinyint | yes | dbo.[INTERACTION].[STATUSCODE] | |
| INTERACTIONSTATUS | nvarchar(50) | yes | dbo.[INTERACTION].[STATUS] | |
| ISALLDAYEVENT | bit | yes | dbo.[INTERACTION].[ISALLDAYEVENT] | |
| ISCONTACTREPORT | bit | yes | dbo.[INTERACTION].[ISCONTACTREPORT] | |
| ISINTERACTION | bit | yes | dbo.[INTERACTION].[ISINTERACTION] | |
| ISINTERACTIONCOMPLETED | bit | yes | dbo.[INTERACTION].[COMPLETED] | |
| 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] |