V_QUERY_RE7_PHONE
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| LOCALID | int | ||
| NUMBER | nvarchar(2047) | yes | |
| PHONETYPE | nvarchar(100) | yes | |
| DONOTCALL | bit | ||
| CONSTITUENT_LOCALID | int | ||
| 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_PHONE AS
select
[PH].[LOCALID],
[PH].[NUMBER],
[PHTC].[DESCRIPTION] [PHONETYPE],
[PH].[DONOTCALL],
[PH].[CONSTITUENT_LOCALID],
[PH].[IMPORTID]
from dbo.[RE7_PHONE] [PH]
left outer join dbo.[RE7_PHONETYPECODE] [PHTC] on [PH].[PHONETYPECODE_LOCALID] = [PHTC].[LOCALID];