v_DIM_CONSTITUENTRELATIONSHIPFLAG
Contains flags for constituent relationships.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTRELATIONSHIPFLAGDIMID | int | BBDW.[DIM_CONSTITUENTRELATIONSHIPFLAG].[CONSTITUENTRELATIONSHIPFLAGDIMID] | |
| ISSPOUSE | bit | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPFLAG].[ISSPOUSE] |
| ISPRIMARYBUSINESS | bit | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPFLAG].[ISPRIMARYBUSINESS] |
| ISCONTACT | bit | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPFLAG].[ISCONTACT] |
| ISPRIMARYCONTACT | bit | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPFLAG].[ISPRIMARYCONTACT] |
| ISMATCHINGGIFTRELATIONSHIP | bit | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPFLAG].[ISMATCHINGGIFTRELATIONSHIP] |
| ISEMERGENCYCONTACT | bit | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPFLAG].[ISEMERGENCYCONTACT] |
| ISCURRENTRELATIONSHIP | bit | yes | BBDW.[DIM_CONSTITUENTRELATIONSHIPFLAG].[ISCURRENTRELATIONSHIP] |
Definition
Copy
create view [BBDW].[v_DIM_CONSTITUENTRELATIONSHIPFLAG] as
select
crf.[CONSTITUENTRELATIONSHIPFLAGDIMID],
crf.[ISSPOUSE],
crf.[ISPRIMARYBUSINESS],
crf.[ISCONTACT],
crf.[ISPRIMARYCONTACT],
crf.[ISMATCHINGGIFTRELATIONSHIP],
crf.[ISEMERGENCYCONTACT],
crf.[ISCURRENTRELATIONSHIP]
from BBDW.[DIM_CONSTITUENTRELATIONSHIPFLAG] crf