USP_DATAFORMTEMPLATE_PRELOAD_ADD_CONSITUENTSPOUSE_2

The load procedure used by the edit dataform template "Constituent Spouse Add Form 2"

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CONSTITUENTNAME	nvarchar(700)	INOUT	Constituent name
@CONSTITUENTHOUSEHOLDNAME	nvarchar(700)	INOUT	Constituent's household name
@CONSTITUENTHOUSEHOLDID	uniqueidentifier	INOUT	Constituent's household ID
@CONSTITUENTTYPE	int	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_CONSITUENTSPOUSE_2(
  @CONSTITUENTID uniqueidentifier,
  @CONSTITUENTNAME nvarchar(700) = null output,
  @CONSTITUENTHOUSEHOLDNAME nvarchar(700) = null output,
  @CONSTITUENTHOUSEHOLDID uniqueidentifier = null output,
  @CONSTITUENTTYPE int = null output
)
as
  set nocount on;

  select @CONSTITUENTNAME = NAME
  from  dbo.UFN_CONSTITUENT_DISPLAYNAME(@CONSTITUENTID) NF;

  select
    @CONSTITUENTHOUSEHOLDNAME = NF.NAME,
    @CONSTITUENTHOUSEHOLDID = C.ID
  from dbo.CONSTITUENT C
  inner join dbo.GROUPMEMBER GM on C.ID = GM.GROUPID
  inner join dbo.GROUPDATA GD on GM.GROUPID = GD.ID
  outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(C.ID) NF
  where
    GM.MEMBERID = @CONSTITUENTID and
    dbo.UFN_GROUPMEMBER_ISCURRENTMEMBER(GM.ID) = 1 and
    GD.GROUPTYPECODE = 0;

  set @CONSTITUENTTYPE = 0

  return 0;