USP_DATAFORMTEMPLATE_PRELOAD_ADD_ASSIGNCONSTITSECURITYATTRIBUTESPROCESS_2

The load procedure used by the edit dataform template "Assign Constituent Security Attributes Process Add Form 2"

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTRECORDTYPEID	uniqueidentifier	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_ASSIGNCONSTITSECURITYATTRIBUTESPROCESS_2
(
    @CONSTITUENTRECORDTYPEID uniqueidentifier = null output
)
as
    set nocount on;

    select
        @CONSTITUENTRECORDTYPEID = [ID]
    from
        dbo.[RECORDTYPE]
    where
        upper(NAME) = 'CONSTITUENT';

    return 0;