v_FACT_CURRENTCONSTITUENCY
The current constituency fact table relates constituents to their current constituency.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENCYFACTID | int | BBDW.[FACT_CONSTITUENCY].[CONSTITUENCYFACTID] | |
| CONSTITUENTDIMID | int | yes | BBDW.[FACT_CONSTITUENCY].[CONSTITUENTDIMID] |
| CONSTITUENCYDIMID | int | yes | BBDW.[FACT_CONSTITUENCY].[CONSTITUENCYDIMID] |
| FROMDATEDIMID | int | yes | BBDW.[FACT_CONSTITUENCY].[FROMDATEDIMID] |
| TODATEDIMID | int | yes | BBDW.[FACT_CONSTITUENCY].[TODATEDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENCY].[CONSTITUENTSYSTEMID] |
| ISCURRENTCONSTITUENCY | bit | yes | BBDW.[FACT_CONSTITUENCY].[ISCURRENTCONSTITUENCY] |
Definition
Copy
create view [BBDW].[v_FACT_CURRENTCONSTITUENCY] as
select
[CONSTITUENCYFACTID],
[CONSTITUENTDIMID],
[CONSTITUENCYDIMID],
[FROMDATEDIMID],
[TODATEDIMID],
[CONSTITUENTSYSTEMID],
[ISCURRENTCONSTITUENCY]
from BBDW.[FACT_CONSTITUENCY]
where (ISCURRENTCONSTITUENCY = 1)