V_QUERY_PHONEFINDERBATCHCONTROLREPORT
View used for output for the PhoneFinder batch control report
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| NAME | nvarchar(154) | yes | Name |
| NUMBER | nvarchar(100) | 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_PHONEFINDERBATCHCONTROLREPORT AS
select
PHONE.[ID],
CONSTITUENT.[NAME],
PHONE.[NUMBER]
from
dbo.PHONE
inner join dbo.CONSTITUENT on PHONE.[CONSTITUENTID] = CONSTITUENT.[ID]