FACT_SOLICITCODECHANNELOPTOUT
Information on solicit code channel opt-out.
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| SOLICITCODECHANNELOPTOUTFACTID | int | Surrogate key for the solicit code channel optout fact. | ||
| SOLICITCODECHANNELOPTOUTSYSTEMID | uniqueidentifier | yes | [dbo].[SOLICITCODECHANNELOPTOUT].[ID] | |
| CONSTITUENTSYSTEMID | uniqueidentifier | [dbo].[SOLICITCODECHANNELOPTOUT].[CONSTITUENTID] | ||
| SOLICITCODECHANNEL | nvarchar(14) | yes | [dbo].[SOLICITCODECHANNELOPTOUT].[SOLICITCODECHANNEL] | |
| SOLICITCODECHANNELOPTOUTCONSENT | nvarchar(16) | yes | [dbo].[SOLICITCODECHANNELOPTOUT].[CONSENT] | |
| SOLICITCODECHANNELOPTOUTSTARTDATE | date | yes | [dbo].[SOLICITCODECHANNELOPTOUT].[STARTDATE] | |
| SOLICITCODECHANNELOPTOUTSOURCECODE | nvarchar(100) | yes | [dbo].[DATAPROTECTIONEVIDENCESOURCECODE].[DESCRIPTION] | |
| SOLICITCODECHANNELOPTOUTCOMMENTS | nvarchar(255) | [dbo].[SOLICITCODECHANNELOPTOUT].[COMMENTS] | ||
| ISINCLUDED | bit | yes | Flag indicating when data should be included in results. | |
| SOURCEDIMID | int | yes | ID generated through the ETL process. | |
| ETLCONTROLID | int | yes | Source system used. |