DIM_CONSTITUENTRELATIONSHIPFLAG

Contains flags for constituent relationships.

Primary Key

Primary Key	Field Type
CONSTITUENTRELATIONSHIPFLAGDIMID	int

Fields

Field	Field Type	Null	Notes	Description
ISSPOUSE	bit	yes		dbo.[RELATIONSHIP].[ISSPOUSE]
ISPRIMARYBUSINESS	bit	yes		dbo.[RELATIONSHIP].[ISPRIMARYBUSINESS]
ISCONTACT	bit	yes		dbo.[RELATIONSHIP].[ISCONTACT]
ISPRIMARYCONTACT	bit	yes		dbo.[RELATIONSHIP].[ISPRIMARYCONTACT]
ISMATCHINGGIFTRELATIONSHIP	bit	yes		dbo.[RELATIONSHIP].[ISMATCHINGGIFTRELATIONSHIP]
ISEMERGENCYCONTACT	bit	yes		dbo.[RELATIONSHIP].[ISEMERGENCYCONTACT]
ISCURRENTRELATIONSHIP	bit	yes		Is the current date between dbo.[RELATIONSHIP].[STARTDATE] and dbo.[RELATIONSHIP].[ENDDATE], or is dbo.[RELATIONSHIP].[ENDDATE] null
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.

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_DIM_CONSTITUENTRELATIONSHIPFLAG	CONSTITUENTRELATIONSHIPFLAGDIMID	yes	yes	yes