v_FACT_CONSTITUENTMAILPREFERENCE
Stores mail preferences for constituents
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTMAILPREFERENCEFACTID | int | BBDW.[FACT_CONSTITUENTMAILPREFERENCE].[CONSTITUENTMAILPREFERENCEFACTID] | |
| CONSTITUENTMAILPREFERENCESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTMAILPREFERENCE].[CONSTITUENTMAILPREFERENCESYSTEMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[FACT_CONSTITUENTMAILPREFERENCE].[CONSTITUENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTMAILPREFERENCE].[CONSTITUENTSYSTEMID] |
| MAILPREFERENCEDIMID | int | yes | BBDW.[FACT_CONSTITUENTMAILPREFERENCE].[MAILPREFERENCEDIMID] |
| BUSINESSUNITDIMID | int | yes | BBDW.[FACT_CONSTITUENTMAILPREFERENCE].[BUSINESSUNITDIMID] |
| SITEDIMID | int | yes | BBDW.[FACT_CONSTITUENTMAILPREFERENCE].[SITEDIMID] |
| ACKNOWLEDGEMENTPROCESSDIMID | int | yes | BBDW.[FACT_CONSTITUENTMAILPREFERENCE].[ACKNOWLEDGEMENTPROCESSDIMID] |
| CORRESPONDENCEPROCESSDIMID | int | yes | BBDW.[FACT_CONSTITUENTMAILPREFERENCE].[CORRESPONDENCEPROCESSDIMID] |
| PLEDGEREMINDERPROCESSDIMID | int | yes | BBDW.[FACT_CONSTITUENTMAILPREFERENCE].[PLEDGEREMINDERPROCESSDIMID] |
| PURPOSELEVELDIMID | int | yes | BBDW.[FACT_CONSTITUENTMAILPREFERENCE].[PURPOSELEVELDIMID] |
| CONSTITUENTADDRESSFACTID | int | yes | BBDW.[FACT_CONSTITUENTMAILPREFERENCE].[CONSTITUENTADDRESSFACTID] |
| CONSTITUENTEMAILADDRESSFACTID | int | yes | BBDW.[FACT_CONSTITUENTMAILPREFERENCE].[CONSTITUENTEMAILADDRESSFACTID] |
| SENDMAIL | bit | yes | BBDW.[FACT_CONSTITUENTMAILPREFERENCE].[SENDMAIL] |
| USESEASONALADDRESS | bit | yes | BBDW.[FACT_CONSTITUENTMAILPREFERENCE].[USESEASONALADDRESS] |
| USEPRIMARYADDRESS | bit | yes | BBDW.[FACT_CONSTITUENTMAILPREFERENCE].[USEPRIMARYADDRESS] |
| USEPRIMARYEMAILADDRESS | bit | yes | BBDW.[FACT_CONSTITUENTMAILPREFERENCE].[USEPRIMARYEMAILADDRESS] |
| DONOTSENDOTHERCHANNEL | bit | yes | BBDW.[FACT_CONSTITUENTMAILPREFERENCE].[DONOTSENDOTHERCHANNEL] |
| CONSTITUENTMAILPREFERENCECOMMENT | nvarchar(500) | yes | BBDW.[FACT_CONSTITUENTMAILPREFERENCE].[CONSTITUENTMAILPREFERENCECOMMENT] |
Definition
Copy
create view [BBDW].[v_FACT_CONSTITUENTMAILPREFERENCE] as
select
[CONSTITUENTMAILPREFERENCEFACTID],
[CONSTITUENTMAILPREFERENCESYSTEMID],
[CONSTITUENTDIMID],
[CONSTITUENTSYSTEMID],
[MAILPREFERENCEDIMID],
[BUSINESSUNITDIMID],
[SITEDIMID],
[ACKNOWLEDGEMENTPROCESSDIMID],
[CORRESPONDENCEPROCESSDIMID],
[PLEDGEREMINDERPROCESSDIMID],
[PURPOSELEVELDIMID],
[CONSTITUENTADDRESSFACTID],
[CONSTITUENTEMAILADDRESSFACTID],
[SENDMAIL],
[USESEASONALADDRESS],
[USEPRIMARYADDRESS],
[USEPRIMARYEMAILADDRESS],
[DONOTSENDOTHERCHANNEL],
[CONSTITUENTMAILPREFERENCECOMMENT]
from [BBDW].[FACT_CONSTITUENTMAILPREFERENCE];