USP_DATAFORMTEMPLATE_PRELOAD_ADD_CONSITUENTSPOUSE

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

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CONSTITUENTNAME	nvarchar(154)	INOUT	Constituent name
@CONSTITUENTHOUSEHOLDNAME	nvarchar(154)	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(
    @CONSTITUENTID uniqueidentifier,
    @CONSTITUENTNAME nvarchar(154) = null output,
    @CONSTITUENTHOUSEHOLDNAME nvarchar(154) = null output,
    @CONSTITUENTHOUSEHOLDID uniqueidentifier = null output,
    @CONSTITUENTTYPE int = null output
)
as
    set nocount on;

    select
        @CONSTITUENTNAME = NAME
    from dbo.CONSTITUENT
    where 
        ID = @CONSTITUENTID;

    select
        @CONSTITUENTHOUSEHOLDNAME = C.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
    where
        GM.MEMBERID = @CONSTITUENTID and
        dbo.UFN_GROUPMEMBER_ISCURRENTMEMBER(GM.ID) = 1 and
        GD.GROUPTYPECODE = 0;

    set @CONSTITUENTTYPE = 0

    return 0;