V_SEARCH_RE7EVENT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | int | ||
| DESCRIPTION | nvarchar(50) | ||
| IDENTIFIER | nvarchar(50) | ||
| CATEGORY | nvarchar(100) | yes | |
| GROUP | nvarchar(100) | yes | |
| TYPE | nvarchar(100) | yes | |
| LOCATIONNAME | nvarchar(60) | 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_SEARCH_RE7EVENT AS
select
[E].[LOCALID] [ID],
[E].[NAME] [DESCRIPTION],
[E].[IDENTIFIER],
[ECC].[DESCRIPTION] [CATEGORY],
[EGC].[DESCRIPTION] [GROUP],
[ETC].[DESCRIPTION] [TYPE],
[E].[LOCATIONNAME]
from [dbo].[RE7_EVENTS] [E]
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]