V_QUERY_DECEASEDFINDERBATCHEXCEPTIONREPORT

View used for output for DeceasedRecordFinder batch exception report.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
NAME	nvarchar(154)	yes	Name
SUBMITTEDADDRESS	nvarchar(300)	yes	Submitted address
DECEASEDDATE	UDT_FUZZYDATE		Deceased date
DECEASEDCONFIRMATION	nvarchar(17)	yes	Deceased date
DECEASEDSOURCE	nvarchar(100)	yes	Source

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:35:42 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_DECEASEDFINDERBATCHEXCEPTIONREPORT AS



                select 
                    BATCH.ID,
                    CONSTITUENT.NAME as NAME,
                    dbo.UFN_BUILDFULLADDRESS(null, BATCH.ADDRESSBLOCK, BATCH.CITY, BATCH.STATEID, BATCH.POSTCODE, (select ID from dbo.COUNTRY where USEFORCOAUPDATE = 1)) as SUBMITTEDADDRESS,
                    BATCH.DECEASEDDATE as DECEASEDDATE,
                    BATCH.DECEASEDCONFIRMATION as DECEASEDCONFIRMATION,
                    DECEASEDSOURCECODE.DESCRIPTION as DECEASEDSOURCE
                from 
                    dbo.BATCHDECEASEDFINDER BATCH
                left join 
                    dbo.CONSTITUENT 
                on 
                    CONSTITUENT.ID = BATCH.CONSTITUENTID
                left join
                    dbo.DECEASEDSOURCECODE
                on
                    BATCH.DECEASEDSOURCECODEID = DECEASEDSOURCECODE.ID