USP_DATAFORMTEMPLATE_PRELOAD_ADD_EDUINSTTOIND_RELATIONSHIP

The load procedure used by the edit dataform template "Relationship Educational Institution to Individual 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
@ORGPRIMARYADDRESSID	uniqueidentifier	INOUT
@PRIMARY	bit	INOUT	Set as primary address
@COUNTRYID	uniqueidentifier	INOUT	Country
@SPOUSENAME	nvarchar(154)	INOUT
@VALIDATIONCOUNTRIES	xml	INOUT
@ZIPLOOKUPCOUNTRIES	xml	INOUT
@CONSTITUENTTYPE	int	INOUT

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_EDUINSTTOIND_RELATIONSHIP
                    (
                        @CONSTITUENTID uniqueidentifier,
                        @CONSTITUENTNAME nvarchar(154) = null output,
                        @ORGPRIMARYADDRESSID uniqueidentifier = null output,
                        @PRIMARY bit = null output,
                        @COUNTRYID uniqueidentifier = null output,
                        @SPOUSENAME nvarchar(154) = null output,
                        @VALIDATIONCOUNTRIES xml = null output,
                        @ZIPLOOKUPCOUNTRIES xml = null output,
                        @CONSTITUENTTYPE int = null output
                    )
                    as
                        set nocount on;

                        exec dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_ORGTOIND_RELATIONSHIP_2 
                            @CONSTITUENTID, 
                            @CONSTITUENTNAME output, 
                            @ORGPRIMARYADDRESSID output, 
                            @PRIMARY output, 
                            @COUNTRYID output, 
                            @SPOUSENAME output, 
                            @VALIDATIONCOUNTRIES output, 
                            @ZIPLOOKUPCOUNTRIES output, 
                            @CONSTITUENTTYPE output;

                        return 0;