V_QUERY_BBDW_PHONE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTPHONESYSTEMID | uniqueidentifier | yes | |
| CONSTITUENTDIMID | int | yes | |
| PHONENUMBER | nvarchar(100) | yes | |
| STARTDATEDIMID | int | yes | |
| STARTDATE | datetime | yes | |
| ENDDATEDIMID | int | yes | |
| ENDDATE | datetime | yes | |
| STARTTIME | char(4) | yes | |
| ENDTIME | char(4) | yes | |
| SEASONALSTARTMONTHDAY | char(4) | yes | |
| SEASONALENDMONTHDAY | char(4) | yes | |
| DONOTCALL | bit | yes | |
| DONOTCALLREASON | nvarchar(100) | yes | |
| ISPRIMARY | bit | yes | |
| CONSTITUENTPHONETYPE | nvarchar(100) | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_PHONE] as
select
p.[CONSTITUENTPHONESYSTEMID],
p.[CONSTITUENTDIMID],
p.[PHONENUMBER],
p.[STARTDATEDIMID],
p.[STARTDATE],
p.[ENDDATEDIMID],
p.[ENDDATE],
p.[STARTTIME],
p.[ENDTIME],
p.[SEASONALSTARTMONTHDAY],
p.[SEASONALENDMONTHDAY],
pf.[DONOTCALL],
dnc.[DONOTCALLREASON],
pf.[ISPRIMARY],
pt.[CONSTITUENTPHONETYPE]
from BBDW.[FACT_CONSTITUENTPHONE] p
left join BBDW.[DIM_CONSTITUENTPHONEFLAG] pf on p.[CONSTITUENTPHONEFLAGDIMID] = pf.[CONSTITUENTPHONEFLAGDIMID] and p.[CONSTITUENTPHONEFLAGDIMID] <> 0
left join BBDW.[DIM_CONSTITUENTPHONETYPE] pt on pt.[CONSTITUENTPHONETYPEDIMID] = p.[CONSTITUENTPHONETYPEDIMID] and p.[CONSTITUENTPHONETYPEDIMID] <> 0
left join BBDW.[DIM_DONOTCALLREASON] dnc on dnc.[DONOTCALLREASONDIMID] = p.[DONOTCALLREASONDIMID] and p.[DONOTCALLREASONDIMID] <> 0