V_SEARCH_RE7CONSTITUENTRATING
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | int | ||
| CATEGORY | nvarchar(150) | yes | |
| FULLNAME | nvarchar(255) | yes | |
| IDENTIFIER | nvarchar(408) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 2/6/2025 8:50:25 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3901.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_RE7CONSTITUENTRATING AS
select
[CR].[LOCALID] [ID],
[CR].[CATEGORY],
[C].[FULLNAME],
case when isnull([CR].[CATEGORY], '') = '' then [C].[FULLNAME]
else [C].[FULLNAME] + ' - ' + [CR].[CATEGORY] end [IDENTIFIER]
from dbo.[RE7_CONSTITUENTRATING] [CR]
left outer join dbo.[RE7_CONSTITUENT] [C] on [CR].[CONSTITUENT_LOCALID] = [C].[LOCALID];