v_FACT_SOLICITCODECHANNELOPTOUT
Information on solicit code channel opt-out.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SOLICITCODECHANNELOPTOUTFACTID | int | [BBDW].[FACT_SOLICITCODECHANNELOPTOUT].[SOLICITCODECHANNELOPTOUTFACTID] | |
| SOLICITCODECHANNELOPTOUTSYSTEMID | uniqueidentifier | yes | [BBDW].[FACT_SOLICITCODECHANNELOPTOUT].[SOLICITCODECHANNELOPTOUTSYSTEMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | [BBDW].[FACT_SOLICITCODECHANNELOPTOUT].[CONSTITUENTSYSTEMID] | |
| SOLICITCODECHANNEL | nvarchar(14) | yes | BBDW.[FACT_SOLICITCODECHANNELOPTOUT].[SOLICITCODECHANNEL] |
| SOLICITCODECHANNELOPTOUTCONSENT | nvarchar(16) | yes | BBDW.[FACT_SOLICITCODECHANNELOPTOUT].[SOLICITCODECHANNELOPTOUTCONSENT] |
| SOLICITCODECHANNELOPTOUTSTARTDATE | date | yes | BBDW.[FACT_SOLICITCODECHANNELOPTOUT].[SOLICITCODECHANNELOPTOUTSTARTDATE] |
| SOLICITCODECHANNELOPTOUTSOURCECODE | nvarchar(100) | yes | BBDW.[FACT_SOLICITCODECHANNELOPTOUT].[SOURCECODEID] |
| SOLICITCODECHANNELOPTOUTCOMMENTS | nvarchar(255) | BBDW.[FACT_SOLICITCODECHANNELOPTOUT].[SOLICITCODECHANNELOPTOUTCOMMENTS] |
Definition
Copy
create view [BBDW].[v_FACT_SOLICITCODECHANNELOPTOUT] as
select
[SOLICITCODECHANNELOPTOUTFACTID],
[SOLICITCODECHANNELOPTOUTSYSTEMID],
[CONSTITUENTSYSTEMID],
[SOLICITCODECHANNEL],
[SOLICITCODECHANNELOPTOUTCONSENT],
[SOLICITCODECHANNELOPTOUTSTARTDATE],
[SOLICITCODECHANNELOPTOUTSOURCECODE],
[SOLICITCODECHANNELOPTOUTCOMMENTS]
from [BBDW].[FACT_SOLICITCODECHANNELOPTOUT];