FACT_CONSTITUENTRELATIONSHIP_STAGE

Intermediate storage table for constituent relationships.

Fields

Field	Field Type	Null	Notes	Description
CONSTITUENTRELATIONSHIPSYSTEMID	uniqueidentifier	yes		[dbo].[RELATIONSHIP].[ID]
CONSTITUENTRELATIONSHIPSETSYSTEMID	uniqueidentifier	yes		[dbo].[RELATIONSHIP].[RELATIONSHIPSETID]
CONSTITUENTSYSTEMID	uniqueidentifier	yes		[dbo].[RELATIONSHIP].[RELATIONSHIPCONSTITUENTID]
CONSTITUENTRELATIONSHIPTYPEDIMID	int	yes		Reference key to the constituent relationship type dimension, derived using [dbo].[RELATIONSHIP].[RELATIONSHIPTYPECODEID]
RECIPROCALCONSTITUENTSYSTEMID	uniqueidentifier	yes		[dbo].[RELATIONSHIP].[RECIPROCALCONSTITUENTID]
RECIPROCALCONSTITUENTRELATIONSHIPTYPEDIMID	int	yes		Reference key to the constituent relationship type dimension, derived using [dbo].[RELATIONSHIP].[RECIPROCALTYPECODEID]
CONSTITUENTRELATIONSHIPFLAGDIMID	int	yes		Reference key to the constituent relationship flag dimension, derived using [dbo].[RELATIONSHIP].[ISSPOUSE] [bit], [dbo].[RELATIONSHIP].[ISPRIMARYBUSINESS], [dbo].[RELATIONSHIP].[ISCONTACT], [dbo].[RELATIONSHIP].[ISPRIMARYCONTACT], [dbo].[RELATIONSHIP].[ISMATCHINGGIFTRELATIONSHIP], [dbo].[RELATIONSHIP].[ISEMERGENCYCONTACT], and [dbo].[RELATIONSHIP].[ISCURRENTRELATIONSHIP]
CONTACTTYPEDIMID	int	yes		Reference key to the contact type dimension, derived using [dbo].[RELATIONSHIP].[CONTACTTYPECODEID]
STARTDATEDIMID	int	yes		Reference key to the date dimension, derived using [dbo].[RELATIONSHIP].[STARTDATE]
STARTDATE	datetime	yes		[dbo].[RELATIONSHIP].[STARTDATE]
ENDDATEDIMID	int	yes		Reference key to the date dimension, derived using [dbo].[RELATIONSHIP].[ENDDATE]
ENDDATE	datetime	yes		[dbo].[RELATIONSHIP].[ENDDATE]
POSITION	nvarchar(100)	yes		[dbo].[RELATIONSHIP].[POSITION]
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.