USP_DATALIST_DECEASEDFINDERBATCHREVIEW

Returns a list of committed deceased constituents.

Parameters

Parameter	Parameter Type	Mode	Description
@DECEASEDFINDERID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@ONLYUNREVIEWED	bit	IN	Only display unreviewed records
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_DECEASEDFINDERBATCHREVIEW
(
  @DECEASEDFINDERID uniqueidentifier,
  @ONLYUNREVIEWED bit = 0,
  @CURRENTAPPUSERID uniqueidentifier
)
as
  set nocount on;

  select 
    CONSTITUENT.ID,
    NF.NAME,
    DECEASEDCONSTITUENT.DECEASEDDATE,
    DECEASEDCONSTITUENT.DECEASEDCONFIRMATION,
    dbo.UFN_DECEASEDSOURCECODE_GETDESCRIPTION(DECEASEDCONSTITUENT.DECEASEDSOURCECODEID) as DECEASEDSOURCE,
    DECEASEDCONSTITUENT.ISREVIEWED
  from
    dbo.DECEASEDFINDER
  inner join
    dbo.BATCHDECEASEDFINDER
  on 
    BATCHDECEASEDFINDER.BATCHID = DECEASEDFINDER.BATCHID
  inner join
    dbo.DECEASEDCONSTITUENT
  on
    DECEASEDCONSTITUENT.ID = BATCHDECEASEDFINDER.CONSTITUENTID
  inner join
    dbo.CONSTITUENT
  on 
    DECEASEDCONSTITUENT.ID = CONSTITUENT.ID
  left join 
    dbo.SITE 
  on 
    DECEASEDFINDER.SITEID = SITE.ID
  outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) NF
  where 
    DECEASEDFINDER.ID = @DECEASEDFINDERID
  and
    (not DECEASEDCONSTITUENT.ISREVIEWED = @ONLYUNREVIEWED or DECEASEDCONSTITUENT.ISREVIEWED = 0)
  and
    dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, dbo.DECEASEDFINDER.SITEID) = 1                            
  order by
    DECEASEDCONSTITUENT.ISREVIEWED