v_FACT_EVENTREGISTRANTBENEFITTOTAL
The event registrant benefit totalfact table contains aggregated information about registrant benefits.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EVENTREGISTRANTBENEFITTOTALFACTID | int | BBDW.[FACT_EVENTREGISTRANTBENEFITTOTAL].[REGISTRANTBENEFITFACTID] | |
| EVENTDIMID | int | yes | BBDW.[FACT_EVENTREGISTRANTBENEFITTOTAL].[EVENTDIMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[FACT_EVENTREGISTRANTBENEFITTOTAL].[CONSTITUENTDIMID] |
| EVENTREGISTRANTFACTID | int | yes | BBDW.[FACT_EVENTREGISTRANTBENEFITTOTAL].[EVENTREGISTRANTFACTID] |
| BENEFITLIST | nvarchar(500) | yes | BBDW.[FACT_EVENTREGISTRANTBENEFITTOTAL].[BENEFITLIST] |
| TOTALVALUE | money | yes | BBDW.[FACT_EVENTREGISTRANTBENEFITTOTAL].[TOTALVALUE] |
| BENEFITTYPEDIMID | int | yes | BBDW.[FACT_EVENTREGISTRANTBENEFITTOTAL].[BENEFITTYPEDIMID] |
Definition
Copy
CREATE view [BBDW].[v_FACT_EVENTREGISTRANTBENEFITTOTAL] as
select
[EVENTREGISTRANTBENEFITTOTALFACTID],
[EVENTDIMID],
[CONSTITUENTDIMID],
[EVENTREGISTRANTFACTID],
[BENEFITLIST],
[TOTALVALUE],
[BENEFITTYPEDIMID]
from
BBDW.[FACT_EVENTREGISTRANTBENEFITTOTAL]