v_DIM_CONSTITUENTINTEREST
Contains information about constituent interests.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTINTERESTDIMID | int | BBDW.[DIM_CONSTITUENTINTEREST].[CONSTITUENTINTERESTDIMID] | |
| CONSTITUENTINTERESTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENTINTEREST].[CONSTITUENTINTERESTSYSTEMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[DIM_CONSTITUENTINTEREST].[CONSTITUENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENTINTEREST].[CONSTITUENTSYSTEMID] |
| INTEREST | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTINTEREST].[INTEREST] |
| INTERESTNOTE | nvarchar(max) | yes | BBDW.[DIM_CONSTITUENTINTEREST].[INTERESTNOTE] |
Definition
Copy
create view [BBDW].[v_DIM_CONSTITUENTINTEREST] as
select
[CONSTITUENTINTERESTDIMID],
[CONSTITUENTINTERESTSYSTEMID],
[CONSTITUENTDIMID],
[CONSTITUENTSYSTEMID],
[INTEREST],
[INTERESTNOTE]
from [BBDW].[DIM_CONSTITUENTINTEREST];