FACT_REVENUEATTRIBUTE

DEPRECATED as of 4.0. Please use the newer FACT_FINANCIALTRANSACTIONATTRIBUTE table. Contains information from revenue attributes.

Primary Key

Primary Key	Field Type
REVENUEATTRIBUTEFACTID	bigint

Fields

Field	Field Type	Null	Notes	Description
REVENUEATTRIBUTESYSTEMID	uniqueidentifier	yes		The attribute's [ID] column
ATTRIBUTEDIMID	int	yes		Reference key to the attribute dimension, derived from dbo.[ATTRIBUTE].[ID] and the attribute's code table ID column
ATTRIBUTESYSTEMID	uniqueidentifier	yes		dbo.[ATTRIBUTECATEGORY].[ID]
ATTRIBUTEVALUESYSTEMID	uniqueidentifier	yes		The [ID] from the appropriate code table for this attribute.
REVENUEFACTID	int	yes		Reference key to the revenue fact, derived from the attribute's [REVENUEID] column
ATTRIBUTESTARTDATEDIMID	int	yes		Reference key to the date dimension, derived from the attribute's [STARTDATE] column
ATTRIBUTESTARTDATE	datetime	yes		The attribute's [STARTDATE] column
ATTRIBUTEENDDATEDIMID	int	yes		Reference key to the date dimension, derived from the attribute's [ENDDATE] column
ATTRIBUTEENDDATE	datetime	yes		The attribute's [ENDDATE] column
ATTRIBUTEVALUE	nvarchar(255)	yes		The attribute's value column
ATTRIBUTEISCURRENT	bit	yes		Flag indicating if the attribute is currently active.
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.
REVENUESYSTEMID	uniqueidentifier	yes		The attribute table's [REVENUEID] column
FINANCIALTRANSACTIONFACTID	int	yes		Reference key to financial transaction fact table, derived from [dbo].[FINANCIALTRANSACTION].[ID]
FINANCIALTRANSACTIONLINEITEMFACTID	int	yes		Reference key to financial transaction line item fact table, derived from [dbo].[FINANCIALTRANSACTIONLINEITEM].[ID]
ATTRIBUTECOMMENT	nvarchar(255)	yes		The attribute's comment column

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_FACT_REVENUEATTRIBUTE	REVENUEATTRIBUTEFACTID	yes	yes	yes