v_FACT_CONSTITUENTSOLICITCODE
Stores information about constituent solicit codes
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTSOLICITCODEFACTID | int | BBDW.[FACT_CONSTITUENTSOLICITCODE].[CONSTITUENTSOLICITCODEFACTID] | |
| CONSTITUENTSOLICITCODESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTSOLICITCODE].[CONSTITUENTSOLICITCODESYSTEMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[FACT_CONSTITUENTSOLICITCODE].[CONSTITUENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTSOLICITCODE].[CONSTITUENTSYSTEMID] |
| SOLICITCODEDIMID | int | yes | BBDW.[FACT_CONSTITUENTSOLICITCODE].[SOLICITCODEDIMID] |
| CONSTITUENTSOLICITCODESEQUENCE | int | yes | BBDW.[FACT_CONSTITUENTSOLICITCODE].[CONSTITUENTSOLICITCODESEQUENCE] |
| CONSTITUENTSOLICITCODESTARTDATE | datetime | yes | BBDW.[FACT_CONSTITUENTSOLICITCODE].[CONSTITUENTSOLICITCODESTARTDATE] |
| CONSTITUENTSOLICITCODESTARTDATEDIMID | int | yes | BBDW.[FACT_CONSTITUENTSOLICITCODE].[CONSTITUENTSOLICITCODESTARTDATEDIMID] |
| CONSTITUENTSOLICITCODEENDDATE | datetime | yes | BBDW.[FACT_CONSTITUENTSOLICITCODE].[CONSTITUENTSOLICITCODEENDDATE] |
| CONSTITUENTSOLICITCODEENDDATEDIMID | int | yes | BBDW.[FACT_CONSTITUENTSOLICITCODE].[CONSTITUENTSOLICITCODEENDDATEDIMID] |
| CONSTITUENTSOLICITCODECOMMENT | nvarchar(100) | yes | BBDW.[FACT_CONSTITUENTSOLICITCODE].[CONSTITUENTSOLICITCODECOMMENT] |
| CONSTITUENTSOLICITCODECONSENTPREFERENCE | nvarchar(11) | yes | BBDW.[FACT_CONSTITUENTSOLICITCODE].[CONSTITUENTSOLICITCODECONSENTPREFERENCE] |
| CONSTITUENTSOLICITCODESOURCECODE | nvarchar(100) | yes | BBDW.[FACT_CONSTITUENTSOLICITCODE].[CONSTITUENTSOLICITCODESOURCECODE] |
| CONSTITUENTSOLICITCODESOURCEFILEPATH | nvarchar(260) | yes | BBDW.[FACT_CONSTITUENTSOLICITCODE].[CONSTITUENTSOLICITCODESOURCEFILEPATH] |
| CONSTITUENTSOLICITCODEPRIVACYPOLICYFILEPATH | nvarchar(260) | yes | BBDW.[FACT_CONSTITUENTSOLICITCODE].[CONSTITUENTSOLICITCODEPRIVACYPOLICYFILEPATH] |
| CONSTITUENTSOLICITCODESUPPORTINGINFORMATION | nvarchar(max) | yes | BBDW.[FACT_CONSTITUENTSOLICITCODE].[CONSTITUENTSOLICITCODESUPPORTINGINFORMATION] |
| CONSTITUENTSOLICITCODECONSENTSTATEMENT | nvarchar(max) | yes | BBDW.[FACT_CONSTITUENTSOLICITCODE].[CONSTITUENTSOLICITCODECONSENTSTATEMENT] |
Definition
Copy
CREATE view [BBDW].[v_FACT_CONSTITUENTSOLICITCODE] as
select
[CONSTITUENTSOLICITCODEFACTID],
[CONSTITUENTSOLICITCODESYSTEMID],
[CONSTITUENTDIMID],
[CONSTITUENTSYSTEMID],
[SOLICITCODEDIMID],
[CONSTITUENTSOLICITCODESEQUENCE],
[CONSTITUENTSOLICITCODESTARTDATE],
[CONSTITUENTSOLICITCODESTARTDATEDIMID],
[CONSTITUENTSOLICITCODEENDDATE],
[CONSTITUENTSOLICITCODEENDDATEDIMID],
[CONSTITUENTSOLICITCODECOMMENT],
[CONSTITUENTSOLICITCODECONSENTPREFERENCE],
[CONSTITUENTSOLICITCODESOURCECODE],
[CONSTITUENTSOLICITCODESOURCEFILEPATH],
[CONSTITUENTSOLICITCODEPRIVACYPOLICYFILEPATH],
[CONSTITUENTSOLICITCODESUPPORTINGINFORMATION],
[CONSTITUENTSOLICITCODECONSENTSTATEMENT]
from [BBDW].[FACT_CONSTITUENTSOLICITCODE];