FACT_REVENUELETTER

Stores information about revenue letters

Primary Key

Primary Key	Field Type
REVENUELETTERFACTID	int

Fields

Field	Field Type	Null	Notes	Description
REVENUELETTERSYSTEMID	uniqueidentifier	yes		dbo.[REVENUELETTER].[ID]
FINANCIALTRANSACTIONFACTID	int	yes		Reference key to the financial transaction fact, derived from dbo.[REVENUELETTER].[REVENUEID]
LETTERDIMID	int	yes		Reference key to the letter dimension, derived from dbo.[REVENUELETTER].[LETTERCODEID]
ACKNOWLEDGEECONSTITUENTDIMID	int	yes		Reference key to the constituent dimension, derived from dbo.[REVENUELETTER].[ACKNOWLEDGEEID]
ACKNOWLEDGEECONSTITUENTSYSTEMID	uniqueidentifier	yes		dbo.[REVENUELETTER].[ACKNOWLEDGEEID]
PROCESSDATE	datetime	yes		dbo.[REVENUELETTER].[PROCESSDATE]
PROCESSDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[REVENUELETTER].[PROCESSDATE]
ACKNOWLEDGEDATE	datetime	yes		dbo.[REVENUELETTER].[ACKNOWLEDGEDATE]
ACKNOWLEDGEDATEDIMID	int	yes		Reference key to the date dimension, derived from dbo.[REVENUELETTER].[ACKNOWLEDGEDATE]
OUTOFDATE	bit	yes		dbo.[REVENUELETTER].[OUTOFDATE]
ISINCLUDED	bit	yes		Flag indicating when data should be included in results.
ETLCONTROLID	int	yes		ID generated through the ETL process.
SOURCEDIMID	int	yes		Source system used.

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_FACT_REVENUELETTER	REVENUELETTERFACTID	yes	yes	yes