v_DIM_MAILPREFERENCE
Stores information about mailing preferences
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| MAILPREFERENCEDIMID | int | BBDW.[DIM_MAILPREFERENCE].[MAILPREFERENCEDIMID] | |
| MAILTYPECODE | tinyint | yes | BBDW.[DIM_MAILPREFERENCE].[MAILTYPECODE] |
| MAILTYPE | nvarchar(29) | yes | BBDW.[DIM_MAILPREFERENCE].[MAILTYPE] |
| APPEALCATEGORYSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_MAILPREFERENCE].[APPEALCATEGORYSYSTEMID] |
| APPEALCATEGORY | nvarchar(100) | yes | BBDW.[DIM_MAILPREFERENCE].[APPEALCATEGORY] |
| CORRESPONDENCECODESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_MAILPREFERENCE].[CORRESPONDENCECODESYSTEMID] |
| CORRESPONDENCECODE | nvarchar(255) | yes | BBDW.[DIM_MAILPREFERENCE].[CORRESPONDENCECODE] |
| RECEIPTTYPECODE | tinyint | yes | BBDW.[DIM_MAILPREFERENCE].[RECEIPTTYPECODE] |
| RECEIPTTYPE | nvarchar(13) | yes | BBDW.[DIM_MAILPREFERENCE].[RECEIPTTYPE] |
| DELIVERYMETHODCODE | tinyint | yes | BBDW.[DIM_MAILPREFERENCE].[DELIVERYMETHODCODE] |
| DELIVERYMETHOD | nvarchar(5) | yes | BBDW.[DIM_MAILPREFERENCE].[DELIVERYMETHOD] |
| EVENTCATEGORYCODESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_MAILPREFERENCE].[EVENTCATEGORYCODESYSTEMID] |
| EVENTCATEGORY | nvarchar(100) | yes | BBDW.[DIM_MAILPREFERENCE].[EVENTCATEGORY] |
Definition
Copy
create view [BBDW].[v_DIM_MAILPREFERENCE] as
select
[MAILPREFERENCEDIMID],
[MAILTYPECODE],
[MAILTYPE],
[APPEALCATEGORYSYSTEMID],
[APPEALCATEGORY],
[CORRESPONDENCECODESYSTEMID],
[CORRESPONDENCECODE],
[RECEIPTTYPECODE],
[RECEIPTTYPE],
[DELIVERYMETHODCODE],
[DELIVERYMETHOD],
[EVENTCATEGORYCODESYSTEMID],
[EVENTCATEGORY]
from [BBDW].[DIM_MAILPREFERENCE];