DIM_CONSTITUENTINTEREST_STAGE
Contains information about constituent interests.
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| CONSTITUENTINTERESTSYSTEMID | uniqueidentifier | yes | dbo.[CONSTITUENTINTEREST].[ID] | |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | dbo.[CONSTITUENTINTEREST].[CONSTITUENTID] | |
| INTEREST | nvarchar(100) | yes | dbo.[CONSTITUENTINTERESTCODE].[DESCRIPTION] | |
| INTERESTNOTE | nvarchar(max) | yes | dbo.[CONSTITUENTINTEREST].[NOTE] | |
| 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. |