V_QUERY_BBDW_EVENTREGISTRANT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EVENTREGISTRANTSYSTEMID | uniqueidentifier | yes | |
| EVENTREGISTRANTFACTID | int | ||
| CONSTITUENTDIMID | int | yes | |
| EVENTDIMID | int | yes | |
| ATTENDED | bit | yes | |
| ISCANCELLED | bit | yes | |
| WILLNOTATTEND | bit | yes | |
| REGISTRATIONFEE | money | yes | |
| REGISTRATIONFEERECEIVED | money | yes | |
| ONLINEREGISTRANT | bit | yes | |
| INBOUNDCHANNEL | nvarchar(24) | yes | |
| RECRUITEMENTCHANNEL | nvarchar(100) | yes | |
| ROLE | nvarchar(100) | yes | |
| CURRENCYSYSTEMID | uniqueidentifier | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_EVENTREGISTRANT] as
select
r.[EVENTREGISTRANTSYSTEMID],
r.[EVENTREGISTRANTFACTID],
r.[CONSTITUENTDIMID],
r.[EVENTDIMID],
er.[ATTENDED],
er.[ISCANCELLED],
er.[WILLNOTATTEND],
r.[REGISTRATIONFEE],
r.[REGISTRATIONFEERECEIVED],
er.[ONLINEREGISTRANT],
rc.[INBOUNDCHANNEL],
rc.[RECRUITEMENTCHANNEL],
rc.[ROLE],
c.[CURRENCYSYSTEMID]
from BBDW.[FACT_EVENTREGISTRANT] r
left join BBDW.[DIM_EVENTREGISTRATION] er on er.[EVENTREGISTRATIONDIMID] = r.[EVENTREGISTRATIONDIMID] and r.[EVENTREGISTRATIONDIMID] <> 0
left join BBDW.[DIM_EVENTREGISTRATIONCODES] rc on r.[EVENTREGISTRATIONCODESDIMID] = rc.[EVENTREGISTRATIONCODESDIMID] and r.[EVENTREGISTRATIONCODESDIMID] <> 0
outer apply BBDW.[DIM_CURRENCY] c
where c.[ISORGANIZATIONCURRENCY] = 1