FACT_REGISTRATIONTOTALCOMMUNICATIONS_STAGE

Contains aggregate information about event registrations.

Fields

Field Field Type Null Notes Description
CONSTITUENTSYSTEMID uniqueidentifier yes dbo.[REGISTRANT].[ID]
EVENTSYSTEMID uniqueidentifier yes dbo.[EVENT].[ID]
COMMUNICATIONSSENT int yes Count of rows from dbo.[FAFCOMMUNICATIONSLOG]
PERSONALPAGEVIEWS int yes aggregate from dbo.[FAFCOMMUNICATIONSLOG].[PAGEVISITS]