USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_EDUINSTTOIND

The save procedure used by the edit dataform template "Relationship Educational Institution to Individual Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Relationship type
@RECIPROCALTYPECODEID	uniqueidentifier	IN	Reciprocal relationship type
@RELATIONSHIPSTARTDATE	datetime	IN	Start date
@RELATIONSHIPENDDATE	datetime	IN	End date
@ISCONTACT	bit	IN	The individual is a contact for this organization
@ISPRIMARYCONTACT	bit	IN	Primary contact
@CONTACTTYPECODEID	uniqueidentifier	IN	Contact type
@POSITION	nvarchar(50)	IN	Position
@ISPRIMARYBUSINESS	bit	IN	This is the primary business
@RELATIONADDRESSID	uniqueidentifier	IN	Address ID
@ADDADDRESS	bit	IN	Add Address
@EDITADDRESS	bit	IN	Edit Address
@ADDRESSTYPECODEID	uniqueidentifier	IN	Type
@PRIMARY	bit	IN	Set as primary address
@DONOTMAIL	bit	IN	Do not send mail to this address
@STARTDATE	UDT_MONTHDAY	IN	Start date
@ENDDATE	UDT_MONTHDAY	IN	End date
@COUNTRYID	uniqueidentifier	IN	Country
@STATEID	uniqueidentifier	IN	State
@ADDRESSBLOCK	nvarchar(150)	IN	Address
@CITY	nvarchar(50)	IN	City
@POSTCODE	nvarchar(12)	IN	ZIP
@CART	nvarchar(10)	IN	CART
@DPC	nvarchar(8)	IN	DPC
@LOT	nvarchar(5)	IN	LOT
@UPDATEMATCHINGSPOUSEADDRESSES	bit	IN	Update matching address information for spouse
@OMITFROMVALIDATION	bit	IN	Omit this address from validation
@COUNTYCODEID	uniqueidentifier	IN	County
@CONGRESSIONALDISTRICTCODEID	uniqueidentifier	IN	Congressional district
@STATEHOUSEDISTRICTCODEID	uniqueidentifier	IN	State house district
@STATESENATEDISTRICTCODEID	uniqueidentifier	IN	State senate district
@LOCALPRECINCTCODEID	uniqueidentifier	IN	Local precinct
@INFOSOURCECODEID	uniqueidentifier	IN	Info source
@REGIONCODEID	uniqueidentifier	IN	Region
@LASTVALIDATIONATTEMPTDATE	datetime	IN	Last attempt
@VALIDATIONMESSAGE	nvarchar(200)	IN	Validation message
@CERTIFICATIONDATA	int	IN
@UPDATECONTACTS	bit	IN	Update contacts that use this address
@DONOTMAILREASONCODEID	uniqueidentifier	IN	Reason
@INFOSOURCECOMMENTS	nvarchar(256)	IN	Comments
@COMMENTS	nvarchar(max)	IN	Comments
@RELATIONPHONEID	uniqueidentifier	IN
@ADDPHONE	bit	IN
@EDITPHONE	bit	IN
@PHONETYPECODEID	uniqueidentifier	IN	Type
@NUMBER	nvarchar(100)	IN	Number
@PHONECOUNTRYID	uniqueidentifier	IN	Country
@PHONESTARTTIME	UDT_HOURMINUTE	IN	Call after
@PHONEENDTIME	UDT_HOURMINUTE	IN	Call before
@PHONESTARTDATE	date	IN	Start date
@PHONEENDDATE	date	IN	End date
@PHONEPRIMARY	bit	IN	Set as primary phone number
@DONOTCALL	bit	IN	Do not call this phone number
@DONOTCALLREASONCODEID	uniqueidentifier	IN	Reason
@PHONEISCONFIDENTIAL	bit	IN	This phone number is confidential
@PHONEINFOSOURCECODEID	uniqueidentifier	IN	Information source
@PHONEINFOSOURCECOMMENTS	nvarchar(256)	IN	Comments
@RELATIONEMAILADDRESSID	uniqueidentifier	IN
@ADDEMAILADDRESS	bit	IN
@EDITEMAILADDRESS	bit	IN
@EMAILADDRESSTYPECODEID	uniqueidentifier	IN	Type
@EMAILADDRESS	UDT_EMAILADDRESS	IN	Email address
@EMAILADDRESSPRIMARY	bit	IN	Set as primary email address
@DONOTEMAIL	bit	IN	Do not send email to this address
@EMAILADDRESSINFOSOURCECODEID	uniqueidentifier	IN	Information source
@EMAILADDRESSINFOSOURCECOMMENTS	nvarchar(256)	IN	Comments

Definition

