v_DIM_BENEFIT
The benefit fact table contains information about benefits.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| BENEFITDIMID | int | BBDW.[DIM_BENEFIT].[BENEFITDIMID] | |
| BENEFITSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_BENEFIT].[BENEFITSYSTEMID] |
| BENEFITNAME | nvarchar(200) | yes | BBDW.[DIM_BENEFIT].[NAME] |
| BENEFITDESCRIPTION | nvarchar(510) | yes | BBDW.[DIM_BENEFIT].[DESCRIPTION] |
| BENEFITCATEGORY | nvarchar(200) | yes | BBDW.[DIM_BENEFIT].[BENEFITCATEGORY] |
| SENDBENEFITCODE | tinyint | yes | BBDW.[DIM_BENEFIT].[SENDBENEFITCODE] |
| SENDBENEFIT | nvarchar(20) | yes | BBDW.[DIM_BENEFIT].[SENDBENEFIT] |
| BENEFITVENDORCONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_BENEFIT].[BENEFITVENDORCONSTITUENTSYSTEMID] |
| BENEFITVENDORCONSTITUENTDIMID | int | yes | BBDW.[DIM_BENEFIT].[BENEFITVENDORCONSTITUENTDIMID] |
| FULFILLMENTVENDORCONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_BENEFIT].[FULFILLMENTVENDORCONSTITUENTSYSTEMID] |
| FULFILLMENTVENDORCONSTITUENTDIMID | int | yes | BBDW.[DIM_BENEFIT].[FULFILLMENTVENDORCONSTITUENTDIMID] |
| BASECURRENCYDIMID | int | yes | BBDW.[DIM_BENEFIT].[BASECURRENCYDIMID] |
| VALUE | money | yes | BBDW.[DIM_BENEFIT].[VALUE] |
| USEPERCENT | bit | yes | BBDW.[DIM_BENEFIT].[USEPERCENT] |
| VALUEPERCENT | decimal(20, 2) | yes | BBDW.[DIM_BENEFIT].[VALUEPERCENT] |
| BENEFITDESC | nvarchar(200) | yes | BBDW.[DIM_BENEFIT].[BENEFITDESC] |
| COST | money | yes | BBDW.[DIM_BENEFIT].[COST] |
Definition
Copy
create view [BBDW].[v_DIM_BENEFIT] as
select
[BENEFITDIMID],
[BENEFITSYSTEMID],
[BENEFITNAME],
[BENEFITDESCRIPTION],
[BENEFITCATEGORY],
[SENDBENEFITCODE],
[SENDBENEFIT],
[BENEFITVENDORCONSTITUENTSYSTEMID],
[BENEFITVENDORCONSTITUENTDIMID],
[FULFILLMENTVENDORCONSTITUENTSYSTEMID],
[FULFILLMENTVENDORCONSTITUENTDIMID],
[BASECURRENCYDIMID],
[VALUE],
[USEPERCENT],
[VALUEPERCENT],
[BENEFITDESC],
[COST]
from
BBDW.[DIM_BENEFIT]