DIM_SPONSORSHIPLOCATION_STAGE

Intermediate storage for sponsorship location records

Fields

Field	Field Type	Null	Notes	Description
SPONSORSHIPLOCATIONSYSTEMID	uniqueidentifier	yes		dbo.[SPONSORSHIPLOCATION].[ID]
SPONSORSHIPLOCATIONLOOKUPID	nvarchar(100)	yes		dbo.[SPONSORSHIPLOCATION].[LOOKUPID]
SPONSORSHIPLOCATIONNAME	nvarchar(100)	yes		dbo.[SPONSORSHIPLOCATION].[NAME]
SPONSORSHIPLOCATIONSTATUSCODE	smallint	yes		dbo.[SPONSORSHIPLOCATION].[STATUSCODE]
SPONSORSHIPLOCATIONSTATUS	nvarchar(25)	yes		dbo.[SPONSORSHIPLOCATION].[STATUS]
SPONSORSHIPLOCATIONCOMMENT	nvarchar(255)	yes		dbo.[SPONSORSHIPLOCATION].[COMMENT]
SPONSORSHIPLOCATIONTYPECODESYSTEMID	uniqueidentifier	yes		dbo.[SPONSORSHIPLOCATION].[SPONSORSHIPLOCATIONTYPECODEID]
SPONSORSHIPLOCATIONTYPE	nvarchar(100)	yes		dbo.[SPONSORSHIPLOCATIONTYPECODE].[DESCRIPTION]
DISPLAYONLINE	bit	yes		dbo.[SPONSORSHIPLOCATION].[DISPLAYONLINE]
DESIGNATIONDIMID	int	yes		Reference key to the designation dimension, derived from dbo.[SPONSORSHIPLOCATION].[DESIGNATIONID]
FIELDOFFICECONSTITUENTSYSTEMID	uniqueidentifier	yes		dbo.[SPONSORSHIPLOCATION].[FIELDOFFICEID]
SPONSORSHIPREASONDIMID	int	yes		Reference key to the sponsorship reason dimension, derived from dbo.[SPONSORSHIPLOCATION].[SPONSORSHIPREASONID]
SPONSORSHIPLOCATIONHIERARCHYID	hierarchyid	yes		dbo.[SPONSORSHIPLOCATION].[HIERARCHYPATH]
PARENTSPONSORSHIPLOCATIONDIMID	int	yes		Reference key to the sponsorship location dimension, derived from dbo.[SPONSORSHIPLOCATION].[HIERARCHYPATH]
PARENTSPONSORSHIPLOCATIONSYSTEMID	uniqueidentifier	yes		Derived from dbo.[SPONSORSHIPLOCATION].[HIERARCHYPATH]
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.