V_QUERY_BBDW_SOLICITCODE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTSOLICITCODESYSTEMID | uniqueidentifier | yes | |
| CONSTITUENTDIMID | int | yes | |
| CONSTITUENTSOLICITCODESTARTDATEDIMID | int | yes | |
| CONSTITUENTSOLICITCODESTARTDATE | datetime | yes | |
| CONSTITUENTSOLICITCODEENDDATEDIMID | int | yes | |
| CONSTITUENTSOLICITCODEENDDATE | datetime | yes | |
| CONSTITUENTSOLICITCODECOMMENT | nvarchar(100) | yes | |
| SOLICITCODE | nvarchar(100) | yes | |
| SOLICITCODEISACTIVE | bit | yes | |
| CONSTITUENTSOLICITCODECONSENTPREFERENCE | nvarchar(11) | yes | |
| CONSTITUENTSOLICITCODESOURCECODE | nvarchar(100) | yes | |
| CONSTITUENTSOLICITCODESOURCEFILEPATH | nvarchar(260) | yes | |
| CONSTITUENTSOLICITCODEPRIVACYPOLICYFILEPATH | nvarchar(260) | yes | |
| CONSTITUENTSOLICITCODESUPPORTINGINFORMATION | nvarchar(max) | yes | |
| CONSTITUENTSOLICITCODECONSENTSTATEMENT | nvarchar(max) | yes | |
| SOLICITCODECHANNELOPTOUTSYSTEMID | uniqueidentifier | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_SOLICITCODE] as
select
fsc.[CONSTITUENTSOLICITCODESYSTEMID],
fsc.[CONSTITUENTDIMID],
fsc.[CONSTITUENTSOLICITCODESTARTDATEDIMID],
fsc.[CONSTITUENTSOLICITCODESTARTDATE],
fsc.[CONSTITUENTSOLICITCODEENDDATEDIMID],
fsc.[CONSTITUENTSOLICITCODEENDDATE],
fsc.[CONSTITUENTSOLICITCODECOMMENT],
dsc.[SOLICITCODE],
dsc.[SOLICITCODEISACTIVE],
case dsc.[SOLICITCODECONSENT]
when 'GDPR' then fsc.[CONSTITUENTSOLICITCODECONSENTPREFERENCE]
else null
end as [CONSTITUENTSOLICITCODECONSENTPREFERENCE],
fsc.[CONSTITUENTSOLICITCODESOURCECODE],
fsc.[CONSTITUENTSOLICITCODESOURCEFILEPATH],
fsc.[CONSTITUENTSOLICITCODEPRIVACYPOLICYFILEPATH],
fsc.[CONSTITUENTSOLICITCODESUPPORTINGINFORMATION],
fsc.[CONSTITUENTSOLICITCODECONSENTSTATEMENT],
fsc.[SOLICITCODECHANNELOPTOUTSYSTEMID]
from BBDW.[FACT_CONSTITUENTSOLICITCODE] fsc
left join BBDW.[DIM_SOLICITCODE] dsc on fsc.[SOLICITCODEDIMID] = dsc.[SOLICITCODEDIMID] and fsc.[SOLICITCODEDIMID] <> 0