v_FACT_EVENTREGISTRANTBENEFIT
The benefit registrant fact table contains information about benefit registrant relationships.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EVENTREGISTRANTBENEFITFACTID | int | BBDW.[FACT_EVENTREGISTRANTBENEFIT].[REGISTRANTBENEFITFACTID] | |
| EVENTREGISTRANTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_EVENTREGISTRANTBENEFIT].[REGISTRANTSYSTEMID] |
| EVENTREGISTRANTFACTID | int | yes | BBDW.[FACT_EVENTREGISTRANTBENEFIT].[REGISTRANTFACTID] |
| BENEFITSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_EVENTREGISTRANTBENEFIT].[BENEFITSYSTEMID] |
| BENEFITDIMID | int | yes | BBDW.[FACT_EVENTREGISTRANTBENEFIT].[BENEFITDIMID] |
| QUANTITY | int | yes | BBDW.[FACT_EVENTREGISTRANTBENEFIT].[QUANTITY] |
| TOTALVALUE | money | yes | BBDW.[FACT_EVENTREGISTRANTBENEFIT].[TOTALVALUE] |
| BASETOTALVALUE | money | yes | BBDW.[FACT_EVENTREGISTRANTBENEFIT].[BASETOTALVALUE] |
| BASECURRENCYDIMID | int | yes | BBDW.[FACT_EVENTREGISTRANTBENEFIT].[BASECURRENCYDIMID] |
Definition
Copy
create view [BBDW].[v_FACT_EVENTREGISTRANTBENEFIT] as
select
[EVENTREGISTRANTBENEFITFACTID],
[EVENTREGISTRANTSYSTEMID],
[EVENTREGISTRANTFACTID],
[BENEFITSYSTEMID],
[BENEFITDIMID],
[QUANTITY],
[TOTALVALUE],
[BASETOTALVALUE],
[BASECURRENCYDIMID]
from
BBDW.[FACT_EVENTREGISTRANTBENEFIT]