V_QUERY_BBDW_SOLICITCODECHANNELOPTOUT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SOLICITCODECHANNELOPTOUTSYSTEMID | uniqueidentifier | yes | |
| CONSTITUENTSYSTEMID | uniqueidentifier | ||
| SOLICITCODECHANNEL | nvarchar(14) | yes | |
| SOLICITCODECHANNELOPTOUTCONSENT | nvarchar(16) | yes | |
| SOLICITCODECHANNELOPTOUTSTARTDATE | date | yes | |
| SOLICITCODECHANNELOPTOUTSOURCECODE | nvarchar(100) | yes | |
| SOLICITCODECHANNELOPTOUTCOMMENTS | nvarchar(255) |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_SOLICITCODECHANNELOPTOUT] as
SELECT
[SOLICITCODECHANNELOPTOUTSYSTEMID],
[CONSTITUENTSYSTEMID],
[SOLICITCODECHANNEL],
[SOLICITCODECHANNELOPTOUTCONSENT],
[SOLICITCODECHANNELOPTOUTSTARTDATE],
[SOLICITCODECHANNELOPTOUTSOURCECODE],
[SOLICITCODECHANNELOPTOUTCOMMENTS]
FROM
[BBDW].[FACT_SOLICITCODECHANNELOPTOUT]