V_QUERY_RE7_EVENTREGISTRANT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| LOCALID | int | ||
| CONSTITUENT_LOCALID | int | ||
| SPONSORPARTICIPANT_LOCALID | int | yes | |
| EVENT_LOCALID | int | ||
| IDENTIFIER | nvarchar(50) | yes | |
| NAME | nvarchar(50) | yes | |
| STARTDATE | datetime | yes | |
| STARTDATEMONTHSDIFF | int | yes | |
| ENDDATE | datetime | yes | |
| CATEGORY | nvarchar(100) | yes | |
| GROUP | nvarchar(100) | yes | |
| TYPE | nvarchar(100) | yes | |
| GOAL | numeric(20, 4) | yes | |
| NUMBERINVITED | int | yes | |
| LOCATIONNAME | nvarchar(60) | yes | |
| COUNTRY | nvarchar(100) | yes | |
| COUNTY | nvarchar(100) | yes | |
| STATE | nvarchar(100) | yes | |
| LOCATIONCITY | nvarchar(50) | yes | |
| LOCATIONPOSTCODE | nvarchar(12) | yes | |
| ATTENDED | bit | ||
| PARTICIPATION | nvarchar(100) | yes | |
| STATUS | nvarchar(100) | yes | |
| REGISTRATION | nvarchar(50) | yes | |
| INVITATION | nvarchar(50) | yes | |
| RESPONSE | nvarchar(100) | yes | |
| GUESTOFPARTICIPANT_LOCALID | int | yes | |
| SOLICITORCONSTITUENT_LOCALID | int | yes | |
| REGISTRATIONDATE | UDT_FUZZYDATE | yes | |
| RESPONSEDATE | UDT_FUZZYDATE | yes | |
| INVITEDATE | UDT_FUZZYDATE | yes | |
| ISCOORDINATOR | bit | ||
| ISINSTRUCTOR | bit | ||
| ISPARTICIPANT | bit | ||
| ISVOLUNTEER | bit | ||
| ISSPEAKER | bit | ||
| ISVENDOR | bit | ||
| LOCATIONNZCITYCODE_LOCALID | int | yes | |
| LOCATIONNZSUBURBCODE_LOCALID | int | yes | |
| ONLINEREGISTRATION | bit | ||
| IMPORTID | nvarchar(20) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 2/6/2025 8:50:26 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3901.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RE7_EVENTREGISTRANT AS
select
[ER].[LOCALID],
[ER].[CONSTITUENT_LOCALID],
[ER].[SPONSORPARTICIPANT_LOCALID],
[ER].[EVENT_LOCALID],
[E].[IDENTIFIER],
[E].[NAME],
[E].[STARTDATE],
datediff(month, [E].[STARTDATE], current_timestamp ) [STARTDATEMONTHSDIFF],
[E].[ENDDATE] ,
[ECC].[DESCRIPTION] [CATEGORY],
[EGC].[DESCRIPTION] [GROUP],
[ETC].[DESCRIPTION] [TYPE],
[E].[GOAL],
[E].[NUMBERINVITED],
[E].[LOCATIONNAME],
[LCC].[DESCRIPTION] [COUNTRY],
[LCOC].[DESCRIPTION] [COUNTY],
[LSC].[DESCRIPTION] [STATE],
[E].[LOCATIONCITY],
[E].[LOCATIONPOSTCODE],
[ER].[ATTENDED],
[PC].[DESCRIPTION] [PARTICIPATION],
[PSC].[DESCRIPTION] [STATUS],
[PRE].[DESCRIPTION] [REGISTRATION],
[PIC].[DESCRIPTION] [INVITATION],
[PRES].[DESCRIPTION] [RESPONSE],
[ER].[GUESTOFPARTICIPANT_LOCALID],
[ER].[SOLICITORCONSTITUENT_LOCALID],
[ER].[REGISTRATIONDATE],
[ER].[RESPONSEDATE],
[ER].[INVITEDATE],
[ER].[ISCOORDINATOR],
[ER].[ISINSTRUCTOR],
[ER].[ISPARTICIPANT],
[ER].[ISVOLUNTEER],
[ER].[ISSPEAKER],
[ER].[ISVENDOR],
[E].[LOCATIONNZCITYCODE_LOCALID],
[E].[LOCATIONNZSUBURBCODE_LOCALID],
[ER].[ONLINEREGISTRATION],
[E].[IMPORTID]
from [dbo].[RE7_EVENTREGISTRANT] [ER]
left outer join [dbo].[RE7_EVENTS] [E] on [ER].[EVENT_LOCALID] = [E].[LOCALID]
left outer join dbo.[RE7_EVENTCATEGORYCODE] [ECC] on [E].[CATEGORYCODE_LOCALID] = [ECC].[LOCALID]
left outer join dbo.[RE7_EVENTGROUPCODE] [EGC] on [E].[GROUPCODE_LOCALID] = [EGC].[LOCALID]
left outer join dbo.[RE7_EVENTTYPECODE] [ETC] on [E].[TYPECODE_LOCALID] = [ETC].[LOCALID]
left outer join dbo.[RE7_COUNTRY] [LCC] on [E].[LOCATIONCOUNTRYCODE_LOCALID] = [LCC].[LOCALID]
left outer join dbo.[RE7_COUNTYCODE] [LCOC] on [E].[LOCATIONCOUNTYCODE_LOCALID] = [LCOC].[LOCALID]
left outer join dbo.[RE7_STATE] [LSC] on [E].[LOCATIONSTATECODE_LOCALID] = [LSC].[LOCALID]
left outer join dbo.[RE7_PARTICIPATIONCODE] [PC] on [ER].[PARTICIPATIONCODE_LOCALID] = [PC].[LOCALID]
left outer join dbo.[RE7_PARTICIPANTSTATUSCODE] [PSC] on [ER].[STATUSCODE_LOCALID] = [PSC].[LOCALID]
left outer join dbo.[RE7_PARTICIPANTREGISTRATIONCODE] [PRE] on [ER].[REGISTRATIONCODE_LOCALID] = [PRE].[LOCALID]
left outer join dbo.[RE7_PARTICIPANTINVITATIONCODE] [PIC] on [ER].[INVITATIONCODE_LOCALID] = [PIC].[LOCALID]
left outer join dbo.[RE7_PARTICIPANTRESPONSECODE] [PRES] on [ER].[RESPONSECODE_LOCALID] = [PRES].[LOCALID];