V_QUERY_MATCHFINDERONLINEEXCEPTIONREPORT
View used for output by the Update Multiple Constituents from MatchFinder Online Batch Exception Report
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| CONSTITUENTID | uniqueidentifier | Constituent ID | |
| CONSTITUENTNAME | nvarchar(154) | yes | Constituent name |
| MATCHFINDERRECORDID | int | MatchFinder record ID | |
| MFORGNAME | nvarchar(100) | MatchFinder organization name |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:35:53 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_MATCHFINDERONLINEEXCEPTIONREPORT AS
select
ID,
CONSTITUENTID,
case when not CONSTITUENTID is null then dbo.UFN_CONSTITUENT_BUILDNAME(CONSTITUENTID) else N'' end as [CONSTITUENTNAME],
MATCHFINDERRECORDID,
MFORGNAME
from dbo.UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH