v_DIM_ETHNICITY
The ethnicity dimension contains information about ethnicities.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ETHNICITYDIMID | int | BBDW.[DIM_ETHNICITY].[ETHNICITYDIMID] | |
| ETHNICITYCODESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_ETHNICITY].[ETHNICITYCODESYSTEMID] |
| ETHNICITY | nvarchar(100) | yes | BBDW.[DIM_ETHNICITY].[ETHNICITY] |
Definition
Copy
create view [BBDW].[v_DIM_ETHNICITY] as
select
[ETHNICITYDIMID],
[ETHNICITYCODESYSTEMID],
[ETHNICITY]
from BBDW.[DIM_ETHNICITY]