| CONSTITUENTPHONESYSTEMID |
uniqueidentifier |
yes |
|
dbo.[PHONE].[ID] |
| CONSTITUENTDIMID |
int |
yes |
|
Reference to the Constituent dimension, derived from dbo.[PHONE].[CONSTITUENTID] |
| CONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[PHONE].[CONSTITUENTID] |
| PHONENUMBER |
nvarchar(100) |
yes |
|
dbo.[PHONE].[NUMBER] |
| PHONENUMBERNOFORMAT |
nvarchar(100) |
yes |
|
dbo.[PHONE].[NUMBERNOFORMAT] |
| STARTDATEDIMID |
int |
yes |
|
Reference to the Date dimension, derived from dbo.[PHONE].[STARTDATE] |
| STARTDATE |
datetime |
yes |
|
dbo.[PHONE].[STARTDATE] |
| ENDDATEDIMID |
int |
yes |
|
Reference to the Date dimension, derived from dbo.[PHONE].[ENDDATE] |
| ENDDATE |
datetime |
yes |
|
dbo.[PHONE].[ENDDATE] |
| STARTTIMEDIMID |
int |
yes |
|
Reference to the Time dimension, derived from dbo.[PHONE].[STARTTIME] |
| STARTTIME |
char(4) |
yes |
|
dbo.[PHONE].[STARTTIME] |
| ENDTIMEDIMID |
int |
yes |
|
Reference to the Time dimension, derived from dbo.[PHONE].[ENDTIME] |
| ENDTIME |
char(4) |
yes |
|
dbo.[PHONE].[ENDTIME] |
| SEASONALSTARTMONTHDAY |
char(4) |
yes |
|
dbo.[PHONE].[SEASONALSTARTDATE] |
| SEASONALENDMONTHDAY |
char(4) |
yes |
|
dbo.[PHONE].[SEASONALENDDATE] |
| CONSTITUENTPHONETYPEDIMID |
int |
yes |
|
Reference to the Constituent Phone Type Dimension, derived from dbo.[PHONE].[PHONETYPECODE] |
| CONSTITUENTPHONEDIMID |
int |
yes |
|
Reference to the Constituent Phone Dimension, derived from dbo.[PHONE].[INFORSOURCECODEID] and dbo.[PHONE].[ORIGINCODE] |
| CONSTITUENTPHONEFLAGDIMID |
int |
yes |
|
Reference to the Constituent Phone Flag Dimension, derived from dbo.[PHONE].[ISPRIMARY], dbo.[PHONE].[DONOTCALL] and dbo.[PHONE].[ISCONFIDENTIAL] |
| DONOTCALLREASONDIMID |
int |
yes |
|
Reference to the Do Not Call Reason dimension, derived from dbo.[PHONE].[DONOTCALLREASONCODEID] |
| COUNTRYDIMID |
int |
yes |
|
Reference to the Country dimension, derived from dbo.[PHONE].[COUNTRYID] |
| CONSTITUENTRELATIONSHIPFACTID |
int |
yes |
|
Reference to the Constituent Relationship dimension, derived from dbo.[PHONE].[RELATIONSHIPID] |
| 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. |
| CONSTITUENTRELATIONSHIPSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[PHONE].[RELATIONSHIPID] |