v_FACT_CONSTITUENTETHNICITY
The constituent ethnicity fact table relates constituents to their ethnicities.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTETHNICITYFACTID | int | BBDW.[FACT_CONSTITUENTETHNICITY].[CONSTITUENTETHNICITYFACTID] | |
| CONSTITUENTDIMID | int | yes | BBDW.[FACT_CONSTITUENTETHNICITY].[CONSTITUENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTETHNICITY].[CONSTITUENTSYSTEMID] |
| ETHNICITYDIMID | int | yes | BBDW.[FACT_CONSTITUENTETHNICITY].[ETHNICITYDIMID] |
Definition
Copy
create view [BBDW].[v_FACT_CONSTITUENTETHNICITY] as
select
[CONSTITUENTETHNICITYFACTID],
[CONSTITUENTDIMID],
[CONSTITUENTSYSTEMID],
[ETHNICITYDIMID]
from BBDW.[FACT_CONSTITUENTETHNICITY]