| CONSTITUENTSOLICITCODESYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[CONSTITUENTSOLICITCODE].[ID] |
| CONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived from [dbo].[CONSTITUENTSOLICITCODE].[CONSTITUENTID] |
| CONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[CONSTITUENTSOLICITCODE].[CONSTITUENTID] |
| SOLICITCODEDIMID |
int |
yes |
|
Reference key to the solicit code dimension, derived from [dbo].[CONSTITUENTSOLICITCODE].[SOLICITCODEID] |
| CONSTITUENTSOLICITCODESEQUENCE |
int |
yes |
|
[dbo].[CONSTITUENTSOLICITCODE].[SEQUENCE] |
| CONSTITUENTSOLICITCODESTARTDATE |
datetime |
yes |
|
[dbo].[CONSTITUENTSOLICITCODE].[STARTDATE] |
| CONSTITUENTSOLICITCODESTARTDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from [dbo].[CONSTITUENTSOLICITCODE].[STARTDATE] |
| CONSTITUENTSOLICITCODEENDDATE |
datetime |
yes |
|
[dbo].[CONSTITUENTSOLICITCODE].[ENDDATE] |
| CONSTITUENTSOLICITCODEENDDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from [dbo].[CONSTITUENTSOLICITCODE].[ENDDATE] |
| 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. |
| CONSTITUENTSOLICITCODECOMMENT |
nvarchar(100) |
yes |
|
[dbo].[CONSTITUENTSOLICITCODE].[COMMENTS] |
| CONSTITUENTSOLICITCODECONSENTPREFERENCE |
nvarchar(11) |
yes |
|
dbo.[CONSTITUENTSOLICITCODE].[CONSENTPREFERENCE] |
| CONSTITUENTSOLICITCODESOURCECODE |
nvarchar(100) |
yes |
|
dbo.[DATAPROTECTIONEVIDENCESOURCECODE].[DESCRIPTION] |
| CONSTITUENTSOLICITCODESOURCEFILEPATH |
nvarchar(260) |
yes |
|
dbo.[CONSTITUENTSOLICITCODE].[SOURCEFILEPATH] |
| CONSTITUENTSOLICITCODEPRIVACYPOLICYFILEPATH |
nvarchar(260) |
yes |
|
dbo.[CONSTITUENTSOLICITCODE].[PRIVACYPOLICYFILEPATH] |
| CONSTITUENTSOLICITCODESUPPORTINGINFORMATION |
nvarchar(max) |
yes |
|
dbo.[CONSTITUENTSOLICITCODE].[SUPPORTINGINFORMATION] |
| CONSTITUENTSOLICITCODECONSENTSTATEMENT |
nvarchar(max) |
yes |
|
dbo.[CONSTITUENTSOLICITCODE].[CONSENTSTATEMENT] |
| SOLICITCODECHANNELOPTOUTSYSTEMID |
uniqueidentifier |
yes |
Default = ('00000000-0000-0000-0000-000000000000') |
dbo.[CONSTITUENTSOLICITCODE].[SOLICITCODECHANNELOPTOUTID] |