v_DIM_SOLICITCODE
Stores information about solicit codes
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SOLICITCODEDIMID | int | BBDW.[DIM_SOLICITCODE].[SOLICITCODEDIMID] | |
| SOLICITCODESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_SOLICITCODE].[SOLICITCODESYSTEMID] |
| SOLICITCODE | nvarchar(100) | yes | BBDW.[DIM_SOLICITCODE].[SOLICITCODE] |
| SOLICITCODEISACTIVE | bit | yes | BBDW.[DIM_SOLICITCODE].[SOLICITCODEISACTIVE] |
| SOLICITCODESEQUENCE | int | yes | BBDW.[DIM_SOLICITCODE].[SOLICITCODESEQUENCE] |
| SOLICITCODETYPE | nvarchar(25) | yes | BBDW.[DIM_SOLICITCODE].[SOLICITCODETYPE] |
| SITEDIMID | int | yes | BBDW.[DIM_SOLICITCODE].[SITEDIMID] |
| SITESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_SOLICITCODE].[SITESYSTEMID] |
| SOLICITCODECONSENT | nvarchar(16) | yes | BBDW.[DIM_SOLICITCODE].[SOLICITCODECONSENT] |
| SOLICITCODECHANNEL | nvarchar(14) | yes | BBDW.[DIM_SOLICITCODE].[SOLICITCODECHANNEL] |
| SOLICITCODECOMMENTS | nvarchar(255) | yes | BBDW.[DIM_SOLICITCODE].[SOLICITCODECOMMENTS] |
Definition
Copy
CREATE view [BBDW].[v_DIM_SOLICITCODE] as
select
[SOLICITCODEDIMID],
[SOLICITCODESYSTEMID],
[SOLICITCODE],
[SOLICITCODEISACTIVE],
[SOLICITCODESEQUENCE],
[SOLICITCODETYPE],
[SITEDIMID],
[SITESYSTEMID],
[SOLICITCODECONSENT],
[SOLICITCODECHANNEL],
[SOLICITCODECOMMENTS]
from [BBDW].[DIM_SOLICITCODE];