| CONSTITUENTMAILPREFERENCESYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[MAILPREFERENCE].[ID] |
| CONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived from dbo.[MAILPREFERENCE].[CONSTITUENTID] |
| CONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[MAILPREFERENCE].[CONSTITUENTID] |
| MAILPREFERENCEDIMID |
int |
yes |
|
Reference key to the mail preference dimension, derived from [dbo].[MAILPREFERENCE].[MAILTYPECODE], [dbo].[MAILPREFERENCE].[CATEGORYCODEID], [dbo].[MAILPREFERENCE].[CORRESPONDENCECODEID], [dbo].[MAILPREFERENCE].[RECEIPTTYPECODE], [dbo].[MAILPREFERENCE].[DELIVERYMETHODCODE] and [dbo].[MAILPREFERENCE].[EVENTCATEGORYCODEID] |
| BUSINESSUNITDIMID |
int |
yes |
|
Reference key to the business unit dimension, derived from [dbo].[MAILPREFERENCE].[BUSINESSUNITCODEID] |
| SITEDIMID |
int |
yes |
|
Reference key to the site dimension, derived from [dbo].[MAILPREFERENCE].[SITEID] |
| ACKNOWLEDGEMENTPROCESSDIMID |
int |
yes |
|
Reference key to the process dimension, derived from [dbo].[MAILPREFERENCE].[ACKNOWLEDGEMENTID] |
| CORRESPONDENCEPROCESSDIMID |
int |
yes |
|
Reference key to the process dimension, derived from [dbo].[MAILPREFERENCE].[CORRESPONDENCEID] |
| PLEDGEREMINDERPROCESSDIMID |
int |
yes |
|
Reference key to the process dimension, derived from [dbo].[MAILPREFERENCE].[PLEDGEREMINDERID] |
| PURPOSELEVELDIMID |
int |
yes |
|
Reference key to the purpose level dimension, derived from [dbo].[MAILPREFERENCE].[PURPOSEID] |
| CONSTITUENTADDRESSFACTID |
int |
yes |
|
Reference key the constituent address fact, derived from [dbo].[MAILPREFERENCE].[ADDRESSID] |
| CONSTITUENTEMAILADDRESSFACTID |
int |
yes |
|
Reference key the constituent email address fact, derived from [dbo].[MAILPREFERENCE].[EMAILADDRESSID] |
| SENDMAIL |
bit |
yes |
|
[dbo].[MAILPREFERENCE].[SENDMAIL] |
| USESEASONALADDRESS |
bit |
yes |
|
[dbo].[MAILPREFERENCE].[USESEASONALADDRESS] |
| USEPRIMARYADDRESS |
bit |
yes |
|
[dbo].[MAILPREFERENCE].[USEPRIMARYADDRESS] |
| USEPRIMARYEMAILADDRESS |
bit |
yes |
|
[dbo].[MAILPREFERENCE].[USEPRIMARYEMAIL] |
| DONOTSENDOTHERCHANNEL |
bit |
yes |
|
[dbo].[MAILPREFERENCE].[DONOTSENDOTHERCHANNEL] |
| CONSTITUENTMAILPREFERENCECOMMENT |
nvarchar(500) |
yes |
|
[dbo].[MAILPREFERENCE].[COMMENTS] |
| ISINCLUDED |
bit |
yes |
|
Flag indicating when data should be included in results |
| ETLCONTROLID |
int |
yes |
|
ID generated through the ETL process. |
| SOURCEDIMID |
int |
yes |
|
Source system used. |
| CONSTITUENTSOLICITCODESYSTEMID |
uniqueidentifier |
yes |
Default = ('00000000-0000-0000-0000-000000000000') |
[dbo].[CONSTITUENTSOLICITCODE].[ID] |
| HASINHERITEDCONSENT |
bit |
yes |
Default = 0 |
[dbo].[MAILPREFERENCE].[HASINHERITEDCONSENT] |
| SOURCECODE |
nvarchar(100) |
yes |
Default = '' |
[dbo].[DATAPROTECTIONEVIDENCESOURCECODE].[DESCRIPTION] |
| SOURCEFILEPATH |
nvarchar(260) |
yes |
Default = '' |
[dbo].[MAILPREFERENCE].[SOURCEFILEPATH] |
| PRIVACYPOLICYFILEPATH |
nvarchar(260) |
yes |
Default = '' |
[dbo].[MAILPREFERENCE].[PRIVACYPOLICYFILEPATH] |
| SUPPORTINGINFORMATION |
nvarchar(max) |
yes |
Default = '' |
[dbo].[MAILPREFERENCE].[SUPPORTINGINFORMATION] |
| CONSENTSTATEMENT |
nvarchar(max) |
yes |
Default = '' |
[dbo].[MAILPREFERENCE].[CONSENTSTATEMENT] |