USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOORG_4

Updates a relationship between an individual and an organization.

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
@ISMATCHINGGIFTRELATIONSHIP	bit	IN	The organization will match contributions for this relationship
@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

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOORG_4
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,                                                                        
                @RELATIONSHIPTYPECODEID uniqueidentifier,
                @RECIPROCALTYPECODEID uniqueidentifier,                                                
                @RELATIONSHIPSTARTDATE datetime,
                @RELATIONSHIPENDDATE datetime,
                @ISCONTACT bit,
                @ISPRIMARYCONTACT bit,
                @CONTACTTYPECODEID uniqueidentifier,
                @POSITION nvarchar(50),
                @ISPRIMARYBUSINESS bit,
                @ISMATCHINGGIFTRELATIONSHIP 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)
            )    
            as
                set nocount on

                declare @COMMENTS nvarchar(max)
                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RELATIONSHIP_INDTOORG_3 @ID = @ID, @COMMENTS = @COMMENTS output

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOORG_5 @ID, @CHANGEAGENTID, @RELATIONSHIPTYPECODEID, @RECIPROCALTYPECODEID,
                    @RELATIONSHIPSTARTDATE, @RELATIONSHIPENDDATE, @ISCONTACT, @ISPRIMARYCONTACT, @CONTACTTYPECODEID, @POSITION, 
                    @ISPRIMARYBUSINESS, @ISMATCHINGGIFTRELATIONSHIP, @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

                return 0