v_DIM_REVENUEFLAG

The revenue flag dimension contains boolean information about revenue.

Fields

Field	Field Type	Null	Description
REVENUEFLAGDIMID	int		BBDW.[DIM_REVENUEFLAG].[REVENUEFLAGDIMID]
BENEFITSWAIVED	int	yes	BBDW.[DIM_REVENUEFLAG].[BENEFITSWAIVED]
BENEFITSWAIVEDDESCRIPTION	nvarchar(50)	yes	BBDW.[DIM_REVENUEFLAG].[BENEFITSWAIVEDDESCRIPTION]
DONOTACKNOWLEDGE	int	yes	BBDW.[DIM_REVENUEFLAG].[DONOTACKNOWLEDGE]
DONOTACKNOWLEDGEDESCRIPTION	nvarchar(50)	yes	BBDW.[DIM_REVENUEFLAG].[DONOTACKNOWLEDGEDESCRIPTION]
DONOTRECEIPT	int	yes	BBDW.[DIM_REVENUEFLAG].[DONOTRECEIPT]
DONOTRECEIPTDESCRIPTION	nvarchar(50)	yes	BBDW.[DIM_REVENUEFLAG].[DONOTRECEIPTDESCRIPTION]
GIVENANONYMOUSLY	int	yes	BBDW.[DIM_REVENUEFLAG].[GIVENANONYMOUSLY]
GIVENANONYMOUSLYDESCRIPTION	nvarchar(50)	yes	BBDW.[DIM_REVENUEFLAG].[GIVENANONYMOUSLYDESCRIPTION]
ISORIGINATION	int	yes	BBDW.[DIM_REVENUEFLAG].[ISORIGINATION]
ISORIGINATIONDESCRIPTION	nvarchar(50)	yes	BBDW.[DIM_REVENUEFLAG].[ISORIGINATIONDESCRIPTION]
NEEDSRERECEIPT	int	yes	BBDW.[DIM_REVENUEFLAG].[NEEDSRERECEIPT]
NEEDSRERECEIPTDESCRIPTION	nvarchar(50)	yes	BBDW.[DIM_REVENUEFLAG].[NEEDSRERECEIPTDESCRIPTION]
ISDELETEDFINANCIALTRANSACTION	int	yes	BBDW.[DIM_REVENUEFLAG].[ISDELETEDFINANCIALTRANSACTION]
ISDELETEDFINANCIALTRANSACTIONDESCRIPTION	nvarchar(50)	yes	BBDW.[DIM_REVENUEFLAG].[ISDELETEDFINANCIALTRANSACTIONDESCRIPTION]
ISDELETEDFINANCIALTRANSACTIONLINEITEM	int	yes	BBDW.[DIM_REVENUEFLAG].[ISDELETEDFINANCIALTRANSACTIONLINEITEM]
ISDELETEDFINANCIALTRANSACTIONLINEITEMDESCRIPTION	nvarchar(50)	yes	BBDW.[DIM_REVENUEFLAG].[ISDELETEDFINANCIALTRANSACTIONLINEITEMDESCRIPTION]

Definition

Copy


            CREATE view [BBDW].[v_DIM_REVENUEFLAG] as
            select
            [REVENUEFLAGDIMID], 
            [BENEFITSWAIVED], 
            [BENEFITSWAIVEDDESCRIPTION],
            [DONOTACKNOWLEDGE], 
            [DONOTACKNOWLEDGEDESCRIPTION],
            [DONOTRECEIPT], 
            [DONOTRECEIPTDESCRIPTION],
            [GIVENANONYMOUSLY], 
            [GIVENANONYMOUSLYDESCRIPTION],
            [ISORIGINATION], 
            [ISORIGINATIONDESCRIPTION],
            [NEEDSRERECEIPT],
            [NEEDSRERECEIPTDESCRIPTION],
            [ISDELETEDFINANCIALTRANSACTION],
            [ISDELETEDFINANCIALTRANSACTIONDESCRIPTION],
            [ISDELETEDFINANCIALTRANSACTIONLINEITEM],
            [ISDELETEDFINANCIALTRANSACTIONLINEITEMDESCRIPTION]
            from [BBDW].[DIM_REVENUEFLAG]