USP_DATAFORMTEMPLATE_EDITLOAD_GLOBALDECEASINGRULES

The load procedure used by the edit dataform template "Global Deceasing Rules Edit 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
@SOLICITCODEID	uniqueidentifier	INOUT	Solicit code
@SETEFTSTATUS	bit	INOUT	If financial accounts exist, change EFT status
@EFTSTATUSCODE	tinyint	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
@MARITALSTATUSCODEID	uniqueidentifier	INOUT	Marital status
@MARKINACTIVE	bit	INOUT	Set record status to inactive for the deceased

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_GLOBALDECEASINGRULES
(
  @DATALOADED bit = 0 output,
  @ADDSOLICITCODE bit = null output,
  @SOLICITCODEID uniqueidentifier = null output,
  @SETEFTSTATUS bit = null output,
  @EFTSTATUSCODE tinyint = null output,
  @DISABLEWEATHRATINGS bit = null output,
  @DISABLESPOUSERECOGNITIONCREDIT bit = null output,
  @SETMARITALSTATUS bit = null output,
  @MARITALSTATUSCODEID uniqueidentifier = null output,
  @MARKINACTIVE bit = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  select top 1
    @ADDSOLICITCODE = ADDSOLICITCODE,
    @SOLICITCODEID = SOLICITCODEID,
    @SETEFTSTATUS = SETEFTSTATUS,
    @EFTSTATUSCODE = EFTSTATUSCODE,
    @DISABLEWEATHRATINGS = DISABLEWEATHRATINGS,
    @DISABLESPOUSERECOGNITIONCREDIT = DISABLESPOUSERECOGNITIONCREDIT,
    @SETMARITALSTATUS = SETMARITALSTATUS,
    @MARITALSTATUSCODEID = MARITALSTATUSCODEID,
    @MARKINACTIVE = MARKINACTIVE,
    @DATALOADED = 1
  from
    dbo.UFN_DECEASINGRULE_GETRULES();

  return 0;