v_DIM_CONSTITUENTPHONE
The Constituent Phone dimension contains information about constituent phone numbers
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTPHONEDIMID | int | BBDW.[DIM_CONSTITUENTPHONE].[CONSTITUENTPHONEDIMID] | |
| INFORMATIONSOURCESYSTEMID | uniqueidentifier | yes | BBDW.[DIM_CONSTITUENTPHONE].[INFORMATIONSOURCESYSTEMID] |
| INFORMATIONSOURCE | nvarchar(100) | yes | BBDW.[DIM_CONSTITUENTPHONE].[INFORMATIONSOURCE] |
| ORIGINCODE | tinyint | yes | BBDW.[DIM_CONSTITUENTPHONE].[ORIGINCODE] |
| ORIGIN | nvarchar(9) | yes | BBDW.[DIM_CONSTITUENTPHONE].[ORIGIN] |
Definition
Copy
create view [BBDW].[v_DIM_CONSTITUENTPHONE] as
select
[CONSTITUENTPHONEDIMID],
[INFORMATIONSOURCESYSTEMID],
[INFORMATIONSOURCE],
[ORIGINCODE],
[ORIGIN]
from BBDW.[DIM_CONSTITUENTPHONE]