USP_DATAFORMTEMPLATE_ADD_RELATIONSHIPINDIVIDUALRECORDTOSTUDENT

The save procedure used by the add dataform template "Individual Record To Student Relationship Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@RECIPROCALCONSTITUENTID	uniqueidentifier	IN	Related individual
@RECIPROCALTYPECODEID	uniqueidentifier	IN	Individual is the
@RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Student is the
@ISSPOUSE	bit	IN	Is spouse?
@COPYPRIMARYINFORMATION	bit	IN	Copy primary contact information
@SKIP_ADDING_SECURITYGROUPS	bit	IN	Skip adding security groups
@SKIP_ADDING_SITES	bit	IN	Skip adding sites
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@COMMENTS	nvarchar(max)	IN	Comments
@ISEMERGENCYCONTACT	bit	IN	Is emergency contact?

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_RELATIONSHIPINDIVIDUALRECORDTOSTUDENT
                    (
                        @ID uniqueidentifier = null output,
                        @CHANGEAGENTID uniqueidentifier = null,    
                        @CONSTITUENTID uniqueidentifier,
                        @RECIPROCALCONSTITUENTID uniqueidentifier,
                        @RECIPROCALTYPECODEID uniqueidentifier,
                        @RELATIONSHIPTYPECODEID uniqueidentifier,
                        @ISSPOUSE bit = 0,
                        @COPYPRIMARYINFORMATION  bit = 0,
                        @SKIP_ADDING_SECURITYGROUPS bit = 0,
                        @SKIP_ADDING_SITES bit = 0,
                        @CURRENTAPPUSERID uniqueidentifier,
                        @COMMENTS nvarchar(max) = null,
                        @ISEMERGENCYCONTACT bit = 0
                    )
                    as

                        set nocount on;                    

                        exec dbo.USP_DATAFORMTEMPLATE_ADD_RELATIONSHIP_INDIVIDUALRECORDTOIND @ID, @CHANGEAGENTID, @CONSTITUENTID, @RECIPROCALCONSTITUENTID, @RECIPROCALTYPECODEID, @RELATIONSHIPTYPECODEID, @ISSPOUSE, @COPYPRIMARYINFORMATION, @SKIP_ADDING_SECURITYGROUPS, @SKIP_ADDING_SITES, @CURRENTAPPUSERID, @COMMENTS, @ISEMERGENCYCONTACT

                        return 0;