FACT_CONSTITUENTETHNICITY_STAGE
Lists the ethnicities listed for constituents.
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| CONSTITUENTETHNICITYSYSTEMID | uniqueidentifier | yes | dbo.[DEMOGRAPHICETHNICITY].[ID] | |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | dbo.[DEMOGRAPHICETHNICITY].[DEMOGRAPHICID] | |
| ETHNICITYDIMID | int | yes | Reference key to the ethnicity dimension, derived from dbo.[DEMOGRAPHICETHNICITY].[ETHNICITYCODEID] | |
| 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. |