V_QUERY_PHONEFINDERBATCHEXCEPTIONREPORT
View used for output for PhoneFinder batch exception report
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| NAME | nvarchar(154) | yes | Name |
| PHONENUMBER | nvarchar(20) | Phone number |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:36:00 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_PHONEFINDERBATCHEXCEPTIONREPORT AS
select
BATCHPHONEFINDER.[ID],
CONSTITUENT.[NAME],
BATCHPHONEFINDER.[PHONENUMBER]
from
dbo.BATCHPHONEFINDER
left outer join dbo.CONSTITUENT on CONSTITUENT.[ID] = BATCHPHONEFINDER.[CONSTITUENTID]