V_QUERY_BBDW_HOUSEHOLDMEMBERSHIP
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTGROUPMEMBERSYSTEMID | uniqueidentifier | yes | |
| GROUPCONSTITUENTDIMID | int | yes | |
| MEMBERCONSTITUENTDIMID | int | yes | |
| ISPRIMARY | bit | yes | |
| FROMDATE | datetime | yes | |
| FROMDATEDIMID | int | yes | |
| TODATE | datetime | yes | |
| TODATEDIMID | int | yes | |
| ISCURRENT | bit | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_HOUSEHOLDMEMBERSHIP] as
select
fcg.[CONSTITUENTGROUPMEMBERSYSTEMID],
fcg.[GROUPCONSTITUENTDIMID],
fcg.[MEMBERCONSTITUENTDIMID],
fcg.[ISPRIMARY],
fcg.[FROMDATE],
fcg.[FROMDATEDIMID],
fcg.[TODATE],
fcg.[TODATEDIMID],
fcg.[ISCURRENT]
from BBDW.[FACT_CONSTITUENTGROUPMEMBER] fcg
inner join BBDW.[DIM_CONSTITUENTGROUP] dcg on fcg.[CONSTITUENTGROUPDIMID] = dcg.[CONSTITUENTGROUPDIMID] and dcg.[ISHOUSEHOLD] = 1