DIM_ATTRIBUTE

Contains information about attribute.

Primary Key

Primary Key	Field Type
ATTRIBUTEDIMID	int

Fields

Field	Field Type	Null	Notes	Description
ATTRIBUTECATEGORYSYSTEMID	uniqueidentifier	yes		dbo.[ATTRIBUTECATEGORY].[ID]
ATTRIBUTEVALUESYSTEMID	uniqueidentifier	yes		The [ID] from the appropriate code table for this attribute.
ATTRIBUTEGROUP	nvarchar(100)	yes		dbo.[ATTRIBUTEGROUPCODE].[DESCRIPTION]
ATTRIBUTETYPE	nvarchar(100)	yes		dbo.[RECORDTYPE].[NAME]
ATTRIBUTENAME	nvarchar(100)	yes		dbo.[ATTRIBUTECATEGORY].[NAME]
ATTRIBUTEVALUE	nvarchar(255)	yes		Valid values for this attribute; from either the code table or Yes/No.
ATTRIBUTEDATATYPE	nvarchar(20)	yes		dbo.[ATTRIBUTECATEGORY].[DATATYPE]
ATTRIBUTEONLYALLOWONEPERRECORD	bit	yes		dbo.[ATTRIBUTECATEGORY].[ONLYALLOWONEPERRECORD]
ATTRIBUTEVALUEACTIVE	bit	yes		The attribute code table's [ACTIVE] column. This is always true for Yes/No attributes.
ATTRIBUTEHASCODETABLE	bit	yes		True when dbo.[ATTRIBUTECATEGORY].[DATATYPECODE] = 5
ATTRIBUTEFORREPORTING	bit	yes		This field is true when there is a row in dbo.[OLAPDATASOURCEATTRIBUTECATEGORY] with a matching [ATTRIBUTECATEGORYSYSTEMID] for this data mart.
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.

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_DIM_ATTRIBUTE	ATTRIBUTEDIMID	yes	yes	yes