FACT_REVENUELETTER_STAGE

Staging table for the revenue letter fact

Fields

Field	Field Type	Null	Notes	Description
REVENUELETTERSYSTEMID	uniqueidentifier	yes		dbo.[REVENUELETTER].[ID]
FINANCIALTRANSACTIONSYSTEMID	uniqueidentifier	yes		dbo.[REVENUELETTER].[REVENUEID]
LETTERDIMID	int	yes		Reference key to the letter dimension, derived from dbo.[REVENUELETTER].[LETTERCODEID]
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.