v_FACT_CONSTITUENTGROUPMEMBERROLE
Stores information about roles for constituent group members
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTGROUPMEMBERROLEFACTID | int | BBDW.[FACT_CONSTITUENTGROUPMEMBERROLE].[CONSTITUENTGROUPMEMBERROLEFACTID] | |
| CONSTITUENTGROUPMEMBERROLESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTGROUPMEMBERROLE].[CONSTITUENTGROUPMEMBERROLESYSTEMID] |
| CONSTITUENTGROUPMEMBERFACTID | int | yes | BBDW.[FACT_CONSTITUENTGROUPMEMBERROLE].[CONSTITUENTGROUPMEMBERFACTID] |
| CONSTITUENTGROUPMEMBERROLEDIMID | int | yes | BBDW.[FACT_CONSTITUENTGROUPMEMBERROLE].[CONSTITUENTGROUPMEMBERROLEDIMID] |
| STARTDATE | datetime | yes | BBDW.[FACT_CONSTITUENTGROUPMEMBERROLE].[STARTDATE] |
| STARTDATEDIMID | int | yes | BBDW.[FACT_CONSTITUENTGROUPMEMBERROLE].[STARTDATEDIMID] |
| ENDDATE | datetime | yes | BBDW.[FACT_CONSTITUENTGROUPMEMBERROLE].[ENDDATE] |
| ENDDATEDIMID | int | yes | BBDW.[FACT_CONSTITUENTGROUPMEMBERROLE].[ENDDATEDIMID] |
Definition
Copy
create view [BBDW].[v_FACT_CONSTITUENTGROUPMEMBERROLE] as
select
[CONSTITUENTGROUPMEMBERROLEFACTID],
[CONSTITUENTGROUPMEMBERROLESYSTEMID],
[CONSTITUENTGROUPMEMBERFACTID],
[CONSTITUENTGROUPMEMBERROLEDIMID],
[STARTDATE],
[STARTDATEDIMID],
[ENDDATE],
[ENDDATEDIMID]
from [BBDW].[FACT_CONSTITUENTGROUPMEMBERROLE];