FACT_CONSTITUENTPHONE_STAGE

Intermediate storage for constituent phone numbers

Fields

Field	Field Type	Null	Description
CONSTITUENTPHONESYSTEMID	uniqueidentifier	yes	dbo.[PHONE].[ID]
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]
COUNTRYDIMID	int	yes	Reference to the Country dimension, derived from dbo.[PHONE].[COUNTRYID]
DONOTCALLREASONDIMID	int	yes	Reference to the Do Not Call Reason dimension, derived from dbo.[PHONE].[DONOTCALLREASONCODEID]
CONSTITUENTRELATIONSHIPSYSTEMID	uniqueidentifier	yes	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.