v_DIM_CONSTITUENTGROUP
Stores information about constituent groups and households
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTGROUPDIMID | int | BBDW.[DIM_CONSTITUENTGROUP].[CONSTITUENTGROUPDIMID] | |
| CONSTITUENTGROUPSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENTGROUP].[CONSTITUENTGROUPSYSTEMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[DIM_CONSTITUENTGROUP].[CONSTITUENTDIMID] |
| DESCRIPTION | nvarchar(300) | yes | BBDW.[DIM_CONSTITUENTGROUP].[DESCRIPTION] |
| GROUPTYPE | nvarchar(150) | yes | BBDW.[DIM_CONSTITUENTGROUP].[GROUPTYPE] |
| ISHOUSEHOLD | bit | yes | BBDW.[DIM_CONSTITUENTGROUP].[ISHOUSEHOLD] |
| ISDISSOLVED | bit | yes | BBDW.[DIM_CONSTITUENTGROUP].[ISDISSOLVED] |
| DISSOLVEDDATE | datetime | yes | BBDW.[DIM_CONSTITUENTGROUP].[DISSOLVEDDATE] |
| DISSOLVEDDATEDIMID | int | yes | BBDW.[DIM_CONSTITUENTGROUP].[DISSOLVEDDATEDIMID] |
| DISSOLVEDREASON | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTGROUP].[DISSOLVEDREASON] |
Definition
Copy
create view [BBDW].[v_DIM_CONSTITUENTGROUP] as
select
[CONSTITUENTGROUPDIMID],
[CONSTITUENTGROUPSYSTEMID],
[CONSTITUENTDIMID],
[DESCRIPTION],
[GROUPTYPE],
[ISHOUSEHOLD],
[ISDISSOLVED],
[DISSOLVEDDATE],
[DISSOLVEDDATEDIMID],
[DISSOLVEDREASON]
from [BBDW].[DIM_CONSTITUENTGROUP];