USP_DATAFORMTEMPLATE_VIEW_DECEASINGRULES

The load procedure used by the view dataform template "Global Deceasing Rules View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@ADDSOLICITCODE	bit	INOUT	Add solicit code to deceased
@SOLICITCODE	nvarchar(200)	INOUT	Solicit code
@SETEFTSTATUS	bit	INOUT	If financial accounts exist, change EFT status
@EFTSTATUS	nvarchar(100)	INOUT	EFT status
@DISABLEWEATHRATINGS	bit	INOUT	Disable wealth updates for prospects marked deceased
@DISABLESPOUSERECOGNITIONCREDIT	bit	INOUT	No longer give recognition credit for gifts given by the spouse
@SETMARITALSTATUS	bit	INOUT	If spouse exists, change marital status
@MARITALSTATUS	nvarchar(100)	INOUT	Marital status
@MARKINACTIVE	bit	INOUT	Set record status to inactive for the deceased

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DECEASINGRULES
(
  @DATALOADED bit = 0 output,
  @ADDSOLICITCODE bit = null output,
  @SOLICITCODE nvarchar(200) = null output,
  @SETEFTSTATUS bit = null output,
  @EFTSTATUS nvarchar(100) = null output,
  @DISABLEWEATHRATINGS bit = null output,
  @DISABLESPOUSERECOGNITIONCREDIT bit = null output,
  @SETMARITALSTATUS bit = null output,
  @MARITALSTATUS nvarchar(100) = null output,
  @MARKINACTIVE bit = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  select top 1
    @ADDSOLICITCODE = UFN_DECEASINGRULE_GETRULES.ADDSOLICITCODE,
    @SOLICITCODE = case when SOLICITCODE.SITEID is null then SOLICITCODE.[DESCRIPTION] else SOLICITCODE.[DESCRIPTION] + ' - ' + SITE.NAME end,
    @SETEFTSTATUS = UFN_DECEASINGRULE_GETRULES.SETEFTSTATUS,
    @EFTSTATUS = UFN_DECEASINGRULE_GETRULES.EFTSTATUS,
    @DISABLEWEATHRATINGS = UFN_DECEASINGRULE_GETRULES.DISABLEWEATHRATINGS,
    @DISABLESPOUSERECOGNITIONCREDIT = UFN_DECEASINGRULE_GETRULES.DISABLESPOUSERECOGNITIONCREDIT,
    @SETMARITALSTATUS = UFN_DECEASINGRULE_GETRULES.SETMARITALSTATUS,
    @MARITALSTATUS = MARITALSTATUSCODE.DESCRIPTION,
    @MARKINACTIVE = UFN_DECEASINGRULE_GETRULES.MARKINACTIVE,
    @DATALOADED = 1
  from
    dbo.UFN_DECEASINGRULE_GETRULES()
  left join
    dbo.MARITALSTATUSCODE on MARITALSTATUSCODE.ID = UFN_DECEASINGRULE_GETRULES.MARITALSTATUSCODEID
  left join
    dbo.SOLICITCODE on SOLICITCODE.ID = UFN_DECEASINGRULE_GETRULES.SOLICITCODEID
  left join
    dbo.SITE on SITE.ID = SOLICITCODE.SITEID;

  return 0;