DIM_EVENTREGISTRANTROLE_STAGE
Contains information about a registrants role
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | Surrogate key for the Event Registration Channel dimension. | |
| FUNDRAISERTEAMSYSTEMID | uniqueidentifier | yes | dbo.[TEAMEXTENSION].[TEAMFUNDRAISINGTEAMID] | |
| FUNDRAISERTEAMDIMID | int | yes | Reference key to DIM_FUNDRAISERTEAM based on dbo.[TEAMEXTENSION].[TEAMFUNDRAISERTEAMID] | |
| ROLE | nvarchar(100) | yes | Roles is calculated from dbo.[TEAMFUNDRAISER].[ID] , dbo.[TEAMFUNDRAISERTEAMCAPTAIN].[ID] and [TEAMEXTENSION].[TYPECODE] | |
| EVENTSYSTEMID | uniqueidentifier | yes | dbo.[EVENT].[ID] |