DIM_SPONSOR_STAGE

Intermediate storage for sponsors

Fields

Field	Field Type	Null	Notes	Description
SPONSORSYSTEMID	uniqueidentifier	yes		dbo.[SPONSOR].[ID]
DONOTTERMINATE	bit	yes		dbo.[SPONSOR].[DONOTTERMINATE]
UNIQUEOPPORTUNITIESFORGIFTDONOR	bit	yes		dbo.[SPONSOR].[UNIQUEOPPORTUNITIESFORGIFTDONOR]
ISINCLUDED	bit	yes		Flag indicating when data should be included in results.
SOURCEDIMID	int	yes		Source system used.
ETLCONTROLID	int	yes		ID generated through the ETL process.