V_QUERY_DECEASEDFINDERBATCHCONTROLREPORT

View used for output for the DeceasedRecordFinder batch control report.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
NAME	nvarchar(154)	yes	Name
BATCHID	uniqueidentifier	yes	Batch ID
SUBMITTEDADDRESS	nvarchar(300)	yes	Submitted address
DECEASEDDATE	UDT_FUZZYDATE	yes	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_DECEASEDFINDERBATCHCONTROLREPORT AS



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