FACT_PROSPECTFUNDINGINTERESTSITE_STAGE

Intermediate storage table for prospect funding interest sites.

Fields

Field	Field Type	Null	Notes	Description
PROSPECTFUNDINGINTERESTSITESYSTEMID	uniqueidentifier	yes		[dbo].[PROSPECTFUNDINGINTERESTSITE].[ID]
SITEDIMID	int	yes		Reference key to the site dimension, derived using [dbo].[PROSPECTFUNDINGINTERESTSITE].[SITEID]
PROSPECTFUNDINGINTERESTSYSTEMID	uniqueidentifier	yes		[dbo].[PROSPECTFUNDINGINTERESTSITE].[PROSPECTFUNDINGINTERESTID]
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.