DIM_SPONSORSHIPLOCATION

Stores information about sponsorship locations

Primary Key

Primary Key	Field Type
SPONSORSHIPLOCATIONDIMID	int

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]
FIELDOFFICECONSTITUENTDIMID	int	yes		Reference key to the constituent dimension, derived from dbo.[SPONSORSHIPLOCATION].[FIELDOFFICEID]
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.
SPONSORSHIPLOCATIONFULLNAME	nvarchar(4000)	yes		Full name for the sponsorship location. Uses logic similar to dbo.[UFN_SPONSORSHIPLOCATION_GETFULLNAME]

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_DIM_SPONSORSHIPLOCATION	SPONSORSHIPLOCATIONDIMID	yes	yes	yes