FACT_CONSTITUENCY_STAGE
The Constituency fact associates constituents to constituencies. This includes user defined constituencies as well as system defined ones (Volunteer, Board Member, Fundraiser, Group Member, Staff, and Committee).
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| CONSTITUENCYSYSTEMID | uniqueidentifier | yes | dbo.[CONSTITUENCY].[ID] | |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | dbo.[CONSTITUENCY].[CONSTITUENTID] | |
| CONSTITUENCYDIMID | int | yes | Reference key to the constituency dimension, derived from dbo.[CONSTITUENCY].[CONSTITUENCYCODEID] | |
| FROMDATEDIMID | int | yes | Reference key to the date dimension, derived from dbo.[CONSTITUENCY].[FROMDATE] | |
| FROMDATE | datetime | yes | dbo.[CONSTITUENCY].[DATEFROM] | |
| TODATEDIMID | int | yes | Reference key to the date dimension, derived from dbo.[CONSTITUENCY].[TODATE] | |
| TODATE | datetime | yes | dbo.[CONSTITUENCY].[DATETO] | |
| ISCURRENTCONSTITUENCY | bit | yes | Flag indicating if the constituent constituency is currently active. | |
| ISINCLUDED | bit | yes | Flag indicating when data should be included in results. | |
| ETLCONTROLID | int | yes | ID generated through the ETL process | |
| SOURCEDIMID | int | yes | Source system used |