v_FACT_CONSTITUENTRELATIONSHIP
Contains information about constituent relationships.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTRELATIONSHIPFACTID | int | BBDW.[FACT_CONSTITUENTRELATIONSHIP].[CONSTITUENTRELATIONSHIPFACTID] | |
| CONSTITUENTRELATIONSHIPSETDIMID | int | yes | BBDW.[FACT_CONSTITUENTRELATIONSHIP].[CONSTITUENTRELATIONSHIPSETDIMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[FACT_CONSTITUENTRELATIONSHIP].[CONSTITUENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTRELATIONSHIP].[CONSTITUENTSYSTEMID] |
| CONSTITUENTAGE | int | yes | BBDW.[DIM_CONSTITUENT].[AGE] |
| CONSTITUENTINFORMATIONDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTINFORMATIONDIMID] |
| CONSTITUENTADDRESSDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTADDRESSDIMID] |
| CONSTITUENTADDRESSDETAILDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTADDRESSDETAILDIMID] |
| CONSTITUENTADDRESSFLAGDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTADDRESSFLAGDIMID] |
| CONSTITUENTADDRESSTYPEDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTADDRESSTYPEDIMID] |
| CONSTITUENTDEMOGRAPHICDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTDEMOGRAPHICDIMID] |
| CONSTITUENTRELATIONSHIPTYPEDIMID | int | yes | BBDW.[FACT_CONSTITUENTRELATIONSHIP].[CONSTITUENTRELATIONSHIPTYPEDIMID] |
| RECIPROCALCONSTITUENTDIMID | int | yes | BBDW.[FACT_CONSTITUENTRELATIONSHIP].[RECIPROCALCONSTITUENTDIMID] |
| RECIPROCALCONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTRELATIONSHIP].[RECIPROCALCONSTITUENTSYSTEMID] |
| RECIPROCALCONSTITUENTAGE | int | yes | BBDW.[DIM_CONSTITUENT].[AGE] |
| RECIPROCALCONSTITUENTINFORMATIONDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTINFORMATIONDIMID] |
| RECIPROCALCONSTITUENTADDRESSDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTADDRESSDIMID] |
| RECIPROCALCONSTITUENTADDRESSDETAILDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTADDRESSDETAILDIMID] |
| RECIPROCALCONSTITUENTADDRESSFLAGDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTADDRESSFLAGDIMID] |
| RECIPROCALCONSTITUENTADDRESSTYPEDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTADDRESSTYPEDIMID] |
| RECIPROCALCONSTITUENTDEMOGRAPHICDIMID | int | yes | BBDW.[DIM_CONSTITUENT].[CONSTITUENTDEMOGRAPHICDIMID] |
| RECIPROCALCONSTITUENTRELATIONSHIPTYPEDIMID | int | yes | BBDW.[FACT_CONSTITUENTRELATIONSHIP].[RECIPROCALCONSTITUENTRELATIONSHIPTYPEDIMID] |
| CONSTITUENTRELATIONSHIPFLAGDIMID | int | yes | BBDW.[FACT_CONSTITUENTRELATIONSHIP].[CONSTITUENTRELATIONSHIPFLAGDIMID] |
| CONTACTTYPEDIMID | int | yes | BBDW.[FACT_CONSTITUENTRELATIONSHIP].[CONTACTTYPEDIMID] |
| STARTDATEDIMID | int | yes | BBDW.[FACT_CONSTITUENTRELATIONSHIP].[STARTDATEDIMID] |
| ENDDATEDIMID | int | yes | BBDW.[FACT_CONSTITUENTRELATIONSHIP].[ENDDATEDIMID] |
| POSITION | nvarchar(100) | yes | BBDW.[FACT_CONSTITUENTRELATIONSHIP].[POSITION] |
Definition
Copy
create view [BBDW].[v_FACT_CONSTITUENTRELATIONSHIP] as
select
cr.[CONSTITUENTRELATIONSHIPFACTID],
cr.[CONSTITUENTRELATIONSHIPSETDIMID],
cr.[CONSTITUENTDIMID],
cr.[CONSTITUENTSYSTEMID],
c.[AGE] AS [CONSTITUENTAGE],
c.[CONSTITUENTINFORMATIONDIMID],
c.[CONSTITUENTADDRESSDIMID],
c.[CONSTITUENTADDRESSDETAILDIMID],
c.[CONSTITUENTADDRESSFLAGDIMID],
c.[CONSTITUENTADDRESSTYPEDIMID],
c.[CONSTITUENTDEMOGRAPHICDIMID],
cr.[CONSTITUENTRELATIONSHIPTYPEDIMID],
cr.[RECIPROCALCONSTITUENTDIMID],
cr.[RECIPROCALCONSTITUENTSYSTEMID],
rc.[AGE] AS [RECIPROCALCONSTITUENTAGE],
rc.[CONSTITUENTINFORMATIONDIMID] [RECIPROCALCONSTITUENTINFORMATIONDIMID],
rc.[CONSTITUENTADDRESSDIMID] [RECIPROCALCONSTITUENTADDRESSDIMID],
rc.[CONSTITUENTADDRESSDETAILDIMID] [RECIPROCALCONSTITUENTADDRESSDETAILDIMID],
rc.[CONSTITUENTADDRESSFLAGDIMID] [RECIPROCALCONSTITUENTADDRESSFLAGDIMID],
rc.[CONSTITUENTADDRESSTYPEDIMID] [RECIPROCALCONSTITUENTADDRESSTYPEDIMID],
rc.[CONSTITUENTDEMOGRAPHICDIMID] [RECIPROCALCONSTITUENTDEMOGRAPHICDIMID],
cr.[RECIPROCALCONSTITUENTRELATIONSHIPTYPEDIMID],
cr.[CONSTITUENTRELATIONSHIPFLAGDIMID],
cr.[CONTACTTYPEDIMID],
cr.[STARTDATEDIMID],
cr.[ENDDATEDIMID],
cr.[POSITION]
from BBDW.[FACT_CONSTITUENTRELATIONSHIP] cr
left join BBDW.[DIM_CONSTITUENT] c on cr.[CONSTITUENTDIMID] = c.[CONSTITUENTDIMID]
left join BBDW.[DIM_CONSTITUENT] rc on cr.[RECIPROCALCONSTITUENTDIMID] = rc.[CONSTITUENTDIMID]