v_FACT_EVENTREGISTRATIONOPPORTUNITY
Stores information about event registrations and opportunity links
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EVENTREGISTRATIONOPPORTUNITYFACTID | int | BBDW.[FACT_EVENTREGISTRATIONOPPORTUNITY].[EVENTREGISTRATIONOPPORTUNITYFACTID] | |
| EVENTREGISTRATIONOPPORTUNITYSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_EVENTREGISTRATIONOPPORTUNITY].[EVENTREGISTRATIONOPPORTUNITYSYSTEMID] |
| EVENTREGISTRANTFACTID | int | yes | BBDW.[FACT_EVENTREGISTRATIONOPPORTUNITY].[EVENTREGISTRANTFACTID] |
| OPPORTUNITYFACTID | int | yes | BBDW.[FACT_EVENTREGISTRATIONOPPORTUNITY].[OPPORTUNITYFACTID] |
Definition
Copy
create view [BBDW].[v_FACT_EVENTREGISTRATIONOPPORTUNITY] as
select
[EVENTREGISTRATIONOPPORTUNITYFACTID],
[EVENTREGISTRATIONOPPORTUNITYSYSTEMID],
[EVENTREGISTRANTFACTID],
[OPPORTUNITYFACTID]
from [BBDW].[FACT_EVENTREGISTRATIONOPPORTUNITY];