v_DIM_CONSTITUENTDEMOGRAPHIC
The constituent demographic dimension contains demographic information for constituents.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTDEMOGRAPHICDIMID | int | BBDW.[DIM_CONSTITUENTDEMOGRAPHIC].[CONSTITUENTDEMOGRAPHICDIMID] | |
| CONSTITUENTRELIGION | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTDEMOGRAPHIC].[CONSTITUENTRELIGION] |
| CONSTITUENTRELIGIONCODESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENTDEMOGRAPHIC].[CONSTITUENTRELIGIONCODESYSTEMID] |
| CONSTITUENTINCOME | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTDEMOGRAPHIC].[CONSTITUENTINCOME] |
| CONSTITUENTINCOMECODESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENTDEMOGRAPHIC].[CONSTITUENTINCOMECODESYSTEMID] |
| CONSTITUENTTARGET | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTDEMOGRAPHIC].[CONSTITUENTTARGET] |
| CONSTITUENTTARGETCODESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENTDEMOGRAPHIC].[CONSTITUENTTARGETCODESYSTEMID] |
Definition
Copy
create view [BBDW].[v_DIM_CONSTITUENTDEMOGRAPHIC] as
select
[CONSTITUENTDEMOGRAPHICDIMID],
[CONSTITUENTRELIGION],
[CONSTITUENTRELIGIONCODESYSTEMID],
[CONSTITUENTINCOME],
[CONSTITUENTINCOMECODESYSTEMID],
[CONSTITUENTTARGET],
[CONSTITUENTTARGETCODESYSTEMID]
from BBDW.[DIM_CONSTITUENTDEMOGRAPHIC]