Copy



                    create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_EDUINSTTOIND
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @RELATIONSHIPTYPECODEID uniqueidentifier,
                        @RECIPROCALTYPECODEID uniqueidentifier,
                        @RELATIONSHIPSTARTDATE datetime,
                        @RELATIONSHIPENDDATE datetime,
                        @ISCONTACT bit,
                        @ISPRIMARYCONTACT bit,
                        @CONTACTTYPECODEID uniqueidentifier,
                        @POSITION nvarchar(50),
                        @ISPRIMARYBUSINESS bit,
                        @RELATIONADDRESSID uniqueidentifier,
                        @ADDADDRESS bit,
                        @EDITADDRESS bit,
                        @ADDRESSTYPECODEID uniqueidentifier,
                        @PRIMARY bit,
                        @DONOTMAIL bit,
                        @STARTDATE dbo.UDT_MONTHDAY,
                        @ENDDATE dbo.UDT_MONTHDAY,
                        @COUNTRYID uniqueidentifier,
                        @STATEID uniqueidentifier,
                        @ADDRESSBLOCK nvarchar(150),
                        @CITY nvarchar(50),
                        @POSTCODE nvarchar(12),
                        @CART nvarchar(10),
                        @DPC nvarchar(8),
                        @LOT nvarchar(5),
                        @UPDATEMATCHINGSPOUSEADDRESSES bit,
                        @OMITFROMVALIDATION bit,                    
                        @COUNTYCODEID uniqueidentifier,
                        @CONGRESSIONALDISTRICTCODEID uniqueidentifier,
                        @STATEHOUSEDISTRICTCODEID uniqueidentifier,
                        @STATESENATEDISTRICTCODEID uniqueidentifier,
                        @LOCALPRECINCTCODEID uniqueidentifier,
                        @INFOSOURCECODEID uniqueidentifier,
                        @REGIONCODEID uniqueidentifier,                    
                        @LASTVALIDATIONATTEMPTDATE datetime,
                        @VALIDATIONMESSAGE nvarchar(200),
                        @CERTIFICATIONDATA integer,
                        @UPDATECONTACTS bit,
                        @DONOTMAILREASONCODEID uniqueidentifier,
                        @INFOSOURCECOMMENTS nvarchar(256),
                        @COMMENTS nvarchar(max),
                        @RELATIONPHONEID uniqueidentifier,
                        @ADDPHONE bit,
                        @EDITPHONE bit,
                        @PHONETYPECODEID uniqueidentifier,
                        @NUMBER nvarchar(100),
                        @PHONECOUNTRYID uniqueidentifier,
                        @PHONESTARTTIME dbo.UDT_HOURMINUTE,
                        @PHONEENDTIME dbo.UDT_HOURMINUTE,
                        @PHONESTARTDATE date,
                        @PHONEENDDATE date,
                        @PHONEPRIMARY bit,
                        @DONOTCALL bit,
                        @DONOTCALLREASONCODEID uniqueidentifier,
                        @PHONEISCONFIDENTIAL bit,
                        @PHONEINFOSOURCECODEID uniqueidentifier,
                        @PHONEINFOSOURCECOMMENTS nvarchar(256),
                        @RELATIONEMAILADDRESSID uniqueidentifier,
                        @ADDEMAILADDRESS bit,
                        @EDITEMAILADDRESS bit,
                        @EMAILADDRESSTYPECODEID uniqueidentifier,
                        @EMAILADDRESS dbo.UDT_EMAILADDRESS,
                        @EMAILADDRESSPRIMARY bit,
                        @DONOTEMAIL bit,
                        @EMAILADDRESSINFOSOURCECODEID uniqueidentifier,
                        @EMAILADDRESSINFOSOURCECOMMENTS nvarchar(256)
                    )    
                    as
                        set nocount on;

                        exec dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_ORGTOIND_6
                            @ID,
                            @CHANGEAGENTID,
                            @RELATIONSHIPTYPECODEID,
                            @RECIPROCALTYPECODEID,
                            @RELATIONSHIPSTARTDATE,
                            @RELATIONSHIPENDDATE,
                            @ISCONTACT,
                            @ISPRIMARYCONTACT,
                            @CONTACTTYPECODEID,
                            @POSITION,
                            @ISPRIMARYBUSINESS,
                            0,
                            @RELATIONADDRESSID,
                            @ADDADDRESS,
                            @EDITADDRESS,
                            @ADDRESSTYPECODEID,
                            @PRIMARY,
                            @DONOTMAIL,
                            @STARTDATE,
                            @ENDDATE,
                            @COUNTRYID,
                            @STATEID,
                            @ADDRESSBLOCK,
                            @CITY,
                            @POSTCODE,
                            @CART,
                            @DPC,
                            @LOT,
                            @UPDATEMATCHINGSPOUSEADDRESSES,
                            @OMITFROMVALIDATION,                    
                            @COUNTYCODEID,
                            @CONGRESSIONALDISTRICTCODEID,
                            @STATEHOUSEDISTRICTCODEID,
                            @STATESENATEDISTRICTCODEID,
                            @LOCALPRECINCTCODEID,
                            @INFOSOURCECODEID,
                            @REGIONCODEID,                    
                            @LASTVALIDATIONATTEMPTDATE,
                            @VALIDATIONMESSAGE,
                            @CERTIFICATIONDATA,
                            @UPDATECONTACTS,
                            @DONOTMAILREASONCODEID,
                            @INFOSOURCECOMMENTS,
                            @COMMENTS,
                            @RELATIONPHONEID,
                            @ADDPHONE,
                            @EDITPHONE,
                            @PHONETYPECODEID,
                            @NUMBER,
                            @PHONECOUNTRYID,
                            @PHONESTARTTIME,
                            @PHONEENDTIME,
                            @PHONESTARTDATE,
                            @PHONEENDDATE,
                            @PHONEPRIMARY,
                            @DONOTCALL,
                            @DONOTCALLREASONCODEID,
                            @PHONEISCONFIDENTIAL,
                            @PHONEINFOSOURCECODEID,
                            @PHONEINFOSOURCECOMMENTS,
                            @RELATIONEMAILADDRESSID,
                            @ADDEMAILADDRESS,
                            @EDITEMAILADDRESS,
                            @EMAILADDRESSTYPECODEID,
                            @EMAILADDRESS,
                            @EMAILADDRESSPRIMARY,
                            @DONOTEMAIL,
                            @EMAILADDRESSINFOSOURCECODEID,
                            @EMAILADDRESSINFOSOURCECOMMENTS;

                        return 0;