v_FACT_CONSTITUENTGROUPMEMBER
Stores information about constituent group members
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTGROUPMEMBERFACTID | int | BBDW.[FACT_CONSTITUENTGROUPMEMBER].[CONSTITUENTGROUPMEMBERFACTID] | |
| CONSTITUENTGROUPMEMBERSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTGROUPMEMBER].[CONSTITUENTGROUPMEMBERSYSTEMID] |
| MEMBERCONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTGROUPMEMBER].[MEMBERCONSTITUENTSYSTEMID] |
| MEMBERCONSTITUENTDIMID | int | yes | BBDW.[FACT_CONSTITUENTGROUPMEMBER].[MEMBERCONSTITUENTDIMID] |
| GROUPCONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTGROUPMEMBER].[GROUPCONSTITUENTSYSTEMID] |
| GROUPCONSTITUENTDIMID | int | yes | BBDW.[FACT_CONSTITUENTGROUPMEMBER].[GROUPCONSTITUENTDIMID] |
| CONSTITUENTGROUPDIMID | int | yes | BBDW.[FACT_CONSTITUENTGROUPMEMBER].[CONSTITUENTGROUPDIMID] |
| ISPRIMARY | bit | yes | BBDW.[FACT_CONSTITUENTGROUPMEMBER].[ISPRIMARY] |
| FROMDATE | datetime | yes | BBDW.[FACT_CONSTITUENTGROUPMEMBER].[FROMDATE] |
| FROMDATEDIMID | int | yes | BBDW.[FACT_CONSTITUENTGROUPMEMBER].[FROMDATEDIMID] |
| TODATE | datetime | yes | BBDW.[FACT_CONSTITUENTGROUPMEMBER].[TODATE] |
| TODATEDIMID | int | yes | BBDW.[FACT_CONSTITUENTGROUPMEMBER].[TODATEDIMID] |
| ISCURRENT | bit | yes | BBDW.[FACT_CONSTITUENTGROUPMEMBER].[ISCURRENT] |
Definition
Copy
CREATE view [BBDW].[v_FACT_CONSTITUENTGROUPMEMBER] as
select
[CONSTITUENTGROUPMEMBERFACTID],
[CONSTITUENTGROUPMEMBERSYSTEMID],
[MEMBERCONSTITUENTSYSTEMID],
[MEMBERCONSTITUENTDIMID],
[GROUPCONSTITUENTSYSTEMID],
[GROUPCONSTITUENTDIMID],
[CONSTITUENTGROUPDIMID],
[ISPRIMARY],
[FROMDATE],
[FROMDATEDIMID],
[TODATE],
[TODATEDIMID],
[ISCURRENT]
from [BBDW].[FACT_CONSTITUENTGROUPMEMBER];