v_FACT_CONSTITUENTPHONE
The Constituent Phone Fact table stores information about constituent phone numbers
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTPHONEFACTID | int | BBDW.[FACT_CONSTITUENTPHONE].[CONSTITUENTPHONEFACTID] | |
| CONSTITUENTPHONESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTPHONE].[CONSTITUENTPHONESYSTEMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[FACT_CONSTITUENTPHONE].[CONSTITUENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_CONSTITUENTPHONE].[CONSTITUENTSYSTEMID] |
| PHONENUMBER | nvarchar(100) | yes | BBDW.[FACT_CONSTITUENTPHONE].[PHONENUMBER] |
| PHONENUMBERNOFORMAT | nvarchar(100) | yes | BBDW.[FACT_CONSTITUENTPHONE].[PHONENUMBERNOFORMAT] |
| STARTDATEDIMID | int | yes | BBDW.[FACT_CONSTITUENTPHONE].[STARTDATEDIMID] |
| STARTDATE | datetime | yes | BBDW.[FACT_CONSTITUENTPHONE].[STARTDATE] |
| ENDDATEDIMID | int | yes | BBDW.[FACT_CONSTITUENTPHONE].[ENDDATEDIMID] |
| ENDDATE | datetime | yes | BBDW.[FACT_CONSTITUENTPHONE].[ENDDATE] |
| STARTTIME | char(4) | yes | BBDW.[FACT_CONSTITUENTPHONE].[STARTTIME] |
| STARTTIMEDIMID | int | yes | BBDW.[FACT_CONSTITUENTPHONE].[STARTTIMEDIMID] |
| ENDTIME | char(4) | yes | BBDW.[FACT_CONSTITUENTPHONE].[ENDTIME] |
| ENDTIMEDIMID | int | yes | BBDW.[FACT_CONSTITUENTPHONE].[ENDTIMEDIMID] |
| SEASONALSTARTMONTHDAY | char(4) | yes | BBDW.[FACT_CONSTITUENTPHONE].[SEASONALSTARTMONTHDAY] |
| SEASONALENDMONTHDAY | char(4) | yes | BBDW.[FACT_CONSTITUENTPHONE].[SEASONALENDMONTHDAY] |
| CONSTITUENTPHONETYPEDIMID | int | yes | BBDW.[FACT_CONSTITUENTPHONE].[CONSTITUENTPHONETYPEDIMID] |
| CONSTITUENTPHONEDIMID | int | yes | BBDW.[FACT_CONSTITUENTPHONE].[CONSTITUENTPHONEDIMID] |
| CONSTITUENTPHONEFLAGDIMID | int | yes | BBDW.[FACT_CONSTITUENTPHONE].[CONSTITUENTPHONEFLAGDIMID] |
| DONOTCALLREASONDIMID | int | yes | BBDW.[FACT_CONSTITUENTPHONE].[DONOTCALLREASONDIMID] |
| COUNTRYDIMID | int | yes | BBDW.[FACT_CONSTITUENTPHONE].[COUNTRYDIMID] |
| CONSTITUENTRELATIONSHIPFACTID | int | yes | BBDW.[FACT_CONSTITUENTPHONE].[CONSTITUENTRELATIONSHIPFACTID] |
Definition
Copy
create view [BBDW].[v_FACT_CONSTITUENTPHONE] as
select
[CONSTITUENTPHONEFACTID],
[CONSTITUENTPHONESYSTEMID],
[CONSTITUENTDIMID],
[CONSTITUENTSYSTEMID],
[PHONENUMBER],
[PHONENUMBERNOFORMAT],
[STARTDATEDIMID],
[STARTDATE],
[ENDDATEDIMID],
[ENDDATE],
[STARTTIME],
[STARTTIMEDIMID],
[ENDTIME],
[ENDTIMEDIMID],
[SEASONALSTARTMONTHDAY],
[SEASONALENDMONTHDAY],
[CONSTITUENTPHONETYPEDIMID],
[CONSTITUENTPHONEDIMID],
[CONSTITUENTPHONEFLAGDIMID],
[DONOTCALLREASONDIMID],
[COUNTRYDIMID],
[CONSTITUENTRELATIONSHIPFACTID]
from BBDW.[FACT_CONSTITUENTPHONE]