v_DIM_EVENTREGISTRATION
The event registration dimension contains information about event registrations.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EVENTREGISTRATIONDIMID | int | BBDW.[DIM_EVENTREGISTRATION].[EVENTREGISTRATIONDIMID] | |
| ATTENDED | bit | yes | BBDW.[DIM_EVENTREGISTRATION].[ATTENDED] |
| WILLNOTATTEND | bit | yes | BBDW.[DIM_EVENTREGISTRATION].[WILLNOTATTEND] |
| BENEFITSWAIVED | bit | yes | BBDW.[DIM_EVENTREGISTRATION].[BENEFITSWAIVED] |
| ONLINEREGISTRANT | bit | yes | BBDW.[DIM_EVENTREGISTRATION].[ONLINEREGISTRANT] |
| ISCANCELLED | bit | yes | BBDW.[DIM_EVENTREGISTRATION].[ISCANCELLED] |
| ISCOMPANYREGISTRATION | bit | yes | BBDW.[DIM_EVENTREGISTRATION].[ISCOMPANYREGISTRATION] |
| ISPREVIOUSPARTICIPANT | bit | yes | BBDW.[DIM_EVENTREGISTRATION].[ISPREVIOUSPARTICIPANT] |
Definition
Copy
CREATE view [BBDW].[v_DIM_EVENTREGISTRATION] as
select
[EVENTREGISTRATIONDIMID],
[ATTENDED],
[WILLNOTATTEND],
[BENEFITSWAIVED],
[ONLINEREGISTRANT],
[ISCANCELLED],
[ISCOMPANYREGISTRATION],
[ISPREVIOUSPARTICIPANT]
from BBDW.[DIM_EVENTREGISTRATION]