v_DIM_EVENTREGISTRATIONCODES
Contains information about inbound and recruitment channels and roles.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EVENTREGISTRATIONCODESDIMID | int | Surrogate key for the Event Registration Codes dimension derived from [DIM_EVENTREGISTRATIONCODES].[EVENTREGISTRATIONCODESDIMID]. | |
| INBOUNDCHANNEL | nvarchar(24) | yes | BBDW.[DIM_EVENTREGISTRATIONCODES].[INBOUNDCHANNEL] |
| RECRUITEMENTCHANNEL | nvarchar(100) | yes | BBDW.[DIM_EVENTREGISTRATIONCODES].[RECRUITEMENTCHANNEL] |
| ROLE | nvarchar(100) | yes | BBDW.[DIM_EVENTREGISTRATIONCODES].[ROLE] |
Definition
Copy
CREATE view [BBDW].[v_DIM_EVENTREGISTRATIONCODES] as
select
[EVENTREGISTRATIONCODESDIMID],
[INBOUNDCHANNEL],
[RECRUITEMENTCHANNEL],
[ROLE]
from BBDW.[DIM_EVENTREGISTRATIONCODES]