FACT_ACCOUNTSYSTEMSITE_STAGE

Intermediate storage table for account system sites.

Fields

Field	Field Type	Null	Notes	Description
ACCOUNTSYSTEMSITESYSTEMID	uniqueidentifier	yes		[dbo].[PDACCOUNTSYSTEMSITE].[ID]
SITESYSTEMID	uniqueidentifier	yes		[dbo].[PDACCOUNTSYSTEMSITE].[SITEID]
SITEDIMID	int	yes		Reference key to the site dimension, derived using [dbo].[PDACCOUNTSYSTEMSITE].[SITEID]
ACCOUNTSYSTEMSYSTEMID	uniqueidentifier	yes		[dbo].[PDACCOUNTSYSTEMSITE].[PDACCOUNTSYSTEMID]
ACCOUNTSYSTEMDIMID	int	yes		Reference key to the account system dimension, derived using [dbo].[PDACCOUNTSYSTEMSITE].[PDACCOUNTSYSTEMID]
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.